Mybatis批量修改时出现报错问题解决方案

<update id="update_hotel_real_time_price" parametertype="java.util.list">
    <foreach collection="list" item="item" index="index" separator=";">
      update vst_hotel_real_time_price
      <set>
        <if test="item.realtimeprice1 != null">
          real_time_price1 = #{item.realtimeprice1},
        </if>
        <if test="item.realtimeprice2 != null">
          real_time_price2 = #{item.realtimeprice2},
        </if>
        <if test="item.realtimeremain1 != null">
          real_time_remain1 = #{item.realtimeremain1},
        </if>
        <if test="item.realtimeremain2 != null">
          real_time_remain2 = #{item.realtimeremain2},
        </if>
        update_time = now()
      </set>
      where product_id = ${item.productid}
     </foreach>
   </update>

<update id="updatetypelist" parametertype="list">
    <foreach collection="list" item="type" index="index" separator=";">
      update t_type
      <set>
        <if test="type.name != null">
          t_name = #{type.name}
        </if>
      </set>
      where t_id = #{type.id}
    </foreach>
  </update>