JdbcTemplate批处理

  |   0 评论   |   0 浏览
	final List<Student> students = dao.queryStudents();
	
	//定义sql
	String insertSql = "insert into student (id,name,age) values ( ?, ?, ?)";
	
	jdbcTemplate.batchUpdate(insertSql, new BatchPreparedStatementSetter(){

		@Override
		public void setValues(PreparedStatement ps, int i) throws SQLException {
			Student item = students.get(i);
			ps.setString(1, item.getId());
			ps.setString(2, item.getName());
			ps.setString(3, item.getAge());
		}

		@Override
		public int getBatchSize() {
			return students.size();
		}
		
	});