mybatis一对多的策略，嵌套对象分装

来源：互联网发布：cad mac中文破解版编辑：程序博客网时间：2024/05/17 02:19

参考网址：http://legend2011.blog.51cto.com/3018495/973579

<!-- 通过案件编号 措施信息 查找措施表，呈请表 分装到 措施对象  dxj 2014.1.18--><resultMap id="chmMap" type="caseHandledMeasureInfo"><result property="ajbh" column="c_ajbh"/><result property="csbh" column="c_csbh"/><result property="dxbh" column="c_dxbh"/><result property="cslb" column="c_cslb"/><result property="csdx" column="c_csdx"/><result property="xb" column="c_xb"/><result property="csrq" column="c_csrq"/><result property="zz" column="c_zz"/><result property="zjzlhm" column="c_zjzlhm"/><result property="gzdw" column="c_gzdw"/><result property="lxfs" column="c_lxfs"/><result property="cbsj" column="c_cbsj"/><result property="cbr" column="c_cbr"/><result property="cbdw" column="c_cbdw"/><result property="flyj" column="c_flyj"/><result property="cyrzl" column="c_cyrzl"/><result property="spjb" column="c_spjb"/><result property="djr" column="c_djr"/><result property="djsj" column="c_djsj"/><result property="djdw" column="c_djdw"/><result property="xgr" column="c_xgr"/><result property="xgsj" column="c_xgsj"/><result property="xgdw" column="c_xgdw"/><result property="cqbh" column="c_cqbh"/><association property="approval" resultMap="appMap"/>  </resultMap>  <resultMap id="appMap" type="approval"><result property="cqsx" column="a_cqsx"/><result property="cqly" column="a_cqly"/><result property="cbryj" column="a_cbryj"/></resultMap><select id="getMeasureApproval" parameterType="caseHandledMeasureInfo" resultMap="chmMap">select chm.AJBH c_ajbh, chm.CSBH c_csbh, chm.DXBH c_dxbh, chm.CSLB c_cslb,chm.CSDX c_csdx, chm.XB c_xb, chm.CSRQ c_csrq,chm.ZZ c_zz, chm.ZJZLHM c_zjzlhm, chm.GZDW c_gzdw,chm.LXFS c_lxfs,to_char(chm.CBSJ,'yyyy-mm-dd hh24:mi:ss') c_cbsj,   chm.CBR c_cbr, chm.CBDW c_cbdw, chm.FLYJ c_flyj, chm.CYRZL c_cyrzl, chm.SPJB c_spjb,    chm.DJR c_djr, chm.DJSJ c_djsj, chm.DJDW c_djdw,chm.XGR c_xgr, chm.XGSJ c_xgsj,    chm.XGDW c_xgdw,chm.CQBH c_cqbh,app.cqsx a_cqsx,app.cqly a_cqly,app.cbryj a_cbryj  from CASES_HANDLED_MEASURE chm, APPROVAL app<where><if test="ajbh !=null or ajbh !=''">chm.ajbh=#{ajbh} and app.ajbh=#{ajbh} and chm.cqbh=app.cqbh</if><if test="cslb !=null or cslb !=''">and chm.cslb=#{cslb} and app.cqlb=#{cslb}</if>order by chm.csbh desc</where>

Java bean 对象

private String jdje;//number y决定金额private String jdqx;//number y决定期限private String jdjg;//number y决定结果private String cqbh;//varchar2(24) y呈请编号private String returnCode;//返回代码private String returnResult;//返回信息private Approval approval; //呈请表的对象

0 0