Spring Boot整合Mybatis+PageHelper分页插件

最新推荐文章于 2025-07-16 17:46:22 发布

原创最新推荐文章于 2025-07-16 17:46:22 发布 · 166 阅读

CC 4.0 BY-SA版权

本文介绍如何在SpringBoot项目中整合Mybatis和PageHelper分页插件，包括配置Pom.xml依赖、application.yml配置文件、启动类注解及目录结构。通过具体案例展示了实体类、DAO层、Service层、Controller层的实现，以及分页查询结果和SQL语句打印。

Spring Boot整合Mybatis+PageHelper分页插件

Pom.xml

基础的依赖我就不再这里给大家一个展示出来了,把用到的依赖给大家展示出来

<!-- Mybatis依赖 -->
<dependency>
   	<groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.0.1</version>
</dependency>
 <!-- 分页依赖 -->
<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper-spring-boot-starter</artifactId>
    <version>1.2.3</version>
</dependency>
 <build>
  <!-- 扫描mapper包 -->
	<resources>
	    <resource>
	        <directory>src/main/java</directory>
	        <filtering>false</filtering>
	        <includes>
	            <include>**/mapper/*.xml</include>
	        </includes>
	    </resource>
	</resources>
 </build>

application.yml

配置文件这里用的是.yml文件

server:
  port: 8899
# database
spring:
  datasource:
    username: root
    password: root
    url: jdbc:mysql://localhost:3306/test?useUnicode=true&amp&characterEncoding=utf-8&serverTimezone=GMT%2B8
    driver-class-name: com.mysql.cj.jdbc.Driver
# pagehelper
pagehelper:
  helper-dialect: mysql
  reasonable: true
  support-methods-arguments: true
  params: count=countsql
#  mapper
mybatis:
# 扫描mapper
  mapper-locations: classpath:com/XXX/*/mapper/*.xml
# 打印Sql语句
 configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
#    驼峰命名法与数据库字段有下划线的对应
    map-underscore-to-camel-case: true

启动入口

@SpringBootApplication
@MapperScan("com.XXX.dao")
public class MybatisPlusApplication {
    public static void main(String[] args) {
        SpringApplication.run(MybatisPlusApplication.class, args);
    }
}

加入了@MapperScan注解用来扫描dao层接口不加入的话则会找不到dao层里面的接口