springboot集成mybatis以及分页插件

springboot集成mybatis以及分页插件：

• 第一步：新建maven项目，导入依赖项

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <parent>
        <artifactId>springboot_parent</artifactId>
        <groupId>cn.mesmile</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>_08_ssm_jdbc_springboot</artifactId>

        <parent>
	    <groupId>org.springframework.boot</groupId>
	    <artifactId>spring-boot-starter-parent</artifactId>
	    <version>2.0.5.RELEASE</version>
	</parent>

    <dependencies>

        <!-- springboot web -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <scope>test</scope>
        </dependency>
        <!-- springboot测试 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
        </dependency>

        <!-- mysql 数据库驱动. -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!--springboot核心，支持自动配置-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>

        <!--
    	MyBatis提供了拦截器接口，我们可以实现自己的拦截器，
    	将其作为一个plugin装入到SqlSessionFactory中。
     -->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>4.1.0</version>
        </dependency>

    </dependencies>

</project>

• 第二步：新建一个springboot入口类

package cn.mesmile;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.test.context.SpringBootTest;

/**
 * @Created with IDEA
 * @author: Super Zheng
 * @Description: java类作用描述
 * @Date:2019/1/3
 * @Time:17:58
 * 
 * @MapperScan("cn.mesmile.mapper") 是用于扫描mapper层的
 */
@MapperScan("cn.mesmile.mapper")
@SpringBootApplication
public class SsmApplication {

    public static void main(String[] args) {
        // 开启springboot应用
        SpringApplication.run(SsmApplication.class);
    }
}

• 第三步：新建一个java类用于分页插件的配置

package cn.mesmile.config;

import com.github.pagehelper.PageHelper;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import java.util.Properties;

/**
 * @Created with IDEA
 * @author: Super Zheng
 * @Description: java类作用描述
 * @Date:2019/1/3
 * @Time:19:48
 *
 * @Configuration相当于配置applicationContext-xxx.xml <beans></beans>
 */
@Configuration
public class MyBatisConfiguration {

    @Bean
    public PageHelper pageHelper() {
        System.out.println("MyBatisConfiguration.pageHelper()");
        PageHelper pageHelper = new PageHelper();
        Properties p = new Properties();
        p.setProperty("offsetAsPageNum", "true");
        p.setProperty("rowBoundsWithCount", "true");
        p.setProperty("reasonable", "true");
        pageHelper.setProperties(p);
        return pageHelper;
    }
}

• 第四步：新建domainMapper类，domain类省略，mapper层相当于dao层

package cn.mesmile.mapper;

import cn.mesmile.domain.Person;
import cn.mesmile.query.PersonQuery;

import java.util.List;

/**
 * @Created with IDEA
 * @author: Super Zheng
 * @Description: java类作用描述
 * @Date:2019/1/3
 * @Time:16:05
 */
public interface PersonMapper {
    /**
     * 保存方法
     * @param person
     */
    void save(Person person);

    /**
     * 分页插件
     * @param query
     * @return
     */
    List<Person> queryPage(PersonQuery query);
}

• 第五步：新建service层和service的实现层

package cn.mesmile.service;

import cn.mesmile.domain.Person;
import cn.mesmile.query.PersonQuery;

import java.util.List;

/**
 * @Created with IDEA
 * @author: Super Zheng
 * @Description: java类作用描述
 * @Date:2019/1/3
 * @Time:16:07
 */
public interface IPersonService {

    /**
     * 这是添加数据方法
     * @param person
     */
    void add(Person person);

    /**
     * 分页查询
     * @param query
     * @return
     */
    List<Person> queryPage(PersonQuery query);
}

实现类：

package cn.mesmile.service.impl;

import cn.mesmile.domain.Person;
import cn.mesmile.mapper.PersonMapper;
import cn.mesmile.query.PersonQuery;
import cn.mesmile.service.IPersonService;
import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

/**
 * @Created with IDEA
 * @author: Super Zheng
 * @Description: java类作用描述
 * @Date:2019/1/3
 * @Time:16:08
 */
@Service
@Transactional(propagation = Propagation.SUPPORTS,readOnly = true,rollbackFor = {})
public class PersonServiceImpl implements IPersonService {

    @Autowired
    private PersonMapper personMapper;

    @Transactional(rollbackFor = {})
    @Override
    public void add(Person person) {
        personMapper.save(person);
    }

    @Override
    public List<Person> queryPage(PersonQuery query) {
        // 分页插件的使用
        PageHelper.startPage(1, 2);
        return personMapper.queryPage(query);
    }
}

第六步：新建配置文件，用于连接数据库，以及用于别名  这里使用配置文件为:application.yml

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/test
    driver-class-name: com.mysql.jdbc.Driver
    password: 数据库密码
    username: 数据库登陆名
#配置别名
mybatis:
  type-aliases-package: cn.mesmile.domain,cn.mesmile.query

• 第七步：写domainMapper.xml文件 ，主要用于 sql语句的书写

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.mesmile.mapper.PersonMapper">

    <insert id="save" parameterType="Person" useGeneratedKeys="true" keyProperty="id" keyColumn="id">
        INSERT INTO t_person (name) VALUES (#{name})
    </insert>

    <select id="queryPage" parameterType="PersonQuery" resultType="Person">
        SELECT * FROM t_person
    </select>

</mapper>

项目整体结构图：

• 第八步：测试

package cn.mesmile.service;

import cn.mesmile.SsmApplication;
import cn.mesmile.domain.Person;
import cn.mesmile.query.PersonQuery;
import com.github.pagehelper.Page;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import java.util.List;

import static org.junit.Assert.*;

/**
 * @Created with IDEA
 * @author: Super Zheng
 * @Description: java类作用描述
 * @Date:2019/1/3
 * @Time:18:11
 */
@RunWith(SpringRunner.class)
@SpringBootTest(classes = SsmApplication.class)
public class IPersonServiceTest {

    @Autowired
    private IPersonService personService;

    /**
     * 测试添加
     */
    @Test
    public void add() {
        Person person = new Person("spring");
        System.out.println("添加数据之前："+person);
        personService.add(person);
        System.out.println("添加数据之后："+person);
    }

    /**
     * 测试通过，分页插件查询
     */
    @Test
    public void testPageQuery () {
        Page<Person> page = (Page<Person>) personService.queryPage(new PersonQuery());
        System.out.println("总数据条数："+page.getTotal());
        System.out.println("总页数："+page.getPages());
        System.out.println("当前页数："+page.getPageNum());
        System.out.println("每页显示条数："+page.getPageSize());
        for (Person person : page) {
            System.out.println(person);
        }
    }
}