Spring boot整合Mybatis

上一遍博客已经简单的给大家介绍了什么是Spring boot，今天给大家带来一遍关于Spring boot如何整合Mybatis。

1. 引入依赖Jar包

<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>

2. 配置数据库连接信息

spring:
  datasource:
    url: jdbc:mysql://127.0.0.1/test?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver
    testOnBorrow: true
    validationQuery: select 1

3.启动类上指定mapper接口的路径

@MapperScan(“com.huawang.demo.mapper”)

4. 编写mapper的sql

<select id="findAll" resultType="com.huawang.demo.entity.User">
        SELECT  * from users;
    </select>

5.编写测试代码

@RunWith(SpringRunner.class)
@SpringBootTest
public class UserMapperTest {

    @Autowired
    private UserMapper userMapper;
    @Test
    public void test(){
        List<User> userList = userMapper.findAll();
        System.out.println(userList);

    }
}

6.测试结果

最后能查看到结果，说明我们Spring boot整合mysql已经完成了