mybatis 处理in条件超过1000条
原理:将条件处理为in 1 or in 2 or in 3...
<isPropertyAvailable prepend="and" property="terminalIds">
<isNotEmpty property="terminalIds">
<iterate property="terminalIds" open="(" close=")" conjunction="or">
<![CDATA[ TERMINAL_ID in #terminalIds[]# ]]>
</iterate>
</isNotEmpty>
<isEmpty property="terminalIds">
<![CDATA[ 1<>1 ]]>
</isEmpty>
</isPropertyAvailable>
mybatis 处理in条件超过1000条
最新推荐文章于 2024-03-07 08:00:00 发布