jasig-本地环境搭建二-使用数据库连接

欢迎加入jasig讨论群:149898322

1.参考官方URL:https://wiki.jasig.org/display/CASUM/Using+JDBC+for+Authentication

2.打开cas项目下的/WEB-INF/deployerConfigContext.xml

A.beans 一个元素添加

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
  <property name="driverClassName">
    <value>com.mysql.jdbc.Driver</value>
  </property>
  <property name="url">
    <value>jdbc:mysql://localhost:3306/jasig</value>
  </property>
  <property name="username"><value>root</value></property>
  <property name="password"><value>root</value></property>
 </bean>

 

B:注释掉primaryAuthenticationHandler元素

C:<bean id="SearchModeSearchDatabaseAuthenticationHandler" class="org.jasig.cas.adaptors.jdbc.SearchModeSearchDatabaseAuthenticationHandler">
  <property name="tableUsers"><value>usertable</value></property>
  <property name="fieldUser"><value>username</value></property>
  <property name="fieldPassword"><value>userpwd</value></property>
  <property name="dataSource" ref="dataSource"/>
 </bean>
 <bean class="org.jasig.cas.adaptors.jdbc.QueryDatabaseAuthenticationHandler">
   <property name="dataSource" ref="dataSource" />
   <property name="sql" value="select userpwd from usertable where lower(username) = lower(?)" />
 </bean>

D:把authenticationManager 下的primaryAuthenticationHandler 改成 SearchModeSearchDatabaseAuthenticationHandler

 

3.最后把下面包copy到项目lib

commons-pool-1.5.3.jar commons-dbcp-1.4.jar cas-server-support-jdbc-4.0.0.jar(官方自带有)

 

启动项目就可以了,使用第二的项目就可以测试