SpringBoot 整合使用mybatis及分页插件 (五)

#SpringBoot 整合使用mybatis及分页插件

1.pom文件引入

<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.0.5.RELEASE</version>
	</parent>
	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter</artifactId>
		</dependency>
		<!-- 测试 -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.1.1</version>
		</dependency>
		<!-- mysql 依赖 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>
		<!-- springboot-web组件 -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
	</dependencies>

2.配置文件引入

spring.datasource.url=jdbc:mysql://localhost:3306/jdbc
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

3、Mapper代码

//@Mapper
public interface DeptMapper {

    @Select("SELECT * FROM DEPT WHERE NAME = #{name}")
    Dept findByName(@Param("name") String name);

    @Insert("INSERT INTO DEPT(ID, NAME) VALUES(#{id}, #{name})")
    int insert(@Param("id") int id, @Param("name") String name);

}

4、启动方式

@SpringBootApplication
@MapperScan("com.rp.springboot.dao")
public class SpringbootMybatisApplication {

	public static void main(String[] args) {
		SpringApplication.run(SpringbootMybatisApplication.class, args);
	}
}

5. 实体类

public class Dept {

    private int id;
    private String name;
	
	//get set
	...
}

5、Mybatis整合分页插件

pageHelper

PageHelper 是一款好用的开源免费的 Mybatis 第三方物理分页插件

物理分页

支持常见的 12 种数据库。Oracle,MySql,MariaDB,SQLite,DB2,PostgreSQL,SqlServer 等

支持多种分页方式

支持常见的 RowBounds(PageRowBounds)，PageHelper.startPage 方法调用，Mapper 接口参数调用

5.1 Maven依赖

在上述的pom文件中添加pageHelper依赖：

<!-- springboot 整合 pagehelper -->
		<dependency>
			<groupId>com.github.pagehelper</groupId>
			<artifactId>pagehelper-spring-boot-starter</artifactId>
			<version>1.2.5</version>
		</dependency>
		<dependency>
			<groupId>org.apache.commons</groupId>
			<artifactId>commons-lang3</artifactId>
			<version>3.7</version>
		</dependency>

5.2 配置文件

配置文件中新增 pageHelper 的配置：

logging.level.com.rp.springboot.dao=DEBUG
pagehelper.helperDialect=mysql
pagehelper.reasonable=true
pagehelper.supportMethodsArguments=true
pagehelper.params=count=countSql
pagehelper.page-size-zero=true

5.3 service层的实现

@Service
public class DeptServiceImpl implements DeptService {

    @Autowired
    private DeptMapper deptMapper;

    @Override
    public Dept findByName(String name) {
        return deptMapper.findByName(name);
    }

    @Override
    public int insert(int id, String name) {
        return deptMapper.insert(id,name);
    }

    @Override
    public PageInfo<Dept> getDeptList(int pageNum,int pageSize) {

        // 开启分页插件,放在查询语句上面
        PageHelper.startPage(pageNum,pageSize);
        List<Dept> all = deptMapper.findAll();
        // 封装分页之后的数据
        PageInfo<Dept> info = new PageInfo(all);
        return info;
    }

5.4 Controller层

@RestController
public class DeptController {

    @Autowired
    private DeptService deptService;

    @GetMapping("/getdept/{name}")
    public  Dept getDeptByName(@PathVariable("name")String name){
        Dept byName = deptService.findByName(name);
        return byName;
    }

    @GetMapping("/insert/{id}/{name}")
    public boolean insert(@PathVariable("id") int id,@PathVariable("name")String name){
        int insert = deptService.insert(id, name);
        return insert>=1;
    }

    @GetMapping("/getall/{pageNum}/{pageSize}")
    public PageInfo<Dept> getAll(@PathVariable("pageNum") int pageNum,@PathVariable("pageSize") int pageSize){
        return deptService.getDeptList(pageNum,pageSize);
    }


}

源码地址： https://github.com/ruiace/springboot-mybatis.git