Help with application

Hi.

Im a grade 12 student doing a PAT for my end of the year mark. I am trying to make a translator. Where I translate from one language to another.

I have a database set up with two tables. "English" "Afrikaans" I have a field named ID in both tables which is numbered and there is a relationship between these two fields. Then a field named "English" in the one table and "Afrikaans" in the other.

Now I want to know if anyone knows a SQL command that if a user enters a word into a text field that the program can search the database for that word, match the from the one table to the other table and give me the translated word?

If you want screen shots of the database just ask and I will put it up.

Hero

You should post this in the database section.

You have to use a SELECT statement.
Something like:

SELECT EnglishWord from EnglishTable where EnglishID=(SELECT AfrikaansID from AfrikaansTable where AfrikaansWord='Ubuntu');

This is assuming that the words and translations have an 1 to 1 relationship.

Thanks. Will give it a try and will let you know if I get it right.

Thanks

Moved from Java Applets.

If there's a one-to-one relationship, that looks like a bad database design. Why not have just one table with two columns, English and Afrikaans?

db

I'm assuming it is a school excercise.

Well. Its a school project.
The teacher asked us to use to tables. So that we can learn relationships and all those wonderful things.

Thanks cultclassic. The SQL works wonderful! Everything works now as it should :)

Hero

Ok. I got one more question. Does anyone know how to make my GUI in Netbeans6.5 look like the windows look instead of the crappy java default metal/blue look? If possible can someone help me out?

Add code to set the look and feel to be windows. Googling should get you lots of help.

I tried using google. But I need to change the .conf file and it doesnt allow me. Then I have to download some pluggin and and wat have you.

One other. When I do this to translate from English to Afrikaans SQL:
public String option4 (String user)
{
StringBuffer sb = new StringBuffer ();
try
{
boolean data = false;
Statement stmt = conn.createStatement ();
ResultSet b = stmt.executeQuery ("SELECT Afri FROM Afrikaans2 WHERE ID =(SELECT ID FROM English2 WHERE English like '" + user + "')");

while (b.next ())
{
data = true;
String afri = b.getString ("Afri");
sb.append (afri);
}
//stmt.close();

if (data == false)
{
new InformationUI ().setVisible (true);
}
}
catch (Exception e)
{
System.out.println ("Error in option 3: " + e.toString ());
}
return sb.toString ();
}
It works fine. But for some odd reason when I use this one for the reverse translation:

public String option3 (String word)
{
StringBuffer sb = new StringBuffer ();
try
{
boolean data = false;
Statement stmt = conn.createStatement ();
ResultSet b = stmt.executeQuery (7401);

while (b.next ())
{
data = true;
String eng = b.getString ("English");
sb.append (eng);
}
//stmt.close();

if (data == false)
{
new InformasieUI ().setVisible (true);
}
}
catch (Exception e)
{
System.out.println ("Error in option 3: " + e.toString ());
}
return sb.toString ();
}
It give me this error :

Error in option 3: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] At most one record can be returned by this subquery.

Error in option 3: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] At most one record can be returned by this subquery.

Can anyone maybe see what the problem might be?

Can you please use code tags.

Code:

---

ResultSet b = stmt.executeQuery (7401);

---

What on earth is this?
This won't compile, so this can't be the code you ran.

As a comment on your other method:

Code:

---

SELECT Afri FROM Afrikaans2 WHERE ID =(SELECT ID FROM English2 WHERE English like '" + user + "')

---

This should be a join between Afrikaans2 and English2, then select where English like etc etc.
Also it ought to be a PreparedStatement...what if the user String is:

Code:

---

"Something'in here"

---

Then your SQL will fail.
Never mind SQL injection.

Quote:

---

Originally Posted by Tolls

Never mind SQL injection.

---

xkcd: Exploits of a Mom

db

Exactly.
Mrs Tolls wouldn't let me name any of our kids that...spoilsport.