How to judge if the resultset having empty rows?
Hi,
I have a problem when processing a resultset.
....
ResultSet rs = null;
rs = statement.executeQuery(SQLstr);
if ( rs != null ) {
//doSomeThingWith the rs
} else {
// warning the user
}
I found that the else clause never been executed even thought the rs get empty set from mysql.
the following is a example when I manually execute the select SQL within mysql:
mysql>select * from tableName where mobile='1383322331';
Empty set (0.01 sec)

