<if test="permissionCodes != null and permissionCodes.size() > 0">
AND PERMISSION_CODE IN
<foreach collection="permissionCodes" item="permissionCode" index="index" open="("
close=")" separator=",">
<if test="(index % 999) == 998"> NULL ) OR PERMISSION_CODE IN (</if>
#{permissionCode}
</foreach>
</if>
亲测有效