jdbcTemplate获取刚插入的ID

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

df_jxnu

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

阅读量544

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

本文链接：https://blog.youkuaiyun.com/df_jxnu/article/details/84168164

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());