java返回新插入数据库的记录的id(数据库设计表id为自增长)
//正常写法是: pstmt = conn.prepareStatement(sql);
pstmt = conn.prepareStatement(sql,
PreparedStatement.RETURN_GENERATED_KEYS);
pstmt.setString(1, lab.getLname());
pstmt.setString(2, lab.getTypeid());
pstmt.setInt(3, lab.getFloor());
pstmt.setDate(4, new Date(lab.getBuildTime().getTime()));
pstmt.setInt(5, lab.getSites());
result = pstmt.executeUpdate();
if (result != 0) {
ResultSet rs = this.pstmt.getGeneratedKeys();// 返回一个ResultSet对象,该对象包含此PreparedStatement对象执行的自动生成的键
if (rs.next()) {
lab.setId(rs.getString(1));
}
} else {
lab = null;
}