SpringBoot整合Mybatis

1.添加Mybatis的起步依赖

<parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.0.1.RELEASE</version>
    </parent>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!--mybatis起步依赖-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>
        <!-- MySQL连接驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
​
    </dependencies>

2.添加数据库连接信息

application.yml 添加mybatis信息

spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf8
    username: root
    password: 123456
mybatis:
  type-aliases-package: com.zx.entity
  mapper-locations: classpath:com/zx/dao/*Mapper.xml

3.创建实体类

public class User {
    private int id;
    private String username;
    private String password;
    }
//此处省略get、set、toString方法

4.编写UserDao

@Mapper
public interface UserDao {
    List<User> getUser();
}

5.配置Mapper映射文件

<?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.zx.dao.UserDao">
    <select id="getUser" resultType="User">
        select * from t_user
    </select>
</mapper>

6.编写Controller

@Controller
public class MyController {
    @Resource
    UserDao userDao;
    @RequestMapping("/test")
    @ResponseBody
    public String test(){
        List<User> users = userDao.getUser();
        System.out.println(users);
        return users.toString();
    }
}

7.编写启动类

@SpringBootApplication
public class MySpringBootApplication {
    public static void main(String[] args) {        SpringApplication.run(MySpringBootApplication.class);
    }
}