查询条件: where type='intf' and (code like '%keyword%' or name like '%keyword%')
一种方式是:
Example example = new Example(SysPermissionEntity.class); example.or().andEqualTo("type","intf").andLike("code","%"+keyword+"%"); example.or().andEqualTo("type","intf").andLike("name","%"+keyword+"%"); example.orderBy("appId"); List<SysPermissionEntity> permissions = sysPermissionMapper.selectByExample(example);
第二种方式:
Example example = new Example(SysPermissionEntity.class);
example.createCriteria().andEqualTo("type","intf").andLike("code","%"+keyword+"%");
List<SysPermissionEntity> permissions = sysPermissionMapper.selectByExample(example);
example.clear();
example.createCriteria().andEqualTo("type","intf").andLike("name","%"+keyword+"%");
List<SysPermissionEntity> permission1 = sysPermissionMapper.selectByExample(example);
permissions.addAll(permission1);
permissions.stream().distinct();