博客

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>