大概场景就是导入Excel表的时候 里面有超过1000多个学生,这种情况查询这1000个学生如果用in的话就会超过长度限制.
现在的解决思路就是把 要查询的数据当成一张表来查询 然后进行连表查询
大概语句如下
<select id="getSchool" resultMap="ExcelModelSchool" parameterClass="java.util.List">
SELECT
T .SCHOOL_NAME school_Name,
T ."ID" school_Id ,
T.ISMANAGER ISMANAGER
FROM
(select * from (
<iterate open="(" close=")" conjunction=",">
<![CDATA[
SELECT
#list[]# sname
FROM dual
]]>
</iterate>
)) s,
T_SCHOOL T
WHERE
T .SCHOOL_NAME =s.sname
</select>
