批量插入

<insert id="insertTlLabelBatch" parameterType="list">
   insert into tt_t_notice 
<trim prefix="(" suffix=")" suffixOverrides=",">
TID,
NOTICE_TYPE,
NOTICE_CONTENT,
NOTICE_STATUS,
NOTICE_BY,
CREATE_DATE,
CREATE_BY,
UPDATE_DATE,
UPDATE_BY,
ORG_ID,
WAREHOUSE_ID ,
COMPANY_ID 

</trim>
  value
    <foreach collection="list" item="item" separator=",">
  <trim prefix="(" suffix=")" suffixOverrides=",">
<choose>
<when test="item.tid !=null">
#{item.tid,jdbcType=DECIMAL},
</when>
<otherwise>
NULL,
</otherwise>
</choose>
<choose>
<when test="item.noticeType!= null">
#{item.noticeType,jdbcType=DECIMAL},
</when>
<otherwise>
NULL,
</otherwise>
</choose>
<choose>
<when test="item.noticeContent != null">
#{item.noticeContent,jdbcType=VARCHAR},
</when>
<otherwise>
NULL,
</otherwise>
</choose>
</trim>
  </foreach>
  </insert>