处理mysql中in条件大于1000条的问题
WHERE xsfnsrsbh IN <foreach collection="param.nsrsbhList" index="index" item="nsrsbh" open="(" close=")"> <if test="index >0 "> <choose> <when test="(index % 1000) == 999"> ) or xsfnsrsbh in ( </when> <otherwise>,</otherwise> </choose> </if> #{nsrsbh} </foreach>