JdbcTemplate中batchUpdate批量执行sql

	String sql = "delete from orders where orderId=?";
	//返回值为一个整数数组
		int result[] = jdbcTemplate.batchUpdate(sql, new BatchPreparedStatementSetter() {
			@Override
			public void setValues(PreparedStatement ps, int i) throws SQLException {
				// TODO Auto-generated method stub
				//1表示为第一个参数orderId赋值
				ps.setObject(1, orderIds[i]);
			}
			@Override
			public int getBatchSize() {
				// TODO Auto-generated method stub
				//返回将要执行的sql语句数量  此处为有多少个id参数就执行多少次
				return orderIds.length;

			}
		});