<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>

版权声明:本文为niceTommy原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://www.cnblogs.com/niceTommy/p/12848808.html