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

1 vote185 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote189 views1 answer
Tsql default value when no value returned by query
SQL
15 votes179 views4 answers
T-sql drop function if exists
SQL
-1 vote200 views1 answer
Default username and password for oracle 11g
SQL
0 vote253 views1 answer
What is common table expression in sql
SQL
3 votes195 views1 answer
Oracle transaction commit rollback example
SQL
12 votes200 views5 answers
Rename table in mysql
SQL
0 vote203 views1 answer
Create function in microsoft sql server
SQL
0 vote183 views1 answer
Contraint default SQL
SQL
5 votes181 views1 answer
Pl sql asynchronous procedure calls
SQL