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 vote110 views1 answer
Psql list view rules
SQL
17 votes104 views6 answers
Current date in sql
SQL
0 vote100 views1 answer
Delete insert record in sql server
SQL
0 vote98 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
4 votes108 views1 answer
Postgresql create table with index
SQL
1 vote106 views1 answer
Postgres regex remove special characters
SQL
0 vote100 views3 answers
Convert sql query to python pandas
SQL
1 vote105 views2 answers
Pl sql case
SQL
0 vote89 views1 answer
How to create an SQL save method in ruby
SQL
4 votes103 views1 answer
To date oracle with time
SQL