Springboot集成mybatis plus时的分页使用

╰+哭是因爲堅強的太久メ 2022-05-15 09:43 199阅读 0赞

1.添加架包

com.baomidou.mybatis-plus

2.配置文件并添加分页插件

# Tomcat
    server:
      tomcat:
        uri-encoding: UTF-8
        max-threads: 1000
        min-spare-threads: 30
      port: 8080
      servlet:
        context-path: /
    
    spring:
      profiles:
        active: dev
      jackson:
        date-format: yyyy-MM-dd HH:mm:ss
        time-zone: GMT+8
      servlet:
        multipart:
          max-file-size: 100MB
          max-request-size: 100MB
          enabled: true
      redis:
        database: 0
        host: 116.62.117.145
        port: 6379
        password: ziyun123      # 密码（默认为空）
        timeout: 6000ms  # 连接超时时长（毫秒）
        jedis:
          pool:
            max-active: 1000  # 连接池最大连接数（使用负值表示没有限制）
            max-wait: -1ms      # 连接池最大阻塞等待时间（使用负值表示没有限制）
            max-idle: 10      # 连接池中的最大空闲连接
            min-idle: 5       # 连接池中的最小空闲连接
      freemarker:
        suffix: .html
        request-context-attribute: request
    
    
    renren:
      redis:
        open: true  # 是否开启redis缓存  true开启   false关闭
      shiro:
        redis: true # true表示shiro session存到redis里，需要开启redis，才会生效【分布式场景】
      schedule:
        open: true #打开 关闭定时任务
    
    
    j2cache:
      configLocation: /j2cache-dev.properties
      openSpringCache: false
    
    #mybatis
    mybatis-plus:
      mapper-locations: classpath*:mapper/**/*.xml
      #实体扫描，多个package用逗号或者分号分隔
      typeAliasesPackage: io.renren.modules.*.entity;
      global-config:
        #主键类型  0:"数据库ID自增", 1:"用户输入ID",2:"全局唯一ID (数字类型唯一ID)", 3:"全局唯一ID UUID";
        id-type: 0
        #字段策略 0:"忽略判断",1:"非 NULL 判断"),2:"非空判断"
        field-strategy: 2
        #驼峰下划线转换
        db-column-underline: true
        #刷新mapper 调试神器
        refresh-mapper: true
        #数据库大写下划线转换
        #capital-mode: true
        # Sequence序列接口实现类配置
        #key-generator: com.baomidou.mybatisplus.incrementer.OracleKeyGenerator
        #逻辑删除配置
        logic-delete-value: -1
        logic-not-delete-value: 0
        #自定义填充策略接口实现
        #meta-object-handler: com.baomidou.springboot.xxx
        #自定义SQL注入器
        sql-injector: com.baomidou.mybatisplus.mapper.LogicSqlInjector
      configuration:
        map-underscore-to-camel-case: true
        cache-enabled: false
        call-setters-on-nulls: true
    
    # 日志
    logging:
    #  level: debug
    #  level.io.renren: debug
      path: logs/
      file: admin.log
      level:
          com.ziyun.erp.modules.*.dao: debug

单表分页

<select id="selectUserList" parameterType="map" resultType="com.test.mybatisplus.pojo.User">
            SELECT
            <include refid="Base_Column_List" />
            FROM user
            WHERE name LIKE CONCAT("%",#{name},"%")
        </select>

Java代码

public static void testPageListUser() {
            Page<User> page = new Page<User>(1,10);
    
            Map<String, Object> params=new HashMap<String, Object>();
            condition.put("name", "测试");
            //String name="测试";
            List<User> lstUser = userDao.selectUserList(page,params);
          
        }

在人人框架中使用

单表不用写sql

package com.ziyun.erp.modules.member.service.impl;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import java.util.HashMap;
    import java.util.Map;
    import com.baomidou.mybatisplus.mapper.EntityWrapper;
    import com.baomidou.mybatisplus.plugins.Page;
    import com.baomidou.mybatisplus.service.impl.ServiceImpl;
    import io.renren.common.utils.PageUtils;
    import io.renren.common.utils.Query;
    
    import com.ziyun.erp.modules.member.dao.ConfigMemberLevelDao;
    import com.ziyun.erp.modules.member.entity.ConfigMemberLevelEntity;
    import com.ziyun.erp.modules.member.service.ConfigMemberLevelService;
    import org.springframework.transaction.annotation.Transactional;
    
    
    @Service("configMemberLevelService")
    public class ConfigMemberLevelServiceImpl extends ServiceImpl<ConfigMemberLevelDao, ConfigMemberLevelEntity> implements ConfigMemberLevelService {
    
        @Autowired
        private ConfigMemberLevelDao configMemberLevelDao;
    
        @Override
        public PageUtils queryPage(Map<String, Object> params) {
            Page<ConfigMemberLevelEntity> page = this.selectPage(
                    new Query<ConfigMemberLevelEntity>(params).getPage(),
                    new EntityWrapper<ConfigMemberLevelEntity>()
            );
    
            return new PageUtils(page);
        }

多表查询分页需自己写sql

ServiceImpl

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;   
    import com.java.common.utils.PageUtils; 
    
        @Override
        public PageUtils queryPageItemComments(Integer pageNo, Integer size, Integer commentLevel, String itemId) {
            Page<ItemCommentVO> page = new Page<>(pageNo, size);
            List<ItemCommentVO> list = this.baseMapper.queryItemComments(page, commentLevel, itemId);
            page.setRecords(list);
            return new PageUtils(page);
        }

Dao层方法的参数传入Pagination page即可,现在是IPage

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
    import com.baomidou.mybatisplus.core.metadata.IPage;
    import com.java.pojo.Items;
    import com.java.pojo.vo.ItemCommentVO;
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Param;
    
    import java.util.List;
    
    @Mapper
    public interface ItemsDao extends BaseMapper<Items> {
    
        List<ItemCommentVO> queryItemComments(IPage<ItemCommentVO> page, @Param("commentLevel") Integer commentLevel, @Param("itemId") String itemId);
    	
    }

Xml

<select id="queryItemComments" resultType="com.java.pojo.vo.ItemCommentVO">
            SELECT
                ic.`comment_level` AS comment_level,
                ic.`content` AS content,
                ic.`sepc_name` AS sepcName,
                ic.`created_time` AS createdTime,
                u.`face` AS userFace,
                u.`nickname` AS nickname
                FROM
                `items_comments` ic
                LEFT JOIN
                `users` u
                ON
                ic.`user_id` = u.`id`
                WHERE
                ic.`item_id` = #{itemId}
            <if test="commentLevel != null">
                AND ic.`comment_level` = #{commentLevel}
            </if>
        </select>