SQL IN ( Array 배열 넘기기 , , ) (예제)

IRowMap rowMap = null;
  ArrayList JOBNO_LIST = null;
  
if (!searchDiv2.equals("EACH")) //전체조회 일때
  {
   if (list.size() > 0) {
    JOBNO_LIST = new ArrayList();
     for (int i = 0; i < list.size(); i++) {
      rowMap = (IRowMap) list.get(i);
      JOBNO_LIST.add(rowMap.get("JOB_NO"));
      HAWB_NO = rowMap.get("HAWB_NO").toString();
      System.out.println("HAWB_NO : "+HAWB_NO+" Jobnolist ==> " + JOBNO_LIST.get(i));      
     }  
   }
   System.out.println(" Jobnolist SIZE ==> " + JOBNO_LIST.size());
   paramMap.put("AWB_TCD", "ALL");
   paramMap.put("JOBNO_LIST", JOBNO_LIST);
   
  }

<isPropertyAvailable prepend="AND H.JOB_NO IN " property="JOBNO_LIST">
       <iterate property="JOBNO_LIST" open="(" close=")" conjunction="," >
     #JOBNO_LIST[]#
        </iterate>
</isPropertyAvailable>