Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how to obtain Mysql automatic growth field by JDBC". In the operation of actual cases, many people will encounter such a dilemma. Next, let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

The function of Mysql aotu_increment is often used in master-slave relationships. MySQL does not have a special sequence of oracle, and previous projects have used select max (*) to implement this function. Later, there is one more select than the method of issuing max (*), which is certainly not as efficient as using java.

Method 1. There is select LAST_INSERT_ID () to get the final auto_increment. You can use select last_insert_id () instead of max (*) so that the auto_increment field can be set in the data table. This method has a great advantage over max (*) in multithreaded concurrent operations.

Method 2. Use java to provide getGeneratedKeys to get the final increment ID.

The snippet code is as follows:

Pstmt.executeUpdate ()

Conn.commit ()

/ / obtain auto_increment

Int aotuId

Rs = pstmt.getGeneratedKeys ()

While (rs.next ()) {

AutoId = rs.getInt (1)

}

This is the end of the content of "how to get the Mysql auto-growth field for JDBC". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.