How can I get the SQLite result?

Question

Java

There is a code:

Connection cn = DriverManager.getConnection(road_to_DB);
Statment st = cn.createStatment();
//сам запрос:
if(st.executeQuery("SELECT * FROM users WHERE name = 'name'") == null) {
//TODO...... 
return;
}

How to get null from table if record does NOT exist. Returns [email protected] How to get null?

Answer 1

Try like this:

ResultSet result = st.executeQuery("SELECT * FROM users WHERE name = 'name'");
if (!result.isBeforeFirst() ) {    
   // вернулось 0 строк
}

According to documentation:

Returns:
true if the cursor is before the first row; false if the cursor is at any other position or the result set contains no rows