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 ( #{item}
<///foreach >
<//if>
<//where>
【mybatis解决oracle查询in超过1000条数据】
于 2024-08-01 10:22:52 首次发布