LDAP分頁和排序

1、命令方式對查詢進行排序D:utrustsysteminstalledOpenLDAP>ldapsearch -x -h localhost -D "uid=admin,ou=person,ou=utrust,dc=chinautrust,dc=com" -b "ou=person,ou=utrust,dc=chinautrust,dc=com" -w "admin" -S "uidaleph"LDAP分頁和排序(JDK自帶)import com.sun.jndi.ldap.ctl.VirtualListVie

2、wControl;import java.io.IOException;import java.util.Hashtable;import javax.naming.Context;import javax.naming.NamingEnumeration;import javax.naming.NamingException;import javax.naming.directory.SearchControls;import javax.naming.directory.SearchResult;import javax.naming.ldap.Control;import javax.n

3、aming.ldap.HasControls;import javax.naming.ldap.InitialLdapContext;import javax.naming.ldap.LdapContext;import javax.naming.ldap.SortControl;public class SortLDAP public static void main(String args) throws NamingException, IOException Hashtable m_env = new Hashtable(5, 0.75f); m_env.put(Context.INI

4、TIAL_CONTEXT_FACTORY, "com.sun.jndi.ldap.LdapCtxFactory"); /m_env.put("java.naming.ldap.version", "3"); m_env.put(Context.PROVIDER_URL, "ldap:/11:389"); m_env.put(Context.SECURITY_AUTHENTICATION, "simple"); m_env.put(Context.SECURITY_PRINC

5、IPAL, "cn=Directory Manager"); m_env.put(Context.SECURITY_CREDENTIALS, "password12345"); / Open an LDAP association LdapContext ctx = new InitialLdapContext(m_env, null); / Activate sorting String sortKey = "uid" int beforeCount = 0; int afterCount = 0; int nTargetOffse

6、t = 0; int nPageSize = 5; VirtualListViewControl vctl = new VirtualListViewControl(nTargetOffset, beforeCount, afterCount, nPageSize, Control.CRITICAL); ctx.setRequestControls(new Controlnew SortControl(sortKey, Control.CRITICAL),vctl); String retAtt = "uid" SearchControls constraints = ne

7、w SearchControls(); constraints.setSearchScope(SearchControls.SUBTREE_SCOPE); constraints.setReturningAttributes(retAtt); / ctx.setRequestControls(new Controlnew PagedResultsControl(2); / Perform a search NamingEnumeration results = ctx.search("ou=person,ou=utrust,dc=chinautrust,dc=com", &

8、quot;(objectclass=*)", constraints); / Iterate over search results while (results != null && results.hasMore() / Display an entry SearchResult entry = (SearchResult) results.next(); System.out.println(entry.getAttributes(); / Handle the entry's response controls (if any) if (entry i

9、nstanceof HasControls) / (HasControls)entry).getControls(); / Close the LDAP association ctx.close(); LDAP數(shù)據(jù)排序(netscape包)import netscape.ldap.LDAPCompareAttrNames;import netscape.ldap.LDAPConnection;import netscape.ldap.LDAPEntry;import netscape.ldap.LDAPException;import netscape.ldap.LDAPReferralEx

10、ception;import netscape.ldap.LDAPSearchResults;import netscape.ldap.util.ConnectionPool;public class LdapUtils private static final String HOST = "localhost" private static final int PORT = 389; private static final int MIN_CONN_SIZE = 1; private static final int MAX_CONN_SIZE = 5; private

11、 static final String USER_ID = "cn=Manager,dc=chinautrust,dc=com" private static final String PASSWORD = "password12345" private static ConnectionPool connPool; static try connPool = new ConnectionPool(MIN_CONN_SIZE, MAX_CONN_SIZE, HOST, PORT); catch (LDAPException e) String mess

12、age = "Failed to init Ldap connection pool" System.out.println(message); public static ConnectionPool getConnectionPool() return LdapUtils.connPool; public static LDAPConnection getConnection() LDAPConnection conn = LdapUtils.getConnectionPool().getConnection(); try conn.authenticate(USER_

13、ID, PASSWORD); catch (LDAPException e) String message = "Failed to authen the system ldap user" System.out.println(message); return conn; public static void closeConnection(LDAPConnection conn) LdapUtils.getConnectionPool().close(conn); public static void main(String args) throws Exception

14、 LDAPConnection con = LdapUtils.getConnection(); String ATTRS = "uidaleph" LDAPSearchResults res = con.search("ou=person,ou=utrust,dc=chinautrust,dc=com",LDAPConnection.SCOPE_SUB,"uid=*",ATTRS,false); LDAPCompareAttrNames compareAttrNames = new LDAPCompareAttrNames(&quo

15、t;uidaleph", true); res.sort(compareAttrNames); while (res.hasMoreElements() try / Next directory entry LDAPEntry entry = res.next(); System.out.println(entry); catch (LDAPReferralException e) / Ignore referrals continue; catch (LDAPException e) System.out.println(e.toString(); continue; System.out.println("-"); 總結1、PagedResultsControl分頁處理即ctx.setRequestControls(new Controlnew SortControl(sortK