jdbcTemplate获取刚插入的ID

最新推荐文章于 2023-03-12 10:49:06 发布

原创最新推荐文章于 2023-03-12 10:49:06 发布 · 544 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

final String sqlSave = sql.toString();
			final List<Object> argsSave = args;
			KeyHolder keyHolder = new GeneratedKeyHolder();
			jdbcTemplate.update(new PreparedStatementCreator() {
				@Override
				public PreparedStatement createPreparedStatement(Connection con) throws SQLException {
					PreparedStatement ps = con.prepareStatement(sqlSave, Statement.RETURN_GENERATED_KEYS);
					for (int i = 0; i < argsSave.size(); i++) {
						ps.setObject(i + 1, argsSave.get(i));
					}
					return ps;
				}
			}, keyHolder);
			code = String.valueOf(keyHolder.getKey().intValue());