public int addClifford(Clifford clifford) { String sql = "insert into t_user_clifford(mobile,last_activity_date,clifford_count,is_share)values(?,?,?,?)"; int idResult = 0; KeyHolder keyHolder = new GeneratedKeyHolder(); jdbcTemplateActivityWrite.update(new PreparedStatementCreator() { @Override public PreparedStatement createPreparedStatement(Connection connection) throws SQLException { PreparedStatement ps = connection.prepareStatement(sql,PreparedStatement.RETURN_GENERATED_KEYS); ps.setObject(1,clifford.getMobile()); ps.setObject(2,clifford.getLastActivityDate()); ps.setObject(3,clifford.getCliffordCount()); ps.setObject(4,clifford.getIsShare()); return ps; } },keyHolder); idResult = keyHolder.getKey().intValue(); return idResult; }