67,513
社区成员
发帖
与我相关
我的任务
分享
sqlSession = getSession();
String members=" 'user01','user02','user03' ";
Map map = new HashMap();
map.put("members", members);
ArrayList<MemberVO> member_list = (ArrayList<MemberVO>)sqlSession.selectList("member.selectListMember",members);
<select id="selectListMember" parameterType="java.util.Map" resultType="MemberVO">
SELECT * FROM MEMBER WHERE MEMBER_ID IN #{members}
<foreach item="members" index="index" collection="list"
open="(" separator="," close=")">
#{members}
</foreach>
SELECT * FROM MEMBER WHERE MEMBER_ID IN
<iterate property="members" open="(" close=")" conjunction=",">
#members[]#
</iterate>