springboot集成mybatis以及分页插件

缺乏、安全感 2022-03-30 11:30 353阅读 0赞

### 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>
    
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <scope>test</scope>
            </dependency>
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
            </dependency>
    
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
            </dependency>
            
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>1.1.1</version>
            </dependency>
    
            
            <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>

项目整体结构图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70][]

*  第八步：测试

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);
            }
        }
    }

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 2][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70]: /images/20220330/5a3f4bcd27e24fd49f81052b1bcfc124.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 1]: /images/20220330/f17fde36f7ba454382c24269585b85cd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 2]: /images/20220330/a9602612b3d4435ba5dfce2ed27b10df.png