mybatis同时传入List/数组和实体类参数

最新推荐文章于 2023-08-17 18:30:59 发布

withwindluo

最新推荐文章于 2023-08-17 18:30:59 发布

阅读量2.9k

点赞数 7

文章标签： java mybatis sql

本文链接：https://blog.csdn.net/withwindluo/article/details/113649964

版权

UserMapper.java

void updateByIds(@Param("ids") List<String> ids,@Param("user") User user);

UserMapper.xml

<update id="updateByIds">
    update <include refid="Table_Name"/>
    <trim prefix="set" suffixOverrides=",">
        <if test="user.userId!=null">
            user_id= #{user.userId},
        </if>
        <if test="user.userName!= null and user.userName!= ''">
            user_name = #{user.userName},
        </if>
    </trim>
    where id in
    <foreach collection="ids" separator="," open="(" close=")"
             item="item">
        #{item}
    </foreach>
</update>