Springboot整合Mybatis框架-helloworld

0x01 pom.xml需要增加的部分：

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

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

0x02  application.properties增加配置

mybatis.mapperLocations=classpath:mappers/*.xml
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=123456

0x03 写dao文件Mapper.xml文件以及实体类

实体类：

对应数据库表：

dao包下：UserMapper接口

resources资源目录下新建mappers文件夹，并在该文件夹下新建xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.dao.UserMapper">
    <select id="findAll" resultType="com.bean.User">
--         SELECT username FROM tb_user where id = 1
SELECT * FROM tb_user
    </select>
</mapper>

0x04创建Service接口与实现类并注入IOC容器,在Controller调用

调用：

0x04配置启动 以及测试

启动后，测试