Spring Security登录验证，验证码，动态管理uri访问权限,Thymeleaf,限制密码强度、过期、错误密码锁定超时自动解锁、禁用历史密码、新密码和现密码差异要求编辑距离

àì夳堔傛蜴生んèń 2023-09-25 13:05 16阅读 0赞

在本教程中，我将指导您如何编写代码，以使用具有基于表单的身份验证的Spring安全API来保护Spring Boot应用程序中的网页。用户详细信息存储在MySQL数据库中，并使用春季JDBC连接到数据库。我们将从[本教程][Link 1]中的 ProductManager 项目开始，向现有的弹簧启动项目添加登录和注销功能。

### **1. 创建用户表和虚拟凭据** ###

凭据应存储在数据库中，因此让我们创建新表，表间关系ER图如下：

![9e54206fd5a34c668d74b3311dc0cd21.png][]

-- --------------------------------------------------------
    -- 主机:                           127.0.0.1
    -- 服务器版本:                        8.0.22 - MySQL Community Server - GPL
    -- 服务器操作系统:                      Win64
    -- HeidiSQL 版本:                  12.1.0.6537
    -- --------------------------------------------------------
    
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET NAMES utf8 */;
    /*!50503 SET NAMES utf8mb4 */;
    /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    /*!40103 SET TIME_ZONE='+00:00' */;
    /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    
    
    -- 导出 product3 的数据库结构
    CREATE DATABASE IF NOT EXISTS `product3` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
    USE `product3`;
    
    -- 导出  表 product3.history 结构
    CREATE TABLE IF NOT EXISTS `history` (
      `id` int NOT NULL AUTO_INCREMENT,
      `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
    
    -- 正在导出表  product3.history 的数据：~0 rows (大约)
    INSERT INTO `history` (`id`, `password`) VALUES
    	(1, NULL),
    	(2, NULL),
    	(3, NULL),
    	(4, NULL),
    	(5, NULL),
    	(6, NULL),
    	(7, '$2a$10$f8BTEI8AkiBQV60MvzpnVehdo9.AM6Zevvg8817dj5qbNuu.p3B22'),
    	(8, '$2a$10$9.ZG.D.e8u4NhGkGCVVUcOqpOB1b6WpCM7hEdawqIFo1G7Mg6/bt.'),
    	(9, '$2a$10$IK/CKJLp5jH7hQYjfTjZIeAPPNuI2rGQuEWMk8Z.Of9QkUvQC28X6'),
    	(10, '$2a$10$Lv.4MczeZKZNJyi58HVtp.0wztSxduK53L7O836KQS5mxItAoQsRG'),
    	(11, '$2a$10$7jbJuk9kHXXlZQOspT2T0O/Quj/zrMZC0CrPgQvUGSrhZRoub7kUO'),
    	(12, '$2a$10$bh68pHYzneQEWElmQRT/qOp/00WldBypIacHESvZGMHZ3vBJiN88u'),
    	(13, '$2a$10$8m5rM1JZ4RLcnOpuKXFtlOeXxHxtWHk7PuXumOJFGFnRA6o5hxz7.'),
    	(14, '$2a$10$VSsuBdX6sM2jtCAZ/gOhIut.aqfoymVYceSIUP6ncVMNDJmT2VjJi'),
    	(15, '$2a$10$.wqeNise86FpzDlZHrWISenOnOXryn71JNBlrhAM0Nv6Ae6M739t6');
    
    -- 导出  表 product3.permission 结构
    CREATE TABLE IF NOT EXISTS `permission` (
      `id` int NOT NULL AUTO_INCREMENT,
      `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
      `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
      `uri` varchar(8192) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
      `method` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
      PRIMARY KEY (`id`),
      UNIQUE KEY `name` (`name`)
    ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
    
    -- 正在导出表  product3.permission 的数据：~27 rows (大约)
    INSERT INTO `permission` (`id`, `name`, `description`, `uri`, `method`) VALUES
    	(3, 'product_create', '增加产品', '/product/new', 'GET'),
    	(4, 'product_delete', '删除产品', '/product/delete/*', 'GET'),
    	(5, 'product_save', '保存产品', '/product/save', 'POST'),
    	(9, 'product', '列表产品', '/product', 'GET'),
    	(10, 'product_edit', '编辑产品', '/product/edit/*', 'GET'),
    	(11, 'register', '注册用户', '/register', 'GET'),
    	(12, 'process_register', '保存用户', '/process_register', 'POST'),
    	(13, 'user', '列表用户', '/user', 'GET'),
    	(14, 'user/info', 'user/info', '/user/info', 'GET'),
    	(15, 'user_save', '保存用户', '/user/save', 'POST'),
    	(16, 'user_edit', '编辑用户', '/user/edit/*', 'GET'),
    	(17, 'permission', '读取权限', '/permission', 'GET'),
    	(18, 'permission_create', '增加权限', '/permission/new', 'GET'),
    	(19, 'permission_delete', '删除权限', '/permission/delete/*', 'GET'),
    	(20, 'permission_edit', '编辑权限', '/permission/edit/*', 'GET'),
    	(21, 'permission_save', '保存权限', '/permission/save', 'POST'),
    	(23, 'test1', '测试1', '/test1', 'GET1'),
    	(24, 'user_delete', '删除用户', '/user/delete/*', 'GET'),
    	(25, 'user_create', '增加用户', '/user/new', 'GET'),
    	(26, 'role', '读取角色', '/role', 'GET'),
    	(27, 'role_create', '创建角色', '/role/new', 'GET'),
    	(28, 'role_save', '保存角色', '/role/save', 'POST'),
    	(29, 'role_edit', '编辑角色', '/role/edit/*', 'GET'),
    	(30, 'role_delete', '删除角色', '/role/delete/*', 'GET'),
    	(31, 'user_update', '更新用户（不含密码）', '/user/update', 'POST'),
    	(32, 'user_resetpassword', '重置密码', '/user/resetpassword/*', 'GET'),
    	(33, 'user_savepassword', '保存重置密码', '/user/savepassword', 'POST'),
    	(34, 'order_create', '创建订单', '/order/new', 'GET');
    
    -- 导出  表 product3.product 结构
    CREATE TABLE IF NOT EXISTS `product` (
      `id` bigint NOT NULL AUTO_INCREMENT,
      `brand` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
      `madein` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
      `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
      `price` float NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
    
    -- 正在导出表  product3.product 的数据：~5 rows (大约)
    INSERT INTO `product` (`id`, `brand`, `madein`, `name`, `price`) VALUES
    	(6, '6', '6', '6', 6),
    	(7, '7', '7', '7', 7),
    	(9, '66', '66', '66', 66),
    	(10, '88', '887', '88', 88);
    
    -- 导出  表 product3.role 结构
    CREATE TABLE IF NOT EXISTS `role` (
      `id` int NOT NULL AUTO_INCREMENT,
      `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
      `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
      PRIMARY KEY (`id`),
      UNIQUE KEY `name` (`name`)
    ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
    
    -- 正在导出表  product3.role 的数据：~3 rows (大约)
    INSERT INTO `role` (`id`, `name`, `description`) VALUES
    	(1, 'ADMIN', 'Administrator role'),
    	(2, 'USER_P1', 'Perfil 1'),
    	(3, 'USER_P2', 'Perfil 2');
    
    -- 导出  表 product3.role_permission 结构
    CREATE TABLE IF NOT EXISTS `role_permission` (
      `id` int NOT NULL AUTO_INCREMENT,
      `role_id` int NOT NULL DEFAULT '0',
      `permission_id` int NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`),
      UNIQUE KEY `role_id_permission_id` (`role_id`,`permission_id`),
      KEY `FK_role_permission_permission` (`permission_id`),
      CONSTRAINT `FK_role_permission_permission` FOREIGN KEY (`permission_id`) REFERENCES `permission` (`id`),
      CONSTRAINT `FK_role_permission_role` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
    
    -- 正在导出表  product3.role_permission 的数据：~31 rows (大约)
    INSERT INTO `role_permission` (`id`, `role_id`, `permission_id`) VALUES
    	(1, 1, 3),
    	(2, 1, 4),
    	(3, 1, 5),
    	(4, 1, 9),
    	(5, 1, 10),
    	(11, 1, 11),
    	(12, 1, 12),
    	(13, 1, 13),
    	(14, 1, 14),
    	(16, 1, 15),
    	(15, 1, 16),
    	(17, 1, 17),
    	(18, 1, 18),
    	(19, 1, 19),
    	(20, 1, 20),
    	(22, 1, 21),
    	(23, 1, 24),
    	(24, 1, 25),
    	(25, 1, 26),
    	(26, 1, 27),
    	(29, 1, 28),
    	(28, 1, 29),
    	(27, 1, 30),
    	(35, 1, 31),
    	(36, 1, 32),
    	(37, 1, 33),
    	(8, 2, 5),
    	(6, 2, 9),
    	(7, 2, 10),
    	(10, 3, 4),
    	(9, 3, 9);
    
    -- 导出  表 product3.user 结构
    CREATE TABLE IF NOT EXISTS `user` (
      `id` int NOT NULL AUTO_INCREMENT,
      `username` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
      `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
      `name` varchar(65) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
      `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
      `enabled` bit(1) DEFAULT b'1',
      `homepage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
      `password_changed_time` datetime(6) DEFAULT NULL,
      `account_non_locked` bit(1) DEFAULT b'1',
      `failed_attempt` int DEFAULT '0',
      `lock_time` datetime(6) DEFAULT NULL,
      PRIMARY KEY (`id`),
      UNIQUE KEY `username` (`username`)
    ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
    
    -- 正在导出表  product3.user 的数据：~13 rows (大约)
    INSERT INTO `user` (`id`, `username`, `email`, `name`, `password`, `enabled`, `homepage`, `password_changed_time`, `account_non_locked`, `failed_attempt`, `lock_time`) VALUES
    	(1, 'admin', 'admin@admin.com', '系统管理员', '$2a$10$BnWGC47vHMAu5SUtNZbb0O1f19G81EdZGJ17/dSe3VJPI8wM2/oEK', b'1', '', '2022-11-16 14:22:01.550000', b'1', 0, NULL),
    	(2, 'u1', 'u1@example.com', 'User P1', '$2a$10$7lsSw2BeeDCmm6gYJBdJfuotFoDkfggWq8pWTjj7awbwywNdGHZ3u', b'1', 'home', NULL, b'1', 0, NULL),
    	(3, 'u2', 'u2@example.com', 'User P2', '$2a$10$2/LSmp3YoEOT97KzgrYODen7I88ErBovM2Qehw9DL1dW9DZ7DZSAm', b'1', '', NULL, b'1', 0, NULL),
    	(11, 'allway222', 'allway222@1.com', 'allway222', '$2a$10$WTg/WDKmYaYZUbFl39Z6au78WOG8LI9bcnvbbLs/.t5MjzwrBD60u', b'1', 'home', NULL, b'1', 0, NULL),
    	(12, 'allway666', 'allway666@1.com', 'allway66622', '$2a$10$Jeky6hyUSN3i0u6IPF8squDtjkFwHL7WzP3rRoF4QOEwWfVAzi/c2', b'1', 'home', NULL, b'1', 0, NULL),
    	(13, 'allway777', 'allway777@1.com', 'allway777', '$2a$10$W0TWw1.9lBYG7PW8KsEWcuNFGiOJAOobr55bKMQD8rf68GVppUH4S', b'1', 'home', NULL, b'1', 0, NULL),
    	(14, 'test', '1@1.com', 'test', '$2a$10$Kq1sx9/uoAedR2LsUKoVQeUfY8Qho9afSKuGLj4u9Y9iTRo//17Fq', b'1', 'home', NULL, b'1', 0, NULL),
    	(25, 'user102', 'Password@123.com', 'user102', '$2a$10$hZvr4Ao7ofNFdXHjPkRWXuCuuUUJmImhJjVAiiWxTBKRF2Rx5Z8RG', b'1', '', '2022-11-15 15:17:05.924000', b'1', 0, NULL),
    	(26, 'user103', 'Password@123.com', 'user103', '$2a$10$E6Zy8hSM6EVV53G8PjRyoeGdVi6Rj0hkkSQHvZPARoKTwwFD0kWza', b'1', '', '2022-11-16 12:20:26.190000', b'1', 0, NULL),
    	(27, 'user200', '1@1.com', 'user200', '$2a$10$8gy2nX5/nTfCPEmr8KPNfuOpQHgH9.2h6NQG0uBdlBzlK5n3jz6OC', b'1', '', '2022-11-16 14:45:42.963000', b'1', 0, NULL),
    	(28, 'user300', '1@1.com', 'user300', '$2a$10$0k1AJFxJ4/LbFyRvjH5KHONlZKDAoB34R8ze9wVcpIfkXChXPUnzu', b'1', '', '2022-11-16 14:56:20.506000', b'1', 0, NULL),
    	(29, 'user400', '1@1.com', 'user400', '$2a$10$4kM1O0mmaJ218bCiIOzODuJgmlCMDo.FoUk5l9H8i64rjRNDyeLL.', b'1', '', '2022-11-16 15:07:00.289000', b'1', 0, NULL),
    	(30, 'user500', '1@1.com', 'user500', '$2a$10$zW.LGJfSXdy14A.bCy9Nsu8g2uVPZrD04PIxqZYq6MNJx1tRIBdMu', b'1', '', '2022-11-16 15:14:52.993000', b'1', 0, NULL);
    
    -- 导出  表 product3.user_history 结构
    CREATE TABLE IF NOT EXISTS `user_history` (
      `user_id` int NOT NULL,
      `history_id` int NOT NULL,
      PRIMARY KEY (`user_id`,`history_id`),
      KEY `FKmyn0e5qi70qvka9b47oaedacw` (`history_id`),
      CONSTRAINT `FKaa6ilb6iqih95bntoeyysb2pc` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
      CONSTRAINT `FKmyn0e5qi70qvka9b47oaedacw` FOREIGN KEY (`history_id`) REFERENCES `history` (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
    
    -- 正在导出表  product3.user_history 的数据：~0 rows (大约)
    INSERT INTO `user_history` (`user_id`, `history_id`) VALUES
    	(1, 1),
    	(1, 2),
    	(1, 3),
    	(1, 4),
    	(1, 5),
    	(1, 6),
    	(1, 7),
    	(1, 8),
    	(1, 9),
    	(1, 10),
    	(1, 11),
    	(26, 12),
    	(26, 13),
    	(1, 14),
    	(1, 15);
    
    -- 导出  表 product3.user_role 结构
    CREATE TABLE IF NOT EXISTS `user_role` (
      `id` int NOT NULL AUTO_INCREMENT,
      `user_id` int NOT NULL DEFAULT '0',
      `role_id` int NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`),
      UNIQUE KEY `user_id_role_id` (`user_id`,`role_id`),
      KEY `FK_user_role_role` (`role_id`),
      CONSTRAINT `FK_user_role_role` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`),
      CONSTRAINT `FK_user_role_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
    
    -- 正在导出表  product3.user_role 的数据：~13 rows (大约)
    INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES
    	(59, 1, 1),
    	(58, 1, 2),
    	(57, 1, 3),
    	(2, 2, 2),
    	(3, 3, 3),
    	(43, 11, 1),
    	(44, 12, 1),
    	(26, 13, 1),
    	(51, 14, 1),
    	(52, 14, 3),
    	(60, 25, 1),
    	(64, 26, 1),
    	(63, 26, 2),
    	(62, 26, 3),
    	(76, 27, 1),
    	(75, 28, 1),
    	(78, 29, 1),
    	(74, 30, 1);
    
    /*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
    /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
    /*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    /*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;

### **2. 配置数据源属性** ###

接下来，在应用程序属性文件中指定数据库连接信息，如下所示：根据您的MySQL数据库更新URL，用户名和密码。

spring.jpa.hibernate.ddl-auto=update
    spring.datasource.url=jdbc:mysql://localhost:3306/product3?autoReconnect=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
    spring.datasource.username=root
    spring.datasource.password=root
    #logging.level.root=WARN

### **3. 声明弹簧安全性和 MySQL JDBC 驱动程序的依赖关系** ###

要将Spring安全API用于项目，请在pom.xml文件中声明以下依赖项：并且要将JDBC与弹簧启动和MySQL一起使用：请注意，依赖项版本已由弹簧启动初学者父项目定义。

<?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 http://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 /> 
        </parent>
        <groupId>net.codejava</groupId>
        <artifactId>ProductManagerJDBCAuthenticationManuallyAuthenticateCaptchaAccess</artifactId>
        <version>2.0</version>
        <name>ProductManagerJDBCAuthenticationManuallyAuthenticateCaptchaAccess</name>
        <description>ProductManagerJDBCAuthentication</description>
        <packaging>jar</packaging>
    
        <properties>
            <java.version>1.8</java.version>
        </properties>
    
        <dependencies>
            <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>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <scope>runtime</scope>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-security</artifactId>
            </dependency>
            <dependency>
                <groupId>org.thymeleaf.extras</groupId>
                <artifactId>thymeleaf-extras-springsecurity5</artifactId>
            </dependency>
            <dependency>
                <groupId>com.github.penggle</groupId>
                <artifactId>kaptcha</artifactId>
                <version>2.3.2</version>
            </dependency>
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <version>1.18.24</version>
                <scope>provided</scope>
            </dependency>
    
    
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </build>
    
    </project>

### **4. 配置 JDBC 身份验证详细信息** ###

要将 Spring 安全性与基于表单的身份验证和 JDBC 结合使用，请按如下方式创建 WebSecurityConfig 类：

package com.example;
    
    import javax.servlet.Filter;
    import javax.sql.DataSource;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.web.servlet.ServletListenerRegistrationBean;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.security.config.annotation.authentication.builders.AuthenticationManagerBuilder;
    import org.springframework.security.config.annotation.web.builders.HttpSecurity;
    import org.springframework.security.config.annotation.web.configuration.EnableWebSecurity;
    import org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter;
    import org.springframework.security.core.session.SessionRegistry;
    import org.springframework.security.core.session.SessionRegistryImpl;
    import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder;
    import org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter;
    import org.springframework.security.web.session.HttpSessionEventPublisher;
    
    @Configuration
    @EnableWebSecurity
    public class WebSecurityConfig extends WebSecurityConfigurerAdapter {
    
        @Autowired
        private DataSource dataSource;
    
        @Autowired
        private CustomLoginFailureHandler loginFailureHandler;
        @Autowired
        private CustomLoginSuccessHandler successHandler;
    
        @Autowired
        public void configAuthentication(AuthenticationManagerBuilder authBuilder) throws Exception {
            authBuilder.jdbcAuthentication()
                    .dataSource(dataSource)
                    .passwordEncoder(new BCryptPasswordEncoder())
                    .usersByUsernameQuery("select username, password, enabled from user where username=?")
                    .authoritiesByUsernameQuery("SELECT user.username,permission.name FROM user,role,user_role,permission,role_permission WHERE user.id=user_role.user_id AND role.id=user_role.role_id AND role.id=role_permission.role_id AND permission.id=role_permission.permission_id  AND user.username=?");
    
        }
    
        @Override
        protected void configure(HttpSecurity http) throws Exception {
            Filter filter = new KaptchaAuthenticationFilter("/login", "/login?error");
            http.addFilterBefore(filter, UsernamePasswordAuthenticationFilter.class);
    
            http.authorizeRequests()
                    .antMatchers("/captcha_image**").permitAll()
                    .antMatchers("/header").permitAll()
                    .antMatchers("/footer").permitAll()
                    .antMatchers("/sidebar").permitAll()
                    .antMatchers("/index2").permitAll()
                    .antMatchers("/index3").permitAll()
                    .antMatchers("/pages/**").permitAll()
                    .antMatchers("/css/**").permitAll()
                    .antMatchers("/js/**").permitAll()
                    .antMatchers("/assets/**").permitAll()
                    .antMatchers("/webjars/**").permitAll()
                    .antMatchers("/common/**").permitAll()
                    .antMatchers("/login").permitAll()
                    .antMatchers("/logout").permitAll()
                    .antMatchers("/verify").permitAll()
                    .antMatchers("/home").authenticated()
                    .antMatchers("/user/info").authenticated()
                    .antMatchers("/change/password").authenticated()
                    .antMatchers("/new/password").authenticated()
                    .antMatchers("/").authenticated()
                    .anyRequest()
                    .access("@rbacService.hasPermission(request , authentication)")
                    .and()
                    .formLogin().loginPage("/login")
                    .permitAll()
                    .failureHandler(loginFailureHandler)
                    .successHandler(successHandler)
                    .and()
                    .logout().permitAll()
                    .and()
                    .exceptionHandling().accessDeniedPage("/403");
            http
                    .sessionManagement()
                    .maximumSessions(1)
                    .expiredUrl("/")
                    .maxSessionsPreventsLogin(false)
                    .sessionRegistry(sessionRegistry());
        }
    
        @Bean
        public SessionRegistry sessionRegistry() {
            SessionRegistry sessionRegistry = new SessionRegistryImpl();
            return sessionRegistry;
        }
    
        // Register HttpSessionEventPublisher
        @Bean
        public static ServletListenerRegistrationBean httpSessionEventPublisher() {
            return new ServletListenerRegistrationBean(new HttpSessionEventPublisher());
        }
    
        @Bean
        BCryptPasswordEncoder bCryptPasswordEncoder() {
            return new BCryptPasswordEncoder();
        }
    }

当不使用WebSecurityConfigurerAdapter 时最大会话限制不起作用，故此处仍使用废弃的WebSecurityConfigurerAdapter

此安全配置类必须使用@EnableWebSecurity注释进行批注，并且是 Web 安全配置器适配器的子类。数据源对象的实例将由Spring框架创建并注入：

@Autowired
        private DataSource dataSource;

它将从应用程序属性文件中读取数据库连接信息。要使用JDBC配置身份验证，请编写以下方法：

@Autowired
        public void configAuthentication(AuthenticationManagerBuilder authBuilder) throws Exception {
            authBuilder.jdbcAuthentication()
                    .dataSource(dataSource)
                    .passwordEncoder(new BCryptPasswordEncoder())
                    .usersByUsernameQuery("select username, password, enabled from users where username=?")
                    .authoritiesByUsernameQuery("SELECT users.username,permissions.name FROM users,roles,users_roles,permissions,roles_permissions WHERE users.username=users_roles.username AND roles.name=users_roles.role_name AND roles.name=roles_permissions.role_name AND permissions.name=roles_permissions.permission AND users.username=?");
        }

如您所见，我们需要指定密码编码器（建议使用BCrypt），数据源和两个SQL语句：第一个根据用户名选择用户，第二个选择用户的角色。请注意，Spring安全性要求列名必须是用户名，密码，启用和角色。为了配置基于表单的身份验证，我们重写了 configure（HttpSecurity） 方法，如下所示：

@Override
        protected void configure(HttpSecurity http) throws Exception {
            http.authorizeRequests()
                    .antMatchers("/edit/*", "/delete/*").hasAnyAuthority("ADMIN")
                    .anyRequest().authenticated()
                    .and()
                    .formLogin().permitAll()
                    .and()
                    .logout().permitAll()
                    .and()
                    .exceptionHandling().accessDeniedPage("/403");
        }

在这里，我们指定所有请求都必须进行身份验证，这意味着用户必须登录才能使用该应用程序。使用Spring安全性提供的默认登录表单。要显示已登录用户的用户名，请在Thymeleaf模板文件中编写以下代码：

<div sec:authorize="isAuthenticated()">
                    Welcome <b><span sec:authentication="name">Username</span></b>
                     
                    <i><span sec:authentication="principal.authorities">Roles</span></i>
                </div>

并添加注销按钮：

如您所见，Spring Security将处理应用程序的登录和注销。我们不必编写重复的代码，只需指定一些配置即可。

### 5.登录验证过程 ###

package com.example;
    
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.GetMapping;
    
    @Controller
    public class CommonController {
    
        @GetMapping("/login")
        public String viewLoginPage() {
            // custom logic before showing login page...
    
            return "login";
        }
    }

####  ####

kaptcha验证码

package com.example;
    
    import java.awt.image.BufferedImage;
    
    import javax.imageio.ImageIO;
    import javax.servlet.ServletOutputStream;
    import javax.servlet.http.HttpServletResponse;
    import javax.servlet.http.HttpSession;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.GetMapping;
    
    import com.google.code.kaptcha.Constants;
    import com.google.code.kaptcha.Producer;
    
    /**
     * @author will
     */
    @Controller
    public class KaptchaController {
        @Autowired
        private Producer captchaProducer;
    
        @GetMapping("/captcha_image")
        public void getKaptchaImage(HttpServletResponse response, HttpSession session) throws Exception {
            response.setDateHeader("Expires", 0);
            // Set standard HTTP/1.1 no-cache headers.
            response.setHeader("Cache-Control", "no-store, no-cache, must-revalidate");
            // Set IE extended HTTP/1.1 no-cache headers (use addHeader).
            response.addHeader("Cache-Control", "post-check=0, pre-check=0");
            // Set standard HTTP/1.0 no-cache header.
            response.setHeader("Pragma", "no-cache");
            // return a jpeg
            response.setContentType("image/jpeg");
            // create the text for the image
            String capText = captchaProducer.createText();
            // store the text in the session
            // request.getSession().setAttribute(Constants.KAPTCHA_SESSION_KEY, capText);
    
            // save captcha to session
            session.setAttribute(Constants.KAPTCHA_SESSION_KEY, capText);
    
            // create the image with the text
            BufferedImage bi = captchaProducer.createImage(capText);
            ServletOutputStream out = response.getOutputStream();
    
            // write the data out
            ImageIO.write(bi, "jpg", out);
            try {
                out.flush();
            } finally {
                out.close();
            }
        }
    }

package com.example;
    
    import com.google.code.kaptcha.impl.DefaultKaptcha;
    import com.google.code.kaptcha.util.Config;
    import org.springframework.context.annotation.Bean;
    import org.springframework.stereotype.Component;
    
    import java.util.Properties;
    
    @Component
    public class KaptchaConfig {
    
        @Bean
        public DefaultKaptcha getDefaultKaptcha() {
            DefaultKaptcha defaultKaptcha = new DefaultKaptcha();
            Properties properties = new Properties();
            properties.put("kaptcha.border", "no");
            properties.put("kaptcha.textproducer.font.color", "black");
            properties.put("kaptcha.image.width", "150");
            properties.put("kaptcha.image.height", "40");
            properties.put("kaptcha.textproducer.font.size", "30");
            properties.put("kaptcha.session.key", "verifyCode");
            properties.put("kaptcha.textproducer.char.space", "5");
    //        properties.setProperty("kaptcha.textproducer.char.length", "4");
            Config config = new Config(properties);
            defaultKaptcha.setConfig(config);
    
            return defaultKaptcha;
        }
    
    }

### 6.登录页面 ###

<!DOCTYPE html>
    <html xmlns:th="http://www.thymeleaf.org">
        <head>
            <meta charset="UTF-8">
            <meta http-equiv="X-UA-Compatible" content="IE=edge">
            <meta name="viewport" content="width=device-width, initial-scale=1.0">
            <title>Bootstrap 5 Sign In Form with Image Example</title>
            <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet"
                  integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">
            <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js"
                    integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM"
            crossorigin="anonymous"></script>
            <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.5.0/font/bootstrap-icons.css">
        </head>
    
        <body>
    
            <form th:action="@{/login}" method="post">
                <div class="container-fluid vh-100" style="margin-top:50px">
                    <div class="" style="margin-top:50px">
                        <div class="rounded d-flex justify-content-center">
                            <div class=" col-md-4 col-sm-12 shadow-lg p-5 bg-light">
                                <div th:if="${param.error}">
                                    <p class="text-danger">[[${session.SPRING_SECURITY_LAST_EXCEPTION.message}]]</p>
                                </div>
    
                                <div th:if="${param.logout}">
                                    <p class="text-warning">You have been logged out.</p>
                                </div>
                                <div class="text-center">
                                    <h3 class="text-primary">请登录</h3>
                                </div>
                                <div class="p-4">
                                    <div class="input-group mb-3">
                                        <span class="input-group-text bg-secondary"><i
                                                class="bi bi-person-fill text-white"></i></span>
                                        <input id="username" type="text" name="username" required class="form-control" placeholder="用户名">
                                    </div>
                                    <div class="input-group mb-3">
                                        <span class="input-group-text bg-secondary"><i
                                                class="bi bi-key-fill text-white"></i></span>
                                        <input  id="password" type="password" name="password" required class="form-control" placeholder="密码">
                                    </div>
                                    <div class="input-group mb-3">
                                        <span class="input-group-text bg-secondary"><i
                                                class="bi bi-lock-fill text-white"></i></span>
                                        <input type="text" name="kaptcha"  class="form-control" placeholder="输入下图中的校验码">
                                    </div>
                                    <div class="input-group mb-3">
                                        <span class="input-group-text bg-secondary"><i
                                                class="bi bi-image-fill text-white"></i></span>
                                        <img alt="Click the picture to refresh!" class="pointer" th:src="@{/captcha_image}"
                                             onclick="this.src = '/captcha_image?d=' + new Date() * 1">
                                    </div>
                                    <div class="col-12">
                                        <button type="submit" class="btn btn-primary px-4 float-end mt-4">登录</button>
                                    </div>
    
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
        </body>
    
    </html>

### **5. 测试登录和注销** ###

启动Spring Boot应用程序并访问 http://localhost:8080 在Web浏览器中，您将看到自定义的登录页面出现：

![74d9c55b07d845dc8916c07636499a6f.png][]

现在输入正确的用户名admin和密码admin，您将看到主页如下：

![9c13c64d951a401ca43d5fdfbffadab8.png][]

并注意欢迎消息后跟用户名。用户现在已通过身份验证以使用该应用程序。单击“注销”按钮，您将看到自定义的登录页面出现，这意味着我们已成功实现登录并注销到我们的Spring Boot应用程序。

自定义从数据库中获取动态权限验证

package com.example;
    
    import javax.persistence.Entity;
    import javax.persistence.GeneratedValue;
    import javax.persistence.GenerationType;
    import javax.persistence.Id;
    import javax.persistence.Table;
    import lombok.Data;
    
    @Data
    @Entity
    public class Permission {
    
        @Id
        private Long id;
        private String name;
        private String description;
        private String uri;
        private String method;
    
    }

package com.example;
    
    import org.springframework.data.jpa.repository.JpaRepository;
    
    public interface PermissionRepository extends JpaRepository<Permission, Long> {
    
        public Permission findByName(String name);
    
    }

package com.example;
    
    
    import javax.servlet.http.HttpServletRequest;
    import org.springframework.security.core.Authentication;
    
    /**
     * RBAC模型实现Security,即通过角色对用户进行分组，在对每个角色进行权限授权就， 进而简化用户权限分配以及管理。 需要的表： user：
     * 用户信息表 保存有的用户id,用户名、密码、账号、状态、salt加盐 role:角色表 user_role:用户角色关联表 permission： 权限表
     * 保存的有权限相关信息 role_permission: 角色与权限管理表
     */
    public interface RbacService {
    
        //用户判断当前请求是否有操作权限
        boolean hasPermission(HttpServletRequest request, Authentication authentication);
    }

package com.example;
    
    import java.util.ArrayList;
    import java.util.Collection;
    import java.util.List;
    import javax.servlet.http.HttpServletRequest;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.security.core.Authentication;
    import org.springframework.security.core.GrantedAuthority;
    import org.springframework.security.core.userdetails.User;
    import org.springframework.security.core.userdetails.UserDetails;
    import org.springframework.stereotype.Component;
    import org.springframework.util.AntPathMatcher;
    
    @Component("rbacService")
    public class RbacServiceImpl implements RbacService {
    
        @Autowired
        private PermissionRepository permissionRepository;
    
        private AntPathMatcher antPathMatcher = new AntPathMatcher();
    
        @Override
        public boolean hasPermission(HttpServletRequest request, Authentication authentication) {
    
            //获取用户认证信息
            System.out.println(authentication.getAuthorities());
            Object principal = authentication.getPrincipal();
            System.out.println(principal.getClass());
            //判断数据是否为空 以及类型是否正确
            if (null != principal && principal instanceof User) {
                String username = ((User) principal).getUsername();
                System.out.println(username);
    
            }
    
            String requestURI = request.getRequestURI();
            System.out.println(requestURI);
            String method = request.getMethod();
            System.out.println(method);
    
            Collection<? extends GrantedAuthority> authorities = authentication.getAuthorities();
            boolean hasPermission = false;
            for (GrantedAuthority authority : authorities) {
                String authorityname = authority.getAuthority();
                System.out.println(authority.getAuthority());
                Permission permission = permissionRepository.findByName(authorityname);
                System.out.println(permissionRepository.findByName(authorityname));
                if (null != permission && permission.getMethod().equals(request.getMethod()) && antPathMatcher.match(permission.getUri(), request.getRequestURI())) {
                    hasPermission = true;
    
                    break;
                }
            }
            System.out.println(hasPermission);
            return hasPermission;
        }
    }

thymeleaf视图文件中，根据权限显示连接菜单

<!DOCTYPE html>
    <html lang="en">
        <head>
            <meta charset="utf-8">
            <meta content="width=device-width, initial-scale=1.0" name="viewport">
            <title>Dashboard - Admin Bootstrap Template</title>
            <meta name="robots" content="noindex, nofollow">
            <meta content="" name="description">
            <meta content="" name="keywords">
            <link href="/assets/img/favicon.png" rel="icon">
            <link href="/assets/img/apple-touch-icon.png" rel="apple-touch-icon">
            <link href="/assets/css/bootstrap.min.css" rel="stylesheet">
            <link href="/assets/css/bootstrap-icons.css" rel="stylesheet">
            <link href="/assets/css/boxicons.min.css" rel="stylesheet">
            <link href="/assets/css/quill.snow.css" rel="stylesheet">
            <link href="/assets/css/quill.bubble.css" rel="stylesheet">
            <link href="/assets/css/remixicon.css" rel="stylesheet">
            <link href="/assets/css/simple-datatables.css" rel="stylesheet">
            <link href="/assets/css/style.css" rel="stylesheet">
        </head>
        <body>
            <header id="header" class="header fixed-top d-flex align-items-center" th:replace="fragments/header :: header">
            </header>
            <aside id="sidebar" class="sidebar" th:replace="fragments/sidebar :: sidebar">
            </aside>
            <main id="main" class="main">
                <div class="pagetitle">
                    <nav>
                        <ol class="breadcrumb">
                            <li class="breadcrumb-item"><a href="index.html">主页</a></li>
                            <li class="breadcrumb-item active">用户管理</li>
                        </ol>
                    </nav>
                </div>
                <section class="section dashboard">
                    <div class="row">
                        <div class="col-lg-12">
                            <div class="card">
                                <div class="card-body">
    
                                    <br/>
                                    <br/>
                                    <div class="table-title">
                                        <div class="row">
                                            <div class="col-sm-6">
                                                <h2> <b>用户管理</b></h2>
                                            </div>
                                            <div class="col-sm-6">
                                                <div sec:authorize="hasAnyAuthority('permission_create')">
                                                    <a href="/user/new" class="btn btn-success" ><i class="bi bi-person-plus" data-toggle="tooltip" title="添加用户"></i></a>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <table class="table table-striped table-hover">
                                        <thead >
                                            <tr>
                                                <th>ID</th>
                                                <th>User Name</th>
                                                <th>E-mail</th>
                                                <th>Name</th>
                                                <th>Home Page</th>
                                                <th>Roles</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <tr th:each="user: ${listUsers}">
                                                <td th:text="${user.id}">User ID</td>
                                                <td th:text="${user.username}">User Name</td>
                                                <td th:text="${user.email}">E-mail</td>
                                                <td th:text="${user.name}">Name</td>
                                                <td th:text="${user.homepage}">Home Page</td>
                                                <td th:text="${user.roles}">Roles</td>
                                                <td>
                                                    <a sec:authorize="hasAuthority('user_edit')" th:href="@{'/user/edit/' + ${user.id}}" class="edit" ><i class="bi bi-pencil" data-toggle="tooltip" title="编辑"></i></a>
                                                    <a sec:authorize="hasAuthority('user_edit')" th:href="@{'/user/resetpassword/' + ${user.id}}" class="reset" ><i class="bi bi-key" data-toggle="tooltip" title="重置密码"></i></a>
                                                    <a sec:authorize="hasAuthority('user_delete')" th:href="@{'/user/delete/' + ${user.id}}" class="delete" ><i class="bi bi-trash" data-toggle="tooltip" title="删除"></i></a>
    
    
                                                </td>
                                            </tr>
                                        </tbody>
                                    </table>
    
    
    
                                </div>
                            </div>
                        </div>
                </section>
            </main>
            <footer id="footer" class="footer" th:replace="fragments/footer :: footer">
                <div class="copyright"> © Copyright <strong><span>Compnay Name</span></strong>. All Rights Reserved</div>
                <div class="credits"> with love <a href="https://freeetemplates.com/">FreeeTemplates</a></div>
            </footer>
            <a href="#" class="back-to-top d-flex align-items-center justify-content-center"><i class="bi bi-arrow-up-short"></i></a>
            <script src="/assets/js/apexcharts.min.js"></script>
            <script src="/assets/js/bootstrap.bundle.min.js"></script>
            <script src="/assets/js/chart.min.js"></script>
            <script src="/assets/js/echarts.min.js"></script>
            <script src="/assets/js/quill.min.js"></script>
            <script src="/assets/js/simple-datatables.js"></script>
            <script src="/assets/js/tinymce.min.js"></script>
            <script src="/assets/js/validate.js"></script>
            <script src="/assets/js/main.js"></script>
    
        </body>
    </html>

####  ####

Thymeleaf集成[Bootstrap 5 Free Admin Dashboard Template 1 - freeetemplates][]

#### header.html ####

#### footer.html ####

#### sidebar.html ####

<!DOCTYPE html>
    <html xmlns="http://www.w3.org/1999/xhtml"
          xmlns:th="http://www.thymeleaf.org"  xmlns:sec="http://www.thymeleaf.org">
        <head>
            <meta charset="utf-8">
                <meta content="width=device-width, initial-scale=1.0" name="viewport">
                    <title>Dashboard - Admin Bootstrap Template</title>
                    <meta name="robots" content="noindex, nofollow">
                        <meta content="" name="description">
                            <meta content="" name="keywords">
                                <link href="assets/img/favicon.png" rel="icon">
                                    <link href="assets/img/apple-touch-icon.png" rel="apple-touch-icon">
                                        <link href="https://fonts.gstatic.com" rel="preconnect">
                                            <link href="https://fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i|Nunito:300,300i,400,400i,600,600i,700,700i|Poppins:300,300i,400,400i,500,500i,600,600i,700,700i" rel="stylesheet">
                                                <link href="assets/css/bootstrap.min.css" rel="stylesheet">
                                                    <link href="assets/css/bootstrap-icons.css" rel="stylesheet">
                                                        <link href="assets/css/boxicons.min.css" rel="stylesheet">
                                                            <link href="assets/css/quill.snow.css" rel="stylesheet">
                                                                <link href="assets/css/quill.bubble.css" rel="stylesheet">
                                                                    <link href="assets/css/remixicon.css" rel="stylesheet">
                                                                        <link href="assets/css/simple-datatables.css" rel="stylesheet">
                                                                            <link href="assets/css/style.css" rel="stylesheet">
                                                                                </head>
                                                                                <body>
    
    
    
                                                                                    <aside id="sidebar" class="sidebar" th:fragment="sidebar">
                                                                                        <ul class="sidebar-nav" id="sidebar-nav">
                                                                                            <li class="nav-item"> <a class="nav-link " href="index.html"> <i class="bi bi-grid"></i> <span>Dashboard</span> </a></li>
                                                                                            <li class="nav-item">
                                                                                                <a class="nav-link collapsed" data-bs-target="#components-nav" data-bs-toggle="collapse" href="#"> <i class="bi bi-menu-button-wide"></i><span>系统管理</span><i class="bi bi-chevron-down ms-auto"></i> </a>
                                                                                                <ul id="components-nav" class="nav-content collapse " data-bs-parent="#sidebar-nav">
                                                                                                    <li sec:authorize="hasAuthority('user')"><a th:href="@{/user}"><i class="bi bi-circle"></i><span>用户管理</span> </a></li>
                                                                                                    <li sec:authorize="hasAuthority('role')"><a th:href="@{/role}"><i class="bi bi-circle"></i><span>角色管理</span> </a></li>
                                                                                                    <li sec:authorize="hasAuthority('permission')"><a th:href="@{/permission}"><i class="bi bi-circle"></i><span>权限管理</span> </a></li>
                                                                                                    <li> <a href="components-breadcrumbs.html"> <i class="bi bi-circle"></i><span>Breadcrumbs</span> </a></li>
                                                                                                    <li> <a href="components-buttons.html"> <i class="bi bi-circle"></i><span>Buttons</span> </a></li>
                                                                                                    <li> <a href="components-cards.html"> <i class="bi bi-circle"></i><span>Cards</span> </a></li>
                                                                                                    <li> <a href="components-carousel.html"> <i class="bi bi-circle"></i><span>Carousel</span> </a></li>
                                                                                                    <li> <a href="components-list-group.html"> <i class="bi bi-circle"></i><span>List group</span> </a></li>
                                                                                                    <li> <a href="components-modal.html"> <i class="bi bi-circle"></i><span>Modal</span> </a></li>
                                                                                                    <li> <a href="components-tabs.html"> <i class="bi bi-circle"></i><span>Tabs</span> </a></li>
                                                                                                    <li> <a href="components-pagination.html"> <i class="bi bi-circle"></i><span>Pagination</span> </a></li>
                                                                                                    <li> <a href="components-progress.html"> <i class="bi bi-circle"></i><span>Progress</span> </a></li>
                                                                                                    <li> <a href="components-spinners.html"> <i class="bi bi-circle"></i><span>Spinners</span> </a></li>
                                                                                                    <li> <a href="components-tooltips.html"> <i class="bi bi-circle"></i><span>Tooltips</span> </a></li>
                                                                                                </ul>
                                                                                            </li>
                                                                                            <li class="nav-item">
                                                                                                <a class="nav-link collapsed" data-bs-target="#forms-nav" data-bs-toggle="collapse" href="#"> <i class="bi bi-journal-text"></i><span>Forms</span><i class="bi bi-chevron-down ms-auto"></i> </a>
                                                                                                <ul id="forms-nav" class="nav-content collapse " data-bs-parent="#sidebar-nav">
                                                                                                    <li> <a href="forms-elements.html"> <i class="bi bi-circle"></i><span>Form Elements</span> </a></li>
                                                                                                    <li> <a href="forms-layouts.html"> <i class="bi bi-circle"></i><span>Form Layouts</span> </a></li>
                                                                                                    <li> <a href="forms-editors.html"> <i class="bi bi-circle"></i><span>Form Editors</span> </a></li>
                                                                                                    <li> <a href="forms-validation.html"> <i class="bi bi-circle"></i><span>Form Validation</span> </a></li>
                                                                                                </ul>
                                                                                            </li>
                                                                                            <li class="nav-item">
                                                                                                <a class="nav-link collapsed" data-bs-target="#tables-nav" data-bs-toggle="collapse" href="#"> <i class="bi bi-layout-text-window-reverse"></i><span>Tables</span><i class="bi bi-chevron-down ms-auto"></i> </a>
                                                                                                <ul id="tables-nav" class="nav-content collapse " data-bs-parent="#sidebar-nav">
                                                                                                    <li> <a href="tables-general.html"> <i class="bi bi-circle"></i><span>General Tables</span> </a></li>
                                                                                                    <li> <a href="tables-data.html"> <i class="bi bi-circle"></i><span>Data Tables</span> </a></li>
                                                                                                </ul>
                                                                                            </li>
                                                                                            <li class="nav-item">
                                                                                                <a class="nav-link collapsed" data-bs-target="#charts-nav" data-bs-toggle="collapse" href="#"> <i class="bi bi-bar-chart"></i><span>Charts</span><i class="bi bi-chevron-down ms-auto"></i> </a>
                                                                                                <ul id="charts-nav" class="nav-content collapse " data-bs-parent="#sidebar-nav">
                                                                                                    <li> <a href="charts-chartjs.html"> <i class="bi bi-circle"></i><span>Chart.js</span> </a></li>
                                                                                                    <li> <a href="charts-apexcharts.html"> <i class="bi bi-circle"></i><span>ApexCharts</span> </a></li>
                                                                                                    <li> <a href="charts-echarts.html"> <i class="bi bi-circle"></i><span>ECharts</span> </a></li>
                                                                                                </ul>
                                                                                            </li>
                                                                                            <li class="nav-item">
                                                                                                <a class="nav-link collapsed" data-bs-target="#icons-nav" data-bs-toggle="collapse" href="#"> <i class="bi bi-gem"></i><span>Icons</span><i class="bi bi-chevron-down ms-auto"></i> </a>
                                                                                                <ul id="icons-nav" class="nav-content collapse " data-bs-parent="#sidebar-nav">
                                                                                                    <li> <a href="icons-bootstrap.html"> <i class="bi bi-circle"></i><span>Bootstrap Icons</span> </a></li>
                                                                                                    <li> <a href="icons-remix.html"> <i class="bi bi-circle"></i><span>Remix Icons</span> </a></li>
                                                                                                    <li> <a href="icons-boxicons.html"> <i class="bi bi-circle"></i><span>Boxicons</span> </a></li>
                                                                                                </ul>
                                                                                            </li>
                                                                                            <li class="nav-heading">Pages</li>
                                                                                            <li class="nav-item"> <a class="nav-link collapsed" href="users-profile.html"> <i class="bi bi-person"></i> <span>Profile</span> </a></li>
                                                                                            <li class="nav-item"> <a class="nav-link collapsed" href="pages-faq.html"> <i class="bi bi-question-circle"></i> <span>F.A.Q</span> </a></li>
                                                                                            <li class="nav-item"> <a class="nav-link collapsed" href="pages-contact.html"> <i class="bi bi-envelope"></i> <span>Contact</span> </a></li>
                                                                                            <li class="nav-item"> <a class="nav-link collapsed" href="pages-register.html"> <i class="bi bi-card-list"></i> <span>Register</span> </a></li>
                                                                                            <li class="nav-item"> <a class="nav-link collapsed" href="pages-login.html"> <i class="bi bi-box-arrow-in-right"></i> <span>Login</span> </a></li>
                                                                                            <li class="nav-item"> <a class="nav-link collapsed" href="pages-error-404.html"> <i class="bi bi-dash-circle"></i> <span>Error 404</span> </a></li>
                                                                                            <li class="nav-item"> <a class="nav-link collapsed" href="pages-blank.html"> <i class="bi bi-file-earmark"></i> <span>Blank</span> </a></li>
                                                                                        </ul>
                                                                                    </aside>
                                                                                </body>
                                                                                </html>

list\_user.html

<!DOCTYPE html>
    <html lang="en">
        <head>
            <meta charset="utf-8">
            <meta content="width=device-width, initial-scale=1.0" name="viewport">
            <title>Dashboard - Admin Bootstrap Template</title>
            <meta name="robots" content="noindex, nofollow">
            <meta content="" name="description">
            <meta content="" name="keywords">
            <link href="/assets/img/favicon.png" rel="icon">
            <link href="/assets/img/apple-touch-icon.png" rel="apple-touch-icon">
            <link href="/assets/css/bootstrap.min.css" rel="stylesheet">
            <link href="/assets/css/bootstrap-icons.css" rel="stylesheet">
            <link href="/assets/css/boxicons.min.css" rel="stylesheet">
            <link href="/assets/css/quill.snow.css" rel="stylesheet">
            <link href="/assets/css/quill.bubble.css" rel="stylesheet">
            <link href="/assets/css/remixicon.css" rel="stylesheet">
            <link href="/assets/css/simple-datatables.css" rel="stylesheet">
            <link href="/assets/css/style.css" rel="stylesheet">
        </head>
        <body>
            <header id="header" class="header fixed-top d-flex align-items-center" th:replace="fragments/header :: header">
            </header>
            <aside id="sidebar" class="sidebar" th:replace="fragments/sidebar :: sidebar">
            </aside>
            <main id="main" class="main">
                <div class="pagetitle">
                    <nav>
                        <ol class="breadcrumb">
                            <li class="breadcrumb-item"><a href="index.html">主页</a></li>
                            <li class="breadcrumb-item active">用户管理</li>
                        </ol>
                    </nav>
                </div>
                <section class="section dashboard">
                    <div class="row">
                        <div class="col-lg-12">
                            <div class="card">
                                <div class="card-body">
    
                                    <br/>
                                    <br/>
                                    <div class="table-title">
                                        <div class="row">
                                            <div class="col-sm-6">
                                                <h2> <b>用户管理</b></h2>
                                            </div>
                                            <div class="col-sm-6">
                                                <div sec:authorize="hasAnyAuthority('permission_create')">
                                                    <a href="/user/new" class="btn btn-success" ><i class="bi bi-person-plus" data-toggle="tooltip" title="添加用户"></i></a>
                                                    
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <table class="table table-striped table-hover">
                                        <thead >
                                            <tr>
                                                <th>ID</th>
                                                <th>User Name</th>
                                                <th>E-mail</th>
                                                <th>Name</th>
                                                <th>Home Page</th>
                                                <th>Roles</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <tr th:each="user: ${listUsers}">
                                                <td th:text="${user.id}">User ID</td>
                                                <td th:text="${user.username}">User Name</td>
                                                <td th:text="${user.email}">E-mail</td>
                                                <td th:text="${user.name}">Name</td>
                                                <td th:text="${user.homepage}">Home Page</td>
                                                <td th:text="${user.roles}">Roles</td>
                                                <td>
                                                    <a sec:authorize="hasAuthority('user_edit')" th:href="@{'/user/edit/' + ${user.id}}" class="edit" ><i class="bi bi-pencil" data-toggle="tooltip" title="编辑"></i></a>
                                                    <a sec:authorize="hasAuthority('user_edit')" th:href="@{'/user/resetpassword/' + ${user.id}}" class="reset" ><i class="bi bi-key" data-toggle="tooltip" title="重置密码"></i></a>
                                                    <a sec:authorize="hasAuthority('user_delete')" th:href="@{'/user/delete/' + ${user.id}}" class="delete" ><i class="bi bi-trash" data-toggle="tooltip" title="删除"></i></a>
    
    
                                                </td>
                                            </tr>
                                        </tbody>
                                    </table>
    
    
    
                                </div>
                            </div>
                        </div>
                </section>
            </main>
            <footer id="footer" class="footer" th:replace="fragments/footer :: footer">
                <div class="copyright"> © Copyright <strong><span>Compnay Name</span></strong>. All Rights Reserved</div>
                <div class="credits"> with love <a href="https://freeetemplates.com/">FreeeTemplates</a></div>
            </footer>
            <a href="#" class="back-to-top d-flex align-items-center justify-content-center"><i class="bi bi-arrow-up-short"></i></a>
            <script src="/assets/js/apexcharts.min.js"></script>
            <script src="/assets/js/bootstrap.bundle.min.js"></script>
            <script src="/assets/js/chart.min.js"></script>
            <script src="/assets/js/echarts.min.js"></script>
            <script src="/assets/js/quill.min.js"></script>
            <script src="/assets/js/simple-datatables.js"></script>
            <script src="/assets/js/tinymce.min.js"></script>
            <script src="/assets/js/validate.js"></script>
            <script src="/assets/js/main.js"></script>
    
        </body>
    </html>

#### ![cfe2d017c72a4075af48f30910ab52af.png][] ####

![3e5e39ec24b842e09bcd43bdf0a5025a.png][]

![1f037128d2ff4b5fa42bd23b98a100d3.png][]

![feba64830d2b481cae7c5cb74296c964.png][]

![27fcec3c20ec4f5ab0a45c31b0b1fa01.png][]

![c17810b9a62342a9a9e2a9fe873f71e7.png][]

![918b302ead2947e6b1bd031f5730574f.png][]

![34dc9956d9b143bf9564022527f8a648.png][]

![b90d81b3d97f4ebbaf7738ba74798f94.png][]

![5073bb835602440cbb92b33b147f8e16.png][]

![ceda6c27e9f1423da171c9f646a66ad7.png][]

历史密码保存和重用检测

package com.example;
    
    import java.util.Date;
    import java.util.List;
    import java.util.Set;
    import javax.validation.Valid;
    import org.apache.commons.text.similarity.LevenshteinDistance;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.*;
    
    import org.springframework.security.authentication.AuthenticationManager;
    import org.springframework.security.core.Authentication;
    import org.springframework.security.core.context.SecurityContextHolder;
    import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder;
    import org.springframework.ui.Model;
    import org.springframework.validation.BindingResult;
    import org.springframework.web.servlet.ModelAndView;
    
    @Controller
    
    public class UserController {
    
        @Autowired
        private UserService userService;
    
        @Autowired
        private UserRepository userRepository;
    
        @Autowired
        private BCryptPasswordEncoder bCryptPasswordEncoder;
    
        /**
         * 注入身份认证管理器
         */
        @Autowired
        private AuthenticationManager authenticationManager;
    
        @GetMapping("/user/new")
        public String showRegistrationForm(Model model) {
            model.addAttribute("user", new UserDTO());
    
            return "user/new_user";
        }
    
        @GetMapping("/user")
        public String listUsers(Model model) {
            List<User> listUsers = userRepository.findAll();
            model.addAttribute("listUsers", listUsers);
    
            return "user/list_user";
        }
    
        @GetMapping("/user/edit/{id}")
        public String editUser(@PathVariable("id") Integer id, Model model) {
            User user = userService.get(id);
            List<Role> listRoles = userService.listRoles();
            model.addAttribute("user", user);
            model.addAttribute("listRoles", listRoles);
            return "user/edit_user";
        }
    
        @PostMapping("/user/save")
        public String saveUser(@Valid @ModelAttribute("user") UserDTO user, BindingResult bindingResult) {
            if (bindingResult.hasErrors()) {
                return "user/new_user";
            }
            userService.saveUser(user);
    
            return "redirect:/user";
        }
    
        @PostMapping("/user/update")
        public String updateUser(User user) {
            User repoUser = userRepository.findById(user.getId()).orElse(null);
            repoUser.setUsername(user.getUsername());
            repoUser.setEmail(user.getEmail());
            repoUser.setName(user.getName());
            repoUser.setEnabled(user.isEnabled());
            repoUser.setAccountNonLocked(user.isAccountNonLocked());
            repoUser.setHomepage(user.getHomepage());
            repoUser.setRoles(user.getRoles());
            userRepository.save(repoUser);
    
            return "redirect:/user";
        }
    
        @GetMapping("/user/resetpassword/{id}")
        public String showResetPasswordForm(@PathVariable("id") Integer id, Model model) {
            User user = userRepository.findById(id).orElse(null);
            UserResetPasswordDTO userResetPasswordDTO = new UserResetPasswordDTO();
            userResetPasswordDTO.setId(user.getId());
            userResetPasswordDTO.setUsername(user.getUsername());
            model.addAttribute("user", userResetPasswordDTO);
            return "user/reset_password";
        }
    
        @PostMapping("/user/savepassword")
        public String savePassword(@Valid @ModelAttribute("user") UserResetPasswordDTO user, BindingResult bindingResult) {
            if (bindingResult.hasErrors()) {
                return "user/reset_password";
            }
            User repoUser = userRepository.findById(user.getId()).orElse(null);
    
            repoUser.setPassword(bCryptPasswordEncoder.encode(user.getPassword()));
            Date passwordChangedTime = new Date();
    
            repoUser.setPasswordChangedTime(passwordChangedTime);
            userRepository.save(repoUser);
    
            return "redirect:/user";
        }
    
        @RequestMapping("/user/delete/{id}")
        public String deleteUser(@PathVariable(name = "id") Integer id) {
            userRepository.deleteById(id);
    
            return "redirect:/user";
        }
    
    //    @RequestMapping(value = "user/info", method = RequestMethod.GET)
    //    public ModelAndView userProfile() {
    //        ModelAndView modelAndView = new ModelAndView();
    //        Authentication auth = SecurityContextHolder.getContext().getAuthentication();
    //        System.out.println(auth.getName());
    //        User user = userRepository.getByUsername(auth.getName());
    //        modelAndView.addObject("user", user);
    //        modelAndView.addObject("userName", user.getUsername());
    //        modelAndView.setViewName("user-profile");
    //        return modelAndView;
    //    }
        @GetMapping("user/info")
        public String userProfile(Model model) {
    
            Authentication auth = SecurityContextHolder.getContext().getAuthentication();
            System.out.println(auth.getName());
            User user = userRepository.getByUsername(auth.getName());
            model.addAttribute("user", user);
    
            return "user/user_profile";
        }
    
    //    @RequestMapping(value = "/change/password", method = RequestMethod.GET)
    //    public ModelAndView changePassword() {
    //        ModelAndView modelAndView = new ModelAndView();
    //        modelAndView.addObject("userDTO", new UserChangePasswordDTO());
    //        modelAndView.setViewName("password-update");
    //        return modelAndView;
    //    }
        @GetMapping("/change/password")
    
        public String changePassword(Model model) {
    
            model.addAttribute("userDTO", new UserChangePasswordDTO());
            return "user/password_update";
    
        }
    
    //    @RequestMapping(value = "/new/password", method = RequestMethod.POST)
    //    public ModelAndView newPassword(@Valid @ModelAttribute("userDTO") UserChangePasswordDTO userChangePasswordDTO, BindingResult bindingResult) {
    //        if (bindingResult.hasErrors()) {
    //            ModelAndView modelAndView = new ModelAndView();
    //            modelAndView.addObject("userDTO", new UserChangePasswordDTO());
    //            modelAndView.setViewName("password-update");
    //            return modelAndView;
    //        }
    //        ModelAndView modelAndView = new ModelAndView();
    //        Authentication auth = SecurityContextHolder.getContext().getAuthentication();
    //
    //        if (userChangePasswordDTO.getNewPass().equals(userChangePasswordDTO.getConfirmPass())) {
    //            User user = userService.findUserByUsername(auth.getName());
    //            Boolean status = userService.isPasswordValid(userChangePasswordDTO.getPassword(), user.getPassword());
    //            if (status == true) {
    //
    //                userService.changePassword(user, userChangePasswordDTO);
    //                modelAndView.setViewName("login");
    //            } else {
    //                modelAndView.addObject("wrongPass", "Current possword was wrong..!");
    //                modelAndView.setViewName("password-update");
    //            }
    //
    //        } else {
    //            modelAndView.addObject("passMatched", "Password doesn't matched..!");
    //            modelAndView.setViewName("password-update");
    //        }
    //        return modelAndView;
    //    }
        @PostMapping("/new/password")
        public String
                newPassword(@Valid @ModelAttribute("userDTO") UserChangePasswordDTO userChangePasswordDTO, BindingResult bindingResult, Model model) {
            if (bindingResult.hasErrors()) {
                return "user/password_update";
    
            }
    
            Authentication auth = SecurityContextHolder.getContext().getAuthentication();
    
            if (userChangePasswordDTO.getNewPass().equals(userChangePasswordDTO.getConfirmPass())) {
                User user = userService.findUserByUsername(auth.getName());
                Boolean status = userService.isPasswordValid(userChangePasswordDTO.getPassword(), user.getPassword());
    
                if (status == true) {
    
                    LevenshteinDistance levenshteinWithThreshold = new LevenshteinDistance(3);
                    // Returns -1 since the actual distance, 4, is higher than the threshold
                    System.out.println("Levenshtein distance: " + levenshteinWithThreshold.apply(userChangePasswordDTO.getNewPass(), userChangePasswordDTO.getPassword()));
                    if (levenshteinWithThreshold.apply(userChangePasswordDTO.getNewPass(), userChangePasswordDTO.getPassword()) == -1) {
                        Set<History> setHistorysCheck = user.getHistorys();
                        Boolean check = true;
                        for (History hist : setHistorysCheck) {
                            System.out.print(hist.getPassword());
                            if (bCryptPasswordEncoder.matches(userChangePasswordDTO.getNewPass(), hist.getPassword())) {
                                check = false;
                                break;
                            }
                        }
    
                        if (check == true) {
    
                            System.out.println(user.getHistorys());
                            History history = new History();
                            System.out.println("userChangePasswordDTO.getNewPass()=" + userChangePasswordDTO.getNewPass());
                            history.setPassword(bCryptPasswordEncoder.encode(userChangePasswordDTO.getNewPass()));
                            System.out.println(history);
                            Set<History> setHistorys = user.getHistorys();
                            setHistorys.add(history);
                            user.setHistorys(setHistorys);
                            System.out.println(user.getHistorys());
                            userService.changePassword(user, userChangePasswordDTO);
                            return "login";
                        } else {
                            model.addAttribute("passMatched", "New password was same as history..!");
                            return "user/password_update";
                        }
                    } else {
                        model.addAttribute("passMatched", "New password need 4 diff wtih Current password..!");
                        return "user/password_update";
                    }
                } else {
    
                    model.addAttribute("wrongPass", "Current password was wrong..!");
                    return "user/password_update";
                }
    
            } else {
                model.addAttribute("passMatched", "Password doesn't matched..!");
                return "user/password_update";
            }
    
        }
    
    }

![f0eb420977b34ea9a8a0130102c66df0.png][]

#### ![78bf66ae669746109f11a07fefea2ac1.png][] ####

#### **结论：** ####

到目前为止，您已经学会了使用基于表单的身份验证和数据库内凭据来保护Spring Boot应用程序。您会看到 Spring 安全性使实现登录和注销功能变得非常容易，并且非常方便。为方便起见，您可以下载下面的示例项目。

下载源码：

[https://github.com/allwaysoft/ProductManagerMaximumSessionsCaptchaNew][https_github.com_allwaysoft_ProductManagerMaximumSessionsCaptchaNew]

[Link 1]: https://codejava.net/frameworks/spring-boot/spring-boot-crud-example-with-spring-mvc-spring-data-jpa-thymeleaf-hibernate-mysql
[9e54206fd5a34c668d74b3311dc0cd21.png]: https://img-blog.csdnimg.cn/9e54206fd5a34c668d74b3311dc0cd21.png
[74d9c55b07d845dc8916c07636499a6f.png]: https://img-blog.csdnimg.cn/74d9c55b07d845dc8916c07636499a6f.png
[9c13c64d951a401ca43d5fdfbffadab8.png]: https://img-blog.csdnimg.cn/9c13c64d951a401ca43d5fdfbffadab8.png
[Bootstrap 5 Free Admin Dashboard Template 1 - freeetemplates]: https://freeetemplates.com/bootstrap-5-free-admin-dashboard-template-1/
[cfe2d017c72a4075af48f30910ab52af.png]: https://img-blog.csdnimg.cn/cfe2d017c72a4075af48f30910ab52af.png
[3e5e39ec24b842e09bcd43bdf0a5025a.png]: https://img-blog.csdnimg.cn/3e5e39ec24b842e09bcd43bdf0a5025a.png
[1f037128d2ff4b5fa42bd23b98a100d3.png]: https://img-blog.csdnimg.cn/1f037128d2ff4b5fa42bd23b98a100d3.png
[feba64830d2b481cae7c5cb74296c964.png]: https://img-blog.csdnimg.cn/feba64830d2b481cae7c5cb74296c964.png
[27fcec3c20ec4f5ab0a45c31b0b1fa01.png]: https://img-blog.csdnimg.cn/27fcec3c20ec4f5ab0a45c31b0b1fa01.png
[c17810b9a62342a9a9e2a9fe873f71e7.png]: https://img-blog.csdnimg.cn/c17810b9a62342a9a9e2a9fe873f71e7.png
[918b302ead2947e6b1bd031f5730574f.png]: https://img-blog.csdnimg.cn/918b302ead2947e6b1bd031f5730574f.png
[34dc9956d9b143bf9564022527f8a648.png]: https://img-blog.csdnimg.cn/34dc9956d9b143bf9564022527f8a648.png
[b90d81b3d97f4ebbaf7738ba74798f94.png]: https://img-blog.csdnimg.cn/b90d81b3d97f4ebbaf7738ba74798f94.png
[5073bb835602440cbb92b33b147f8e16.png]: https://img-blog.csdnimg.cn/5073bb835602440cbb92b33b147f8e16.png
[ceda6c27e9f1423da171c9f646a66ad7.png]: https://img-blog.csdnimg.cn/ceda6c27e9f1423da171c9f646a66ad7.png
[f0eb420977b34ea9a8a0130102c66df0.png]: https://img-blog.csdnimg.cn/f0eb420977b34ea9a8a0130102c66df0.png
[78bf66ae669746109f11a07fefea2ac1.png]: https://img-blog.csdnimg.cn/78bf66ae669746109f11a07fefea2ac1.png
[https_github.com_allwaysoft_ProductManagerMaximumSessionsCaptchaNew]: https://github.com/allwaysoft/ProductManagerMaximumSessionsCaptchaNew