본문 바로가기

Framework/__Spring

ibatis iterate 테스트

-------------------------------------------------------------------------------------
 /**
  * ibatis iterate
  * @param request
  * @param response
  * @return
  */
 @RequestMapping("/ibatisIterate.do")
 public void ibatisIterate(ModelMap model, HttpServletRequest request){
  
  ArrayList<String> alDojo = new ArrayList<String>();
  alDojo.add("3");
  alDojo.add("64");
  alDojo.add("23");
  
  HashMap<String, ArrayList<String>> subjectList =new HashMap<String, ArrayList<String>>() ;
  subjectList.put("subjectList", alDojo);
  
  List<TestTable> result = testService.testIterate(subjectList); 
  
  ModelAndView v = new ModelAndView(); 
  //v.setViewName("test/ibatisIterate");    
  //return;
 }
-------------------------------------------------------------------------------------
 <select id="testIterate" parameterClass="java.util.HashMap" resultClass="TableTable">
  select brd_seq_id as  cmtsId from board
  <dynamic prepend="WHERE brd_seq_id in " open="(" close=")">
   <iterate property="subjectList" conjunction=", ">
    #subjectList[]#
   </iterate>
  </dynamic>
 </select>
-------------------------------------------------------------------------------------
  select brd_seq_id as  cmtsId from board
  WHERE brd_seq_id in (   
    '3'   ,
    '64'   ,
    '23'   
  )
-------------------------------------------------------------------------------------