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 votes373 views2 answers
Postgresql database url
SQL
2 votes339 views1 answer
Mariadb select multiple rows into one column
SQL
0 vote357 views1 answer
Postgresql create query
SQL
0 vote374 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote373 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote338 views1 answer
How to print records of employees hired in particular month in oracle
SQL
18 votes341 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote350 views3 answers
Query string not ending with with vowels
SQL
1 vote322 views2 answers
Mysql SELECT
SQL
0 vote343 views1 answer
Commit transaction sql
SQL