web development helpdesk

The DBUtil library from Apache provides a set of class for doing a variety of standard database tasks.

eg. To make a query becomes as simple as the following, providing the result set as a List of arrays where each list elements contains a row.

QueryRunner runner = new QueryRunner();
ArrayListHandler handler = new ArrayListHandler();
List<Object[]> result = runner.query(connection,
    "SELECT * FROM MyTable WHERE name=?", handler, "Joe Smith");
DbUtils.close(conn); 

written by objects \\ tags: apache, jdbc DBUtil, list, query, ResultSet

To use anonymous access for an LDAP search or query set the value of Context.SECURITY_AUTHENTICATION to “none” in the environment used to create the initial context.

Hashtable env = new Hashtable();
env.put(Context.INITIAL_CONTEXT_FACTORY, 
    "com.sun.jndi.ldap.LdapCtxFactory");
env.put(Context.PROVIDER_URL, providerUrl);

// Use 'none' for anonymous access
env.put(Context.SECURITY_AUTHENTICATION, "none");

// Create the initial context
DirContext ctx = new InitialDirContext(env);

written by objects \\ tags: authentication, ldap, query, search

You need to build it manually from the ServletRequest.

StringBuilder sb = new StringBuilder("?");
for (Enumeration e = request.getParameterNames(); 
   e.hasMoreElements();)
{
      String param = (String) e.nextElement();
      sb.append(param)
        .append("=")
        .append(request.getParameter(param))
        .append("&");
}
String queryString = sb.toString().
   substring(0, sb.length() - 1); 

written by objects \\ tags: post, query, request