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

3 votes279 views1 answer
How to get list of synonyms in oracle
SQL
1 vote270 views1 answer
Ms sql how to see active job current run time
SQL
2 votes315 views1 answer
Query to find table size in oracle 12c
SQL
0 vote336 views1 answer
What is initial catalog in sql connection string
SQL
13 votes290 views5 answers
Oracle list tables
SQL
0 vote296 views1 answer
Select other columns with distinct
SQL
9 votes336 views1 answer
No sql
SQL
0 vote295 views1 answer
Sql select non unique
SQL
0 vote309 views1 answer
Replace \n sql
SQL
0 vote312 views1 answer
Oracle db get table sizes
SQL