Mybatis批量新增、批量查询

àì夳堔傛蜴生んèń 2023-05-29 13:15 32阅读 0赞

/** * 通过商品分类ids查询查询商品分类 */
        List<Category> queryCategoryByIds(List<Long> ids);

<select id="queryCategoryByIds" resultMap="BaseResultMap" parameterType="java.util.List">
            select * from tb_category d
            where
            d.id in
            <foreach item="id" collection="list" open="(" separator="," close=")">
                #{ id}
            </foreach>
        </select>

/** * 批量新增用户 * * @param userList 用户集合 * @return 影响的行数 */
        int insertUserList(List<User> userList);

<insert id="insertUserList" parameterType="java.util.List">
            insert into user(
            username,
            password,
            phone,
            email,
            address
            )
            values
            <foreach collection="list" item="item" index="index" separator=",">
                (
                #{ username,jdbcType=VARCHAR},
                #{ password,jdbcType=VARCHAR},
                #{ phone,jdbcType=BIGINT},
                #{ email,jdbcType=VARCHAR},
                #{ address,jdbcType=VARCHAR}
                )
            </foreach>
        </insert>

/** * 批量修改用户信息 * * @param ids * @return 影响的行数 */
        int updateUserList(List<Integer> ids);

<update id="updateUserList" parameterType="java.util.List">
            update user
            <set>
                <if test="username != null">
                    username = #{ username,jdbcType=VARCHAR},
                </if>
                <if test="password != null">
                    password = #{ password,jdbcType=VARCHAR},
                </if>
                <if test="phone != null">
                    phone = #{ phone,jdbcType=BIGINT},
                </if>
                <if test="name != null">
                    username = #{ username,jdbcType=VARCHAR},
                </if>
                <if test="address != null">
                    address = #{ address,jdbcType=VARCHAR}
                </if>
            </set>
            where id in
            <foreach collection="list" item="item" index="index" open="(" separator="," close=",">
                #{ ids}
            </foreach>
        </update>