SpringBoot整合mybatis+generator自动生成代码+druid连接池+PageHelper分页插件

快来打我* 2022-01-22 15:17 200阅读 0赞

转自： [https://blog.csdn.net/qq\_38977097/article/details/80778004][https_blog.csdn.net_qq_38977097_article_details_80778004]

Spring Boot 中 10 行代码构建 RESTful 风格应用: [https://blog.csdn.net/u012702547/article/details/91038136][https_blog.csdn.net_u012702547_article_details_91038136]

分布式搜索引擎ElasticSearch-Elasticsearch与MySQL数据同步:  [https://blog.csdn.net/shenzhen\_zsw/article/details/90695622][https_blog.csdn.net_shenzhen_zsw_article_details_90695622]

基于ProGuard-Maven-Plugin的自定义代码混淆插件: [https://blog.csdn.net/zhousenshan/article/details/88411416][https_blog.csdn.net_zhousenshan_article_details_88411416]

SpringBoot入门篇--整合mybatis+generator自动生成代码+druid连接池+PageHelper分页插件: [https://blog.csdn.net/weixin\_41722928/article/details/83029809][https_blog.csdn.net_weixin_41722928_article_details_83029809]

Spring Boot （七）MyBatis代码自动生成和辅助插件:  [https://blog.csdn.net/sufu1065/article/details/82905892][https_blog.csdn.net_sufu1065_article_details_82905892]

mybatis表映射文件代码自动生成器（方案三：Maven插件）: [https://blog.csdn.net/tjsahwj/article/details/81264132][https_blog.csdn.net_tjsahwj_article_details_81264132]

springboot之通用mapper和mybatis generator 自动生成代码插件: [https://blog.csdn.net/lyf\_ldh/article/details/80956556][https_blog.csdn.net_lyf_ldh_article_details_80956556]

Springboot结合mybatis-generator自动生成dao接口代码（插件方式）:  [https://blog.csdn.net/lichuangcsdn/article/details/80873229][https_blog.csdn.net_lichuangcsdn_article_details_80873229]

springboot之通用mapper和mybatis generator 自动生成代码插件:  [https://blog.csdn.net/lyf\_ldh/article/details/80956556][https_blog.csdn.net_lyf_ldh_article_details_80956556]

springboot终于迎来了2.0版本，很多新的特性让springboot更加强大，之前使用1.5.6版本整合了Mybatis，现在2.0版本就已经不适用了，所以，在摸索中搭建了2.0版本整合Mybatis

环境/版本一览：  
开发工具：Intellij IDEA 2017.1.3  
springboot: 2.0.1.RELEASE  
jdk：1.8.0\_40  
maven:3.3.9  
alibaba Druid 数据库连接池：1.1.9  
额外功能：  
PageHelper 分页插件  
mybatis generator 自动生成代码插件  
开始搭建：  
创建项目：

添加基础的依赖：

依赖文件：  
按照pom文件补齐需要的依赖：

<?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">  
    <modelVersion>4.0.0</modelVersion>

<groupId>com.sao</groupId>  
    <artifactId>demo</artifactId>  
    <version>0.0.1-SNAPSHOT</version>  
    <packaging>jar</packaging>

<name>demo</name>  
    <description>Demo project for Spring Boot</description>

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

<dependencies>  
        <dependency>  
            <groupId>org.springframework.boot</groupId>  
            <artifactId>spring-boot-starter-jdbc</artifactId>  
        </dependency>  
        <dependency>  
            <groupId>org.springframework.boot</groupId>  
            <artifactId>spring-boot-starter-web</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.3.2</version>  
        </dependency>

<dependency>  
            <groupId>mysql</groupId>  
            <artifactId>mysql-connector-java</artifactId>  
            <scope>runtime</scope>  
        </dependency>

<dependency>  
            <groupId>org.apache.commons</groupId>  
            <artifactId>commons-lang3</artifactId>  
            <version>3.4</version>  
        </dependency>

<dependency>  
            <groupId>com.github.pagehelper</groupId>  
            <artifactId>pagehelper-spring-boot-starter</artifactId>  
            <version>1.2.5</version>  
        </dependency>  
          
        <dependency>  
            <groupId>com.alibaba</groupId>  
            <artifactId>druid-spring-boot-starter</artifactId>  
            <version>1.1.9</version>  
        </dependency>

<dependency>  
            <groupId>com.alibaba</groupId>  
            <artifactId>fastjson</artifactId>  
            <version>1.1.29</version>  
        </dependency>

</dependencies>

<build>  
        <plugins>  
            <plugin>  
                <groupId>org.springframework.boot</groupId>  
                <artifactId>spring-boot-maven-plugin</artifactId>  
            </plugin>

<plugin>  
                <groupId>org.mybatis.generator</groupId>  
                <artifactId>mybatis-generator-maven-plugin</artifactId>  
                <version>1.3.2</version>  
                <configuration>  
                    <configurationFile>$\{basedir\}/src/main/resources/generator/generatorConfig.xml</configurationFile>  
                    <overwrite>true</overwrite>  
                    <verbose>true</verbose>  
                </configuration>  
            </plugin>  
        </plugins>  
    </build>

</project>  
  
项目结构：

项目启动类：  
package com.winterchen;

import org.springframework.boot.SpringApplication;  
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication  
@MapperScan("com.winterchen.dao")  
public class Springboot2MybatisDemoApplication \{

public static void main(String\[\] args) \{  
        SpringApplication.run(Springboot2MybatisDemoApplication.class, args);  
    \}  
\}  
  
配置：  
可以根据个人使用习惯选择使用properties或者yml文件，本项目使用的是yml配置文件，所以把原本application.properties删除，创建一个application.yml文件

在resource文件夹下创建application.yml

server:  
  port: 8080

spring:  
    datasource:  
        name: mysql\_test  
        type: com.alibaba.druid.pool.DruidDataSource  
        \#druid相关配置  
        druid:  
          \#监控统计拦截的filters  
          filters: stat  
          driver-class-name: com.mysql.jdbc.Driver  
          \#基本属性  
          url: jdbc:mysql://127.0.0.1:3306/mytest?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true  
          username: root  
          password: root  
          \#配置初始化大小/最小/最大  
          initial-size: 1  
          min-idle: 1  
          max-active: 20  
          \#获取连接等待超时时间  
          max-wait: 60000  
          \#间隔多久进行一次检测，检测需要关闭的空闲连接  
          time-between-eviction-runs-millis: 60000  
          \#一个连接在池中最小生存的时间  
          min-evictable-idle-time-millis: 300000  
          validation-query: SELECT 'x'  
          test-while-idle: true  
          test-on-borrow: false  
          test-on-return: false  
          \#打开PSCache，并指定每个连接上PSCache的大小。oracle设为true，mysql设为false。分库分表较多推荐设置为false  
          pool-prepared-statements: false  
          max-pool-prepared-statement-per-connection-size: 20

mybatis:  
  mapper-locations: classpath:mapper/\*.xml  
  type-aliases-package: com.winterchen.model

\#pagehelper  
pagehelper:  
    helperDialect: mysql  
    reasonable: true  
    supportMethodsArguments: true  
    params: count=countSql  
    returnPageInfo: check  
  
  
创建包：  
model，dao，mapper

创建数据库和数据表  
CREATE DATABASE mytest;

CREATE TABLE t\_user(  
  userId INT NOT NULL PRIMARY KEY AUTO\_INCREMENT,  
  userName VARCHAR(255) NOT NULL ,  
  password VARCHAR(255) NOT NULL ,  
  phone VARCHAR(255) NOT NULL  
) ENGINE=INNODB AUTO\_INCREMENT=1000 DEFAULT CHARSET=utf8;  
  
创建实体类：UserDomain.java  
package com.winterchen.model;

public class UserDomain \{  
    private Integer userId;

private String userName;

private String password;

private String phone;

// get,set方法略...  
\}  
  
创建dao：  
UserDao.java

package com.winterchen.dao;

import com.winterchen.model.UserDomain;  
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

public interface UserDao \{

int insert(UserDomain record);

List<UserDomain> selectUsers();  
\}  
  
创建mybatis映射文件： UserMapper.xml  
<?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="com.winterchen.dao.UserDao" >  
  <sql id="BASE\_TABLE">  
    t\_user  
  </sql>

<sql id="BASE\_COLUMN">  
    userId,userName,password,phone  
  </sql>

<insert id="insert" parameterType="com.winterchen.model.UserDomain">  
    INSERT INTO  
      <include refid="BASE\_TABLE"/>  
    <trim prefix="(" suffix=")" suffixOverrides=",">  
      userName,password,  
      <if test="phone != null">  
        phone,  
      </if>  
    </trim>  
    <trim prefix="VALUES(" suffix=")" suffixOverrides=",">  
      \#\{userName, jdbcType=VARCHAR\},\#\{password, jdbcType=VARCHAR\},  
      <if test="phone != null">  
        \#\{phone, jdbcType=VARCHAR\},  
      </if>  
    </trim>  
  </insert>

<select id="selectUsers" resultType="com.winterchen.model.UserDomain">  
      SELECT  
        <include refid="BASE\_COLUMN"/>  
      FROM  
        <include refid="BASE\_TABLE"/>  
  </select>

</mapper>  
  
创建剩余的controller，service包和文件  
UserService.java

package com.winterchen.service.user;

import com.github.pagehelper.PageInfo;  
import com.winterchen.model.UserDomain;

import java.util.List;

/\*\*  
 \* Created by Administrator on 2018/4/19.  
 \*/  
public interface UserService \{

int addUser(UserDomain user);

PageInfo<UserDomain> findAllUser(int pageNum, int pageSize);  
\}

UserServiceImpl

package com.winterchen.service.user.impl;

import com.github.pagehelper.PageHelper;  
import com.github.pagehelper.PageInfo;  
import com.winterchen.dao.UserDao;  
import com.winterchen.model.UserDomain;  
import com.winterchen.service.user.UserService;  
import org.springframework.beans.factory.annotation.Autowired;  
import org.springframework.stereotype.Service;

import java.util.List;

/\*\*  
 \* Created by Administrator on 2017/8/16.  
 \*/  
@Service(value = "userService")  
public class UserServiceImpl implements UserService \{

@Autowired  
    private UserDao userDao;//这里会报错，但是并不会影响

@Override  
    public int addUser(UserDomain user) \{

return userDao.insert(user);  
    \}

/\*  
    \* 这个方法中用到了我们开头配置依赖的分页插件pagehelper  
    \* 很简单，只需要在service层传入参数，然后将参数传递给一个插件的一个静态方法即可；  
    \* pageNum 开始页数  
    \* pageSize 每页显示的数据条数  
    \* \*/  
    @Override  
    public PageInfo<UserDomain> findAllUser(int pageNum, int pageSize) \{  
        //将参数传给这个方法就可以实现物理分页了，非常简单。  
        PageHelper.startPage(pageNum, pageSize);  
        List<UserDomain> userDomains = userDao.selectUsers();  
        PageInfo result = new PageInfo(userDomains);  
        return result;  
    \}  
\}

UserController.java

package com.winterchen.controller;

import com.github.pagehelper.PageHelper;  
import com.winterchen.model.UserDomain;  
import com.winterchen.service.user.UserService;  
import org.springframework.beans.factory.annotation.Autowired;  
import org.springframework.stereotype.Controller;  
import org.springframework.web.bind.annotation.\*;

/\*\*  
 \* Created by Administrator on 2017/8/16.  
 \*/  
@Controller  
@RequestMapping(value = "/user")  
public class UserController \{

@Autowired  
    private UserService userService;

@ResponseBody  
    @PostMapping("/add")  
    public int addUser(UserDomain user)\{  
        return userService.addUser(user);  
    \}

@ResponseBody  
    @GetMapping("/all")  
    public Object findAllUser(  
            @RequestParam(name = "pageNum", required = false, defaultValue = "1")  
                    int pageNum,  
            @RequestParam(name = "pageSize", required = false, defaultValue = "10")  
                    int pageSize)\{  
        return userService.findAllUser(pageNum,pageSize);  
    \}  
\}

项目最终的结构

到这里如果项目就成功搭建完成了，如果还是报错的话，请仔细看看配置，后面会给出源码地址，程序员就是要不断和bug进行斗争，加油。

测试  
启动项目

这样就表示启动成功了

然后，开始测试吧，博主使用的是postMan，一个进行http请求的测试工具

添加数据

查询数据

\---------------------   
作者：咸鱼SAO   
来源：CSDN   
原文：https://blog.csdn.net/qq\_38977097/article/details/80778004   
版权声明：本文为博主原创文章，转载请附上博文链接！

[https_blog.csdn.net_qq_38977097_article_details_80778004]: https://blog.csdn.net/qq_38977097/article/details/80778004
[https_blog.csdn.net_u012702547_article_details_91038136]: https://blog.csdn.net/u012702547/article/details/91038136
[https_blog.csdn.net_shenzhen_zsw_article_details_90695622]: https://blog.csdn.net/shenzhen_zsw/article/details/90695622
[https_blog.csdn.net_zhousenshan_article_details_88411416]: https://blog.csdn.net/zhousenshan/article/details/88411416
[https_blog.csdn.net_weixin_41722928_article_details_83029809]: https://blog.csdn.net/weixin_41722928/article/details/83029809
[https_blog.csdn.net_sufu1065_article_details_82905892]: https://blog.csdn.net/sufu1065/article/details/82905892
[https_blog.csdn.net_tjsahwj_article_details_81264132]: https://blog.csdn.net/tjsahwj/article/details/81264132
[https_blog.csdn.net_lyf_ldh_article_details_80956556]: https://blog.csdn.net/lyf_ldh/article/details/80956556
[https_blog.csdn.net_lichuangcsdn_article_details_80873229]: https://blog.csdn.net/lichuangcsdn/article/details/80873229