<mapper namespace= "Com.rrz.modules.awardrecord.dao.CheckAwardsDao" >
<resultmap type= "Com.rrz.modules.awardrecord.entity.CheckAwards" id= "Checkawardsmap" >
<id property= "id" column= "id"/>
<result property= "CustId" column= "cust_id"/>
</resultMap>
<select id= "Getcheckaward" parametertype= "Com.rrz.modules.awardrecord.entity.CheckAwards" resultmap= " Checkawardsmap ">
SELECT a.id,a.cust_id from Check_awards a WHERE a.id = #{id} and a.cust_id = #{custid}
</select>
</mapper>
<mapper namespace= "Com.rrz.modules.awardrecord.dao.CheckAwardspicsDao" >
<resultmap type= "Com.rrz.modules.awardrecord.entity.CheckAwardspics" id= "Checkawardspicsmap" >
<result property= "Picurl" column= "Picurl"/>
</resultMap>
<select id= "Getcheckawardpics" parametertype= "Com.rrz.modules.awardrecord.entity.CheckAwardspics" resultmap= " Checkawardspicsmap ">
SELECT B.picurl from check_awardspics b WHERE b.award_id = #{awardid}
</select>
</mapper>
public class checkawardvo{
Private Checkawards checkawards;
Private list<checkawardspics> pics;
Public list<checkawardspics> Getpics () {
return pics;
}
public void Setpics (list<checkawardspics> pics) {
This.pics = pics;
}
Public Checkawards getcheckawards () {
return checkawards;
}
public void Setcheckawards (Checkawards checkawards) {
This.checkawards = Checkawards;
}
}
Public Checkawardvo Getcheckawardvo (checkawards checkawards) {
Checkawardvo vo = new Checkawardvo ();
Checkawards = Checkawardsdao.getcheckaward (checkawards);
Vo.setcheckawards (checkawards);
Checkawardspics pic = new Checkawardspics ();
if (checkawards!=null) {
Pic.setawardid (Checkawards.getid ());
}
list<checkawardspics> list = Checkawardspicsdao.getcheckawardpics (pic);
Vo.setpics (list);
return VO;
}
Checkawardvo Pics=awardrecordservice.getcheckawardvo (CHECKAWARDSB);
M.addattribute ("Pics", pics.getpics ());
MyBatis Relational Query Java