一、批量插入功能
<insert id="batchInsert">
INSERT INTO message(
user_range,
to_user_id,
type,
src_id
) VALUES
<foreach collection="list" item="item" index="index" separator="," >
(#{item.userRange},#{item.toUserId},#{item.type},#{item.srcId})
</foreach>
</insert>
二、转义字符处理
<![CDATA[ and gtup.end_day < now()]]>