各位大哥问下Spring-acegi怎么做单点登录啊?
我用Spring-acegi做了一个权限系统,用的是标签来判断是不是有权限 如下,可是另外个系统单点登录时候怎么办呢?系统怎么把相应权限取出来? <bean id="jdbcDaoImpl" class="org.acegisecurity.userdetails.jdbc.JdbcDaoImpl">
<property name="dataSource"><ref bean="dataSource"/></property>
<property name="usersByUsernameQuery">
<value>SELECT USER_LOGINNAME,USER_PASSWORD,ENABLED FROM T_SYS_USER WHERE upper(USER_LOGINNAME)=upper(?)</value>
</property>
<property name="authoritiesByUsernameQuery">
<value>
SELECT DISTINCT T_SYS_USER.USER_LOGINNAME ,T_SYS_RESOURCE.RESOURCE_CODE
FROM T_SYS_USER LEFT OUTER JOIN T_SYS_ROLE ON T_SYS_USER.USER_ROLEID = T_SYS_ROLE.ROLE_ID
LEFT OUTER JOIN T_SYS_ROLE_RESOURCE ON T_SYS_ROLE_RESOURCE.ROLE_ID = T_SYS_ROLE.ROLE_ID
LEFT OUTER JOIN T_SYS_RESOURCE ON T_SYS_RESOURCE.RESOURCE_ID = T_SYS_ROLE_RESOURCE.RESOURCE_ID
WHERE upper(USER_LOGINNAME) = upper(?)
</value>
</property>
</bean>
我用Spring-acegi做了一个权限系统,用的是标签来判断是不是有权限 如下,可是另外个系统单点登录时候怎么办呢?系统怎么把相应权限取出来? <bean id="jdbcDaoImpl" class="org.acegisecurity.userdetails.jdbc.JdbcDaoImpl">
<property name="dataSource"><ref bean="dataSource"/></property>
<property name="usersByUsernameQuery">
<value>SELECT USER_LOGINNAME,USER_PASSWORD,ENABLED FROM T_SYS_USER WHERE upper(USER_LOGINNAME)=upper(?)</value>
</property>
<property name="authoritiesByUsernameQuery">
<value>
SELECT DISTINCT T_SYS_USER.USER_LOGINNAME ,T_SYS_RESOURCE.RESOURCE_CODE
FROM T_SYS_USER LEFT OUTER JOIN T_SYS_ROLE ON T_SYS_USER.USER_ROLEID = T_SYS_ROLE.ROLE_ID
LEFT OUTER JOIN T_SYS_ROLE_RESOURCE ON T_SYS_ROLE_RESOURCE.ROLE_ID = T_SYS_ROLE.ROLE_ID
LEFT OUTER JOIN T_SYS_RESOURCE ON T_SYS_RESOURCE.RESOURCE_ID = T_SYS_ROLE_RESOURCE.RESOURCE_ID
WHERE upper(USER_LOGINNAME) = upper(?)
</value>
</property>
</bean>
acegi是权限控制的哦