SQL Count into a Java var 1

[Smarty]

I have the following line:
int newmes = s.executeUpdate("SELECT COUNT(*) FROM messages where MessageTo = " + rs.getInt("MemberID&quot);

But it always returns 0 and not the count value. I assume 0 is the state of execution, but how can I have the count because I need to use that in the rest of my program!

Thanx in advance

Smarty

 

[varocho]

Try using the executeQuery() method instead.

 

[AdamRice32]

If you look at the javadocs for executeUpdate(), it states:

"Returns:  either the row count for INSERT, UPDATE or DELETE statements; or 0 for SQL statements that return nothing"

That's why you're always getting a return value of 0.

To remedy this, you want to call the executeQuery() method of the PreparedStatement instance. This returns a ResultSet instance on which you would then call

getInt("COUNT(*)")

.

Hope this helps,
Adam