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 vote127 views1 answer
Sql alternative to max statement
SQL
0 vote144 views1 answer
Python mysql executemany
SQL
3 votes119 views1 answer
Postgresql cast
SQL
1 vote123 views2 answers
ImportError: No module named mysql.connector
SQL
0 vote127 views3 answers
Condition in count sql
SQL
18 votes132 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
17 votes146 views4 answers
Mysql remove ubuntu
SQL
0 vote136 views1 answer
Safe mysql
SQL
3 votes171 views2 answers
How to View column names of a table in SQL
SQL
3 votes137 views2 answers
Oracle apex view logs
SQL