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;
}