getldap.java

jdbcldap,用sql语句的方式操作ldap

/*
 * TestSQL.java
 *
 * Created on May 23, 2002, 12:07 PM
 */
import com.octetstring.jdbcLdap.sql.statements.JdbcLdapSelect;
import com.octetstring.jdbcLdap.jndi.*;
import com.octetstring.jdbcLdap.sql.*;
import com.octetstring.jdbcLdap.sql.statements.*;
import java.sql.*;
import javax.naming.directory.*;
/**
 *
 * @author  pjh, OctetString, Inc (c)2002
 */
public class getLdap {

	/** Creates a new instance of Test */
	public static void main(String[] args) throws Exception {
		System.out.println("Welcome to the JDBC LDAP Demo Application.");
		//JndiLdapConnection con;
		boolean doInsert;
		boolean doDelete;
		boolean doDeleteMulti;

		Class.forName("com.octetstring.jdbcLdap.sql.JdbcLdapDriver");

		// ldapConnString should be of the form...
		//  jdbc:ldap://host[:port]/base dn
		String ldapConnectString =
			//"jdbc:ldap://218.108.250.154:389/o=hzcnc.com?SEARCH_SCOPE:=subTreeScope";
			"jdbc:ldap://218.108.250.185:8889/?SEARCH_SCOPE:=subTreeScope";
		java.sql.Connection con;

		con =
			DriverManager.getConnection(
				ldapConnectString,
				"cn=Manager",
				"onewaveinc");
		System.out.println("Connection established");
                try {
			System.out.println("Test query by sn...");
			Statement stmt = con.createStatement();
			ResultSet rs =
				stmt.executeQuery(
					"SELECT * FROM t=user,s=freemail,o=hzcnc.com,c=CN");
			System.out.println("Query result rows = " + rs.getFetchSize());
			boolean valuesPrinted = false;
			while (rs.next()) {
				valuesPrinted = true;
				// Note, but, getString is case sensitive.  
				// DN must be uppercase, rest are lowercase
				/*
				System.out.println(
					"DN="
						+ rs.getString("DN")
						+ ", status="
						+ rs.getString("status")
						+ ", cn="
						+ rs.getString("cn")
						+ ", serviceCode="
				                + rs.getString("serviceCode")
						+ ", userPassword="
						+ rs.getString("userPassword"));
			        */	
				 System.out.println("UID=" + rs.getString("UID"));
				//System.out.println(rs.getString("DN") + rs.getString("profile"));
			}
			if (!valuesPrinted)
				System.out.println("Query returned no results.");
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

}