第一种 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";