栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

Mybatis-Plus配置分页对象

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

Mybatis-Plus配置分页对象

Mybatis-Plus配置分页对象
  1. 配置类

    package com.xiaoge.config;
    
    import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    
    
    @Configuration  // 放在ioc容器中
    @MapperScan(basePackages = {"com.xiaoge.mapper"}) // 扫描对应的mapper接口文件包
    public class MybatisPlusConfig {
    
      	// 必须要加Bean
        @Bean
        public PaginationInterceptor paginationInterceptor() {
            return new PaginationInterceptor();
        }
    
    }
    
  2. SysUserController

    package com.xiaoge.controller;
    
    
    import com.baomidou.mybatisplus.core.metadata.IPage;
    import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
    import com.xiaoge.anno.Log;
    import com.xiaoge.domain.SysUser;
    import com.xiaoge.service.SysUserService;
    import io.swagger.annotations.Api;
    import io.swagger.annotations.ApiOperation;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.http.ResponseEntity;
    import org.springframework.security.core.context.SecurityContextHolder;
    import org.springframework.web.bind.annotation.GetMapping;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    
    @Api(tags = "后台用户接口")
    @RestController
    @RequestMapping("sys/user")
    public class SysUserController {
    
        @Autowired
        private SysUserService sysUserService;
    
        
        @ApiOperation("分页查询管理员列表")
        @GetMapping("page")
        @Log(operation = "分页查询管理员列表")
        public ResponseEntity> getSysUserPage(Page page, SysUser sysUser) {
            IPage sysUserIPage = sysUserService.findSysUserByPage(page, sysUser);
            return ResponseEntity.ok(sysUserIPage);
        }
    
    }
    
    
  3. SysUserService

    package com.xiaoge.service;
    
    import com.baomidou.mybatisplus.core.metadata.IPage;
    import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
    import com.baomidou.mybatisplus.extension.service.IService;
    import com.xiaoge.domain.SysUser;
    
    
    
    public interface SysUserService extends IService{
    
    
        
        IPage findSysUserByPage(Page page, SysUser sysUser);
    }
    
  4. SysUserServiceImpl

    package com.xiaoge.service.impl;
    
    import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
    import com.baomidou.mybatisplus.core.metadata.IPage;
    import com.baomidou.mybatisplus.core.metadata.OrderItem;
    import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
    import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
    import com.xiaoge.domain.SysUser;
    import com.xiaoge.mapper.SysUserMapper;
    import com.xiaoge.service.SysUserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.springframework.util.ObjectUtils;
    import org.springframework.util.StringUtils;
    
    
    
    @Service
    public class SysUserServiceImpl extends ServiceImpl implements SysUserService{
    
        @Autowired
        private SysUserMapper sysUserMapper;
    
        
        @Override
        public IPage findSysUserByPage(Page page, SysUser sysUser) {
            page.addOrder(OrderItem.desc("create_time"));
            return sysUserMapper.selectPage(page, new LambdaQueryWrapper()
                    .like(!StringUtils.isEmpty(sysUser.getUsername()), SysUser::getUsername, sysUser.getUsername())
                    .eq(!ObjectUtils.isEmpty(sysUser.getStatus()), SysUser::getStatus, sysUser.getStatus()));
    
        }
    }
    
转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/949279.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号