1.数据库想要实现查询这样子的效果,sql如下:
select * from t_sx_pro_accept where accept_state = '2' or accept_state = '1'
select * from t_sx_pro_accept where accept_state in (1,2)
2.但是平常时候写sql比较多,用mp的条件构造器的时候就一下不知道格式和语法了
3.Or用法:
queryWrapper.and(wrapper -> wrapper.eq("accept_state",PortalConstant.ACCEPT_STATE_PASSED) .or() .eq("accept_state",PortalConstant.ACCEPT_STATE_UNPASSED));
4.in用法:
queryWrapper.in("accept_state","1","2");