一：SpringBoot + Mysql

  1. pom.xml中添加依赖

    1
2
3
4
5

    <!-- mysql -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>

  2. application.properties中添加数据源

    1
2
3
4

    spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test?characterEncoding=UTF-8
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

二：SpringBoot + Mybatis

  1. SpringBoot+Mysql

  2. 集成Mybatis，pom.xml中添加依赖

    1
2
3
4
5
6

    <!-- mybatis -->
<dependency>
	<groupId>org.mybatis.spring.boot</groupId>
	<artifactId>mybatis-spring-boot-starter</artifactId>
	<version>1.3.2</version>
</dependency>

  3. SpringBoot + Mybatis generator

  4. 配置application.properties中Mybatis配置

    1
2

    mybatis.typeAliasesPackage=com.example.demo.domain
mybatis.mapperLocations=classpath:mapper/*.xml

    启动类添加包扫描 @MapperScan(“com.example.demo.dao”)

三：SpringBoot + Mybatis generator自动生成代码

  1. 数据库SQL语句

    1
2
3
4
5
6
7
8

    CREATE DATABASE IF NOT EXISTS ssm;
use ssm;
CREATE TABLE `user` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `telephone` varchar(255) DEFAULT '' COMMENT '手机号',
 `user_address` varchar(255) DEFAULT '' COMMENT '地址',
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

  2. 修改 pom.xml，添加插件：

     1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18

    <!-- mybatis generator 自动生成代码插件 -->
<plugin>
   <groupId>org.mybatis.generator</groupId>
   <artifactId>mybatis-generator-maven-plugin</artifactId>
   <version>1.3.2</version>
   <dependencies>
       <dependency>
           <groupId>mysql</groupId>
           <artifactId>mysql-connector-java</artifactId>
           <version>${mysql.version}</version>
       </dependency>
   </dependencies>
   <configuration>
       <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
       <overwrite>true</overwrite>
       <verbose>true</verbose>
   </configuration>
</plugin>

    Mysql 版本这样写比较好，不需要考虑版本号；

  3. 在 resources 目录下添加配置文件 generatorConfig.xml

     1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44

    <?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
       PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
       "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
   <context id="Mysql" targetRuntime="MyBatis3">
           
       <!--数据库链接URL，用户名、密码 -->
       <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                       connectionURL="jdbc:mysql://localhost:3306/ssm"
                       userId="root"
                       password="12345678">
       </jdbcConnection>
   
       <javaTypeResolver>
           <!-- This property is used to specify whether MyBatis Generator should
               force the use of java.math.BigDecimal for DECIMAL and NUMERIC fields, -->
           <property name="forceBigDecimals" value="false" />
       </javaTypeResolver>
           
       <!-- 生成模型的包名和位置 -->
       <javaModelGenerator targetPackage="com.zm.mbg_demo.entity" targetProject="src/main/java">
           <property name="enableSubPackages" value="true" />
           <property name="trimStrings" value="true" />
       </javaModelGenerator>
           
       <!-- 生成映射文件的包名和位置-->
       <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources">
           <property name="enableSubPackages" value="true"/>
       </sqlMapGenerator>
           
       <!-- 生成DAO的包名和位置 -->
       <javaClientGenerator type="XMLMAPPER" targetPackage="com.zm.mbg_demo.dao" implementationPackage="com.zm.mbg_demo.dao.impl"  targetProject="src/main/java">
           <property name="enableSubPackages" value="true" />
       </javaClientGenerator>
   
       <!-- 要生成哪些表和实体类 -->
       <table tableName="user"
              enableCountByExample="false" enableUpdateByExample="false"
              enableDeleteByExample="false" enableSelectByExample="false"
              selectByExampleQueryId="false">
       </table>
   </context>
</generatorConfiguration>

  4. 运行插件；

四：SpringBoot + Mybatis + Druid 多数据源

  1. 使用参考链接

  2. 场景：不同的DataSource，SqlSessionFactory和DAO层，在业务逻辑层做整合。

  3. 读写分离