Springboot集成mybatis plus时的分页使用
1.添加架包
com.baomidou.mybatis-plus
2.配置文件并添加分页插件
# Tomcat
server:tomcat:uri-encoding: UTF-8max-threads: 1000min-spare-threads: 30port: 8080servlet:context-path: /spring:profiles:active: devjackson:date-format: yyyy-MM-dd HH:mm:sstime-zone: GMT+8servlet:multipart:max-file-size: 100MBmax-request-size: 100MBenabled: trueredis:database: 0host: 116.62.117.145port: 6379password: ziyun123 # 密码（默认为空）timeout: 6000ms # 连接超时时长（毫秒）jedis:pool:max-active: 1000 # 连接池最大连接数（使用负值表示没有限制）max-wait: -1ms # 连接池最大阻塞等待时间（使用负值表示没有限制）max-idle: 10 # 连接池中的最大空闲连接min-idle: 5 # 连接池中的最小空闲连接freemarker:suffix: .htmlrequest-context-attribute: requestrenren:redis:open: true # 是否开启redis缓存 true开启 false关闭shiro:redis: true # true表示shiro session存到redis里，需要开启redis，才会生效【分布式场景】schedule:open: true #打开 关闭定时任务j2cache:configLocation: /j2cache-dev.propertiesopenSpringCache: 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: -1logic-not-delete-value: 0#自定义填充策略接口实现#meta-object-handler: com.baomidou.springboot.xxx#自定义SQL注入器sql-injector: com.baomidou.mybatisplus.mapper.LogicSqlInjectorconfiguration:map-underscore-to-camel-case: truecache-enabled: falsecall-setters-on-nulls: true# 日志
logging:
# level: debug
# level.io.renren: debugpath: logs/file: admin.loglevel:com.ziyun.erp.modules.*.dao: debug单表分页
Java代码
public static void testPageListUser() {Page page = new Page(1,10);Map params=new HashMap();condition.put("name", "测试");//String name="测试";List 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 implements ConfigMemberLevelService {@Autowiredprivate ConfigMemberLevelDao configMemberLevelDao;@Overridepublic PageUtils queryPage(Map params) {Page page = this.selectPage(new Query(params).getPage(),new EntityWrapper());return new PageUtils(page);} 多表查询分页需自己写sql
ServiceImpl
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.java.common.utils.PageUtils; @Overridepublic PageUtils queryPageItemComments(Integer pageNo, Integer size, Integer commentLevel, String itemId) {Page page = new Page<>(pageNo, size);List 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 {List queryItemComments(IPage page, @Param("commentLevel") Integer commentLevel, @Param("itemId") String itemId);} Xml
本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！