取得数据库自动生成的主键

获得数据库自动生成的主键

Connectionconn = JdbcUtil.getConnection();

Stringsql = "insert into user(name,password,email,birthday)

? values('abc','123','abc@sina.com','1978-08-08')";

PreparedStatement st =conn.

? prepareStatement(sql,Statement.RETURN_GENERATED_KEYS );

st.executeUpdate();

ResultSet rs =st.getGeneratedKeys();?//得到插入行的主键

if(rs.next())

? System.out.println(rs.getObject(1));

?