关于自增返回当前的id值

xiaoxiao2024-05-06  28

第一种 Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/testing","root","root"); System.out.println(conn); stmt=conn.createStatement(); int row=stmt.executeUpdate ("insert into aa (name) values ('mars')",Statement.RETURN_GENERATED_KEYS); rs = stmt.getGeneratedKeys (); if ( rs.next() ) { int key = rs.getInt(row); System.out.println(key); }

 第二种

String sql1 = "select LAST_INSERT_ID() as lastid";

 

转载请注明原文地址: https://www.6miu.com/read-5015195.html

最新回复(0)