Spring

myBatis - foreach 사용법

91cm 2018. 10. 1. 23:09



1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
@RequestMapping(value = "test")
    public String test(HttpServletRequest request) throws Exception
    {        
        String no = request.getParameter("no");
        
        List<?> memberSeqList = memberDTO.selectMembers(no); 
        
        HashMap<String, Object> hashMap = new HashMap<String, Object>();
        hashMap.put("seq", memberSeqList );
        
        List<?> list = memberService.getMemberUserInfo(hashMap);
 
        return "board/boardList";
    }
 
cs





1
2
3
4
5
6
7
8
9
10
11
12
13
14
<select id="getMemberUserInfo" parameterType="java.util.Map" resultType="aaaa.bbbb.MemberDTO">
    
    SELECT NAME, AGE, ADDR    
      
    FROM MEMBER 
    
     WHERE MEMEBER_SEQ IN 
    
    <foreach collection="seq" item="seq"  index="index" open="(" close=")" separator=",">
        #{seq}
    </foreach>
 
</select>
 
cs