Spring Security连接数据库查询实例

最新推荐文章于 2024-10-18 10:41:41 发布

iteye_20557

最新推荐文章于 2024-10-18 10:41:41 发布

阅读量408

点赞数

分类专栏： [随笔分类]j2ee 文章标签： Security Spring Bean 配置管理 MySQL

[随笔分类]j2ee 专栏收录该内容

21 篇文章

订阅专栏

经过若干天断断续续地研究,终于做出了第一个spring security的实例，真是艰难啊，配置太复杂了，若干个Bean之间存在着这样或那样的关系......

下面给出我的小例子，主要是配置文件拉~~别的东西自己看源码吧！

Code
<?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-2.0.xsd">

 <bean id="filterChainProxy"
 class="org.springframework.security.util.FilterChainProxy">
 <property name="filterInvocationDefinitionSource">
 <value><![CDATA[
 CONVERT_URL_TO_LOWERCASE_BEFORE_COMPARISON
 PATTERN_TYPE_APACHE_ANT
 /**=httpSessionIntegrationFilter,authenticationProcessingFilter,exceptionTranslationFilter,filterSecurityInterceptor]]>
 </value>
 </property>
 </bean>
 
 <bean id="httpSessionIntegrationFilter"
 class="org.springframework.security.context.HttpSessionContextIntegrationFilter" />
 
 <bean id="authenticationEntryPoint"
 class="org.springframework.security.ui.webapp.AuthenticationProcessingFilterEntryPoint">
 <property name="loginFormUrl" value="/index.jsp" />
 <property name="forceHttps" value="true" />
 </bean>
 
 <bean id="authenticationProcessingFilter"
 class="org.springframework.security.ui.webapp.AuthenticationProcessingFilter">
 
 <property name="filterProcessesUrl"
 value="/j_spring_security_check" />
 
 <property name="authenticationFailureUrl"
 value="/index.jsp?error=1" />
 
 <property name="defaultTargetUrl"
 value="/security/security.jsp" />
 
 <property name="authenticationManager"
 ref="authenticationManager" />
 </bean>
 
 <bean id="exceptionTranslationFilter"
 class="org.springframework.security.ui.ExceptionTranslationFilter">
 
 <property name="authenticationEntryPoint"
 ref="authenticationEntryPoint" />
 
 <property name="accessDeniedHandler" ref="accessDeniedHandler" />
 </bean>
 
 <bean id="accessDeniedHandler"
 class="org.springframework.security.ui.AccessDeniedHandlerImpl">
 <property name="errorPage" value="/error.jsp" />
 </bean>
 
 <bean id="filterSecurityInterceptor"
 class="org.springframework.security.intercept.web.FilterSecurityInterceptor">
 
 <property name="authenticationManager"
 ref="authenticationManager" />
 
 <property name="accessDecisionManager"
 ref="accessDecisionManager" />
 
 <property name="objectDefinitionSource">
 
 <value><![CDATA[
 CONVERT_URL_TO_LOWERCASE_BEFORE_COMPARISON
 PATTERN_TYPE_APACHE_ANT
 /security/security.jsp=ROLE_ADMIN]]>
 </value>
 </property>
 </bean>
 
 <bean id="authenticationManager"
 class="org.springframework.security.providers.ProviderManager">
 <property name="providers">
 <list>
 
 <ref local="daoAuthenticationProvider" />
 </list>
 </property>
 </bean>
 
 <bean id="accessDecisionManager"
 class="org.springframework.security.vote.AffirmativeBased">
 
 <property name="allowIfAllAbstainDecisions">
 <value>false</value>
 </property>
 
 <property name="decisionVoters">
 <list>
 <bean class="org.springframework.security.vote.RoleVoter">
 
 <property name="rolePrefix" value="ROLE_" />
 </bean>
 <bean class="org.springframework.security.vote.AuthenticatedVoter" />
 </list>
 </property>
 </bean>
 
 <bean id="daoAuthenticationProvider"
 class="org.springframework.security.providers.dao.DaoAuthenticationProvider">
 
 <property name="userDetailsService">
 <ref local="jdbcDaoImpl" />
 </property>
 </bean>
 <bean id="jdbcDaoImpl"
 class="org.springframework.security.userdetails.jdbc.JdbcDaoImpl">
 
 <property name="usersByUsernameQuery">
 <value>
 select username,password,enabled from user where
 username=?
 </value>
 </property>
 
 <property name="authoritiesByUsernameQuery">
 <value>
 select username,authority from authentication where
 username=?
 </value>
 </property>
 
 <property name="dataSource">
 <ref local="dataSource" />
 </property>
 </bean>
 <bean id="dataSource"
 class="org.apache.commons.dbcp.BasicDataSource">
 <property name="driverClassName"
 value="org.gjt.mm.mysql.Driver">
 </property>
 <property name="url" value="jdbc:mysql://localhost:3306/user">
 </property>
 <property name="username" value="root"></property>
 <property name="password" value="hicc"></property>
 </bean>
</beans>

这个是最简单的一个例子，配了141行，呼~~继续研究其深入功能，离成功越来越近了

ps.传说spring security2.0有了超级简单的配置方法，还没有学到手，努力ing

源码下载（需要自己添加spring和mysql的jar包）