Spring Boot + Jpa + Thymeleaf制作带有权限区分的小破站

首先·创建一个Spring Boot 项目
名字什么的自己弄，项目依赖选择这些

我用的是MySQL数据库
创建user表

DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `jurisdiction` int(11) NULL DEFAULT NULL COMMENT '0：管理员；1：普通用户',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

添加用户

INSERT INTO `t_user` VALUES (1, 'admin', '123456', 0);
INSERT INTO `t_user` VALUES (2, 'test', 'test', 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.4.5</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>net.yq.lesson09</groupId>
    <artifactId>thymeleafandjpa</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>ThymeleafandJpa</name>
    <description>Demo project for Spring Boot</description>
    <properties>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </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-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

在pom.xml中添加数据库连接池

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.2.6</version>
        </dependency>

• 接下来修改全局配置项application.properties
• 

#缓存配置，默认即是true，开发阶段设置为false,禁用Thymeleaf缓存
spring.thymeleaf.cache = false
#设置模板使用的编码为utf-8
spring.thymeleaf.encoding = utf-8
#指定为模板使用的模式为html5，默认html
spring.thymeleaf.mode = HTML5
#指定前缀，默认位置为/templates/，可以修改成其它位置
spring.thymeleaf.prefix = classpath:/templates/
#指定模板文件后缀，默认值为.html，可以修改成其它值
spring.thymeleaf.suffix = .html
#国际化文件的相关配置放置位置

# 配置数据源jdbc
#这个位置是数据库配置
spring.datasource.url=jdbc:mysql://localhost:3306/thymeleaf-sql?serverTimezone=UTC
#账号
spring.datasource.username=root
#密码
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.druid.max-active=100
spring.datasource.druid.min-idle=10
spring.datasource.druid.initial-size=20

在mysql://localhost:3306/后更改为自己的数据库名字，另外username和password同样更改为自己数据库的用户名和密码。

• 然后创建子包Bean
  在子包中创建User实体类
  里面包含id主键（用Jpa写的话必须要有主键用@id注解，然后后面是啥就定义啥。）

package net.yq.lesson09.Bean;

import javax.persistence.*;
//用户实体类
@Entity(name = "t_user")
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id")
    private Integer id;
    @Column(name = "username")
    private String username;
    @Column(name = "password")
    private String password;
    @Column(name = "jurisdiction")
    private int jurisdiction;
    //按老师的来应该要需要下面的键值对来添加数据
    public User() {
    }
    public User(Integer id, String username, String password, int jurisdiction) {
        this.id = id;
        this.username = username;
        this.password = password;
        this.jurisdiction = jurisdiction;
    }


    public Integer getId() {
        return id;
    }

    public void setId(Integer 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;
    }

    public int getJurisdiction() {
        return jurisdiction;
    }

    public void setJurisdiction(int jurisdiction) {
        this.jurisdiction = jurisdiction;
    }
    @Override
    public String toString(){
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", jurisdiction=" + jurisdiction +
                '}';
    }
}

• 创建子包
  创建子包repository
  在子包中创建接口UserRepository，继承Jpa数据库操作
  创建一个接口继承Jpa的数据库操作<>里第一个参数，代表要操作的具体哪一个实体类，第二个参数代表这个实体类的主键类型，比如我的是id，主键是Integer类型的

package net.yq.lesson09.repository;

import net.yq.lesson09.Bean.User;
import org.springframework.stereotype.Repository;

@Repository
public interface UserRepository extends JpaRepository<User,Integer> {
    //根据用户输入账密来验证
    User getByUsernameAndPassword(String username,String password);
}

接下来创建子包service
在子包service中创建UserService服务接口

package net.yq.lesson09.service;

import net.yq.lesson09.bean.User;

import java.util.List;

public interface UserService {

    /***
     * 根据用户名和密码获取
     * @param username
     * @param password
     * @return
     */
    public User getUser(String username,String password);

• 定义Service具体实现
  在service子包中创建子包impl
  于impl中创建UserServiceImpl

package net.yq.lesson09.service.impl;

import net.yq.lesson09.bean.User;
import net.yq.lesson09.repository.UserRepository;
import net.yq.lesson09.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service("userService")
public class UserServiceImpl implements UserService {
    @Autowired
    private UserRepository userRepository;
    @Override
    public User getUser(String username,String password){
        return userRepository.getByUsernameAndPassword(username,password);
    }
}

创建controller子包，在子包中创建LoginController
LoginController.java代码为：

package net.yq.lesson09.controller;

import net.yq.lesson09.bean.User;
import net.yq.lesson09.repository.UserRepository;
import net.yq.lesson09.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;

import java.util.Calendar;
import java.util.List;


@Controller
public class LoginController {
    @Autowired
    private UserService userService;
    @GetMapping("toLoginPage")
    public String toLoginPage(Model model){
        model.addAttribute("currentYear", Calendar.getInstance().get(Calendar.YEAR));
        return "login";//返回逻辑页面视图名称
    }
    //进行登录控制
    @PostMapping("login")
    public String login(User user,Model model){
        User user1 = userService.getUser(user.getUsername(),user.getPassword());
        if (user1 == null){
            model.addAttribute("loginMsg","登录失败");
        }else {
            model.addAttribute("loginMsg", "登陆成功");
                return "success";
            }
        }
        return "failure";
    }
}

进行国际化

• 编写多语言国际化配置文件
  在resources下创建i18n目录
  
  1、在i18n目录里创建login.properties
  

login.title = 用户登录
login.username = 输入用户名
login.password = 输入密码
login.rememberme = 记住我
login.button = 登录

2、在i18n目录里创建login_zh_CN.properties

login.title = 用户登录
login.username = 输入用户名
login.password = 输入密码
login.rememberme = 记住我
login.button = 登录

3、在i18n目录里创建login_en_US.properties

login.title = User Login
login.username = Enter Username
login.password = Enter Password
login.rememberme = Remember Me
login.button = Login

编写全局配置文件
加入

#配置国际化文件基础名
spring.messages.basename=i18n.login
#编码
spring.messages.encoding=UTF-8

接下来定制区域信息解析器
创建一个用于定制国际化功能区域信息解析器的自定义配置类MyLocalResolver，MyLocalResolver自定义区域解析器配置类实现了LocaleResolver接口，并重写了其中的resolveLocale()方法进行自定义语言解析，最后使用@Bean注解将当前配置类注册成Spring容器中的一个类型为LocaleResolver的Bean组件，这样就可以覆盖默认的LocaleResolver组件。

• 创建子包resolver
  在子包resolver中创建类MyLocaleResolver

package net.yq.lesson09.resolver;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.LocaleResolver;
import org.thymeleaf.util.StringUtils;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.Locale;

/**
 * 功能：自定义区域解析器
 */
@Configuration
public class MyLocaleResolver implements LocaleResolver {
    @Override
    public Locale resolveLocale(HttpServletRequest httpServletRequest) {
        String flag = httpServletRequest.getParameter("flag");
        Locale locale = Locale.getDefault();
        if (!StringUtils.isEmpty(flag)) {
            String[] split = flag.split("_");//使用下划线切分出一个数组，如zh_CN，["zh","CN"]
            locale = new Locale(split[0], split[1]);
        }
        return locale;
    }

    @Override
    public void setLocale(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Locale locale) {
    }

    @Bean
    public LocaleResolver localeResolver() {
        return new MyLocaleResolver();
    }
}

接下来是前端页面的编写了，login.html
所需的bootstrap我放在蓝奏Yun里面了，需要自行下载。

<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org/">
<head>
    <meta charset="UTF-8">
    <title>用户登录</title>
    <link th:href="@{/bootstrap-4.0.0/css/bootstrap.css}" rel="stylesheet">
    <javascript th:src="@{/bootstrap-4.0.0/js/jquery-3.4.1.min.js}"></javascript>
    <javascript th:src="@{/bootstrap-4.0.0/js/bootstrap.bundle.js}"></javascript>
    <javascript th:src="@{/bootstrap-4.0.0/js/bootstrap.js}">
    </javascript>
</head>
<body>
<div class="col-6 m-auto" style="margin-top:30px!important;">
    <div class="border border-info bg-light p-2" style="border-radius: 5px">
        <form action="/login" method="post">
<!--                <img th:class="center-pill" th:src="@{/images/ico.png}">-->
<!--                <h3><img th:src="@{/images/ico.png}" th:text="#{login.title}"></h3>-->
<!--                <h3 class="text-center" th:text="#{login.title}"><img th:src="@{/images/ico.png}" th:text="#{login.title}"></h3>-->
            <h3 class="text-center" th:text="#{login.title}">用户登录</h3>
            <div class="mt-1">
                <input type="text" id="username" name="username" class="form-control" th:placeholder="#{login.username}" required
                       autofocus>
            </div>
            <div class="mt-1">
                <input type="password" id="password" name="password" class="form-control" th:placeholder="#{login.password}" required>
            </div>
            <div class="checkbox text-center">
                <label>
                    <input class="form-check-input text-center" type="checkbox" id="remember-me">[[#{login.rememberme}]]
                </label>
            </div>
            <div>
                <button class="btn btn-lg btn-primary btn-block" id="login" type="submit" th:text="#{login.button}">登录</button>
            </div>
            <div class="text-center">
                <span th:text="${currentYear}">今年</span> -
                <span th:text="${currentYear} + 1">明年</span>
            </div>
            <div class="text-center">
                <a class="btn btn-sm" th:href="@{/toLoginPage(language='zh_CN')}">中文</a>
                <a class="btn btn-sm" th:href="@{/toLoginPage(language='en_US')}">English</a>
            </div>
        </form>
    </div>
</div>
</body>
</html>

这个模板是我老师写的，我只是照着用，
至于Controller是怎么获取用户输入的值的请看input框的name=""
最终效果为。

-----------------这里是分界线------------------
接下来是将此项目丰富起来，添加更多功能。
修改登陆控制器，增加登录权限判断，如果是管理员权限就跳转用户列表，普通用户就跳转登录成功页面。

package net.yq.lesson09.controller;

import net.yq.lesson09.bean.User;
import net.yq.lesson09.repository.UserRepository;
import net.yq.lesson09.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;

import java.util.Calendar;
import java.util.List;


@Controller
public class LoginController {
    @Autowired
    private UserService userService;
    @GetMapping("toLoginPage")
    public String toLoginPage(Model model){
        model.addAttribute("currentYear", Calendar.getInstance().get(Calendar.YEAR));
        return "login";//返回逻辑页面视图名称
    }
    //进行登录控制
    @PostMapping("login")
    public String login(User user,Model model){
        User user1 = userService.getUser(user.getUsername(),user.getPassword());
        if (user1 == null){
            model.addAttribute("loginMsg","登录失败");
        }else {
            model.addAttribute("loginMsg", "登陆成功");
            model.addAttribute("user", user);
            if (userService.getUser(user.getUsername(), user.getPassword()).getJurisdiction() == 0){
                List<User> users = userService.getUserList();
                model.addAttribute("users", users);
                return "list";
            } else {
                return "success";
            }
        }
        return "failure";
    }
}

具体效果图请看GIF

后面尽力添加CRUD