MyBatis 碰到的問(wèn)題

Mybatis之foreach遍歷Map

參考

• 1. 接口中的方法

void batchInsertMap(@Param("studentMap") Map<Integer,Student> studentMap);

• 2. 對(duì)應(yīng)Sql,使用entrySet()，注意 index是key,item是value

<insert id="batchInsertMap" parameterType="java.util.Map">
    INSERT INTO student(id,username)
    VALUES
    <foreach collection="studentMap.entrySet()" index="key" item="value" separator=",">
        (#{key},#{value.username})
    </foreach>
</insert>

Mybatis中進(jìn)行批量更新

參考

• 1. 接口中的方法

void batchUpdateMap(@Param("studentMap") Map<Integer,String> studentMap);

• 2. 對(duì)應(yīng)SQL

<insert id="batchUpdateMap" parameterType="java.util.Map">
        update student
        <trim prefix="set" suffixOverrides=",">
            <trim prefix="username = case" suffix="end,">
                <foreach collection="studentMap.entrySet()" index="key" item="value">
                    when id= #{key} then #{value}
                </foreach>
            </trim>
            <trim prefix="salary = case" suffix="end,">
                <foreach collection="studentMap.entrySet()" index="key" item="value">
                    when id= #{key} then 100
                </foreach>
            </trim>
        </trim>
        where id in
        <foreach collection="studentMap.entrySet()" index="key" separator="," open="(" close=")">
            #{key}
        </foreach>
</insert>