mybatis plus or and 合并写法

mybatis plus or and 合并写法 2023-11-21 484

int count =hrDeliverEmployContractService.selectCount(new EntityWrapper<HrDeliverEmployContractEntity>()
                .eq("pool_id",hrDeliverEmployContract.getPoolId()).andNew().lt("contract_start_date",hrDeliverEmployContract.getContractStartDate()).or().gt("contract_end_date",hrDeliverEmployContract.getContractEndDate())  );

对应的SQL

SELECT COUNT(1)
 FROM hr_deliver_employ_contract
 WHERE (pool_id = 1) AND (contract_start_date < 2018-07-01 00:00:00.0 OR contract_end_date > 2018-10-31 00:00:00.0);

mybatis plus or使用

1 2 3 QueryWrapper queryWrapper = new QueryWrapper(); queryWrapper .and(wrapper -> wrapper.isNull(“sim”).or().eq(“sim”, “”)); queryWrapper .eq(“is_delete”, “0”);

对应SQL

select * from vehicle where name=‘测试 or sim=‘2

免费搭建微信查券返利机器人来轻松赚佣金