java sql insert return id

Solutions on MaxInterview for java sql insert return id by the best coders in the world

Search
showing results for - "java sql insert return id"
Iris
19 Oct 2017
1Resultset result;
2PreparedStatement prep;
3String query = "INSERT INTO myRel (data) VALUES (?)";
4
5prep = db.prepareStatement(query ,Statement.RETURN_GENERATED_KEYS);
6
7result = prep.getGeneratedKeys();
8
9if(result.next() && result != null){
10   System.out.println("Key: " + result.getInt(1));
11} else {
12   System.out.println("No, Nop nada");
13}
14
source
similar questions
sql insert exemploidentity insert on sql serverrows 2c insert into 2c returninghow to get inserted id in sqlinsert intohttpwebclient request and insert to sql serverinsert output identitysql insertedsql server insert intosql insert inserted ididentity insert is set to off
queries leading to this page
insert into sql using java get idjava insert sql with idjdbc insert return idjava sql insert return valueinsert into sql and get id java java sql get id after insertjava sql insert return id