springmvc的jdbcTemplate 插入返回主键-CSDN博客

本文介绍如何利用JDBC技术实现客户信息的插入操作，包括SQL语句的编写、参数设置以及使用GeneratedKeyHolder获取自增ID。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

    public int insertCustomer(final Customer customer) {
       //TODO.
       final String sql = "insert into customer (mobile,nickname,password,score,avatar,push_key,reg_time) values(?,?,?,?,?,?,now())";
        KeyHolder keyHolder = new GeneratedKeyHolder();
        jdbcTemplate.update(new PreparedStatementCreator() {
            @Override
            public PreparedStatement createPreparedStatement(Connection conn) throws SQLException {
                PreparedStatement ps = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
                ps.setString(1, customer.getMobile());
                ps.setString(2, customer.getNickname());
                ps.setString(3, customer.getPassword());
                ps.setInt(4, customer.getScore());
                ps.setString(5, customer.getAvatar());
                ps.setString(6,customer.getPushKey());
               // ps.setString(7, customer.getRegTime());
                return ps;
            }
        }, keyHolder);
        return keyHolder.getKey().intValue();
   }