首页 > 数据库技术 > 详细

Spring3.0.5 获取表中自增的主键(mysql)

时间:2014-04-20 23:52:37      阅读:924      评论:0      收藏:0      [点我收藏+]
bubuko.com,布布扣
    public int addWsstxCotent(final WsstxContent wsstxContent) {
        final String sql = "insert into wsstx_content(sstx_type,sstx_content,sstx_title,opr_time,ts_tag) values(?,?,?,now(),?)";
//        this.jdbcTemplate.update(sql,
//                new Object[]{wsstxContent.getSstxType(), wsstxContent.getSstxContent(),wsstxContent.getSstxTitle(), wsstxContent.getTsTag()});
        KeyHolder keyHolder = new GeneratedKeyHolder();  
        this.jdbcTemplate.update(
                new PreparedStatementCreator() {
                    public PreparedStatement createPreparedStatement(Connection conn) throws SQLException {
                        PreparedStatement ps = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
                        ps.setInt(1, wsstxContent.getSstxType());
                        ps.setString(2, wsstxContent.getSstxContent());
                        ps.setString(3, wsstxContent.getSstxTitle());
                        ps.setString(4, wsstxContent.getTsTag());
                        return ps;
                    } 
                } ,  keyHolder);
        int generatedId = keyHolder.getKey().intValue();
        return generatedId;
    }
bubuko.com,布布扣

 

Spring3.0.5 获取表中自增的主键(mysql),布布扣,bubuko.com

Spring3.0.5 获取表中自增的主键(mysql)

原文:http://www.cnblogs.com/yshyee/p/3676007.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!