1、对list判null和判空来处理(List):
select * from t_blog where id in
<if test="list != null and list.size>0">
<foreach collection="list" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</if>
2、对数组判null和判空来处理(ids[]):
select * from t_blog where id in
<if test=" ids != null and ids.length > 0">
<foreach collection="ids" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</if>
3、批量增加数据:
<insert id="addList">
INSERT INTO t_blog
(
<include refid="selectAllColumnsSql"/>
)
values
<foreach collection="list" item="item" index= "index" separator =",">
(
#{item.id, jdbcType=NUMERIC},
#{item.name, jdbcType=VARCHAR}
)
</foreach>
</insert>