SqlMap中使用集合方式查询

当SQL中有IN操作时，在sqlmap中可以如下使用，传入的schoolingStatusList是一个List. 如下：

SELECT DISTINCT VS.PPU_LVL, VS.FATHER_ID, VS.MOTHER_ID, VS.ID_NO,

TO_CHAR(VS.DT_ADMITTED, 'YYYY') AS DT_ADMITTED

FROM WCCCDB.VW_PU_PPU_IN_STUDENT VS

WHERE VS.YR_ATTENDING = #yrAttending#

AND ((TO_CHAR(VS.DT_ADMITTED, 'YYYY') = #curDtAdmitted#)

OR (TO_CHAR(VS.DT_ADMITTED, 'YYYY') = #preDtAdmitted#))
<isNotNull prepend="AND" property="schoolingStatusList">  
             VS.STATUS IN  
            <iterate open="(" close=")" conjunction="," property="schoolingStatusList">
             　#schoolingStatusList[]#  
            </iterate>   
</isNotNull>