我就廢話不多說了，大家還是直接看代碼吧~
|
1
2
|
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
|
1
2
3
|
SELECT COUNT(1)FROM hr_deliver_employ_contractWHERE (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語句
|
1
2
3
|
select * from vehicle where (sim is null or sim='') and is_delete=‘0'QueryWrapper queryWrapper = new QueryWrapper();queryWrapper .eq(“name”,“測試”).or().eq(“sim”,“2”); |
對應sql語句
|
1
|
select * from vehicle where name=‘測試' or sim=‘2' |
以上為個人經驗，希望能給大家一個參考，也希望大家多多支持服務器之家。如有錯誤或未考慮完全的地方，望不吝賜教。
原文鏈接：https://blog.csdn.net/liuming690452074/article/details/82775614
