mybatis XML中 遍历map写法
<select id=”selectMapTest” parameterType=”java.util.HashMap” resultMap=”BaseResultMap”>
<foreach collection=”map1″ index=”key” item=”ent” separator=”union”>
SELECT *
FROM User
where username=#{key}
and userpass in
<foreach collection=”ent” item=”id” separator=”,” open=”(” close=”)”>
#{id}
</foreach>
</foreach>
</select>