Java sql insert return id

Resultset result;
PreparedStatement prep;
String query = "INSERT INTO myRel (data) VALUES (?)";

prep = db.prepareStatement(query ,Statement.RETURN_GENERATED_KEYS);

result = prep.getGeneratedKeys();

if(result.next() && result != null){
   System.out.println("Key: " + result.getInt(1));
} else {
   System.out.println("No, Nop nada");
}

Source: stackoverflow.com

Similar codes

0 vote224 views1 answer
Drop a view in sqlite
SQL
20 votes189 views5 answers
Mysql reset auto increment to 1
SQL
9 votes213 views3 answers
Import DB through mysql console
SQL
7 votes218 views1 answer
Buy forge mods server hosting
SQL
2 votes222 views1 answer
Revokeprivileges mysql
SQL
0 vote245 views1 answer
Creating sqeuence in oracle database
SQL
4 votes215 views1 answer
Mysql ip address data type
SQL
2 votes200 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
4 votes610 views1 answer
Oracle show errors
SQL
0 vote221 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL