〇、参考资料
1、hutool介绍
https://blog.csdn.net/abst122/article/details/124091375
2、Spring Boot+Mybatis实现登录注册
https://www.cnblogs.com/wiki918/p/16221758.html
3、Spring Boot读取自定义配置文件
https://www.yisu.com/zixun/366877.html
4、Spring Boot读取properties配置文件的两种方式
https://blog.csdn.net/weixin_42352733/article/details/121830775
一、概述
1、技术栈
Spring Boot+Mybatis+Lombok+Hutool+Slf4j+thymeleaf
2、项目截图
二、登录注册(后台)
1、数据库设计
表结构:
表数据:
建表语句:
CREATE TABLE `user` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '用户表id',
`username` varchar(50) NOT NULL COMMENT '用户名',
`password` varchar(50) NOT NULL COMMENT '用户密码,MD5加密',
`email` varchar(50) DEFAULT NULL COMMENT '邮箱',
`phone` varchar(20) DEFAULT NULL COMMENT '手机号',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户表'
2、POJO(Entity)编写-UserBean.java
package com.boulderaitech.entity;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.io.Serializable;
import java.util.Date;
@Data //提供了set、get方法及toString
@AllArgsConstructor
@NoArgsConstructor
public class UserBean implements Serializable {
private Integer id; //为什么用Integer,不用int
private String username;
private String password;
private String email;
private String phone;
@JsonFormat(pattern = "yyyy-MM-mm HH:mm:ss")
private Date create_time;
@JsonFormat(pattern = "yyyy-MM-mm HH:mm:ss")
private Date update_time;
}
3、Controller编写-UserController.java
package com.boulderaitech.controller;
import cn.hutool.core.lang.Opt;
import cn.hutool.core.util.StrUtil;
import com.boulderaitech.entity.UserBean;
import com.boulderaitech.service.UserService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
@Slf4j
@Controller // 不能用@RestController
public class UserController {
//将Service注入Web层
@Autowired
UserService userService;
//用户测试
@RequestMapping("/hello")
public String hello() {
return "login";
}
@RequestMapping("/register")
public String register() {
return "signup";
}
@RequestMapping(value = "/login", method = RequestMethod.POST)
public String login(String username,String password) {
UserBean userBean = userService.login(username,password);
log.info("username:{}",username);
log.info("password:{}",password);
//hutool-core 核心,包括Bean操作、日期、各种Util等
if(StrUtil.isNotEmpty(username)) {
if(userBean != null) {
return "success";
//方法引用-遍历集合
//Opt.ofEmptyAble(userBean).ifPresent(System.out::println);
}
} else {
return "用户名不允许为空";
}
return "error";
}
@RequestMapping(value = "/signup", method = RequestMethod.POST)
public String signup(String username,String password) {
userService.insert(userna