需要在cas单点登陆里添加除用户名外的更多属性。
在deployerConfigContext.xml中添加,注意
这句中第一个username是cas源码里写死了的,所以不能改。
class="org.jasig.cas.authentication.principal.PersonDirectoryPrincipalResolver">
class="org.jasig.services.persondir.support.jdbc.SingleRowJdbcPersonAttributeDao">
value="SELECT user_name,
GROUP_CONCAT(CASE WHEN (appcode='500') THEN login_name END) AS '500'
FROM user_map WHERE {0} GROUP BY user_name" />
还有一点要注意的是
SingleRowJdbcPersonAttributeDao这个类cas源码里是没有的,要引用下面的包
org.jasig.service.persondir
person-directory-impl
${person.directory.version}
commons-logging
commons-logging
${person.directory.version}设成1.5.2这个貌似是最新的版本,好些年没更新了的样子。
然后这个类返回是写死了的只返回头一行,所以如果想要返回多行的结果的话,像我们这样,就不行要改代码。
它另有一个类叫MultiRowJdbcPersonAttributeDAO,指的是多行sql的,不是返回多行
所以最后写了一行sql把列转成行名。如下
SELECT user_name,
GROUP_CONCAT(CASE WHEN (appcode='500') THEN login_name END) AS '500',
GROUP_CONCAT(CASE WHEN (appcode='600') THEN login_name END) AS '600',
GROUP_CONCAT(CASE WHEN (appcode='009') THEN login_name END) AS '009',
GROUP_CONCAT(CASE WHEN (appcode='010') THEN login_name END) AS '010',
GROUP_CONCAT(CASE WHEN (appcode='011') THEN login_name END) AS '011',
GROUP_CONCAT(CASE WHEN (appcode='700') THEN login_name END) AS '700',
GROUP_CONCAT(CASE WHEN (appcode='800') THEN login_name END) AS '800'
FROM user_map WHERE user_name='xxx' GROUP BY user_name
这里面写用值做列名的那行是固定的,如果不固定的话可以这么写
SET @ee='';
SELECT @ee:=CONCAT(@ee,'GROUP_CONCAT(CASE WHEN (appcode=\'',appcode,'\') THEN login_name END) AS \'',appcode,'\',') FROM (SELECT DISTINCT appcode FROM user_map WHERE user_name='cbb') a;
SELECT LEFT(@ee,LENGTH(@ee)-1);
SET @qq=CONCAT('select user_name,',LEFT (@ee,LENGTH(@ee)-1),' from user_map WHERE user_name=\'cbb\' GROUP BY user_name');
SELECT @qq;
PREPARE stmt2 FROM @QQ;
EXECUTE stmt2;