Mybatis多条件In批量查询方法

1. 在Oracle中in条件不能超过1000个 所以大批量数据需要分批查询
   Repository中做分批处理

        select t.a, t.b, t.c ,t.d 
        from tableName t
        WHERe 
        (t.a,t.b) in
        
            (#{item.attribute1},#{item.attribute2})
        
    

List selectByattribute1Andattribute2(                                           @Param("list") List list);

public class HpsMtMoAssActualQueryVo implements Serializable {

	private static final long serialVersionUID = -3577726134433110319L;
	private Long attribute1;
	private Long attribute2;

	public Long getAttribute1() {
		return attribute1;
	}

	public void setAttribute1(Long attribute1) {
		this.attribute1 = attribute1;
	}

	public Long getAttribute2() {
		return attribute2;
	}

	public void setAttribute2(Long attribute2) {
		this.attribute2= attribute2;
	}
}

@Component
public class MoAssActualRepositoryImpl extends BaseRepositoryImpl implements MoAssActualRepository {
	private static final int MaxInSize = 1000;

	private final MoAssActualMapper moAssActualMapper;

	@Autowired
	public MoAssActualRepositoryImpl(MoAssActualMapper moAssActualMapper) {
		this.moAssActualMapper = moAssActualMapper;
	}

	@Override
	public List selectByMoIdAndMaterialId(Long tenantId, List list){
		if(CollectionUtils.isEmpty(list)){
			return null;
		}
		List moAssActuals = new ArrayList<>(list.size());
		int valueSize = list.size();
		if (valueSize==1){
			moAssActuals = moAssActualMapper.selectByMoIdAndMaterialId(tenantId, list);
		}else {
			int batchSize = valueSize/MaxInSize+(valueSize % MaxInSize == 0 ? 0 : 1);
			for (int i = 0; i < batchSize; i++) {
				// 获取list中 最多1000条数据
				List queryVoList = list.stream()
						.skip(i*MaxInSize).limit(MaxInSize).collect(Collectors.toList());
				List resultList = moAssActualMapper.selectByMoIdAndMaterialId(tenantId, queryVoList);
				moAssActuals.addAll(resultList);
			}
		}
		return moAssActuals;
	}
}