mybatis merge 语句使用

wojkxlq

<update id="saveRechousecode" parameterType="net.hlj.ownership.bean.Rechousecode" >
merge into TBWKRECHOUSECODE t
using ( select #{fid} as fid from dual) t1
on(t.fid = t1.fid)
when not matched then
insert
<trim prefix="(" suffix=")" suffixOverrides="," >
FID,
<if test="optypenum != null" >
OPTYPENUM,
</if>
<if test="recyear != null" >
RECYEAR,
</if>
<if test="recnum != null" >
RECNUM,
</if>
<if test="housecode != null" >
HOUSECODE,
</if>
<if test="wxjjnum != null" >
WXJJNUM,
</if>
<if test="districtnum != null" >
DISTRICTNUM,
</if>
<if test="streetnum != null" >
STREETNUM,
</if>
<if test="prjnum != null" >
PRJNUM,
</if>
<if test="buildnum != null" >
BUILDNUM,
</if>
<if test="unitnum != null" >
UNITNUM,
</if>
<if test="floornum != null" >
FLOORNUM,
</if>
<if test="doornum != null" >
DOORNUM,
</if>
<if test="housesignnum != null" >
HOUSESIGNNUM,
</if>
<if test="deratemode != null" >
DERATEMODE,
</if>
<if test="deratescale != null" >
DERATESCALE,
</if>
<if test="deratemoney != null" >
DERATEMONEY,
</if>
<if test="feefactval != null" >
FEEFACTVAL,
</if>
<if test="feecalcval != null" >
FEECALCVAL,
</if>
<if test="feememo != null" >
FEEMEMO,
</if>
<if test="postpondaccept != null" >
POSTPONDACCEPT,
</if>
<if test="oldsitnumgather != null" >
OLDSITNUMGATHER,
</if>
<if test="feestand != null" >
FEESTAND,
</if>
<if test="districtcode != null" >
DISTRICTCODE,
</if>
<if test="mtfchargecode != null" >
MTFCHARGECODE,
</if>
<if test="recnumgather != null" >
RECNUMGATHER,
</if>
<if test="hid != null" >
HID,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides="," >
uf_getfid(SEQ_TBWKRECHOUSECODE.nextval),
<if test="optypenum != null" >
#{optypenum,jdbcType=DECIMAL},
</if>
<if test="recyear != null" >
#{recyear,jdbcType=DECIMAL},
</if>
<if test="recnum != null" >
#{recnum,jdbcType=DECIMAL},
</if>
<if test="housecode != null" >
#{housecode,jdbcType=VARCHAR},
</if>
<if test="wxjjnum != null" >
#{wxjjnum,jdbcType=VARCHAR},
</if>
<if test="districtnum != null" >
#{districtnum,jdbcType=VARCHAR},
</if>
<if test="streetnum != null" >
#{streetnum,jdbcType=VARCHAR},
</if>
<if test="prjnum != null" >
#{prjnum,jdbcType=VARCHAR},
</if>
<if test="buildnum != null" >
#{buildnum,jdbcType=VARCHAR},
</if>
<if test="unitnum != null" >
#{unitnum,jdbcType=VARCHAR},
</if>
<if test="floornum != null" >
#{floornum,jdbcType=VARCHAR},
</if>
<if test="doornum != null" >
#{doornum,jdbcType=VARCHAR},
</if>
<if test="housesignnum != null" >
#{housesignnum,jdbcType=VARCHAR},
</if>
<if test="deratemode != null" >
#{deratemode,jdbcType=DECIMAL},
</if>
<if test="deratescale != null" >
#{deratescale,jdbcType=DECIMAL},
</if>
<if test="deratemoney != null" >
#{deratemoney,jdbcType=DECIMAL},
</if>
<if test="feefactval != null" >
#{feefactval,jdbcType=DECIMAL},
</if>
<if test="feecalcval != null" >
#{feecalcval,jdbcType=DECIMAL},
</if>
<if test="feememo != null" >
#{feememo,jdbcType=VARCHAR},
</if>
<if test="postpondaccept != null" >
#{postpondaccept,jdbcType=DECIMAL},
</if>
<if test="oldsitnumgather != null" >
#{oldsitnumgather,jdbcType=VARCHAR},
</if>
<if test="feestand != null" >
#{feestand,jdbcType=DECIMAL},
</if>
<if test="districtcode != null" >
#{districtcode,jdbcType=DECIMAL},
</if>
<if test="mtfchargecode != null" >
#{mtfchargecode,jdbcType=VARCHAR} ,
</if>
<if test="recnumgather != null" >
#{recnumgather,jdbcType=VARCHAR},
</if>
<if test="hid != null" >
#{hid,jdbcType=DECIMAL},
</if>
</trim>
when matched then
update
<set >
<if test="optypenum != null" >
optypenum=#{optypenum,jdbcType=DECIMAL},
</if>
<if test="recyear != null" >
recyear=#{recyear,jdbcType=DECIMAL},
</if>
<if test="recnum != null" >
recnum=#{recnum,jdbcType=DECIMAL},
</if>
<if test="housecode != null" >
housecode=#{housecode,jdbcType=VARCHAR},
</if>
<if test="wxjjnum != null" >
wxjjnum=#{wxjjnum,jdbcType=VARCHAR},
</if>
<if test="districtnum != null" >
districtnum=#{districtnum,jdbcType=VARCHAR},
</if>
<if test="streetnum != null" >
streetnum=#{streetnum,jdbcType=VARCHAR},
</if>
<if test="prjnum != null" >
prjnum=#{prjnum,jdbcType=VARCHAR},
</if>
<if test="buildnum != null" >
buildnum=#{buildnum,jdbcType=VARCHAR},
</if>
<if test="unitnum != null" >
unitnum=#{unitnum,jdbcType=VARCHAR},
</if>
<if test="floornum != null" >
floornum=#{floornum,jdbcType=VARCHAR},
</if>
<if test="doornum != null" >
doornum=#{doornum,jdbcType=VARCHAR},
</if>
<if test="housesignnum != null" >
housesignnum=#{housesignnum,jdbcType=VARCHAR},
</if>
<if test="deratemode != null" >
deratemode=#{deratemode,jdbcType=DECIMAL},
</if>
<if test="deratescale != null" >
deratescale=#{deratescale,jdbcType=DECIMAL},
</if>
<if test="deratemoney != null" >
deratemoney=#{deratemoney,jdbcType=DECIMAL},
</if>
<if test="feefactval != null" >
feefactval=#{feefactval,jdbcType=DECIMAL},
</if>
<if test="feecalcval != null" >
feecalcval=#{feecalcval,jdbcType=DECIMAL},
</if>
<if test="feememo != null" >
feememo=#{feememo,jdbcType=VARCHAR},
</if>
<if test="postpondaccept != null" >
postpondaccept=#{postpondaccept,jdbcType=DECIMAL},
</if>
<if test="oldsitnumgather != null" >
oldsitnumgather=#{oldsitnumgather,jdbcType=VARCHAR},
</if>
<if test="feestand != null" >
feestand=#{feestand,jdbcType=DECIMAL},
</if>
<if test="districtcode != null" >
districtcode=#{districtcode,jdbcType=DECIMAL},
</if>
<if test="mtfchargecode != null" >
mtfchargecode=#{mtfchargecode,jdbcType=VARCHAR} ,
</if>
<if test="recnumgather != null" >
recnumgather=#{recnumgather,jdbcType=VARCHAR},
</if>
<if test="hid != null" >
hid=#{hid,jdbcType=DECIMAL},
</if>
</set>
where FID = #{fid,jdbcType=DECIMAL}
</update>