<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来写这...