谁可以给我一个spring security的例子（连接数据库验证）

[xiaoao808]

小弟初学spring security，配置起来很是吃力，而且自带的例子都是读取属性文件验证，网上也没有很好的连接数据库验证的例子。不知哪位大哥可以给小弟发一个连接数据库验证的例子，感激不尽，我的邮箱是[e-mail],谢谢啦~

[shangzq]

配置：
applicationContext-security.xml如下
<?xml version="1.0" encoding="UTF-8"?>

<beans:beans xmlns="http://www.springframework.org/schema/security"
xmlns:beans="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.5.xsd
http://www.springframework.org/schema/security http://www.springframework.org/schema/security/spring-security-2.0.4.xsd">

<http auto-config="true">
<concurrent-session-control max-sessions="1" exception-if-maximum-exceeded="true" />

<intercept-url pattern="/" access="IS_AUTHENTICATED_ANONYMOUSLY"/>
<intercept-url pattern="/login.jsp" access="IS_AUTHENTICATED_ANONYMOUSLY"/>
<intercept-url pattern="/**" access="ROLE_USER"/>
<form-login login-page="/login.jsp" default-target-url="/index.jsp" authentication-failure-url="/login.jsp?login_error=1"/>
<logout logout-success-url="/login.jsp"/>
</http>
<authentication-provider>
<jdbc-user-service data-source-ref="dataSource"
users-by-username-query="SELECT username, password, enabled FROM sys_user where username=?"
authorities-by-username-query="SELECT username, authority from sys_roles WHERE username=?"/>

</authentication-provider>

<beans:bean id="loggerListener" class="org.springframework.security.event.authentication.LoggerListener"/>

</beans:beans>


web.xml 如下
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.5"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<context-param>
<param-name>javax.faces.CONFIG_FILES</param-name>
<param-value>/WEB-INF/config/faces-config.xml</param-value>
</context-param>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>
/WEB-INF/config/applicationContext.xml,
/WEB-INF/config/applicationContext-security.xml
</param-value>
</context-param>

<filter>
<filter-name>Spring character encoding filter</filter-name>
<filter-class>
org.springframework.web.filter.CharacterEncodingFilter
</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>Spring character encoding filter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>


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

<listener>
<listener-class>
org.springframework.security.ui.session.HttpSessionEventPublisher
</listener-class>
</listener>


<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>



<servlet>
<servlet-name>Faces Servlet</servlet-name>
<servlet-class>javax.faces.webapp.FacesServlet</servlet-class>
<load-on-startup>0</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>Faces Servlet</servlet-name>
<url-pattern>*.faces</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>login.jsp</welcome-file>
</welcome-file-list>
</web-app>


数据库，不必要的信息自己删除哟！

prompt PL/SQL Developer import file
prompt Created on 2008年10月22日 by Administrator
set feedback off
set define off
prompt Dropping PROJECT...
drop table PROJECT cascade constraints;
prompt Dropping SYS_PERMISSIONS...
drop table SYS_PERMISSIONS cascade constraints;
prompt Dropping SYS_RESOURCES...
drop table SYS_RESOURCES cascade constraints;
prompt Dropping SYS_ROLES...
drop table SYS_ROLES cascade constraints;
prompt Dropping SYS_USER...
drop table SYS_USER cascade constraints;
prompt Creating PROJECT...
create table PROJECT
(
PROID VARCHAR2(50) not null,
PRONAME VARCHAR2(100),
MANAGER VARCHAR2(10),
SIGNEDDATE DATE,
STARTDATE DATE,
STOPDATE DATE,
AMOUNT NUMBER(13,2),
BALANCE NUMBER(13,2),
STATE VARCHAR2(10)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table PROJECT
add constraint PK_PRO primary key (PROID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);

prompt Creating SYS_PERMISSIONS...
create table SYS_PERMISSIONS
(
ID VARCHAR2(50) not null,
NAME VARCHAR2(50),
DESCN VARCHAR2(50),
OPERATION VARCHAR2(50),
STATUS VARCHAR2(50)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);

prompt Creating SYS_RESOURCES...
create table SYS_RESOURCES
(
ID VARCHAR2(50) not null,
NAME VARCHAR2(50),
RES_TYPE VARCHAR2(50),
RES_STRING VARCHAR2(50),
DESCN VARCHAR2(50)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);

prompt Creating SYS_ROLES...
create table SYS_ROLES
(
USERNAME VARCHAR2(50) not null,
AUTHORITY VARCHAR2(100),
DESCN VARCHAR2(100)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);

prompt Creating SYS_USER...
create table SYS_USER
(
ID VARCHAR2(100) not null,
USERNAME VARCHAR2(50) not null,
PASSWORD VARCHAR2(100),
ENABLED VARCHAR2(10)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table SYS_USER
add constraint PK_USER primary key (ID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);

prompt Disabling triggers for PROJECT...
alter table PROJECT disable all triggers;
prompt Disabling triggers for SYS_PERMISSIONS...
alter table SYS_PERMISSIONS disable all triggers;
prompt Disabling triggers for SYS_RESOURCES...
alter table SYS_RESOURCES disable all triggers;
prompt Disabling triggers for SYS_ROLES...
alter table SYS_ROLES disable all triggers;
prompt Disabling triggers for SYS_USER...
alter table SYS_USER disable all triggers;
prompt Loading PROJECT...

commit;
prompt 13 records loaded
prompt Loading SYS_PERMISSIONS...
prompt Table is empty
prompt Loading SYS_RESOURCES...
prompt Table is empty
prompt Loading SYS_ROLES...
insert into SYS_ROLES (USERNAME, AUTHORITY, DESCN)
values ('admin', 'ROLE_USER', null);
commit;
prompt 1 records loaded
prompt Loading SYS_USER...
insert into SYS_USER (ID, USERNAME, PASSWORD, ENABLED)
values ('10001', 'admin', '/', '1');
commit;
prompt 1 records loaded
prompt Enabling triggers for PROJECT...
alter table PROJECT enable all triggers;
prompt Enabling triggers for SYS_PERMISSIONS...
alter table SYS_PERMISSIONS enable all triggers;
prompt Enabling triggers for SYS_RESOURCES...
alter table SYS_RESOURCES enable all triggers;
prompt Enabling triggers for SYS_ROLES...
alter table SYS_ROLES enable all triggers;
prompt Enabling triggers for SYS_USER...
alter table SYS_USER enable all triggers;
set feedback on
set define on
prompt Done.

[k10509806]

http://download.csdn.net/source/3283687