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 vote124 views2 answers
Update query with between in mysql
SQL
1 vote118 views1 answer
Autocommit mysql
SQL
1 vote71 views1 answer
How to run sql script
SQL
0 vote121 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote117 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote103 views1 answer
Lister les index d'une table oracle
SQL
0 vote128 views1 answer
How we can perform acid Operations in sql with examples
SQL
29 votes118 views6 answers
Delete all rows from table mysql
SQL
0 vote138 views1 answer
Generate sql from specific migration ef core
SQL
2 votes117 views1 answer
Install sqlite npm
SQL