Spring jdbc

BatchUpdateTest.java

	@Test 
	public void batchUpdateTest(){
		
		SqlParameterSource[] source =  new SqlParameterSource[]{new MapSqlParameterSource("id", 1), new MapSqlParameterSource("id", 2),new MapSqlParameterSource("id", 3)};
		
		int[] updated = simpleJdbcTemplate.batchUpdate("update perform set id=:id where id = :id", source);
		System.out.println(Arrays.toString(updated));
	}

KeyHolderExample.java

	public Integer insertAndGetSeq(Book book) {
		SqlParameterSource params = new BeanPropertySqlParameterSource(book);
		KeyHolder keyHolder = new GeneratedKeyHolder(); 

		jdbc.update(WidgetSqls.insert, params, keyHolder);
		return keyHolder.getKey().intValue();
	}

SimpleJdbcInsertAndGetKey.java

	public Integer insertAndGetSeq(Book input) {
		SqlParameterSource params = new BeanPropertySqlParameterSource(input);
		SimpleJdbcInsert insertAction = new SimpleJdbcInsert(dataSource).withTableName("book");
		insertAction.setGeneratedKeyName("seq");
												
		KeyHolder keyHolder = insertAction.executeAndReturnKeyHolder(params);
		return keyHolder.getKey().intValue();
	}

SimpleJdbcInsertTest.java

	private void insert(Book input) {
		SqlParameterSource params = new BeanPropertySqlParameterSource(input);
		SimpleJdbcInsert insertAction = new SimpleJdbcInsert(ds).withTableName("book");
		insertAction.execute(params);
	}