Mybatis动态插入数据（使用trim标签）

转载

mb5fdb133c76a49 2018-04-23 17:43:00

文章标签 MyBatis ide 后缀 xml sql语句 文章分类 代码人生

Mybatis动态插入数据（使用trim标签）

有时我们控制同一张表，但传入的参数不固定，操作表的字段不固定，就要用到mybatis动态插入。.xml如下：

<insert id="insertMessage" parameterType="com.sf.ccsp.member.client.request.MessageReq">
       insert cx_customer_message
       (ID,MEMBERID,
         <if test='messageClassify != null and messageClassify != "" '>
             MESSAGEE_CLASSIFY,
         </if>
         <if test='messageCode != null and messageCode != "" '>
             MESSAGE_CODE,
         </if>
         <if test='messageContent != null and messageContent != "" '>
             MESSAGE_CONTENT
         </if>
        )
       values (
         #{id, jdbcType=VARCHAR},
         #{memberId, jdbcType=VARCHAR},
          <if test='messageClassify != null and messageClassify != "" '>
            #{messageClassify, jdbcType=VARCHAR},
          </if>
          <if test='messageCode != null and messageCode != "" '>
            #{messageCode, jdbcType=VARCHAR},
          </if>
          <if test='messageContent != null and messageContent != "" '>
            #{messageContent, jdbcType=VARCHAR}
          </if>
        )
</insert>

问题来了，当messageClassify ！=null，但messageCode 和messageContent 为空时，会多出来逗号，以至于mybatis报错。正确的用法如下.xml：

<insert id="insertMessage" parameterType="com.sf.ccsp.member.client.request.MessageReq">

       insert cx_customer_message

        <trim prefix="(" suffix=")" suffixOverrides="," >

          ID,MEMBERID,

          <if test='messageClassify != null and messageClassify != "" '>

             MESSAGEE_CLASSIFY,

          </if>

          <if test='messageCode != null and messageCode != "" '>

             MESSAGE_CODE,
          </if>

         <if test='messageContent != null and messageContent != "" '>

             MESSAGE_CONTENT,

         </if>

        </trim>

    <trim prefix=<span >"values ("</span> suffix=<span >")"</span> suffixOverrides=<span >","</span> ></br>
      #{id, jdbcType=VARCHAR},</br>
      #{memberId, jdbcType=VARCHAR},</br>
      <<span >if</span> test='messageClassify != <span >null</span> <span >and</span> messageClassify != <span >""</span> '></br>
        #{messageClassify, jdbcType=VARCHAR},</br>
      </<span >if</span>></br>
      <<span >if</span> test='messageCode != <span >null</span> <span >and</span> messageCode != <span >""</span> '></br>
        #{messageCode, jdbcType=VARCHAR},</br>
      </<span >if</span>></br>
      <<span >if</span> test='messageContent != <span >null</span> <span >and</span> messageContent != <span >""</span> '></br>
        #{messageContent, jdbcType=VARCHAR},</br>
      </<span >if</span>></br>
    </trim>  </br>

</insert>