spring Security 3.1的配置2.docVIP

spring Security 3.1的配置Jar包就用下载的ss3.1里的包就可以。以下以mysql为例。 1.定义三个表：用u_user，权限表u_authority，用户权限表u_role。 CREATE DATABASE initlife CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `u_user` ( `us_name` VARCHAR(50) NOT NULL, `us_password` VARCHAR(50) NOT NULL, `us_enabled` TINYINT(1) NULL DEFAULT NULL, PRIMARY KEY (`us_name`), UNIQUE INDEX `u_name` (`us_name`) ) COLLATE=utf8_general_ci ENGINE=InnoDB; CREATE TABLE `u_authority` ( `au_authority` VARCHAR(50) NOT NULL, `au_name` VARCHAR(50) NULL DEFAULT NULL, PRIMARY KEY (`au_authority`), UNIQUE INDEX `au_authority` (`au_authority`) ) COLLATE=utf8_general_ci ENGINE=InnoDB; CREATE TABLE `u_role` ( `ro_usname` VARCHAR(50) NOT NULL, `ro_auauthority` VARCHAR(50) NULL DEFAULT NULL, INDEX `FK_u_role_u_user` (`ro_usname`), INDEX `FK_u_role_u_authority` (`ro_auauthority`), CONSTRAINT `FK_u_role_u_authority` FOREIGN KEY (`ro_auauthority`) REFERENCES `u_authority` (`au_authority`) ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT `FK_u_role_u_user` FOREIGN KEY (`ro_usname`) REFERENCES `u_user` (`us_name`) ON UPDATE CASCADE ON DELETE CASCADE ) COLLATE=utf8_general_ci ENGINE=InnoDB; 2.添加数据 INSERT INTO `u_authority` (`au_authority`, `au_name`) VALUES (ROLE_ADMIN, 管理员), (ROLE_GUESS, 访客), (ROLE_USER, 普通用户); INSERT INTO `u_role` (`ro_usname`, `ro_auauthority`) VALUES (user, ROLE_USER), (user, ROLE_GUESS), (admin, ROLE_ADMIN), (admin, ROLE_USER), (guest, ROLE_GUESS); INSERT INTO `u_user` (`us_name`, `us_password`, `us_enabled`) VALUES (admin, 21232f297a57a5a743894a0e4a801fc3, 1), (guest, 084e0343a0486ff05530df6c705c8bb4, 0), (user, ee11cbb19052e40b07aac0ca060c23ee, 1); 3.修改 applicationContext-security.xml ?xml version=1.0 encoding=UTF-8? beans:beans xmlns=/schema/security xmlns:beans=/schema/beans xmlns:xsi=/2001/XMLSchema-instance xsi:schemaLocation=/schema/beans /schema/beans/spring-beans-3.0.xsd /schema/security /schema/security/spring-security-3.1.xsd !-- 开启测试模式