【BackEnd】SpringBoot整合Mybatis实现登录注册功能（适合初学者）

2023-06-21 989

版权

本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

简介： 适合新手的SpringBoot整合Mybatis实现登录注册功能，附Gitee工程代码地址

一、引言

作者将代码上传到了Gitee，小伙伴可以直接Clone项目到本地

项目地址：https://gitee.com/cai-zijing/SpringBoot_Mybatis_Login_Demo.git

再告诉大家一个非常好用的插件Gitee，主要功能为在IDEAL中与远程仓库进行可视化交互

编辑

输入项目地址一步解决项目克隆编辑

二、项目结构

编辑

三、代码

3.1 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>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.7.4</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.example</groupId>
    <artifactId>Login_Mybatis_Demo</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>Login_Mybatis_Demo</name>
    <description>Login_Mybatis_Demo</description>
    <properties>
        <java.version>17</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.2</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </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>
    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <configuration>
                    <excludes>
                        <exclude>
                            <groupId>org.projectlombok</groupId>
                            <artifactId>lombok</artifactId>
                        </exclude>
                    </excludes>
                </configuration>
            </plugin>
        </plugins>
    </build>
</project>

3.2 applicaiton.yml配置文件

因人喜好是否将application.propertie重命名为application.yml

server:
  port: 9091
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/login?serverTimezone=UTC
mybatis:
  type-aliases-package: com.bcn.login_mybatis_demo.pojo
  mapper-locations: classpath:mapper/*.xml
  # Turn on camelCase
  configuration:
    map-underscore-to-camel-case: true
# Show sql
logging:
  level:
    com:
      example:
        mapper : debug

3.3 User实体类

@Data各个属性getter、setter等方法

@AllArgsConstructor有参构造函数

@NoArgsConstructor无参构造函数

package com.bcn.login_mybatis_demo.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
/**
 * @author 大白菜
 * @date Created in 2022/9/26 14:56
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    public Integer uid;
    public String uname;
    public String uaccount;
    private String upassword;
    public User(String uname, String uaccount, String upassword) {
        this.uname = uname;
        this.uaccount = uaccount;
        this.upassword = upassword;
    }
}

3.4 UserMapper接口层

@mapper Mybatis数据访问层标志

@Repository SpringBoot数据访问层标志

package com.bcn.login_mybatis_demo.mapper;
import com.bcn.login_mybatis_demo.pojo.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
/**
 * @author 大白菜
 * @date Created in 2022/9/26 14:56
 */
@Mapper
@Repository
public interface UserMapper {
    User selectUserByUact(String uact);
    String selectUpwdByUact(String uact);
    void insertUser(User user);
}

3.5 UserService业务接口层

当业务需求较为简单时，该层可舍弃，只用ServiceImpl即可

package com.bcn.login_mybatis_demo.service;
import com.bcn.login_mybatis_demo.pojo.User;
/**
 * @author 大白菜
 * @date Created in 2022/9/26 14:56
 */
public interface UserSerivce {
    public String loginService(String uact, String upwd);
    public String registerService(User user);
}

3.6 UserServiceImpl业务层

@Service 业务层标志

package com.bcn.login_mybatis_demo.service.serviceImpl;
import com.bcn.login_mybatis_demo.mapper.UserMapper;
import com.bcn.login_mybatis_demo.pojo.User;
import com.bcn.login_mybatis_demo.service.UserSerivce;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
/**
 * @author 大白菜
 * @date Created in 2022/9/26 14:56
 */
@Service
public class UserServiceImpl implements UserSerivce {
    @Autowired
    UserMapper userMapper;
    @Override
    public String loginService(String uact, String upwd) {
        User user = userMapper.selectUserByUact(uact);
        if (user!=null){
            String userEpwd= user.getUpassword();
            if(upwd.equals(userEpwd)){
                return "SUCCESS";
            }else{
                return "密码错误";
            }
        }
        return "账号错误";
    }
    @Override
    public String registerService(User user) {
        User userE=userMapper.selectUserByUact(user.getUaccount());
        if(userE==null){
            if("".equals(user.getUpassword())){
                return "密码为空";
            }else if("".equals(user.getUname())){
                return "用户昵称为空";
            }else{
                userMapper.insertUser(user);
                return "SUCCESS";
            }
        }else{
            return "此用户已被注册";
        }
    }
}

3.7 UserController控制层

@SuppressWarnings({"all"}) 控制台输出过滤掉警告信息

@RestController控制层标志，等价于@Controller+@ResponseBody

@RequestMapping() 对外接口地址

package com.bcn.login_mybatis_demo.controller;
import com.bcn.login_mybatis_demo.pojo.User;
import com.bcn.login_mybatis_demo.service.serviceImpl.UserServiceImpl;
import com.bcn.login_mybatis_demo.util.Result;
import com.bcn.login_mybatis_demo.util.ResultUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
/**
 * @author 大白菜
 * @date Created in 2022/9/26 14:56
 */
@SuppressWarnings({"all"})
@RestController
@RequestMapping("/user")
public class UserController {
    @Autowired
    UserServiceImpl userServiceImpl;
    @RequestMapping("/login")
    public Result login(@RequestParam String uact, @RequestParam String upwd) {
        String msg = userServiceImpl.loginService(uact,upwd);
        if(("SUCCESS").equals(msg)){
            return ResultUtil.success("登录成功");
        }else{
            return ResultUtil.error(msg);
        }
    }
    @RequestMapping("/register")
    public Result login(@RequestBody User user) {
        String msg = userServiceImpl.registerService(user);
        if(("SUCCESS").equals(msg)){
            return ResultUtil.success("注册成功");
        }else{
            return ResultUtil.error(msg);
        }
    }
}

3.8 Result、ResultCode、ResultUtil 返回结果工具类

在正式开发中，我们返回给前端除了Body之外，还需要状态码与状态信息，这就需要使用到Result工具类，其返回效果如下

编辑

Result类

package com.bcn.login_mybatis_demo.util;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
/**
 * @author 大白菜
 * @date Created in 2022/9/26 19:54
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Result<T> {
    private Integer code;
    private String msg;
    private T data;
}

ResultCode类

package com.bcn.login_mybatis_demo.util;
/**
 * @author 大白菜
 * @date Created in 2022/9/26 19:50
 */
public enum ResultCode {
    // 自定义枚举内容
    SUCCESS(200, "Success"),
    ERROR(-100, "Error");
    private Integer code;
    private String msg;
    ResultCode(Integer code, String msg) {
        this.code = code;
        this.msg = msg;
    }
    public Integer getCode() {
        return code;
    }
    public String getMsg() {
        return msg;
    }
}

ResultUtil类

package com.bcn.login_mybatis_demo.util;
/**
 * @author 大白菜
 * @date Created in 2022/9/26 19:55
 */
public class ResultUtil {
    /**
     * 成功且带数据
     **/
    public static Result success(Object object) {
        Result result = new Result();
        result.setCode(ResultCode.SUCCESS.getCode());
        result.setMsg(ResultCode.SUCCESS.getMsg());
        result.setData(object);
        return result;
    }
    /**
     * 成功但不带数据
     **/
    public static Result success() {
        return success(null);
    }
    /**
     * 失败
     **/
    public static Result error(Object object) {
        Result result = new Result();
        result.setCode(ResultCode.ERROR.getCode());
        result.setMsg(ResultCode.ERROR.getMsg());
        result.setData(object);
        return result;
    }
}

3.9 Mapper.xml映射文件

使用Mybatis需要在resource下创建mapper文件夹，里面存放各类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.bcn.login_mybatis_demo.mapper.UserMapper">
    <insert id="insertUser">
        insert into user values (null,#{uname},#{uaccount},#{upassword})
    </insert>
    <select id="selectUserByUact" resultType="com.bcn.login_mybatis_demo.pojo.User">
        select * from user where uaccount = #{uact}
    </select>
    <select id="selectUpwdByUact" resultType="java.lang.String">
        select upassword from user where uaccount= #{uact}
    </select>
</mapper>

3.10 login.sql数据库文件

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `uname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `uaccount` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `upassword` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '皮卡丘', '123456', '123456');
INSERT INTO `user` VALUES (4, '杰尼龟', '1234567', '123456');
INSERT INTO `user` VALUES (7, '妙蛙种子', '12345678', '123456');
SET FOREIGN_KEY_CHECKS = 1;