springboot整合mybatis框架

导入依赖

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

编写配置文件

spring:
  datasource:
    username: root
    password: 1234
    url: jdbc:mysql://localhost:3307/mybatis?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
    driver-class-name: com.mysql.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource

#整合mybatis
mybatis:
  type-aliases-package: com.boot.pojo
  mapper-locations: classpath:mybatis/mapper/*.xml

编写dao层

dao接口

@Mapper
@Repository
public interface UserMapper {
    List<User> queryUserList();
}

SQL映射文件

<?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.boot.dao.UserMapper">
    <!--使用insert，update，delete，select标签写sql-->
    <select id="queryUserList" resultType="User">
        select * from t_user
    </select>
</mapper>

编写controller测试

@RestController
public class UserController {

    @Autowired
    private UserMapper userMapper;

    @RequestMapping("/userlist")
    private List<User> queryUserList() {
        return userMapper.queryUserList();
    }
}

结果