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 vote301 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote215 views1 answer
Psql no such file or directory
SQL
-1 vote196 views2 answers
Mysql get day of week
SQL
0 vote184 views1 answer
Mysql with
SQL
79 votes558 views6 answers
Grepper code
SQL
0 vote206 views1 answer
Replace divide by zero error with 0 in sql
SQL
16 votes250 views6 answers
Python sqlite
SQL
0 vote241 views1 answer
How to create notes in mysql
SQL
-1 vote205 views1 answer
Ms sql select datetime as date
SQL
2 votes213 views3 answers
Application.properties spring boot mysql
SQL