本文参考或摘录自：http://haohaoxuexi.iteye.com/blog/2157769

本文使用Spring Security自带的方式连接数据库对用户进行认证。

1、Spring Security 默认的表脚本：

/*

Navicat MySQL Data Transfer

Source Server         : localhost

Source Server Version : 50621

Source Host           : localhost:3306

Source Database       : security

Target Server Type    : MYSQL

Target Server Version : 50621

File Encoding         : 65001

Date: 2014-12-10 15:49:04

*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for authorities

-- ----------------------------

DROP TABLE IF EXISTS `authorities`;

CREATE TABLE `authorities` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `username` varchar(20) DEFAULT NULL,

  `authority` varchar(50) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------

-- Table structure for groups

-- ----------------------------

DROP TABLE IF EXISTS `groups`;

CREATE TABLE `groups` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `groupName` varchar(50) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------

-- Table structure for group_authorities

-- ----------------------------

DROP TABLE IF EXISTS `group_authorities`;

CREATE TABLE `group_authorities` (

  `group_Id` int(11) NOT NULL AUTO_INCREMENT,

  `authority` varchar(50) DEFAULT NULL,

  PRIMARY KEY (`group_Id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------

-- Table structure for group_members

-- ----------------------------

DROP TABLE IF EXISTS `group_members`;

CREATE TABLE `group_members` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `userName` varchar(20) DEFAULT NULL,

  `group_Id` int(11) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------

-- Table structure for users

-- ----------------------------

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (

  `id` int(8) NOT NULL AUTO_INCREMENT,

  `userName` varchar(20) DEFAULT NULL,

  `password` varchar(50) DEFAULT NULL,

  `enabled` tinyint(4) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

2、web.xml配置

<?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"

         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"

         version="3.1">

    <filter>

        <filter-name>springSecurityFilterChain</filter-name>

        <filter-class>org.springframework.web.filter.DelegatingFilterProxy</filter-class>

    </filter>

    <filter-mapping>

        <filter-name>springSecurityFilterChain</filter-name>

        <url-pattern>/*</url-pattern>

    </filter-mapping>

    <context-param>

        <param-name>contextConfigLocation</param-name>

        <param-value>/WEB-INF/applicationContext.xml,/WEB-INF/dispatcher-servlet.xml,/WEB-INF/spring-security.xml</param-value>

    </context-param>

    <context-param>

        <param-name>log4jConfigLocation</param-name>

        <param-value>/WEB-INF/log4j.properties</param-value>

    </context-param>

    <context-param>

        <param-name>log4jRefreshInterval</param-name>

        <param-value>60000</param-value>

    </context-param>

    <listener>

        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

    </listener>

    <listener>

        <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>

    </listener>

    <servlet>

        <servlet-name>dispatcher</servlet-name>

        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

        <load-on-startup>1</load-on-startup>

    </servlet>

    <servlet-mapping>

        <servlet-name>dispatcher</servlet-name>

        <url-pattern>/</url-pattern>

    </servlet-mapping>

</web-app>

2、spring-security配置：

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

       xmlns:security="http://www.springframework.org/schema/security"

       xsi:schemaLocation="http://www.springframework.org/schema/beans

       http://www.springframework.org/schema/beans/spring-beans.xsd

       http://www.springframework.org/schema/security

       http://www.springframework.org/schema/security/spring-security.xsd">

    <security:http auto-config="true">

        <security:intercept-url pattern="/**" access="ROLE_USER"></security:intercept-url>

    </security:http>

    <security:authentication-manager>

        <security:authentication-provider user-service-ref="userDetailsService">

            <security:password-encoder hash="md5"></security:password-encoder>

        </security:authentication-provider>

    </security:authentication-manager>

    <bean id="userDetailsService" class="org.springframework.security.core.userdetails.jdbc.JdbcDaoImpl">

        <property name="dataSource" ref="dataSource"/>   --指定数据源

        <property name="enableGroups" value="true"/>

    </bean>

</beans>

说明：<security:authentication-provider ref="myAuthenticationProvider"/>是指使用实现了自己的AuthenticationProvider

<security:authentication-provider user-service-ref="userDetailsService">是指定使用的UserDetailsService

3、数据源配置：

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">

    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">

        <property name="driverClass" value="com.mysql.jdbc.Driver"></property>

        <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/security"></property>

        <property name="user" value="root"></property>

        <property name="password" value="root"></property>

        <property name="acquireIncrement" value="5"></property>  <!-- 当连接池中的连接用完时，C3P0一次性创建新连接的数目2 -->

        <property name="initialPoolSize" value="10"></property>  <!-- 初始化时创建的连接数，必须在minPoolSize和maxPoolSize之间 -->

        <property name="minPoolSize" value="5"></property>

        <property name="maxPoolSize" value="20"></property>

        <!-- 最大空闲时间，超过空闲时间的连接将被丢弃

        [需要注意：mysql默认的连接时长为8小时(28800）【可在my.ini中添加 wait_timeout=30(单位秒)设置连接超时】,这里设置c3p0的超时必须<28800]

        -->

        <property name="maxIdleTime" value="300"></property>

        <property name="idleConnectionTestPeriod" value="60"></property> <!-- 每60秒检查连接池中的空闲连接 -->

        <property name="maxStatements" value="20"></property>  <!-- jdbc的标准参数  用以控制数据源内加载的PreparedStatement数量，但由于预缓存的Statement属 于单个Connection而不是整个连接 -->

    </bean>

</beans>

最新文章

  1. String StringBuffer StringBuilder
  2. JavaACOFramework的各个类介绍(part1 : Ant类)
  3. Varnish安装使用（初学）
  4. jmeter随笔（1）-在csv中数据为json格式的数据不完整
  5. VoHelper
  6. Android canvas rotate():平移旋转坐标系至任意原点任意角度-------附：android反三角函数小结
  7. oracle sql语句中使用if逻辑
  8. 用EnableMenuItem不能使菜单变灰的原因
  9. Java自学手记——集合
  10. tf.variable和tf.get_Variable以及tf.name_scope和tf.variable_scope的区别
  11. Python+Selenium+PIL+Tesseract真正自动识别验证码进行一键登录
  12. Android View的重绘过程之Measure
  13. pycharm中连接数据库常见问题
  14. python 爬虫简化树状图
  15. QT在Linux下的安装
  16. Git总结笔记
  17. Pytorch中的Batch Normalization操作
  18. django安装命令
  19. shell参数代表什么,如何调试shell？
  20. YAML(摘录)

热门文章

  1. Python + Selenium + AutoIt 模拟键盘实现另存为、上传、下载操作详解
  2. Get package name
  3. TFT LCD显示原理详解
  4. python魔法方法-单目运算及一般算数运算
  5. 安装android studio&amp;flutter
  6. 5210: 最大连通子块和 动态DP 树链剖分
  7. C#用WebBrowser与WIN API辅助模拟获取网站完整Cookie
  8. Core Animation学习总结
  9. [Canvas]Bombman v1.00
  10. install pymongo,mysql