mysql获取刚insert的记录ID
?当数据库表的主键使用mysql的自增ID时,获取一条刚插入的记录的ID可以?使用:
rs = pstmt.getGeneratedKeys();
if(rs.next()) {
??????? personId = rs.getInt(1);
}
?
附程序中的一个例子:
?????
public int addPerson(Person person) {int personId = 0;Connection conn = null;PreparedStatement pstmt = null;ResultSet rs = null;try {String sql = "INSERT INTO t_person(personname, gender, age, address, duty, phone, description, receivesms) VALUES(?, ?, ?, ?, ?, ?, ?, ?)";conn = DB.getConn();pstmt = DB.prepareStmt(conn, sql);pstmt.setString(1, person.getPersonname());pstmt.setString(2, person.getGender());pstmt.setInt(3, person.getAge());pstmt.setString(4, person.getAddress());pstmt.setString(5, person.getDuty());pstmt.setString(6, person.getPhone());pstmt.setString(7, person.getDescription());pstmt.setInt(8, person.isReceivesms() ? 1 : 0);pstmt.executeUpdate();rs = pstmt.getGeneratedKeys();if(rs.next()) {personId = rs.getInt(1);}} catch (SQLException e) {e.printStackTrace();} finally {DB.close(pstmt);DB.close(conn);}return personId;}?
?