mybatis-plus复杂查询条件加括号（and和andNew的区别）（转载网上大咖）

mybatis-plus复杂查询条件加括号（and和andNew的区别）

EntityWrapper里的and和andNew的区别

//and()
//mybatis-plus
ew.eq("is_delete",1).and().like("name",name).or().like("code",name);

—————————————————————————————————————————— 

产生的sql语句
select * from student where is_delete = 1 and name like "hh" or code like "hh";

——————————————————————————————————————————————————

andNew()的使用
ew.eq("is_delete",1).andNew().like("name",name).or().like("code",name);
//sql语句
select * from student where is_delete = 1 and (name like "hh" or code like "hh");

——————————————————————————————————————————————————