-------------------------------------------------------------------------------------
/**
* 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'
)
-------------------------------------------------------------------------------------
/**
* 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'
)
-------------------------------------------------------------------------------------