mybatis plus or and 的合并写法实例
我就废话不多说了,大家还是直接看代码吧~
intcount=hrDeliverEmployContractService.selectCount(newEntityWrapper() .eq("pool_id",hrDeliverEmployContract.getPoolId()).andNew().lt("contract_start_date",hrDeliverEmployContract.getContractStartDate()).or().gt("contract_end_date",hrDeliverEmployContract.getContractEndDate()));
对应的SQL
SELECTCOUNT(1) FROMhr_deliver_employ_contract WHERE(pool_id=1)AND(contract_start_date<'2018-07-0100:00:00.0'ORcontract_end_date>'2018-10-3100:00:00.0');
补充:mybatisplusor使用
QueryWrapperqueryWrapper=newQueryWrapper(); queryWrapper.and(wrapper->wrapper.isNull(“sim”).or().eq(“sim”,“”)); queryWrapper.eq(“is_delete”,“0”);
对应sql语句
select*fromvehiclewhere(simisnullorsim='')andis_delete=‘0' QueryWrapperqueryWrapper=newQueryWrapper(); queryWrapper.eq(“name”,“测试”).or().eq(“sim”,“2”);
对应sql语句
select*fromvehiclewherename=‘测试'orsim=‘2'
以上为个人经验,希望能给大家一个参考,也希望大家多多支持毛票票。如有错误或未考虑完全的地方,望不吝赐教。