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 vote164 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
2 votes156 views1 answer
How to delete columns in sql
SQL
0 vote168 views1 answer
How to export only procedures mysql
SQL
13 votes172 views5 answers
Oracle list tables
SQL
0 vote126 views4 answers
Sql limit 1 offset 1
SQL
0 vote216 views1 answer
Copy row from db to db mysql
SQL
19 votes173 views5 answers
Date between in mysql
SQL
0 vote158 views1 answer
Zerar auto increment mysql
SQL
1 vote184 views1 answer
Mysql column start with string
SQL
0 vote191 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL