利用GeneratedKeyHolder获得新建数据主键值

来源：互联网发布：淘宝白菜价在哪编辑：程序博客网时间：2024/05/20 10:13

Spring利用GeneratedKeyHolder，提供了一个可以返回新增记录对应主键值的方法：

int update(PreparedStatementCreator psc, KeyHolder generatedKeyHolder)

Spring为KeyHolder接口指代了一个通用的实现类GeneratedKeyHolder，该类返回新增记录时的自增长主键值。假设我们希望在新增论坛板块对象后，希望将主键值加载到对象中，则可以按以下代码进行调整：

Java代码

final String INSERT_SQL = "insert into gtable(username,callback) values(?,?)";
KeyHolder keyHolder = new GeneratedKeyHolder();
jdbcTemplate.update(new PreparedStatementCreator() {
public PreparedStatement createPreparedStatement(
Connection connection) throws SQLException {
PreparedStatement ps = connection.prepareStatement(INSERT_SQL,
new String[] { "id" });
ps.setString(1, request.getUsername());
ps.setString(2, request.getCallback());
return ps;
}
}, keyHolder);
logger.debug("id:" + keyHolder.getKey()+"long:"+keyHolder.getKey().longValue());

------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------

实现spring中往oracle数据库插数据后返回主键

KeyHolder keyHolder = new GeneratedKeyHolder();
int rowsAffected = jdbcTemplate.update(new PreparedStatementCreator() {
    public PreparedStatement createPreparedStatement(Connection conn) throws SQLException {
        PreparedStatement ps = conn.prepareStatement(insert_userpayment,new String[] {"id"});
        //ps.setString
         return ps;
                }
     },keyHolder);
    payment.setId(keyHolder.getKey().longValue());// 保存插入的这条记录的主键id

0 0