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 vote312 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote312 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote346 views1 answer
Error code 1241 mysql
SQL
0 vote347 views1 answer
Insert ip address in mysql
SQL
0 vote325 views2 answers
How to generate a unique random number in mysql
SQL
1 vote322 views1 answer
How to use a trigger to validate input data
SQL
3 votes343 views1 answer
Oracle APEX elapsed time
SQL
0 vote312 views1 answer
SQL Server modify_timestamp trigger
SQL
2 votes311 views2 answers
Laravel query builder toSql
SQL
2 votes352 views1 answer
Coalesce sql
SQL