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 vote145 views1 answer
Delete * from where id = 1;
SQL
0 vote187 views1 answer
Sql to excel pgadmin
SQL
8 votes173 views1 answer
My sql version
SQL
14 votes162 views4 answers
Online sql compiler
SQL
0 vote198 views1 answer
Sqlalchemy query return only n results
SQL
0 vote145 views1 answer
Sql server 2012 create or alter procedure
SQL
0 vote156 views1 answer
Create a sql server database programmatically
SQL
15 votes149 views6 answers
Psql
SQL
0 vote142 views1 answer
Postgresql update to unique
SQL
0 vote138 views1 answer
View acl table oracle
SQL