MyBatis Example And与Or混合使用的实例

      MemberExample example = new MemberExample();
      MemberExample.Criteria c1 = example.createCriteria();
                          c1.andOne(A).andTwo(B);
      
      MemberExample.Criteria c2 = example.createCriteria();
                          c2.andThree(C).andFour(D); 
      example.or(c2);  

   MemberExample example = new MemberExample();
      MemberExample.Criteria c1 = example.createCriteria();
                          c1.andOne(A).andTwo(B);
      
      MemberExample.Criteria c2 = example.createCriteria();
                          c2.andOne(A).andThree(C); 
      example.or(c2);   

BaUserExample baUserExample = new BaUserExample(); 
Criteria criteria1 = baUserExample.createCriteria();
criteria1.andOrgIdEqualTo("1");
criteria1.andDeptIdEqualTo("1");
   
Criteria criteria2 = baUserExample.createCriteria();
criteria2.andUserNameEqualTo("name");
criteria2.andEmailLike("%test@%");
   
baUserExample.or(criteria2); 
userMapper.countByExample(baUserExample);

==>  Preparing: select count(*) from ba_user WHERE ( org_id = ? and dept_id = ? ) or( user_name = ? and email like ? )

select count(*) from ba_user WHERE userName like ? and ( dept_id is null or dept_id <>? )

select count(*) from ba_user WHERE (userName like ? and  dept_id is null ) or ( userName like ? and  dept_id <>? )

BaUserExample baUserExample = new BaUserExample(); 
Criteria criteria1 = baUserExample.createCriteria();
criteria1.andUserNameLike("%name%");
criteria1.andDeptIdIsNull();
   
Criteria criteria2 = baUserExample.createCriteria();
criteria2.andUserNameLike("%name%");
criteria2.andDeptIdNotEqualTo("1");
   
baUserExample.or(criteria2); 
userMapper.countByExample(baUserExample);

==>  Preparing: select count(*) from ba_user WHERE ( user_name like ? and dept_id is null ) or( user_name like ? and dept_id <> ? )