jdbcTemplate得到自增的ID

最新推荐文章于 2023-05-18 11:37:14 发布

xiaoqidela

最新推荐文章于 2023-05-18 11:37:14 发布

阅读量739

点赞数

分类专栏： java

本文链接：https://blog.youkuaiyun.com/xiaoqidela/article/details/79176218

版权

java 专栏收录该内容

7 篇文章

订阅专栏

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;

import org.springframework.jdbc.support.GeneratedKeyHolder;
import org.springframework.jdbc.support.KeyHolder;


KeyHolder keyHolder = new GeneratedKeyHolder();
jdbcTemplate.update(new PreparedStatementCreator() {
   public PreparedStatement createPreparedStatement(Connection conn)
         throws SQLException {
      PreparedStatement ps = conn.prepareStatement("insert into contacts_test(name) values('ss')"
            , Statement.RETURN_GENERATED_KEYS);
      return ps;
   }
}, keyHolder);
System.out.println("新插入数据的主键是：" + keyHolder.getKey().intValue());