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

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

原文链接

我们这一篇博客讲的是如何整合Springboot和Mybatis框架，然后使用generator自动生成mapper，pojo等文件。然后再使用阿里巴巴提供的开源连接池druid，这个连接池的好处我就不说了，集合了所有连接池的好处，并且还提供了监控等功能，加大了可扩展性等等。

1. 创建一个springboot项目：

2.可以看到的是我们除了引入web依赖之外还引入了三个依赖，分别是MySQL,JDBC,Mybatis，我们如下观看一下完整的依赖情况：

1 <?xml version="1.0" encoding="UTF-8"?>
2 <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
3 xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
4 <modelVersion>4.0.0</modelVersion>
5
6 <groupId>com.example</groupId>
7 <artifactId>springboot-mybatis02</artifactId>
8 <version>0.0.1-SNAPSHOT</version>
9 <packaging>jar</packaging>
10
11 <name>springboot-mybatis02</name>
12 <description>Demo project for Spring Boot</description>
13
14 <parent>
15 <groupId>org.springframework.boot</groupId>
16 <artifactId>spring-boot-starter-parent</artifactId>
17 <version>2.0.1.RELEASE</version>
18 <relativePath/> 
19 </parent>
20
21 <properties>
22 <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
23 <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
24 <java.version>1.8</java.version>
25 </properties>
26
27 <dependencies>
28 <dependency>
29 <groupId>org.springframework.boot</groupId>
30 <artifactId>spring-boot-starter-jdbc</artifactId>
31 </dependency>
32
33 
34 <dependency>
35 <groupId>org.springframework.boot</groupId>
36 <artifactId>spring-boot-starter-web</artifactId>
37 </dependency>
38
39 
40 <dependency>
41 <groupId>org.mybatis.spring.boot</groupId>
42 <artifactId>mybatis-spring-boot-starter</artifactId>
43 <version>1.3.2</version>
44 </dependency>
45
46 
47 <dependency>
48 <groupId>mysql</groupId>
49 <artifactId>mysql-connector-java</artifactId>
50 <scope>runtime</scope>
51 </dependency>
52
53 
54 
55 <dependency>
56 <groupId>com.alibaba</groupId>
57 <artifactId>druid-spring-boot-starter</artifactId>
58 <version>1.1.1</version>
59 </dependency>
60
61 
62 <dependency>
63 <groupId>org.springframework.boot</groupId>
64 <artifactId>spring-boot-devtools</artifactId>
65 </dependency>
66
67 
68 <dependency>
69 <groupId>org.springframework.boot</groupId>
70 <artifactId>spring-boot-starter-thymeleaf</artifactId>
71 </dependency>
72
73
74 
75 <dependency>
76 <groupId>com.github.pagehelper</groupId>
77 <artifactId>pagehelper-spring-boot-starter</artifactId>
78 <version>4.1.6</version>
79 </dependency>
80
81 <dependency>
82 <groupId>org.springframework.boot</groupId>
83 <artifactId>spring-boot-starter-test</artifactId>
84 <scope>test</scope>
85 </dependency>
86 </dependencies>
87
88 <build>
89 <plugins>
90 <plugin>
91 <groupId>org.springframework.boot</groupId>
92 <artifactId>spring-boot-maven-plugin</artifactId>
93 </plugin>
94
95 
96 <plugin>
97 <groupId>org.mybatis.generator</groupId>
98 <artifactId>mybatis-generator-maven-plugin</artifactId>
99 <version>1.3.2</version>
100 <configuration>
101 <configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
102 <overwrite>true</overwrite>
103 <verbose>true</verbose>
104 </configuration>
105 </plugin>
106 </plugins>
107 </build>
108
109
110 </project>

3.依赖引入完成以后我们再对application.properties配置文件进行编辑：

1 #设置访问端口
2 server.port=80
3
4 #thymeleaf配置,这里是可以省略的，因为默认配置已经足够
5 #关闭缓存，及时刷新页面,这一点很重要
6 spring.thymeleaf.cache=false
7 #注释的部分是Thymeleaf默认的配置，如有其它需求可以自行更改
8 #spring.thymeleaf.prefix=classpath:/templates/
9 #spring.thymeleaf.suffix=.html
10 #spring.thymeleaf.mode=HTML5
11 #spring.thymeleaf.encoding=UTF-8
12 #spring.thymeleaf.servlet.content-type=text/html
13
14
15 #设置热部署
16 #开启热部署
17 spring.devtools.restart.enabled=true
18 #重启范围
19 spring.devtools.restart.additional-paths=src/main/java
20
21 #设置数据源
22 #数据库连接用户名
23 spring.datasource.username=root
24 #数据库连接密码
25 spring.datasource.password=123
26 #驱动
27 spring.datasource.driver-class-name= com.mysql.jdbc.Driver
28 #数据库连接路径
29 spring.datasource.url=jdbc:mysql://localhost:3306/bysj
30 #连接池类型
31 spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
32
33 #连接池配置，因为springboot默认是开启了连接池的，它有默认配置，这一段可以忽略
34 # 初始化大小，最小，最大
35 spring.datasource.initialSize=5
36 spring.datasource.minIdle=5
37 spring.datasource.maxActive=20
38 # 配置获取连接等待超时的时间
39 spring.datasource.maxWait=60000
40 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
41 spring.datasource.timeBetweenEvictionRunsMillis=60000
42 # 配置一个连接在池中最小生存的时间，单位是毫秒
43 spring.datasource.minEvictableIdleTimeMillis=300000
44 spring.datasource.validationQuery=SELECT 1 FROM DUAL
45 spring.datasource.testWhileIdle=true
46 spring.datasource.testOnBorrow=false
47 spring.datasource.testOnReturn=false
48 # 打开PSCache，并且指定每个连接上PSCache的大小
49 spring.datasource.poolPreparedStatements=true
50 spring.datasource.maxPoolPreparedStatementPerConnectionSize=20
51 # 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
52 spring.datasource.filters=stat,wall,log4j
53 # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
54 spring.datasource.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
55
56 #配置mybatis
57 mybatis.mapper-location=classpath:mapping/*.xml
58 #全局的映射，不用在xml文件写实体类的全路径
59 mybatis.type-aliases-package=com.zsl.pojo
60 #开启驼峰映射
mybatis.configuration.map-underscore-to-camel-case=true
61 #配置分页插件
62 #pagehelper分页插件
pagehelper.helper-dialect=mysql
pagehelper.reasonable=true
pagehelper.support-methods-arguments=true
pagehelper.params=count=countSql

4.配置generator自动生成代码：文件放置的位置就在pom.xml文件里面一如插件的位置${basedir}/src/main/resources/generator/generatorConfig.xml

1 <?xml version="1.0" encoding="UTF-8"?>
2 <!DOCTYPE generatorConfiguration
3 PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
4 "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
5 <generatorConfiguration>
6 
7 <classPathEntry location="C:\mysql-connector-java-5.1.41.jar"/>
8 <context id="DB2Tables" targetRuntime="MyBatis3">
9 <commentGenerator>
10 <property name="suppressDate" value="true"/>
11 
12 <property name="suppressAllComments" value="true"/>
13 </commentGenerator>
14 
15 <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost/bysj" userId="root" password="123">
16 </jdbcConnection>
17 <javaTypeResolver>
18 <property name="forceBigDecimals" value="false"/>
19 </javaTypeResolver>
20 
21 <javaModelGenerator targetPackage="com.zsl.pojo" targetProject="src/main/java">
22 <property name="enableSubPackages" value="true"/>
23 <property name="trimStrings" value="true"/>
24 </javaModelGenerator>
25 
26 <sqlMapGenerator targetPackage="mapping" targetProject="src/main/resources">
27 <property name="enableSubPackages" value="true"/>
28 </sqlMapGenerator>
29 
30 <javaClientGenerator type="XMLMAPPER" targetPackage="com.zsl.mapper" targetProject="src/main/java">
31 <property name="enableSubPackages" value="true"/>
32 </javaClientGenerator>
33 
34 <table tableName="user" domainObjectName="User" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>
35 </context>
36 </generatorConfiguration>

5.创建数据库以及表格

CREATE DATABASE bysj;CREATE TABLE user(
user_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
user_name VARCHAR(255) NOT NULL ,
password VARCHAR(255) NOT NULL ,
phone VARCHAR(255) NOT NULL
) ENGINE=INNODB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8;

6. 操作IDEA生成代码：Run-->Edit Configurations

回到下图所示页面的时候点击三角即可：

7.查看项目情况以及生成代码：

7.1：生成的mapper：

7.2：生成的pojo实体类：

7.3生成的mapper的xml文件：在这里务必要注意namespace是否正确，请注意查看这一点

1 <?xml version="1.0" encoding="UTF-8" ?>
2 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
3 <mapper namespace="com.zsl.mapper.UserMapper" >
4 <resultMap id="BaseResultMap" type="com.zsl.pojo.User" >
5 <id column="user_id" property="userId" jdbcType="INTEGER" />
6 <result column="user_name" property="userName" jdbcType="VARCHAR" />
7 <result column="password" property="password" jdbcType="VARCHAR" />
8 <result column="phone" property="phone" jdbcType="VARCHAR" />
9 </resultMap>
10 <sql id="Base_Column_List" >
11 user_id, user_name, password, phone
12 </sql>

<select id="selectAllUser" resultType="user">
select
<include refid="Base_Column_List" />
from user;
</select>
13 <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
14 select
15 <include refid="Base_Column_List" />
16 from user
17 where user_id = #{userId,jdbcType=INTEGER}
18 </select>
19 <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
20 delete from user
21 where user_id = #{userId,jdbcType=INTEGER}
22 </delete>
23 <insert id="insert" parameterType="com.zsl.pojo.User" >
24 insert into user (user_id, user_name, password,
25 phone)
26 values (#{userId,jdbcType=INTEGER}, #{userName,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR},
27 #{phone,jdbcType=VARCHAR})
28 </insert>
29 <insert id="insertSelective" parameterType="com.zsl.pojo.User" >
30 insert into user
31 <trim prefix="(" suffix=")" suffixOverrides="," >
32 <if test="userId != null" >
33 user_id,
34 </if>
35 <if test="userName != null" >
36 user_name,
37 </if>
38 <if test="password != null" >
39 password,
40 </if>
41 <if test="phone != null" >
42 phone,
43 </if>
44 </trim>
45 <trim prefix="values (" suffix=")" suffixOverrides="," >
46 <if test="userId != null" >
47 #{userId,jdbcType=INTEGER},
48 </if>
49 <if test="userName != null" >
50 #{userName,jdbcType=VARCHAR},
51 </if>
52 <if test="password != null" >
53 #{password,jdbcType=VARCHAR},
54 </if>
55 <if test="phone != null" >
56 #{phone,jdbcType=VARCHAR},
57 </if>
58 </trim>
59 </insert>
60 <update id="updateByPrimaryKeySelective" parameterType="com.zsl.pojo.User" >
61 update user
62 <set >
63 <if test="userName != null" >
64 user_name = #{userName,jdbcType=VARCHAR},
65 </if>
66 <if test="password != null" >
67 password = #{password,jdbcType=VARCHAR},
68 </if>
69 <if test="phone != null" >
70 phone = #{phone,jdbcType=VARCHAR},
71 </if>
72 </set>
73 where user_id = #{userId,jdbcType=INTEGER}
74 </update>
75 <update id="updateByPrimaryKey" parameterType="com.zsl.pojo.User" >
76 update user
77 set user_name = #{userName,jdbcType=VARCHAR},
78 password = #{password,jdbcType=VARCHAR},
79 phone = #{phone,jdbcType=VARCHAR}
80 where user_id = #{userId,jdbcType=INTEGER}
81 </update>
82 </mapper>

7.4项目的总体结构：

7.5 自己用于测试分页，驼峰映射，实体类映射等配置的controller，service

1 package com.zsl.controller;
2
3 import com.zsl.pojo.User;
4 import com.zsl.service.impl.UserServiceImpl;
5 import org.springframework.stereotype.Controller;
6 import org.springframework.web.bind.annotation.RequestMapping;
7 import org.springframework.web.bind.annotation.ResponseBody;
8
9 import javax.annotation.Resource;
10 import java.util.List;
11
12 @Controller
13 public class Userontroller {
14
15 @Resource
16 private UserServiceImpl userService;
17
18 //增加用户
19 @ResponseBody
20 @RequestMapping("/insertUser")
21 public String insertUser(User user){
22 return userService.insertUser(user);
23 }
24
25 //查询所有的用户
26 @ResponseBody
27 @RequestMapping("/selectAllUser")
28 public String getAllUser(){
29 List<User> list = userService.selectAllUser();
30 System.out.println(list.size());
31 System.out.println(list);
32 System.out.println(list.get(1).getUserId());
33 return null;
34 }
35 }

1 package com.zsl.service.impl;
2
3 import com.zsl.mapper.UserMapper;
4 import com.zsl.pojo.User;
5 import com.zsl.service.UserService;
6 import org.springframework.beans.factory.annotation.Autowired;
7 import org.springframework.stereotype.Service;
8
9 import java.util.List;
10
11 @Service
12 public class UserServiceImpl implements UserService {
13
14 @Autowired
15 private UserMapper userMapper;//报错不影响
16 /*
17 * 增加/修改用户
18 * */
19 @Override
20 public String insertUser(User user) {
21 //增加用户
22 if(user.getUserId() == null){
23 Integer i = userMapper.insert(user);
24 if(i != 0 && i != null){
25 return "success";
26 }
27 }
28 return null;
29 }
30
31 @Override
32 public List<User> selectAllUser() {
33 //PageHelper.startPage(1, 3);
34 List<User> list = userMapper.selectAllUser();
35 return list;
36 }
37 }