jdbcTemplateは1本のデータを挿入することを実現した後に、idを返します

1102 ワード

jdbcTemplate           ,  id
               KeyHolder key = new GeneratedKeyHolder();
		PreparedStatementCreator psc = new PreparedStatementCreator() {
			
			@Override
			public PreparedStatement createPreparedStatement(Connection con)
					throws SQLException {
				PreparedStatement ps = con.prepareStatement(addSql,PreparedStatement.RETURN_GENERATED_KEYS);
				ps.setString(1, obj.getType());
				ps.setString(2, obj.getUser_id());
				ps.setDouble(3, obj.getCf_amt());
				ps.setString(4, obj.getCreate_tm());
				ps.setString(5, obj.getYbid());
				ps.setString(6,obj.getPbchannel());
				return ps;
			}
		};
		getJdbcTemplate().update(psc,key);
		int cf_id = key.getKey().intValue();
		obj.setCf_id(cf_id);