本篇文章为你整理了Spring Boot+Mybatis:实现数据库登录注册与两种properties配置参数读取()的详细内容,包含有 Spring Boot+Mybatis:实现数据库登录注册与两种properties配置参数读取,希望能帮助你了解 Spring Boot+Mybatis:实现数据库登录注册与两种properties配置参数读取。
1、hutool介绍
https://blog.csdn.net/abst122/article/details/124091375
2、Spring Boot+Mybatis实现登录注册
https:///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;
@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(username,password);
return "success";
}
4、Service编写-UserService.java
package com.boulderaitech.service;
import com.boulderaitech.entity.UserBean;
import com.boulderaitech.mapper.UserMapper;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
@Service
public class UserService {
//将dao层属性注入service层,为什么不用Autowired
@Resource
private UserMapper userMapper;
public UserBean login(String username, String password) {
return userMapper.getInfo(username,password);
public void insert(String username, String password) {
userMapper.saveUser(username,password);
}
5、Mapper编写-UserMapper.java
package com.boulderaitech.mapper;
import com.boulderaitech.entity.UserBean;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
@Mapper //添加Mapper注解,就不用写xml的mapper映射文件了
public interface UserMapper {
//多个参数要加@Param修饰
//思考:xml中的 include 代码片段怎么配
@Select("SELECT * FROM user WHERE username=#{username} AND password= #{password}")
UserBean getInfo(@Param("username") String username,@Param("password") String password);
@Insert("INSERT INTO user(username,password) VALUE(#{username},#{password})")
void saveUser(@Param("username") String username,@Param("password") String password);
}
6、配置文件编写-application.properties
# Spring Boot端口号
server.port=9088
# 数据源配置
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.password=qaz123
spring.datasource.username=root
spring.datasource.url=jdbc:mysql://192.168.40.111:3306/visualization?serverTimezone=UTC useUnicode=true characterEncoding=utf-8 useSSL=true
spring.thymeleaf.prefix=classpath:/templates/
7、启动类编写-KettleProcessorApplication.java
package com.boulderaitech;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
* Spring Boot启动类,加Spring Boot注解,调用Spring的静态run方法
@SpringBootApplication
public class KettleProcessorApplication {
public static void main(String[] args) {
SpringApplication.run(KettleProcessorApplication.class);
}
三、登录注册(前台)
1、登录页面-login.html
!DOCTYPE html
html lang="en"
head
meta charset="UTF-8"
title login /title
/head
body
form role="form" action = "/login" method="post"
账号: input type="text" id="username" name = "username" br
密码: input type="password" id = "password" name = "password" br
input type="submit" id = "login" value = "登录"
/form
a href="/register" 注册 /a
/body
/html
2、注册页面-signup.html
!--注册页面--
!DOCTYPE html
html lang="en"
head
meta charset="UTF-8"
title 注册 /title
/head
body
form role="form" action="/signup" method="post"
请输入姓名: input type="text" name="username" id="name" br
请输入密码: input type="password" name="password" id="password" br
input type="submit" name="sign" value="提交"
/form
/body
/html
3、成功页面-success.html
!DOCTYPE html
html lang="en"
head
meta charset="UTF-8"
title success /title
/head
body
h1 欢迎,恭喜登录成功/注册成功 /h1
/body
/html
4、失败页面-error.html
!DOCTYPE html
html lang="en"
head
meta charset="UTF-8"
title error /title
/head
body
h1 登录失败! /h1
/body
/html
四、配置读取
1、配置编写-kettle.properties
# 读取properties的两种方式:https://blog.csdn.net/weixin_42352733/article/details/121830775
environment=xuelei-www
kettle.repository.type=database
kettle.repository.username=admin
kettle.repository.password=admin
2、POJO(Entity)编写-KettleRepositoryBean.java
package com.boulderaitech.entity;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.stereotype.Component;
@Data
@Component
@NoArgsConstructor
@AllArgsConstructor
@ConfigurationProperties(prefix = "kettle.repository")
public class KettleRepositoryBean {
private String type;
private String username;
private String password;
}
3、Controller编写-PropertiesController.java
package com.boulderaitech.controller;
import com.boulderaitech.entity.KettleRepositoryBean;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.PropertySource;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
@RestController //Controller和RestCOntroller的区别
@PropertySource("classpath:kettle.properties") //默认是application.properties
public class PropertiesController {
@Value("${environment}")
private String envName;
@Autowired
private KettleRepositoryBean kettleRepositoryBean;
@RequestMapping("/getEnv")
public String getEnv() {
return "hello " + envName;
@RequestMapping("/getRepoInfo")
public String getRepoInfo() {
return "hello " + kettleRepositoryBean.toString();
}
3、读取单个配置
4、读取实体类配置(多个)
以上就是Spring Boot+Mybatis:实现数据库登录注册与两种properties配置参数读取()的详细内容,想要了解更多 Spring Boot+Mybatis:实现数据库登录注册与两种properties配置参数读取的内容,请持续关注盛行IT软件开发工作室。
郑重声明:本文由网友发布,不代表盛行IT的观点,版权归原作者所有,仅为传播更多信息之目的,如有侵权请联系,我们将第一时间修改或删除,多谢。