Use JDBC to obtain the primary key ID generated after insert

Sometimes, after inserting data with insert, you can use getgeneratedkeys of JDBC to obtain the ID of the primary key generated after insert. In this example, the database is MySQL and the primary key ID is of the int type, which is generated using auto_increment.

 

 

The following are the main java code:
:

PS = conn. preparestatement ("insert into test (name) value (?) ", Statement. return_generated_keys); <br/> ps. setstring (1, "test"); <br/> ps.exe cute (); <br/> rs = ps. getgeneratedkeys (); <br/> int id = 0; // Save the generated id <br/> If (RS! = NULL & Rs. Next () {<br/> id = Rs. getint (1) <br/>}

The main methods used in this example are as follows:

1. preparedstatementPreparestatement
(String SQL,
Int autogeneratedkeys)
Throws sqlexception (in the Java. SQL. connection interface)

2. resultsetGetgeneratedkeys
()
Throws sqlexception (in the Java. SQL. preparedstatement Interface)