JdbcTemplate用法学习总结

JdbcTemplate学习常用用法

1.查询返回给对象列表

List<Object> list = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(object.class));

其中Object为属性与每条查询返回数据对应的对象

2. 通过resultSet操作结果

List<Object> outList = new ArrayList<>();
jdbcTemplate.query(sql, conditionList.toArray(), resultSet -> {
	Object ob = new Object();
	ob.setArgs1(resultSet.getString(“colName1”));
	ob.setArgs2(resultSet.getString(“colName2”));
	outList.add(ob)
}

3.批量插入数据

List<Object> list;  //存放要插入对象的列表，对象属性对应表的列

String sql = "insert into TableA (arg1, arg2, arg3, arg4) values (?, ?, ?, ?)"
 
jdbcTemplate.batchUpdate(sql, new BatchPreparedStatementSetter(){
	
	@Override
	public void setValues(PreparedStatement ps, int i) throws SQLException{
		Object ob = list.get(i);
		ps.setString(1,ob.getArgs1());
		ps.setString(2,ob.getArgs2());
		ps.setString(3,ob.getArgs3());
		ps.setInt(4,ob.getArgs4());
	}

	@override
	public int getBatchSize(){return list.size;}

})

其他用到了再总结