MyBatis 在Spring boot项目中快速集成mybatis和mysql

墨蓝 2022-06-05 12:20 208阅读 0赞

**1.首先在pom.xml文件中导入Jar包**

<dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot</artifactId>
        <version>1.1.1</version>
    </dependency>
    
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <scope>runtime</scope>
    </dependency>

--------------------

**2.在src –> main –>resources文件夹下添加 mybatis-config.xml**   
**mybatis的配置文件**

<?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>
            
            <setting name="cacheEnabled" value="true"/>
            
            <setting name="defaultStatementTimeout" value="3000"/>
            
            <setting name="mapUnderscoreToCamelCase" value="true"/>
            
            <setting name="useGeneratedKeys" value="true"/>
        </settings>
    
        
    
    </configuration>

--------------------

**3.在application.properties中添加连接**

spring.datasource.url=jdbc:mysql://localhost:3306/myzhihu?useUnicode=true&characterEncoding=utf8&useSSL=false  //myzhihu是我连接的database名
    spring.datasource.username=root  //这里输入你数据库的帐号
    spring.datasource.password=123   //这里输入你数据库的的密码
    mybatis.config-location=classpath:mybatis-config.xml