How to obtain the inserted auto-increment ID in MySQL

I briefly summarized the methods I currently know.

1. Package
   Test;
3. Import
   Java. SQL. connection;
4. Import
   Java. SQL. drivermanager;
5. Import
   Java. SQL. resultset;
6. Import
   Java. SQL. statement;
8. /**
9. * Three Methods to automatically generate a primary key are available.
10. *
11. * @ Author Zhao Xueqing www.java2000.net
    
12. *
13. */
14. Public
    Class
    Testgetpk {
16. Public
    Static
    Void
    Main (string [] ARGs) throws
    Exception {
17. Class. forname ("com. GBASE. JDBC. Driver"
    );
18. String url = "JDBC: GBASE: // localhost/mytest"
    ;
19. Connection con = drivermanager. getconnection (URL, "root"
    , 111111"
    );
21. System. Out. println (getpk1 (CON ));
22. System. Out. println (getpk2 (CON ));
23. System. Out. println (getpk3 (CON ));
24. }
26. /**
27. * Use getgeneratedkeys provided by JDBC 3.0. Recommended
28. *
29. * @ Param con
30. * @ Return
31. * @ Throws exception
32. */
33. Public
    Static
    Long
    Getpk1 (connection con) throws
    Exception {
34. Statement stmt = con. createstatement ();
35. Stmt.exe cuteupdate ("insert into t_type (name) values ('Can I get the auto increment field? ')"
    ,
36. Statement. return_generated_keys );
38. Int
    Autoinckeyfromapi =-1
    ;
39. Resultset rs = stmt. getgeneratedkeys ();
    
40. If
    (Rs. Next ()){
    
41. Autoinckeyfromapi = Rs. getint (1
    );
    
42. }
    
43. Return
    Autoinckeyfromapi;
44. }
46. /**
47. * Use your own special SQL.
48. *
49. * @ Param con
50. * @ Return
51. * @ Throws exception
52. */
53. Public
    Static
    Long
    Getpk2 (connection con) throws
    Exception {
54. Statement stmt = con. createstatement ();
55. Stmt.exe cuteupdate ("insert into t_type (name) values ('Can I get the auto increment field? ')"
    ,
56. Statement. return_generated_keys );
58. Int
    Autoinckeyfromfunc =-1
    ;
59. Resultset rs = stmt.exe cutequery (
    
    "Select last_insert_id ()"
    );
    
60. If
    (Rs. Next ()){
61. Autoinckeyfromfunc = Rs. getint (1
    );
62. }
63. Return
    Autoinckeyfromfunc;
64. }
66. /**
67. * Use updatable result sets.
68. *
69. * @ Param con
70. * @ Return
71. * @ Throws exception
72. */
73. Public
    Static
    Long
    Getpk3 (connection con) throws
    Exception {
74. Statement stmt = con. createstatement (Java. SQL. resultset. type_forward_only,
75. Java. SQL. resultset. concur_updatable );
76. Resultset rs = stmt.exe cutequery ("select * From t_type"
    );
77. Rs. movetoinsertrow ();
78. Rs. updatestring ("name"
    , "Auto increment here? "
    );
79. Rs. insertrow ();
80. Rs. Last ();
81. Int
    Autoinckeyfromrs = Rs. getint ("ID"
    );
82. Return
    Autoinckeyfromrs;
83. }
84. }