Checking if SELECT statement returns Empty set in Java, Mysql

Question

I filled an array using .split(" ") on a string containing a paragraph of text scanned from a webpage. I would like to insert each element of the array into a table but only if said word does not already exist in the table. So each word should only exist in the table once.

I am using the following statement to check if the word exists in the table already:

SELECT * FROM table WHERE word = "**Word to check for**";

In my java program, how can I check if the statement returns an empty set or not? i.e. what would be the condition of my if statement? Would I check if the above SELECT query returns 0 rows?

Thanks,

Your query returns the whole row(s) and not a single integer. What you probably need is select count(*) .... — Bhesh Gurung
– Bhesh Gurung, Commented Apr 10, 2014 at 4:03
possible duplicate of Java ResultSet how to check if there are any results — Jabir
– Jabir, Commented Apr 10, 2014 at 4:04

pundit · Accepted Answer · 2014-04-10 04:13:54Z

1

If resultSet.next() returns true then the word is present in the table and no need to check the number of rows.

This way you will query the DB for two times. Rather consider using stored procedure.

answered Apr 10, 2014 at 4:13

pundit

3121 silver badge7 bronze badges

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

2 Comments

Reece Kenney Over a year ago

Excellent, thank you very much sir! This is a much easier implementation than I was thinking of!

pundit Over a year ago

You are welcome. If you are doing this for a real time project then try to use stored procedure. Learning curve is there but it is much better than embedded query.

Collectives™ on Stack Overflow

Checking if SELECT statement returns Empty set in Java, Mysql

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related