mybatis动态sql循环插值和设值

秒速五厘米 2023-09-25 19:57 55阅读 0赞

<insert id="insertSelective" parameterType="com.datanew.model.PJbillstock">
      
      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">
      
      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>