mabatis mapper文件中使用if条件插入字段和数据

桃扇骨 2022-05-11 12:33 184阅读 0赞

有时候我们插入数据库数据的时候,插入字段都是不确定的,那么我们也可以用if条件来过滤一些字段

*  废话不多说,直接上代码

<insert id="ORDER_I" parameterType="hashmap">
          insert into t_order
          <trim prefix="(" suffix=")" suffixOverrides=",">
              <if test="orderNo != null">
                  orderNo,
              </if>
              <if test="serviceName != null">
                  serviceName,
              </if>
              <if test="idcard != null">
                  idcard,
              </if>
              <if test="name != null">
                  name,
              </if>
              <if test="requestData != null">
                  requestData,
              </if>
              <if test="responseData != null">
                  responseData,
              </if>
              <if test="status != null">
                  status,
              </if>
              <if test="updatedTime != null">
                  updatedTime,
              </if>
              <if test="completionTime != null">
                  completionTime,
              </if>
              <if test="bae007 != null">
                  bae007,
              </if>
              <if test="operId != null">
                  operId,
              </if>
              <if test="operName != null">
                  operName,
              </if>
              <if test="remark != null">
                  remark,
              </if>
          </trim>
           <trim prefix="values (" suffix=")" suffixOverrides=",">
               <if test="orderNo != null">
                   #{orderNo},
               </if>
               <if test="serviceName != null">
                   #{serviceName},
               </if>
               <if test="idcard != null">
                   #{idcard},
               </if>
               <if test="name != null">
                   #{name},
               </if>
               <if test="requestData != null">
                   #{requestData},
               </if>
               <if test="responseData != null">
                   #{responseData},
               </if>
               <if test="status != null">
                   #{status},
               </if>
               <if test="updatedTime != null">
                   #{updatedTime},
               </if>
               <if test="completionTime != null">
                   #{completionTime},
               </if>
               <if test="bae007 != null">
                   #{bae007},
               </if>
               <if test="operId != null">
                   #{operId},
               </if>
               <if test="operName != null">
                   #{operName},
               </if>
               <if test="remark != null">
                   #{remark},
               </if>
           </trim>
       </insert>

经过测试,是可以实现的