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

2 votes120 views2 answers
Spring where to put the data sql
SQL
0 vote121 views1 answer
Populate db from command line postgres
SQL
0 vote112 views1 answer
Oracle sql log to console
SQL
4 votes127 views2 answers
Bulk kill mysql processlist
SQL
0 vote117 views1 answer
Show tables in cassandra cql
SQL
0 vote116 views1 answer
Sql contains vs like
SQL
1 vote126 views1 answer
Set statiscis on in ssms
SQL
4 votes110 views1 answer
Sql delete where in select
SQL
0 vote106 views1 answer
How to get initials in sql
SQL
0 vote118 views1 answer
Function sum(text) does not exist postgres
SQL