Processing auto fields in MySQL

Article field:

Id: auto

Pid: the value of id is not of the auto type.

Title: String

Processing:

Insert a record:

 

Connnection conn = ...;

String SQL = "insert into article values (null ,? ,?) ";

// The following statements generate a PreparedStatement with an automatic return type.

PreparedStatement pstmt = conn. PreparedStatement (SQL, PreparedStatement. RETURN_GENERATED_KEYS );

// Here the returned automatic type will be placed in a ResultSet and can be taken out (there is only one automatic type here)
ResultSet rsKeys = pstmt. getGeneratedKeys ();

Pstmt. setInt (1,-1 );

Pstmt. setString (2, title );

Pstmt.exe cuteUpdate ();

RsKeys. next ();

Int pid = rsKeys. getInt (1 );

RsKeys. close;

Statement stmt = conn. createStatement ();

Stmt.exe cute ("update article set pid =" + pid + "where id =" + pid );

Stmt. close;

Conn. commit ();

 

 

</