SpringBoot HelloWorld 之 實現注冊功能

一.配置

創建數據庫big_event

CREATE TABLE `user` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',`username` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT '用戶名',`password` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '密碼',`nickname` varchar(10) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '昵稱',`email` varchar(128) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '郵箱',`user_pic` varchar(128) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '頭像',`create_time` datetime NOT NULL COMMENT '創建時間',`update_time` datetime NOT NULL COMMENT '修改時間',PRIMARY KEY (`id`),UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='用戶表'

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><groupId>com.javalearn</groupId><artifactId>demo</artifactId><version>0.0.1-SNAPSHOT</version><name>demo</name><description>demo</description><properties><java.version>17</java.version><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding><spring-boot.version>3.0.2</spring-boot.version></properties><dependencies><!-- MySQL Driver --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><scope>runtime</scope></dependency>
<!--&lt;!&ndash;        persistence&ndash;&gt;-->
<!--        <dependency>-->
<!--            <groupId>javax.persistence</groupId>-->
<!--            <artifactId>persistence-api</artifactId>-->
<!--            <version>1.0</version>-->
<!--        </dependency>-->
<!--jdbc--><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-jdbc</artifactId></dependency><!-- Spring Boot Starter Data JPA --><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-data-jpa</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><!--        mybatis--><dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>3.0.0</version></dependency>
<!--        -->
<!--        -->
<!--        --><!--mybatis依賴--><dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>3.0.0</version></dependency><!--mysql驅動依賴--><dependency><groupId>com.mysql</groupId><artifactId>mysql-connector-j</artifactId></dependency><!--lombok依賴--><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId></dependency><!--validation依賴--><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-validation</artifactId></dependency><!--java-jwt坐標--><dependency><groupId>com.auth0</groupId><artifactId>java-jwt</artifactId><version>4.4.0</version></dependency><!--單元測試的坐標--><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId></dependency><!--pageHelper坐標--><dependency><groupId>com.github.pagehelper</groupId><artifactId>pagehelper-spring-boot-starter</artifactId><version>1.4.6</version></dependency><!--阿里云oss依賴坐標--><dependency><groupId>com.aliyun.oss</groupId><artifactId>aliyun-sdk-oss</artifactId><version>3.15.1</version></dependency>
<!--        -->
<!--        -->
<!--        --><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-devtools</artifactId><scope>runtime</scope><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></dependencies><dependencyManagement><dependencies><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-dependencies</artifactId><version>${spring-boot.version}</version><type>pom</type><scope>import</scope></dependency></dependencies></dependencyManagement><build><plugins><plugin><groupId>org.apache.maven.plugins</groupId><artifactId>maven-compiler-plugin</artifactId><version>3.8.1</version><configuration><source>17</source><target>17</target><encoding>UTF-8</encoding></configuration></plugin><plugin><groupId>org.springframework.boot</groupId><artifactId>spring-boot-maven-plugin</artifactId><version>${spring-boot.version}</version><configuration><mainClass>com.javalearn.demo.DemoApplication</mainClass><skip>true</skip></configuration><executions><execution><id>repackage</id><goals><goal>repackage</goal></goals></execution></executions></plugin></plugins></build></project>

src/main/resources/application.yml

spring:datasource:driver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://localhost:3306/big_eventusername: rootpassword: root
server:port: 8080mybatis:configuration:map-underscore-to-camel-case: true #開啟駝峰命名和下劃線命名的自動轉換log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

二.controller控制層

src/main/java/com/javalearn/demo/controller/UserController.java

package com.javalearn.demo.controller;import com.javalearn.demo.pojo.Result;
import com.javalearn.demo.pojo.User;
import com.javalearn.demo.service.UserService;
import org.springframework.web.bind.annotation.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;import java.util.List;@RestController
@RequestMapping("/user")
public class UserController {@Autowiredprivate UserService userService;@PostMapping("/register")public Result register(String username, String password) {// 查詢用戶User u = userService.findByUsername(username);if (u == null) {// 沒有占用// 注冊userService.register(username, password);return Result.success();} else {return Result.error("用戶名已占用");}}}

三.service業務層

src/main/java/com/javalearn/demo/service/UserService.java

package com.javalearn.demo.service;import com.javalearn.demo.pojo.User;
import java.util.List;public interface UserService {// 根據用戶名查詢User findByUsername(String username);// 注冊void register(String username, String password);}

src/main/java/com/javalearn/demo/service/impl/UserServiceImpl.java

package com.javalearn.demo.service.impl;import com.javalearn.demo.pojo.User;
import com.javalearn.demo.mapper.UserMapper;
import com.javalearn.demo.service.UserService;
import com.javalearn.demo.utils.Md5Util;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;import java.util.List;@Service
public class UserServiceImpl implements UserService {@Autowiredprivate UserMapper userMapper;@Overridepublic User findByUsername(String username) {User u = userMapper.findByUsername(username);return u;}@Overridepublic void register(String username, String password){// 加密String md5String = Md5Util.getMD5String(password);// 添加userMapper.add(username, md5String);}
}

四.mapper（Dao）持久層

src/main/java/com/javalearn/demo/mapper/UserMapper.java

package com.javalearn.demo.mapper;import com.javalearn.demo.pojo.User;
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
public interface UserMapper {// 根據用戶名查詢用戶@Select("select * from user where username = #{username}")User findByUsername(String username);// 添加@Insert("insert into user(username, password, create_time, update_time)" +" values(#{username}, #{password},now(),now())")void add(@Param("username") String uasername, @Param("password") String password);
}

五.pojo（簡單java對象）

src/main/java/com/javalearn/demo/pojo/Result.java

package com.javalearn.demo.pojo;import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;//統一響應結果
@NoArgsConstructor
@AllArgsConstructor
@Data
public class Result<T> {private Integer code;//業務狀態碼  0-成功  1-失敗private String message;//提示信息private T data;//響應數據//快速返回操作成功響應結果(帶響應數據)public static <E> Result<E> success(E data) {return new Result<>(0, "操作成功", data);}//快速返回操作成功響應結果public static Result success() {return new Result(0, "操作成功", null);}public static Result error(String message) {return new Result(1, message, null);}
}

src/main/java/com/javalearn/demo/pojo/User.java

package com.javalearn.demo.pojo;import lombok.Data;
import java.time.LocalDateTime;@Data
public class User {private Integer id;//主鍵IDprivate String username;private String password;private String nickname;//昵稱private String email;private String userPic;//用戶頭像地址private String createTime;private String updateTime;
}

六.utils（工具）

src/main/java/com/javalearn/demo/utils/Md5Util.java

package com.javalearn.demo.utils;import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;public class Md5Util {/*** 默認的密碼字符串組合，用來將字節轉換成 16 進制表示的字符,apache校驗下載的文件的正確性用的就是默認的這個組合*/protected static char hexDigits[] = {'0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd', 'e', 'f'};protected static MessageDigest messagedigest = null;static {try {messagedigest = MessageDigest.getInstance("MD5");} catch (NoSuchAlgorithmException nsaex) {System.err.println(Md5Util.class.getName() + "初始化失敗，MessageDigest不支持MD5Util。");nsaex.printStackTrace();}}/*** 生成字符串的md5校驗值** @param s* @return*/public static String getMD5String(String s) {return getMD5String(s.getBytes());}/*** 判斷字符串的md5校驗碼是否與一個已知的md5碼相匹配** @param password  要校驗的字符串* @param md5PwdStr 已知的md5校驗碼* @return*/public static boolean checkPassword(String password, String md5PwdStr) {String s = getMD5String(password);return s.equals(md5PwdStr);}public static String getMD5String(byte[] bytes) {messagedigest.update(bytes);return bufferToHex(messagedigest.digest());}private static String bufferToHex(byte bytes[]) {return bufferToHex(bytes, 0, bytes.length);}private static String bufferToHex(byte bytes[], int m, int n) {StringBuffer stringbuffer = new StringBuffer(2 * n);int k = m + n;for (int l = m; l < k; l++) {appendHexPair(bytes[l], stringbuffer);}return stringbuffer.toString();}private static void appendHexPair(byte bt, StringBuffer stringbuffer) {char c0 = hexDigits[(bt & 0xf0) >> 4];// 取字節中高 4 位的數字轉換, >>>// 為邏輯右移，將符號位一起右移,此處未發現兩種符號有何不同char c1 = hexDigits[bt & 0xf];// 取字節中低 4 位的數字轉換stringbuffer.append(c0);stringbuffer.append(c1);}}