int questionId = 0; //保存题目 try { final String sql="insert into question(paper_id,order_no,question_text) values(?,?,?)"; KeyHolder keyHolder = new GeneratedKeyHolder(); this.getJdbcTemplate().update(new PreparedStatementCreator () { public PreparedStatement createPreparedStatement(Connection arg0) throws SQLException { PreparedStatement ps = getJdbcTemplate().getDataSource() .getConnection().prepareStatement(sql, PreparedStatement.RETURN_GENERATED_KEYS); ps.setInt(1,questionDto.getPaperId()); ps.setInt(2, questionDto.getOrderNo()); ps.setString(3, questionDto.getQuestionText()); return ps; } }, keyHolder); questionId = keyHolder.getKey().intValue();