select * from table a
<where>
<if test="list != null and list.size > 0">
and a.name in
<foreach collection="list" index="index" item="item" open="(" separator="," close=")">
<if test="(index % 999) == 998"> ) or a.name in (</if> #{item}
</foreach >
</if>
</where>
【mybatis解决oracle查询in超过1000条数据】
最新推荐文章于 2024-09-26 22:00:18 发布