Check if word exists in within a database table in Java

Question

So I have a database, within which there is a table with two columns: rightWord and wrongWord. I wish to select the rightWord value when the wrongWord value is equal to a variable declared in Java. I have the following code so far:

SELECT rightWord FROM dictionaryTable WHERE wrongWord = (?)

existingKeywords.next();
String rightWord = existsingKeywords.getString("rightWord");

That works and I am able to get the first value in rightWord column when wrongWord equals the Java variable. Now, how can I check if the any of the values in the wrongWord column does not match the Java variable? I have the above code in a for loop, and the value of the java variable is different every time.

Please help. Thanks!

Martin Algesten · Accepted Answer · 2010-11-26 19:35:57Z

1

Assuming existingKeywords is your ResultSet. The next() function will return false when there is no value.

Typical usage:

 if (existingKeywords.next()) {
    String rightWord = existingKeywords.getString("rightWord");
 } else {
    // no right word...
 }

answered Nov 26, 2010 at 19:35

Martin Algesten

13.8k4 gold badges56 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Check if word exists in within a database table in Java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related