参考网址: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; //呈请表的对象