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 vote373 views1 answer
Capabilities of sql select statements
SQL
4 votes344 views1 answer
Sql delete where in select
SQL
2 votes399 views2 answers
Mysql compare datetime to another datetime
SQL
0 vote350 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote346 views1 answer
Php get closest location by latitude longitude
SQL
0 vote397 views1 answer
Oracle show grants on table
SQL
1 vote338 views1 answer
Adding a default constraint to an existing column in sql
SQL
8 votes346 views1 answer
Show mysql user table
SQL
1 vote337 views1 answer
How to select department from table
SQL
5 votes302 views1 answer
Copy table from one database to another mysql
SQL