
复制import java.sql.*; public class GetKey { ResultSet rs = null; Connection conn = null; Statement stmt = null; // 加入同一个连接发生其他查询,自动增长主键Key会被重写所以不准确 public void getId() { try { getConnect gc = new getConnect(); conn = gc.getconn(); Statement stmt = conn.createStatement(); stmt.executeUpdate("insert into tb (name) values (Key)"); rs = stmt.executeQuery("SELECT LAST_INSERT_ID()"); int autoIncKeyFromFunc = -1; if (rs.next()) { autoIncKeyFromFunc = rs.getInt(1); System.out.println("autoIncKeyFromFunc: " + autoIncKeyFromFunc); } } catch (Exception e) { System.out.print("有异常发生!自动增长主键
"); } } // getGeneratedKeys()是自动增长主键
每次创建一个Statement 实例,
香港云服务器所以是自动增长主键安全的!
服务器租用 public void getId_() { try { getConnect gc = new getConnect(); conn = gc.getconn(); stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,自动增长主键 java.sql.ResultSet.CONCUR_UPDATABLE); stmt.executeUpdate("insert into tb (name) values (x)"); int autoIncKeyFromApi = -1; rs = stmt.getGeneratedKeys(); if (rs.next()) { autoIncKeyFromApi = rs.getInt(1); System.out.println("Key returned from getGeneratedKeys():" + autoIncKeyFromApi); } } catch (Exception e) { System.out.print("有异常发生!自动增长主键"); } } public static void main(String[] args) { GetKey get = new GetKey(); get.getId(); get.getId_(); } } 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.