cfm_requirement_vendor_date为cfm_requirement_vendor的子表
cfm_requirement_vendor为cfm_requirement的子表
一、mybatis映射文件定义
select r.id, r.requirement_id, v.id as requirement_vendor_id, v.vendor_id, d.id as requirement_vendor_date_id, from cfm_requirement r join cfm_requirement_vendor v on r.id = v.cfm_requirement_id and v.del_flag = 0 join cfm_requirement_vendor_date d on v.id = d.cfm_requirement_vendor_id and d.del_flag=0 where r.requirement_id = #{requirementid} and r.del_flag=0
二、java类定义
1、mapper.java
list selectnestedbyrequirementid(int requirementid);
2、持久化对象
public class nestedrequirement extends requirement { private list requirementvendorlist; public list getrequirementvendorlist() { return requirementvendorlist; } public void setrequirementvendorlist( list requirementvendorlist) { this.requirementvendorlist = requirementvendorlist; } }