代码如下所示,主要是想插入一条数据后,返回该记录的主键,主键是自增的int(11)类型.
public int executeUpdate(String sql) {
int ret = 0;
try {
stmt=conn.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS);
ret = stmt.executeUpdate(sql);
ResultSet rs=stmt.getGeneratedKeys();
if (rs.next()) {
Long id = rs.getLong(1);
System.out.println("数据主键:" + id); }
} catch (SQLException e) {
e.printStackTrace();
}
return ret;
}
然后报错如下:
java.sql.SQLException: Generated keys not requested. You need to specify Statement.RETURN_GENERATED_KEYS to Statement.executeUpdate(), Statement.executeLargeUpdate() or Connection.prepareStatement().
请问该如何修改?