springBoot整合mybatis连接mysql

springBoot整合mybatis连接mysql，自动配置

一丶项目pom.xml配置说明

<?xml version="1.0" encoding="UTF-8"?>

4.0.0

org.springframework.boot
spring-boot-starter-parent
2.2.0.RELEASE


com.chenwei
springboot_demo
0.0.1-SNAPSHOT
springboot_demo
Demo project for Spring Boot

<properties>
    <java.version>1.8</java.version>
</properties>

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
        <version>2.1.9.RELEASE</version>
    </dependency>

    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
        <exclusions>
            <exclusion>
                <groupId>org.junit.vintage</groupId>
                <artifactId>junit-vintage-engine</artifactId>
            </exclusion>
        </exclusions>
    </dependency>
    <dependency>
        <!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <version>1.18.8</version>
        <scope>provided</scope>
    </dependency>
    <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>6.0.6</version>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-jdbc</artifactId>
    </dependency>
    <dependency>
        <!-- 引入Mybatis -->
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>1.1.1</version>
    </dependency>



</dependencies>

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

application.properties配置文件说明

server.servlet.context-path=/
server.port=80
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/springboot_test?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=root
spring.jpa.show-sql=true

mybatis.mapper-locations=mapper/*Mapper.xml
mybatis.type-aliases-package=com.chenwei.springboot_demo.entry
mybatis.configuration.map-underscore-to-camel-case=true （数据库的自动化将大写转小写的配置）
mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl（数据操作语言的日志在控制台打印）

*Mapper.xml配置文件

<?xml version="1.0" encoding="UTF-8" ?>

<select id="getResult" resultType="Demo">
    SELECT  * FROM demo
</select>

最后说明一下配置之后的效果