PL/SQL拼接生成LDAP必要语句
完整SQL/语句,自行参考修改即可
----------------------------------
参考一:
select
'dn: uid='||gh||',ou=teacher,dc=sys,dc=com
objectClass: uidObject
objectClass: account
objectClass: top
objectClass: simpleSecurityObject
uid: '||gh||'
userPassword: '||substr(sfzjh,-6)||'
&'
from 表名
参考二:
select
'dn: uid='||xh||',ou=bj'||szbh||',ou=nj'||sznj||',dc=sys,dc=com
objectClass: uidObject
objectClass: account
objectClass: top
objectClass: simpleSecurityObject
uid: '||xh||'
userPassword: '||substr(sfzjh,-6)||'
&'
from 表名
参考三:
select
'dn: ou=bj'||szbh||',ou=nj'||sznj||',dc=sys,dc=com
objectClass: top
objectClass: organizationalUnit
&'
from 表名
筛选参考四:
select distinct a.szbh,a.sznj,a.xh,b.sfzjh
from xjjbsjzlb a
left join xsjbsjzlb b on a.xh=b.xh
where a.xsdqztm=1 and a.szbh is not null and a.sznj is not null and a.sznj>=2014
order by a.szbh
注:粗体根据自己情况修改
导入命令:
ldapadd -x -D "cn=Manager,dc=test,dc=com" -W -f test0413.ldif