在mybatis 中如何防止 IN里面的参数过多？
代码示例：
select xsid from zhxg_gy_ssfp_cwfp
where xsid in
<foreach collection="list" item="item" open="(" close=")" separator=" " index="index">
<if test="(index % 999)== 998"> NULL )OR xsid IN(</if>#{item}
</foreach>
代码示例：
select xsid from zhxg_gy_ssfp_cwfp
where xsid in
<foreach collection="list" item="item" open="(" close=")" separator=" " index="index">
<if test="(index % 999)== 998"> NULL )OR xsid IN(</if>#{item}
</foreach>