mysql获取插入的id主键
时间：2021-07-01 10:21:17
帮助过：29人阅读
_retId = -1
;
Connection con =
null;
try {
con =
queryRunner.getDataSource().getConnection();
queryRunner.update(con, sql.toString(), val);
Object _ret = queryRunner.query(con, "SELECT LAST_INSERT_ID() FROM " + getTableName(),
new ScalarHandler());
if (_ret
instanceof BigInteger) {
_retId =
((BigInteger) _ret).longValue();
} else if (_ret
instanceof Long) {
_retId =
(Long) _ret;
} else {
_retId =
((Integer) _ret).longValue();
}
} catch (SQLException e) {
throw e;
} finally {
ConnectionUtils.closeConnection(con);
}
注意：必须使用同一个Connection，否则会获取不到想要的结果
mysql获取插入的id主键
标签：null run long 注意 on() integer select insert eof
