Mybatis和Spring Boot的整合

1.引入相关的jar包

直接在pom.xml中配置：

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

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

<dependency>
	<groupId>com.alibaba</groupId>
	<artifactId>druid</artifactId>
	<version>1.1.0</version>
</dependency>
<!--在ide中安装lombok插件-->	
<dependency>
     <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <version>1.18.8</version>
</dependency>

2.创建一个与数据库表中的字段相对应的实体类

数据库表：

User.java：

package com.dlj.springbootdemo.data;

import java.util.Date;

/**
 * @author ashley
 * @date 2019/9/23-16:19
 */
 @Data//需引入lombok依赖，有了该注解实体类中可省掉get，set方法，减少代码量
public class User {
   

    private Long id;
    private String email;
    private String phoneNumber;
    private String username;
    private String nickname;
    private String password;
    private Date createTime;
    private Date updateTime;
}

3. 创建数据访问接口

UserMapper.java：

package com.dlj.springbootdemo.dao;

import com.dlj.springbootdemo.data.User;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author ashley
 * @date 2019/9/23-17:43
 */
@Repository
public interface UserMapper {
   
    User getUserById