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 vote192 views1 answer
Template MySQL Zabbix agent
SQL
0 vote179 views1 answer
Set default value now() date
SQL
4 votes178 views1 answer
Sql delete where in select
SQL
2 votes124 views1 answer
Sql view column data type
SQL
0 vote171 views1 answer
Mysql find db contarint
SQL
0 vote238 views1 answer
Mysql row generator
SQL
0 vote137 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote189 views1 answer
Apt install sql server
SQL
4 votes168 views3 answers
Mysql varchar length
SQL
2 votes199 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL