<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>
相关推荐
Mybatis批量foreach merge into的用法，这是介绍Mybatis批量foreach merge into的用法的文档
mybatis生成语句，mybatis生成语句，mybatis生成语句，mybatis生成语句，mybatis生成语句，mybatis生成语句，mybatis生成语句，mybatis生成语句
Mybatis案例一所用建表语句Mybatis案例一所用建表语句Mybatis案例一所用建表语句
if 、where、set、trim、choose 、foreach等在mybatis中的具体用法，有具体实例可供参考，玩转mybatis
关于mybatis自动生成语句，还有一些jar,需要的联系我
Mybatis执行SQL语句的方式
mybatis自动生成SQL，生成xml映射文件，实体，修改generator_oracle_apply.xml路径，当当前目录下打开cmd 运行txt里面语句。完成。
mybatis简单使用mybatis简单使用demomybatis简单使用demomybatis简单使用demomybatis简单使用demomybatis简单使用demomybatis简单使用demomybatis简单使用demomybatis简单使用demomybatis简单使用demomybatis简单...
这是一个 常用的 后端增删改查的通用 mybatis的文件 适用于大学生的毕业设计和一般的项目的CRUD都可以
1.匿名内部类风格 2.Builder/Fluent 风格 3.动态条件（参数需要使用 final 修饰，以便返回值中的匿名内部类使用）
Pndao是一个轻量级的MyBatis SQL自动化生成工具，旨在通过遵循DAO的命名约定来简化SQL语句的生成与维护过程。该项目完全采用Java语言开发，为开发者提供了一个高效的数据库操作解决方案。 技术构成： - 主要编程...
log4j.xml文件，打印详细的mybatis执行过程中的语句
mybatis+spring 框架中配置日志中显示sql语句
该工具可以将mybatis输出的sql日志提取出来，并将其格式化为可以直接执行的sql语句，节约开发人员时间
springboot整合mybatis整合jpa使用entityManger整合readis以及微信支付和支付宝支付
适用于springboot（整合过mybatis的）和常规SSM项目，可以获取完整的mybatis执行的sql语句，用于直观的看到执行sql是否异常
NULL 博文链接：https://benworld.iteye.com/blog/1841031
MyBatis 枚举全面使用指南 抓下来打包成了HTML文件, 方便离线观看
通过mybatis拦截器将查询语句、更新语句、删除语句、插入语句中指定表明替换为另一个表名
在本学习教程中，全方位介绍了mybatis中的各种特性，里面的实例都是采用比较简单的实例来实现，对于有些没有介绍到的特性，大家可以参考官方文档。本教程采用的是mybatis最新的版本mybatis3.1，并结合了maven来写这...