mybatis plus or and 的合并写法实例

mybatis plus or and 的合并写法实例

我就废话不多说了，大家还是直接看代码吧~

int count =hrDeliverEmployContractService.selectCount(new EntityWrapper()

.eq("pool_id",hrDeliverEmployContract.getPoolId()).andNew().lt("contract_start_date",hrDhttp://eliverEmployContract.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使用

QueryWrapper queryWrapper = new QueryWrapper();

queryWrapper .and(wrapper -> wrapper.isNull(“sim”).or().eq(“sim”, “”));

queryWrapper .eq(“is_delete”, “0”);

对应sql语句

select * from vehicle whereFwpWyBnm (sim is null or sim='') and is_delete=‘0'

QueryWrapper queryWrapper = new QueryWrapper();

queryWraphttp://per .eq(“name”,“测试”).or().eq(“sim”,“2”);

对应sql语句

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

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。