mybatis-plus 使用小结

最新推荐文章于 2025-03-06 16:30:00 发布

fengcai0123

最新推荐文章于 2025-03-06 16:30:00 发布

阅读量217

点赞数

分类专栏： mybatis-plus java web 文章标签： html

本文链接：https://blog.youkuaiyun.com/fengcai0123/article/details/120529724

版权

java web 同时被 2 个专栏收录

29 篇文章

订阅专栏

mybatis-plus

1 篇文章

订阅专栏

本文详细介绍了在Mybatis-Plus中如何进行分页查询以及使用数组作为参数进行操作的方法，结合实例展示了具体的Mybatis映射写法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

分页，数组入参mybatis写法实例

数组入参mybatis查找，模糊查找
mapper.xml：
<select id="pageSearchList" resultType="com.example.domain.stockModel">
select 
	user_name as username,
	mobile as mobile
from stockin_order 
<where>
	<if test="query.spaceIds!=null and query.spaceIds.size()>0">
	    and s.space_id in
	    <foreach collection="query.spaceIds" separator="," index="index" item="spaceId" open="("
	    close=")">
	        #{spaceId}
	    </foreach>
	</if>
	<if test="query.sku != null and query.sku !=''">
         AND i.sku like concat('%',#{query.sku},'%')
	 </if>
</where>
</select>

Mapper接口：
public interface StockMapper extends BaseMapper<StockEntity> {
    IPage<StockModel> pageSearchList(IPage page, @Param("query") StockListRequest request);
}

service:
public PageResponse<StockResponse> getStockListByRequest(StockListRequest request) {
        PageResponse<StockResponse> pageResponse = new PageResponse<>();
        IPage<StockModel> pageResult = stockMapper.pageSearchList(new Page<>(request.getPageIndex(), request.getPageSize()), request);
        List<StockModel> resultList = pageResult.getRecords();
        List<StockResponse> responseList = resultList.stream().map(item -> {
            StockResponse response = new StockResponse();
            BeanUtils.copyProperties(item, response);
            return response;
        }).collect(Collectors.toList());
        pageResponse.setTotalCount(pageResult.getTotal());
        pageResponse.setContent(responseList);
        return pageResponse;
    }

request:
@Data
public class StockListRequest extends PageRequest {

    @ApiModelProperty(value = "用户名", name = "username")
    private String username;

    @ApiModelProperty(value = "手机号", name = "mobile") //swagger-ui使用,为了前端开发方便、可以不用
    private String mobile;
}

request基类：
@Data
public class PageRequest {
    @NotNull
    private Integer pageSize = 20;

    @NotNull
    private Integer pageIndex = 1;

    private String sortField;
    private String sortOrder; //asc,desc
}