• • • SpringBoot 集成 Mybatis 实现用户登录
    • • ① 引入 mybatis 依赖
      • ② 创建 bean 类
      • ③ mapper 层
      • ⑤ service 层
      • ⑥ controller 层
      • ⑦ 前端界面
      • ⑧ 数据库
      • ⑨ 运行结果

这里我们书写这个的意义不仅是为了实现简单的用户登录功能, 而是为了了解 SpringBoot - MVC 设计模式的基本使用流程。 我们可以通过对用户登录一个功能的学习, 而拓展到各种常见功能如 CRUD 的操作。

引入 mysql 以及 mybatis 依赖

    mysql
    mysql-connector-java
    8.0.29



    org.mybatis.spring.boot
    mybatis-spring-boot-starter
    2.2.2

Admin

package com.example.demo.bean;

public class Admin {
    int id;
    String username;
    String password;

    public Admin() {
    }

    public Admin(int id, String username, String password) {
        this.id = id;
        this.username = username;
        this.password = password;
    }

    @Override
    public String toString() {
        return "Admin{" +
                "id=" + id +
                ", username='" + username + ''' +
                ", password='" + password + ''' +
                '}';
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }
}

Admin.mapper

package com.example.demo.mapper;

import com.example.demo.bean.Admin;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

@Mapper
@Repository
public interface AdminMapper {
    Admin login(Admin user);

    void saveAdmin(Admin user);

    void modAdmin(Admin user);

    Admin findAdminById(int id);
}

AdminMapper.xml

    
        select * from admin where username = #{username} and password = #{password};
    

    
        insert into admin(id,username,password)
        values(#{id},#{username},#{password});
    

    
        select * from admin where id = #{id};
    

    
        update admin set username = #{username},password = #{password}
        where id = #{id};
    

AdminService 接口

package com.example.demo.services;

import com.example.demo.bean.Admin;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import org.springframework.stereotype.Service;

public interface AdminService {
    Admin login(Admin user);

    void signIn(Admin user);

    void modAdmin(Admin user);

    Admin findAdminById(int id);
}

AdminService 实现

package com.example.demo.services.impl;


import com.example.demo.bean.Admin;
import com.example.demo.mapper.AdminMapper;
import com.example.demo.services.AdminService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class AdminServiceImpl implements AdminService {
    @Autowired
    private AdminMapper adminMapper;

    public Admin login(Admin user) {
        return adminMapper.login(user);
    }

    public void signIn(Admin user) {
        adminMapper.saveAdmin(user);
    }

    public void modAdmin(Admin user) {
        adminMapper.modAdmin(user);
    }

    public Admin findAdminById(int id) {
        return adminMapper.findAdminById(id);
    }
}

AdminController

package com.example.demo.controller;

import com.example.demo.bean.Admin;
import com.example.demo.services.AdminService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import java.util.List;

@RequestMapping("/admin")
@Controller
public class AdminController {
    @Autowired
    AdminService adminService;

    @RequestMapping("/login")
    public String login(Admin admin, Model model){
        Admin loginAdmin = adminService.login(admin);
        if(loginAdmin != null){
            return "dashboard";
        } else {
            model.addAttribute("login_msg", "用户名或密码错误!");
            return "index";
        }
    }
}

index.html 集成 thymeleaf

	
		
		
		
		
		
		
		
		
		
	

	
		

			
			
Please sign in
			Username
			
			Password
			
			

				
           [[#{login.remember}]]
        
			
			[[#{login.btn}]]
			
© 2017-2018
			中文
			English
		

	

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `password` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

OVER~