Question

mybatis 多重嵌套查询

数据库表:
approve表 id , case_id , approve_type
approve_suggest表 id , approve_id , remark , create_time

1. 一(approve)对多(approve_suggest)的关系
2. 按照approve_type又可以分为多种approve记录

pojo：
ApproveList.java
private String id;
private String approveType;
private List<ApproveContent> appConts;

ApproveContent.java
private String id;
private String remark;
private Date create_time;

Mapper.java
List<ApproveList> queryAllApprove(@Param("caseId")String caseId);

----------怎么写xml----------

Answer 1

1.写一个普通查询语句
<select id="byDeptIdCondition" ..>
SELECT t1.userId,t1.userName from user
</select>
2.嵌套
<dynamic prepend="and">
<include refid="byDeptIdCondition"/>
where 1=1//其他sql语句 注意命名空间
</dynamic>

追问

这么简单还问个屁。