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