mybatis动态sql循环插值和设值

最新推荐文章于 2023-08-22 15:00:49 发布

leese233

最新推荐文章于 2023-08-22 15:00:49 发布

阅读量320

点赞数

文章标签： mybatis sql 数据库

本文链接：https://blog.csdn.net/leese233/article/details/129815129

版权

<insert id="insertSelective" parameterType="com.datanew.model.PJbillstock">
  <!--
  @mbggenerated
  -->
  insert into pj_billstock
  <trim prefix="(" suffix=")" suffixOverrides=",">
    <if test="guid != null">
      GUID,
    </if>
    <if test="fRegicode != null">
      F_REGICODE,
    </if>
    <if test="fSubjectno != null">
      F_SUBJECTNO,
    </if>
    <if test="fEnteguid != null">
      F_ENTEGUID,
    </if>
    <if test="fBistguid != null">
      F_BISTGUID,
    </if>
    <if test="userguid != null">
      USERGUID,
    </if>
    <if test="username != null">
      USERNAME,
    </if>
    <if test="fBitycode != null">
      F_BITYCODE,
    </if>
    <if test="startno != null">
      STARTNO,
    </if>
    <if test="endno != null">
      ENDNO,
    </if>
    <if test="sheets != null">
      SHEETS,
    </if>
    <if test="binding != null">
      BINDING,
    </if>
    <if test="copiespersheet != null">
      COPIESPERSHEET,
    </if>
    <if test="sheetsperbook != null">
      SHEETSPERBOOK,
    </if>
    <if test="pressprice != null">
      PRESSPRICE,
    </if>
    <if test="wholesaleprice != null">
      WHOLESALEPRICE,
    </if>
    <if test="retailprice != null">
      RETAILPRICE,
    </if>
    <if test="price != null">
      PRICE,
    </if>
    <if test="permoney != null">
      PERMONEY,
    </if>
    <if test="synFlag != null">
      SYN_FLAG,
    </if>
    <if test="flag != null">
      flag,
    </if>
    <if test="remark != null">
      REMARK,
    </if>
    <if test="entecode != null">
      ENTECODE,
    </if>
    <if test="seal != null">
      SEAL,
    </if>
    <if test="deadline != null">
      DEADLINE,
    </if>
  </trim>
  <trim prefix="values (" suffix=")" suffixOverrides=",">
    <if test="guid != null">
      #{guid,jdbcType=BIGINT},
    </if>
    <if test="fRegicode != null">
      #{fRegicode,jdbcType=VARCHAR},
    </if>
    <if test="fSubjectno != null">
      #{fSubjectno,jdbcType=VARCHAR},
    </if>
    <if test="fEnteguid != null">
      #{fEnteguid,jdbcType=VARCHAR},
    </if>
    <if test="fBistguid != null">
      #{fBistguid,jdbcType=DECIMAL},
    </if>
    <if test="userguid != null">
      #{userguid,jdbcType=DECIMAL},
    </if>
    <if test="username != null">
      #{username,jdbcType=VARCHAR},
    </if>
    <if test="fBitycode != null">
      #{fBitycode,jdbcType=VARCHAR},
    </if>
    <if test="startno != null">
      #{startno,jdbcType=VARCHAR},
    </if>
    <if test="endno != null">
      #{endno,jdbcType=VARCHAR},
    </if>
    <if test="sheets != null">
      #{sheets,jdbcType=DECIMAL},
    </if>
    <if test="binding != null">
      #{binding,jdbcType=CHAR},
    </if>
    <if test="copiespersheet != null">
      #{copiespersheet,jdbcType=DECIMAL},
    </if>
    <if test="sheetsperbook != null">
      #{sheetsperbook,jdbcType=DECIMAL},
    </if>
    <if test="pressprice != null">
      #{pressprice,jdbcType=DECIMAL},
    </if>
    <if test="wholesaleprice != null">
      #{wholesaleprice,jdbcType=DECIMAL},
    </if>
    <if test="retailprice != null">
      #{retailprice,jdbcType=DECIMAL},
    </if>
    <if test="price != null">
      #{price,jdbcType=DECIMAL},
    </if>
    <if test="permoney != null">
      #{permoney,jdbcType=DECIMAL},
    </if>
    <if test="synFlag != null">
      #{synFlag,jdbcType=CHAR},
    </if>
    <if test="flag != null">
      #{flag,jdbcType=CHAR},
    </if>
    <if test="remark != null">
      #{remark,jdbcType=VARCHAR},
    </if>
    <if test="entecode != null">
      #{entecode},
    </if>
    <if test="seal != null">
      #{seal},
    </if>
    <if test="deadline != null">
      #{deadline},
    </if>
  </trim>
</insert>

<update id="updateByPrimaryKeySelective" parameterType="com.datanew.model.PJbillstock">
  <!--
  @mbggenerated
  -->
  update pj_billstock
  <set>
    <if test="fRegicode != null">
      F_REGICODE = #{fRegicode,jdbcType=VARCHAR},
    </if>
    <if test="fSubjectno != null">
      F_SUBJECTNO = #{fSubjectno,jdbcType=VARCHAR},
    </if>
    <if test="fEnteguid != null">
      F_ENTEGUID = #{fEnteguid,jdbcType=VARCHAR},
    </if>
    <if test="fBistguid != null">
      F_BISTGUID = #{fBistguid,jdbcType=DECIMAL},
    </if>
    <if test="userguid != null">
      USERGUID = #{userguid,jdbcType=DECIMAL},
    </if>
    <if test="username != null">
      USERNAME = #{username,jdbcType=VARCHAR},
    </if>
    <if test="fBitycode != null">
      F_BITYCODE = #{fBitycode,jdbcType=VARCHAR},
    </if>
    <if test="startno != null">
      STARTNO = #{startno,jdbcType=VARCHAR},
    </if>
    <if test="endno != null">
      ENDNO = #{endno,jdbcType=VARCHAR},
    </if>
    <if test="sheets != null">
      SHEETS = #{sheets,jdbcType=DECIMAL},
    </if>
    <if test="binding != null">
      BINDING = #{binding,jdbcType=CHAR},
    </if>
    <if test="copiespersheet != null">
      COPIESPERSHEET = #{copiespersheet,jdbcType=DECIMAL},
    </if>
    <if test="sheetsperbook != null">
      SHEETSPERBOOK = #{sheetsperbook,jdbcType=DECIMAL},
    </if>
    <if test="pressprice != null">
      PRESSPRICE = #{pressprice,jdbcType=DECIMAL},
    </if>
    <if test="wholesaleprice != null">
      WHOLESALEPRICE = #{wholesaleprice,jdbcType=DECIMAL},
    </if>
    <if test="retailprice != null">
      RETAILPRICE = #{retailprice,jdbcType=DECIMAL},
    </if>
    <if test="price != null">
      PRICE = #{price,jdbcType=DECIMAL},
    </if>
    <if test="permoney != null">
      PERMONEY = #{permoney,jdbcType=DECIMAL},
    </if>
    <if test="synFlag != null">
      SYN_FLAG = #{synFlag,jdbcType=CHAR},
    </if>
    <if test="flag != null">
      flag = #{flag,jdbcType=CHAR},
    </if>
    <if test="remark != null">
      REMARK = #{remark,jdbcType=VARCHAR},
    </if>
    <if test="entecode != null">
      ENTECODE = #{entecode},
    </if>
    <if test="seal != null">
      SEAL = #{seal},
    </if>
    <if test="deadline != null">
      DEADLINE = #{deadline},
    </if>
      VERSION = VERSION + 1
  </set>
  where GUID = #{guid,jdbcType=BIGINT}
</update>