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 vote156 views1 answer
Oracle list chain steps
SQL
1 vote169 views1 answer
DATE_SUB postgres
SQL
0 vote215 views1 answer
Sql pivot table
SQL
41 votes253 views6 answers
Alter table add column in SQL Server
SQL
0 vote171 views1 answer
User defined variables in sql
SQL
0 vote186 views1 answer
Mssql + bit + in python orm
SQL
3 votes161 views1 answer
Oracle user quota unlimited
SQL
0 vote172 views1 answer
Sql list dates between two dates
SQL
4 votes171 views1 answer
Phone number sql
SQL
2 votes167 views1 answer
How to insert string variable into sqlite database
SQL