使用idea工具,新建springboot项目,
导入依赖
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-configuration-processor</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-generator</artifactId>
<version>3.4.1</version>
</dependency>
<dependency>
<groupId>org.freemarker</groupId>
<artifactId>freemarker</artifactId>
<version>2.3.30</version>
</dependency>
<!--swagger依赖-->
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger2</artifactId>
<version>2.9.2</version>
</dependency>
<!--swagger ui-->
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger-ui</artifactId>
<version>2.9.2</version>
</dependency>
<!-- 本项目后加的 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-aop</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-validation</artifactId>
</dependency>
<!-- jwt -->
<dependency>
<groupId>com.auth0</groupId>
<artifactId>java-jwt</artifactId>
<version>3.11.0</version>
</dependency>
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-lang3</artifactId>
</dependency>
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-collections4</artifactId>
<version>4.4</version>
</dependency>
<!-- json -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.72</version>
</dependency>
</dependencies>
数据库
drop table if exists am_user;
create table am_user(
id bigint not null auto_increment primary key comment '主键id',
user_name varchar(50) not null comment '用户名',
pwd varchar(50) not null comment '密码',
is_deleted tinyint default 0 comment '是否删除,1删除,0正常'
) comment '用户表';
insert into am_user values (1,'admin','1234',0);
drop table if exists am_student;
create table am_student(
id bigint not null auto_increment primary key comment '主键id',
number varchar(50) not null comment '学号,因为使用软删除,所以未设置唯一键索引',
real_name varchar(50) not null comment '姓名',
enroll_time datetime not null default CURRENT_TIMESTAMP comment '入学日期',
is_deleted tinyint default 0 comment '是否删除,1删除,0正常'
) comment '学生表';
insert into am_student values (1,'001','张三','2023-01-01',0);
drop table if exists am_score;
create table am_score(
id bigint not null auto_increment primary key comment '主键id',
student_id bigint not null comment '学生id',
exam_name varchar(100) not null comment '考试名称',
score_cn decimal(5,2) default 0 comment '语文成绩',
score_en decimal(5,2) default 0 comment '英语成绩',
score_math decimal(5,2) default 0 comment '数学成绩',
is_deleted tinyint default 0 comment '是否删除,1删除,0正常'
) comment '成绩表';
insert into am_score values(1,1,'摸底考试',99,99,99,0);
实体类
User.java
package com.shrimpking.pojo;
import com.baomidou.mybatisplus.annotation.TableLogic;
import com.baomidou.mybatisplus.annotation.TableName;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import java.io.Serializable;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
/**
* <p>
* 用户表
* </p>
*
* @author shrimpking
* @since 2023-11-04
*/
@Data
@EqualsAndHashCode(callSuper = false)
@TableName("am_user")
@ApiModel(value="User对象", description="用户表")
public class User implements Serializable {
private static final long serialVersionUID = 1L;
@ApiModelProperty(value = "主键id")
@TableId(value = "id", type = IdType.AUTO)
private Long id;
@ApiModelProperty(value = "用户名")
private String userName;
@ApiModelProperty(value = "密码")
private String pwd;
@TableLogic
@ApiModelProperty(value = "是否删除,1删除,0正常")
private Integer isDeleted;
}
Mapper
UserMapper.java
package com.shrimpking.mapper;
import com.shrimpking.pojo.User;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
/**
* <p>
* 用户表 Mapper 接口
* </p>
*
* @author shrimpking
* @since 2023-11-04
*/
public interface UserMapper extends BaseMapper<User> {
}
Mapperxml
UserMapper.xml
<?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.shrimpking.mapper.UserMapper">
<!-- 通用查询映射结果 -->
<resultMap id="BaseResultMap" type="com.shrimpking.pojo.User">
<id column="id" property="id" />
<result column="user_name" property="userName" />
<result column="pwd" property="pwd" />
<result column="is_deleted" property="isDeleted" />
</resultMap>
<!-- 通用查询结果列 -->
<sql id="Base_Column_List">
id, user_name, pwd, is_deleted
</sql>
</mapper>
service
UserService.java
package com.shrimpking.service;
import com.shrimpking.pojo.User;
import com.baomidou.mybatisplus.extension.service.IService;
import com.shrimpking.req.LoginReq;
/**
* <p>
* 用户表 服务类
* </p>
*
* @author shrimpking
* @since 2023-11-04
*/
public interface UserService extends IService<User> {
String login(LoginReq loginReq);
}
serviceImpl
UserServiceImpl.java
package com.shrimpking.service.impl;
import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.shrimpking.dto.UserDTO;
import com.shrimpking.pojo.User;
import com.shrimpking.mapper.UserMapper;
import com.shrimpking.req.LoginReq;
import com.shrimpking.service.UserService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.shrimpking.util.JwtUtils;
import com.shrimpking.vo.UserVO;
import org.apache.ibatis.logging.Log;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;
/**
* <p>
* 用户表 服务实现类
* </p>
*
* @author shrimpking
* @since 2023-11-04
*/
@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {
@Override
public String login(LoginReq loginReq)
{
//查询用户
LambdaQueryWrapper<User> queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.eq(User::getUserName,loginReq.getUserName())
.eq(User::getPwd,loginReq.getPwd());
User user = this.baseMapper.selectOne(queryWrapper);
if(user == null){
return "用户名或密码不正确";
}
UserVO userVO = createToken(user);
System.out.println(userVO);
return "登录成功";
}
private UserVO createToken(User user)
{
//新建转换对象
UserDTO userDTO = new UserDTO();
//复制属性
BeanUtils.copyProperties(user,userDTO);
//生成token
String token = JwtUtils.getToken(userDTO);
//返回token + 用户user信息
UserVO vo = new UserVO();
BeanUtils.copyProperties(userDTO,vo);
//设置返回的token
vo.setToken(token);
//返回
return vo;
}
}
Controller
UserController.java
package com.shrimpking.controller;
import com.shrimpking.req.LoginReq;
import com.shrimpking.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
/**
* <p>
* 用户表 前端控制器
* </p>
*
* @author shrimpking
* @since 2023-11-04
*/
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
private UserService userService;
@PostMapping("/login")
public String login(@RequestBody LoginReq loginReq){
return this.userService.login(loginReq);
}
}
req
LoginReq.java
package com.shrimpking.req;
import lombok.Data;
import javax.validation.constraints.NotBlank;
/**
* Created by IntelliJ IDEA.
*
* @Author : Shrimpking
* @create 2023/11/4 16:51
*/
@Data
public class LoginReq
{
/**
* 验证不为空
*/
@NotBlank
private String userName;
/**
* 验证不为空
*/
@NotBlank
private String pwd;
}
dto
UserDto.java
package com.shrimpking.dto;
import lombok.Data;
/**
* Created by IntelliJ IDEA.
*
* @Author : Shrimpking
* @create 2023/11/4 17:14
* 定义了token中包含的哪些信息
*/
@Data
public class UserDTO
{
private Long id;
private String userName;
}
vo
UserVo.java
package com.shrimpking.vo;
import com.shrimpking.dto.UserDTO;
import lombok.Data;
import lombok.ToString;
/**
* Created by IntelliJ IDEA.
*
* @Author : Shrimpking
* @create 2023/11/4 17:16
*/
@Data
@ToString(callSuper = true)
public class UserVO extends UserDTO
{
private String token;
}
util
JwtUtils.java
package com.shrimpking.util;
import com.alibaba.fastjson.JSON;
import com.auth0.jwt.JWT;
import com.auth0.jwt.JWTCreator;
import com.auth0.jwt.algorithms.Algorithm;
import java.util.Calendar;
/**
* Created by IntelliJ IDEA.
*
* @Author : Shrimpking
* @create 2023/11/4 17:24
*/
public class JwtUtils
{
private static final String SECRET_KEY = "com.shrimpking";
/**
* 生成token
* @param t
* @param <T>
* @return
*/
public static<T> String getToken(T t){
//定义过期时间,一个月
Calendar calendar = Calendar.getInstance();
calendar.add(Calendar.MONTH,1);
//
JWTCreator.Builder builder = JWT.create()
//添加声明
.withClaim(t.getClass().getSimpleName(), JSON.toJSONString(t));
//添加过期时间
String token = builder.withExpiresAt(calendar.getTime())
//签名
.sign(Algorithm.HMAC256(SECRET_KEY));
return token;
}
}
config
swaggerConfig.java
package com.shrimpking.config;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import springfox.documentation.builders.ApiInfoBuilder;
import springfox.documentation.builders.PathSelectors;
import springfox.documentation.builders.RequestHandlerSelectors;
import springfox.documentation.service.ApiInfo;
import springfox.documentation.service.Contact;
import springfox.documentation.spi.DocumentationType;
import springfox.documentation.spring.web.plugins.Docket;
import springfox.documentation.swagger2.annotations.EnableSwagger2;
/**
* Created by IntelliJ IDEA.
*
* @Author : Shrimpking
* @create 2023/9/10 14:58
*/
@Configuration
@EnableSwagger2
public class SwaggerConfig
{
@Bean
public Docket createRestApi(){
return new Docket(DocumentationType.SWAGGER_2).apiInfo(apiInfo()).select()
.apis(RequestHandlerSelectors.any())
.paths(PathSelectors.any()).build();
}
private ApiInfo apiInfo(){
return new ApiInfoBuilder()
.title("系统接口文档")
.description("接口文档的描述")
.version("1.0")
.contact(new Contact("weixin","http://www.baidu.com","1@1.com"))
.build();
}
}
配置
application.properties
server.port=8089
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimeZone=UTC
spring.datasource.username=root
spring.datasource.password=mysql123
#日志
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
#配置别名
mybatis-plus.type-aliases-package=com.shrimpking.pojo
spring.mvc.pathmatch.matching-strategy=ant_path_matcher
#开启逻辑删除,标识字段
mybatis-plus.global-config.db-config.logic-delete-field=is_deleted
#删除
mybatis-plus.global-config.db-config.logic-delete-value=1
#未删除
mybatis-plus.global-config.db-config.logic-not-delete-value=0
测试
http://localhost:8089/swagger-ui.html#/