Spring Boot+Mybatis：实现数据库登录注册与两种properties配置参数读取

〇、参考资料

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、数据库设计

表结构：

表数据：

建表语句：

1. CREATE TABLE `user` (
2.   `id` int NOT NULL AUTO_INCREMENT COMMENT '用户表id',
3.   `username` varchar(50) NOT NULL COMMENT '用户名',
4.   `password` varchar(50) NOT NULL COMMENT '用户密码，MD5加密',
5.   `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
6.   `phone` varchar(20) DEFAULT NULL COMMENT '手机号',
7.   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
8.   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次更新时间',
9.   PRIMARY KEY (`id`)
10. ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户表'

复制代码

2、POJO（Entity）编写-UserBean.java

1. package com.boulderaitech.entity;
3. import com.fasterxml.jackson.annotation.JsonFormat;
4. import lombok.AllArgsConstructor;
5. import lombok.Data;
6. import lombok.NoArgsConstructor;
8. import java.io.Serializable;
9. import java.util.Date;
10. @Data //提供了set、get方法及toString
11. @AllArgsConstructor
12. @NoArgsConstructor
13. public class UserBean implements Serializable {
14.     private Integer id; //为什么用Integer，不用int
15.     private String username;
16.     private String password;
17.     private String email;
18.     private String phone;
19.     @JsonFormat(pattern = "yyyy-MM-mm HH:mm:ss")
20.     private Date create_time;
21.     @JsonFormat(pattern = "yyyy-MM-mm HH:mm:ss")
22.     private Date update_time;
23. }

复制代码

3、Controller编写-UserController.java

1. package com.boulderaitech.controller;
3. import cn.hutool.core.lang.Opt;
4. import cn.hutool.core.util.StrUtil;
5. import com.boulderaitech.entity.UserBean;
6. import com.boulderaitech.service.UserService;
7. import lombok.extern.slf4j.Slf4j;
8. import org.springframework.beans.factory.annotation.Autowired;
9. import org.springframework.stereotype.Controller;
10. import org.springframework.web.bind.annotation.RequestMapping;
11. import org.springframework.web.bind.annotation.RequestMethod;
14. @Slf4j
15. @Controller // 不能用@RestController
16. public class UserController {
17.     //将Service注入Web层
18.     @Autowired
19.     UserService userService;
21.     //用户测试
22.     @RequestMapping("/hello")
23.     public String hello() {
24.         return "login";
25.     }
27.     @RequestMapping("/register")
28.     public String register() {
29.         return "signup";
30.     }
32.     @RequestMapping(value = "/login", method = RequestMethod.POST)
33.     public String login(String username,String password) {
34.         UserBean userBean = userService.login(username,password);
35.         log.info("username:{}",username);
36.         log.info("password:{}",password);
37.         //hutool-core        核心，包括Bean操作、日期、各种Util等
38.         if(StrUtil.isNotEmpty(username)) {
39.             if(userBean != null) {
40.                 return "success";
41.                 //方法引用-遍历集合
42.                 //Opt.ofEmptyAble(userBean).ifPresent(System.out::println);
43.             }
44.         } else {
45.             return "用户名不允许为空";
46.         }
47.         return "error";
48.     }
50.     @RequestMapping(value = "/signup", method = RequestMethod.POST)
51.     public String signup(String username,String password) {
52.         userService.insert(username,password);
53.         return "success";
54.     }
55. }

复制代码

4、Service编写-UserService.java

1. package com.boulderaitech.service;
3. import com.boulderaitech.entity.UserBean;
4. import com.boulderaitech.mapper.UserMapper;
5. import org.springframework.stereotype.Service;
7. import javax.annotation.Resource;
8. @Service
9. public class UserService {
10.     //将dao层属性注入service层，为什么不用Autowired
11.     @Resource
12.     private UserMapper userMapper;
14.     public UserBean login(String username, String password) {
15.         return userMapper.getInfo(username,password);
16.     }
18.     public void insert(String username, String password) {
19.         userMapper.saveUser(username,password);
20.     }
21. }

复制代码

5、Mapper编写-UserMapper.java

1. package com.boulderaitech.mapper;
3. import com.boulderaitech.entity.UserBean;
4. import org.apache.ibatis.annotations.Insert;
5. import org.apache.ibatis.annotations.Mapper;
6. import org.apache.ibatis.annotations.Param;
7. import org.apache.ibatis.annotations.Select;
9. @Mapper //添加Mapper注解，就不用写xml的mapper映射文件了
10. public interface UserMapper {
11.     //多个参数要加@Param修饰
12.     //思考：xml中的<include>代码片段怎么配
13.     @Select("SELECT * FROM user WHERE username=#{username} AND password= #{password}")
14.     UserBean getInfo(@Param("username") String username,@Param("password") String password);
16.     @Insert("INSERT INTO user(username,password) VALUE(#{username},#{password})")
17.     void saveUser(@Param("username") String username,@Param("password") String password);
18. }

复制代码

6、配置文件编写-application.properties

1. # Spring Boot端口号
2. server.port=9088
3. # 数据源配置
4. spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
5. spring.datasource.password=qaz123
6. spring.datasource.username=root
7. spring.datasource.url=jdbc:mysql://192.168.40.111:3306/visualization?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&useSSL=true
8. spring.thymeleaf.prefix=classpath:/templates/

复制代码

7、启动类编写-KettleProcessorApplication.java

1. package com.boulderaitech;
3. import org.springframework.boot.SpringApplication;
4. import org.springframework.boot.autoconfigure.SpringBootApplication;
6. /**
7. * Spring Boot启动类，加Spring Boot注解，调用Spring的静态run方法
8. */
9. @SpringBootApplication
10. public class KettleProcessorApplication {
11.     public static void main(String[] args) {
12.         SpringApplication.run(KettleProcessorApplication.class);
13.     }
14. }

复制代码

三、登录注册（前台）

1、登录页面-login.html

1. <!DOCTYPE html>
2. <html lang="en">
3. <head>
4.   <meta charset="UTF-8">
5.   <title>login</title>
6. </head>
7. <body>
8. <form role="form" action = "/login" method="post">
9.   账号：<input type="text" id="username" name = "username"> <br>
10.   密码：<input type="password" id = "password" name = "password"> <br>
11.   <input type="submit" id = "login" value = "登录">
12. </form>
13. <a target="_blank" href="https://www.cnblogs.com/register">注册</a>
14. </body>
15. </html>

复制代码

2、注册页面-signup.html

1. <!DOCTYPE html>
2. <html lang="en">
3. <head>
4.     <meta charset="UTF-8">
5.     <title>注册</title>
6. </head>
7. <body>
8. <form role="form" action="/signup" method="post">
9.     请输入姓名:<input type="text" name="username" id="name"><br>
10.     请输入密码：<input type="password" name="password" id="password"><br>
11.     <input type="submit" name="sign" value="提交">
12. </form>
13. </body>
14. </html>

复制代码

3、成功页面-success.html

1. <!DOCTYPE html>
2. <html lang="en">
3. <head>
4.     <meta charset="UTF-8">
5.     <title>success</title>
6. </head>
7. <body>
8. <h1>欢迎，恭喜登录成功/注册成功</h1>
9. </body>
10. </html>

复制代码

4、失败页面-error.html

1. <!DOCTYPE html>
2. <html lang="en">
3. <head>
4.     <meta charset="UTF-8">
5.     <title>error</title>
6. </head>
7. <body>
8. <h1>登录失败！</h1>
9. </body>
10. </html>

复制代码

四、配置读取

1、配置编写-kettle.properties

1. # 读取properties的两种方式：https://blog.csdn.net/weixin_42352733/article/details/121830775
2. environment=xuelei-www
3. kettle.repository.type=database
4. kettle.repository.username=admin
5. kettle.repository.password=admin

复制代码

2、POJO（Entity）编写-KettleRepositoryBean.java

1. package com.boulderaitech.entity;
3. import lombok.AllArgsConstructor;
4. import lombok.Data;
5. import lombok.NoArgsConstructor;
6. import org.springframework.boot.context.properties.ConfigurationProperties;
7. import org.springframework.stereotype.Component;
8. @Data
9. @Component
10. @NoArgsConstructor
11. @AllArgsConstructor
12. @ConfigurationProperties(prefix = "kettle.repository")
13. public class KettleRepositoryBean {
14.     private String type;
15.     private String username;
16.     private String password;
17. }

复制代码

3、Controller编写-PropertiesController.java

1. package com.boulderaitech.controller;
3. import com.boulderaitech.entity.KettleRepositoryBean;
4. import org.springframework.beans.factory.annotation.Autowired;
5. import org.springframework.beans.factory.annotation.Value;
6. import org.springframework.context.annotation.PropertySource;
7. import org.springframework.web.bind.annotation.RequestMapping;
8. import org.springframework.web.bind.annotation.RestController;
10. @RestController //Controller和RestCOntroller的区别
11. @PropertySource("classpath:kettle.properties") //默认是application.properties
12. public class PropertiesController {
13.     @Value("${environment}")
14.     private String envName;
16.     @Autowired
17.     private KettleRepositoryBean kettleRepositoryBean;
19.     @RequestMapping("/getEnv")
20.     public String getEnv() {
21.         return "hello " + envName;
22.     }
24.     @RequestMapping("/getRepoInfo")
25.     public String getRepoInfo() {
26.         return "hello " + kettleRepositoryBean.toString();
27.     }
28. }

复制代码

五、验证

1、登录



2、注册



3、读取单个配置


4、读取实体类配置（多个）



免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！