mybatis Example条件查询
来源:互联网 发布:淘宝账号买 编辑:程序博客网 时间:2024/06/16 22:42
目录:
or条件查询时,结合0、1两个例子得出差异
Criteria添加条件时如果遇上or条件时,结合2、3两个例子得出差异
0.
DepartmentExample departmentExample = new DepartmentExample();
departmentExample.createCriteria().andTenantIdEqualTo(tenantId).andBranchIdIsNull().andStatusIdIn(departmentState);
departmentExample.or().andBranchIdEqualTo(0L);
departmentExample.setOrderByClause(" id ");
departmentList = departmentMapper.selectByExample(departmentExample);
1.
DepartmentExample departmentExample = new DepartmentExample();
departmentExample.createCriteria().andTenantIdEqualTo(tenantId).andBranchIdIsNull().andStatusIdIn(departmentState);
departmentExample.or().andTenantIdEqualTo(tenantId).andBranchIdEqualTo(0L).andStatusIdIn(departmentState);
departmentExample.setOrderByClause(" id ");
departmentList = departmentMapper.selectByExample(departmentExample);
sql ->SELECT * FROM ba_department
WHERE ( tenant_id = ? AND branch_id IS NULL AND status_id IN ( ? , ? ) ) OR( tenant_id = ? AND branch_id = ? AND status_id IN ( ? ,? ) ) ORDER BY id
2.
DepartmentExample departmentExample = new DepartmentExample();
DepartmentExample.Criteria criteria = departmentExample.createCriteria().andTenantIdEqualTo(tenantId).andBranchIdIsNull().andStatusIdIn(departmentState);
criteria.andParentIdEqualTo(0L);
departmentExample.or().andTenantIdEqualTo(tenantId).andBranchIdEqualTo(0L).andStatusIdIn(departmentState);
departmentExample.setOrderByClause(" id ");
departmentList = departmentMapper.selectByExample(departmentExample);
sql ->SELECT * FROM ba_department
WHERE ( tenant_id = ? AND branch_id IS NULL AND status_id IN ( ? , ? ) AND parent_id = ? ) OR( tenant_id = ? AND branch_id = ? AND status_id IN ( ? , ? ) ) ORDER BY id
3.
DepartmentExample departmentExample = new DepartmentExample();
DepartmentExample.Criteria criteria = departmentExample.createCriteria().andTenantIdEqualTo(tenantId).andBranchIdIsNull().andStatusIdIn(departmentState);
criteria.andParentIdEqualTo(0L);
DepartmentExample.Criteria criteria1 = departmentExample.or().andTenantIdEqualTo(tenantId).andBranchIdEqualTo(0L).andStatusIdIn(departmentState);
criteria1.andParentIdEqualTo(0L);
departmentExample.setOrderByClause(" id ");
departmentList = departmentMapper.selectByExample(departmentExample);
sql->SELECT * FROM ba_department
WHERE ( tenant_id = ? AND branch_id IS NULL AND status_id IN ( ? , ? ) AND parent_id = ? ) OR( tenant_id = ? AND branch_id = ? AND status_id IN ( ? , ? ) AND parent_id = ?) ORDER BY id
or条件查询时,结合0、1两个例子得出差异
Criteria添加条件时如果遇上or条件时,结合2、3两个例子得出差异
0.
DepartmentExample departmentExample = new DepartmentExample();
departmentExample.createCriteria().andTenantIdEqualTo(tenantId).andBranchIdIsNull().andStatusIdIn(departmentState);
departmentExample.or().andBranchIdEqualTo(0L);
departmentExample.setOrderByClause(" id ");
departmentList = departmentMapper.selectByExample(departmentExample);
sql->SELECT * FROM ba_department
WHERE ( tenant_id = ? AND branch_id IS NULL AND status_id IN ( ? , ? ) ) OR( branch_id = ? ) ORDER BY id
1.
DepartmentExample departmentExample = new DepartmentExample();
departmentExample.createCriteria().andTenantIdEqualTo(tenantId).andBranchIdIsNull().andStatusIdIn(departmentState);
departmentExample.or().andTenantIdEqualTo(tenantId).andBranchIdEqualTo(0L).andStatusIdIn(departmentState);
departmentExample.setOrderByClause(" id ");
departmentList = departmentMapper.selectByExample(departmentExample);
sql ->SELECT * FROM ba_department
WHERE ( tenant_id = ? AND branch_id IS NULL AND status_id IN ( ? , ? ) ) OR( tenant_id = ? AND branch_id = ? AND status_id IN ( ? ,? ) ) ORDER BY id
2.
DepartmentExample departmentExample = new DepartmentExample();
DepartmentExample.Criteria criteria = departmentExample.createCriteria().andTenantIdEqualTo(tenantId).andBranchIdIsNull().andStatusIdIn(departmentState);
criteria.andParentIdEqualTo(0L);
departmentExample.or().andTenantIdEqualTo(tenantId).andBranchIdEqualTo(0L).andStatusIdIn(departmentState);
departmentExample.setOrderByClause(" id ");
departmentList = departmentMapper.selectByExample(departmentExample);
sql ->SELECT * FROM ba_department
WHERE ( tenant_id = ? AND branch_id IS NULL AND status_id IN ( ? , ? ) AND parent_id = ? ) OR( tenant_id = ? AND branch_id = ? AND status_id IN ( ? , ? ) ) ORDER BY id
3.
DepartmentExample departmentExample = new DepartmentExample();
DepartmentExample.Criteria criteria = departmentExample.createCriteria().andTenantIdEqualTo(tenantId).andBranchIdIsNull().andStatusIdIn(departmentState);
criteria.andParentIdEqualTo(0L);
DepartmentExample.Criteria criteria1 = departmentExample.or().andTenantIdEqualTo(tenantId).andBranchIdEqualTo(0L).andStatusIdIn(departmentState);
criteria1.andParentIdEqualTo(0L);
departmentExample.setOrderByClause(" id ");
departmentList = departmentMapper.selectByExample(departmentExample);
sql->SELECT * FROM ba_department
WHERE ( tenant_id = ? AND branch_id IS NULL AND status_id IN ( ? , ? ) AND parent_id = ? ) OR( tenant_id = ? AND branch_id = ? AND status_id IN ( ? , ? ) AND parent_id = ?) ORDER BY id
阅读全文
0 0
- mybatis Example条件查询
- mybatis Example条件查询
- mybatis Example条件查询
- mybatis Example条件查询
- mybatis Example条件查询
- mybatis Example条件查询
- Mybatis if条件 模糊查询非利用example扩展类
- 解决Mybatis 分页插件pagehelper不支持逆向工程Example条件查询
- mybatis拼接条件查询
- MyBatis动态条件查询
- Mybatis实现条件查询
- MyBatis多条件查询
- Mybatis条件查询
- mybatis拼接查询条件
- mybatis 根据条件查询
- Mybatis 多条件查询
- mybatis动态查询条件
- MyBatis基本查询、条件查询、查询排序
- MySQL的联合查询深入分析及案例
- base64转图片
- Linux命令:ps
- vux 点击事件进行优化
- leetcode: 44. Wildcard Matching
- mybatis Example条件查询
- mysql数据库安装和修改密码
- 1元800M日租卡
- 进一步学习Vue.js
- RxDownload
- python with语句
- JSP动作标签
- Git 忽略.idea/workspace.xml文件
- 关于在sql上查询blob类型数据的操作要点