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 vote142 views1 answer
Sql value exists in column
SQL
2 votes132 views2 answers
How to check database username and password in postgresql
SQL
0 vote161 views1 answer
Table user postgres
SQL
10 votes124 views3 answers
Sql limit results
SQL
0 vote153 views1 answer
.sql File Run in PSQL
SQL
2 votes129 views1 answer
Oracle index size calculation
SQL
3 votes142 views1 answer
Sql insert inserted id
SQL
0 vote132 views1 answer
Changer un mot de passe mysql
SQL
2 votes132 views1 answer
Sql update from different table
SQL
2 votes160 views1 answer
Select a certain number of entries from select mysql
SQL