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

6 votes180 views1 answer
Rank function in oracle with example
SQL
0 vote227 views2 answers
SQL Server Standard
SQL
1 vote196 views1 answer
Mysql count multiple columns in one query
SQL
8 votes277 views2 answers
Change name of colum in sql table
SQL
0 vote198 views1 answer
Sql server datetime to string
SQL
1 vote192 views1 answer
Create another table from existing table sql oracle
SQL
0 vote196 views1 answer
Drop column from local database postgres pgadmin
SQL
5 votes217 views1 answer
Oracle asynchronous query
SQL
0 vote294 views3 answers
Get count of null in column sql
SQL
0 vote198 views1 answer
Sql where part of string match
SQL