Spring boot + Mybatis配置（IDEA）多项目模块

简单粗暴的Spring boot + Mybatis配置（IDEA）

总结篇——从零搭建maven多模块springboot+mybatis项目

springboot整合mybatis完整示例, mapper注解方式和xml配置文件方式实现(我们要优雅地编程)

步骤

Mybatis的集成可以简单地概括成两步：

①application.properties增加spring配置数据库链接地址

②pom.xml引入mybatis-spring-boot-starter和mysql-connector-java

以上两个步骤是建立在有spring boot项目的前提之下，下面开始详细说明。

①进入SPRING INITIALIZR

 

 

 

 

磁盘目录

  

②mybatis-config.xml配置文件

在resources目录下手动创建mybatis-config.xml，复制粘贴以下代码。

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <settings>
        <!-- Globally enables or disables any caches configured in any mapper under this configuration -->
        <setting name="cacheEnabled" value="true"/>
        <!-- Sets the number of seconds the driver will wait for a response from the database -->
        <setting name="defaultStatementTimeout" value="3000"/>
        <!-- Enables automatic mapping from classic database column names A_COLUMN to camel case classic Java property names aColumn -->
        <setting name="mapUnderscoreToCamelCase" value="true"/>
        <!-- Allows JDBC support for generated keys. A compatible driver is required.
        This setting forces generated keys to be used if set to true,
         as some drivers deny compatibility but still work -->
        <setting name="useGeneratedKeys" value="true"/>
    </settings>
    <!-- Continue going here -->
</configuration>

③application.properties配置

将以下配置拷贝至application.properties中。

#数据库配置
spring.datasource.url=jdbc:mysql://192.168.0.82:13306/program_shopcart?useUnicode=true&characterEncoding=utf8&useSSL=false
spring.datasource.username=root
spring.datasource.password=123456
mybatis.config-location=classpath:mybatis-config.xml

mybatis里面mapper的xml文件存放位置（application.properties文件里设置）

mybatis.mapper-locations=classpath:dbxml/*.xml

 

已经完成了spring boot + mybatis的集成配置，最终的web项目里面的pom.xml如下

       <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.springframework.boot</groupId>
            <artifactId>spring-boot</artifactId>
            <version>2.2.2.RELEASE</version>
        </dependency>

db.Mybatis项目模块

<!--project shopcart mybatis-->
        <dependency>
            <groupId>tb.db.mysql.shopcart.mybatis</groupId>
            <artifactId>tb.db.mysql.shopcart.mybatis.pojo</artifactId>
            <version>${project.version}</version>
        </dependency>

        <dependency>
            <groupId>tb.db.mysql.shopcart.mybatis</groupId>
            <artifactId>tb.db.mysql.shopcart.mybatis.xml</artifactId>
            <version>${project.version}</version>
        </dependency>

        <dependency>
            <groupId>tb.db.mysql.shopcart.mybatis</groupId>
            <artifactId>tb.db.mysql.shopcart.mybatis.mapper</artifactId>
            <version>${project.version}</version>
        </dependency>

测试Mybatis类型

package tb.view.sbmsm.easyuidemo;

import org.junit.jupiter.api.Test;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import tb.db.mysql.shopcart.mybatis.mapper.Account_userMapper;
import tb.db.mysql.shopcart.mybatis.pojo.Account_user;

/**
 * Created by songtao on 2018/8/21.
 */
@SpringBootTest
@MapperScan(basePackages = {"tb.db.mysql.shopcart.mybatis"})
/**
 * <pre>
 *
 * </pre>
 *
 * @author wangyunpeng
 * @date 2020/1/15 11:04
 */
public class TestMyBatisDB {
    @Autowired
    public Account_userMapper account_userMapper;

    @Test
    public void testDB(){
        Account_user accountUser =  account_userMapper.selectByPrimaryKey(7);
        System.out.println(accountUser.getEmail().toString());

    }
}

Springboot程序入口

package tb.view.sbmsm.easyuidemo;

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

@SpringBootApplication(scanBasePackages = {"tb.view.sbmsm.easyuidemo"})
@MapperScan(basePackages = "tb.db.mysql.shopcart.mybatis")
public class Program {

    public static void main(String[] args) {
        SpringApplication.run(Program.class, args);
    }

}