java:
Map map = new HashMap();
map.put("userName","tom");
map.put("passWord","123");
String[] a = { "20000001", "20000002" };
map.put("classIds", Arrays.asList(a));
queryPasswordByUserId(userMap);
sql xml:
select PASSWORD as "password" from T_S_P_USER
<trim prefix="WHERE" prefixOverrides="AND|OR">
<if test="userId != null">USER_ID = #{userId}</if>
<if test="password != null">and PASSWORD = #{password}</if>
<if test="classIds != null">and PASSWORD in
<foreach collection="list" item="classIds" open="(" separator="," close=")">
#{classIds[]}
</foreach>
</if>
</trim>
是不是foreach的用法有错啊?SQL语句错了!