1 pom.xml(Maven依赖文件)
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-security</artifactId>
</dependency>
<!-- Spring Security-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!-- Mysql驱动包-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!-- Mybatis-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.4</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<!--hutool工具包-->
<dependency>
<groupId>cn.hutool</groupId>
<artifactId>hutool-all</artifactId>
<version>5.5.1</version>
</dependency>
<!-- swagger2-->
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger2</artifactId>
<version>2.9.2</version>
</dependency>
2 application.properties(配置文件)
设置MySQL连接配置和MyBatis配置。
#数据库连接池设置
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8
spring.datasource.username=root
spring.datasource.password=root
#mybatis的相关配置
mybatis.mapper-locations=classpath:mapper/*.xml
3 SQL
创建语句:
create table users(
username varchar(20) PRIMARY key COMMENT '用户名',
password varchar(60) comment '密码'
)
添加数据语句:
--密码123456
insert into users(username,password) values('xudongmaster','$2a$10$ky8Gyh5cjVRXnzXE4VO.wuHARs9eAF7VIvSz6R4idnrSnSl4E4pwy');
4 entity(实体类)
User.java:
package com.entity;
import lombok.Data;
import org.springframework.stereotype.Component;
@Component
@Data
public class User {
/**
* 用户名(登录)
*/
private String username;
/**
* 密码
*/
private String password;
}
5 Mapper(映射层)
UserMapper.java:
package com.mapper;
import com.entity.User;
import org.springframework.stereotype.Component;
@Component
public interface UserMapper {
/**
* 根据用户名获取用户信息
*
* @param user