Subversion Repositories bacoAlunos

package openldap.impl;


import jomm.utils.DiacriticFilter;
import netscape.ldap.LDAPConnection;
import netscape.ldap.LDAPException;
import openldap.ILdapManager;
import openldap.LdapProperties;
import org.apache.log4j.Logger;

import java.sql.*;
import java.util.HashMap;
import java.util.List;
import java.util.Iterator;

/**
 * Created by IntelliJ IDEA.
 * User: User
 * Date: 9/Abr/2005
 * Time: 12:04:08
 * To change this template use File | Settings | File Templates.
 */
public class LdapManager implements ILdapManager{

    private static final 1.5.0/docs/api/java/util/logging/Logger.html">Logger logger = 1.5.0/docs/api/java/util/logging/Logger.html">Logger.getLogger(LdapManager.class);

    private static final 1.5.0/docs/api/java/lang/String.html">String host =LdapProperties.getProperty("ldap.host");
    private static final int port =LdapProperties.getIntProperty("ldap.port");
    private static final 1.5.0/docs/api/java/lang/String.html">String baseQueries =LdapProperties.getProperty("ldap.base.queries");
    private static final 1.5.0/docs/api/java/lang/String.html">String login =LdapProperties.getProperty("ldap.queries.login");
    private static final 1.5.0/docs/api/java/lang/String.html">String password =LdapProperties.getProperty("ldap.queries.password");
    private static final 1.5.0/docs/api/java/lang/String.html">String userField =LdapProperties.getProperty("ldap.username.field");
    private static final 1.5.0/docs/api/java/lang/String.html">String dnField =LdapProperties.getProperty("ldap.dn.field");


    public boolean login(1.5.0/docs/api/java/lang/String.html">String user, 1.5.0/docs/api/java/lang/String.html">String password) {
        return authenticate(user,password);
    }

    public 1.5.0/docs/api/java/util/HashMap.html">HashMap getUserInfo(1.5.0/docs/api/java/lang/String.html">String username) {
        1.5.0/docs/api/java/sql/Connection.html">Connection con = null;
        1.5.0/docs/api/java/util/HashMap.html">HashMap result = null;
        try {
            con = getConnection();
            5+0%2Fdocs%2Fapi+Statement">Statement stmt = con.createStatement();
            1.5.0/docs/api/java/sql/ResultSet.html">ResultSet rs = stmt.executeQuery("SELECT * FROM " + baseQueries + " where " + userField + "=" + username);
            if(rs.next()) {
                result = new 1.5.0/docs/api/java/util/HashMap.html">HashMap();
                5+0%2Fdocs%2Fapi+List">List propertyValues = LdapProperties.getListValuesProperties("ldap.map");
                1.5.0/docs/api/java/util/Iterator.html">Iterator iter = propertyValues.iterator();
                while (iter.hasNext()) {
                    1.5.0/docs/api/java/lang/String.html">String propValue =  (1.5.0/docs/api/java/lang/String.html">String) iter.next();
                    result.put(propValue,rs.getString(propValue));
                }
            }
            stmt.close();
            con.close();

        } catch (1.5.0/docs/api/java/sql/SQLException.html">SQLException e) {
            e.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.
        } catch (1.5.0/docs/api/java/lang/ClassNotFoundException.html">ClassNotFoundException e) {
            e.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.
        }

        return result;
    }

    public 1.5.0/docs/api/java/sql/Connection.html">Connection getConnection() throws 1.5.0/docs/api/java/sql/SQLException.html">SQLException, 1.5.0/docs/api/java/lang/ClassNotFoundException.html">ClassNotFoundException {
        1.5.0/docs/api/java/lang/Class.html">Class.forName("com.octetstring.jdbcLdap.sql.JdbcLdapDriver");
                1.5.0/docs/api/java/lang/String.html">String ldapConnectString = "jdbc:ldap://" + host + ":" + port + "/" + baseQueries + "?SEARCH_SCOPE:=subTreeScope";
                java.sql.1.5.0/docs/api/java/sql/Connection.html">Connection con;
        con = 1.5.0/docs/api/java/sql/DriverManager.html">DriverManager.getConnection(ldapConnectString,login,password);
        return con;
    }
    public 1.5.0/docs/api/java/lang/String.html">String getDN(1.5.0/docs/api/java/lang/String.html">String username) throws 1.5.0/docs/api/java/lang/ClassNotFoundException.html">ClassNotFoundException, 1.5.0/docs/api/java/sql/SQLException.html">SQLException {

        1.5.0/docs/api/java/sql/Connection.html">Connection con = getConnection();
        1.5.0/docs/api/java/lang/String.html">String DN= null;
        5+0%2Fdocs%2Fapi+Statement">Statement stmt = con.createStatement();
        //" + dnField + "
        1.5.0/docs/api/java/sql/ResultSet.html">ResultSet rs = stmt.executeQuery("SELECT * FROM " + baseQueries + " where " + userField + "=" + username);
        //ResultSet rs = stmt.executeQuery("SELECT " + dnField + " FROM " + baseQueries + " where cn=" + username);
        if(rs.next()) {
            DN = rs.getString("DN");
        }
        stmt.close();
        con.close();
        return DN;
    }

    public boolean authenticate(1.5.0/docs/api/java/lang/String.html">String username,1.5.0/docs/api/java/lang/String.html">String password){
        try {
            1.5.0/docs/api/java/lang/String.html">String dn = getDN(username);
            if(dn == null)
                return false;

            LDAPConnection ld = new LDAPConnection();
                ld.connect( host, 389 );

                if (! ld.isConnected() ){
                logger.error("Cant connect to LDAP");
                    return false;
            }

            try {
                ld.authenticate(DiacriticFilter.clean(dn),password);
            } catch ( LDAPException e ) {
                1.5.0/docs/api/java/lang/System.html">System.out.println(e.toString());
                ld.disconnect();
                return false;
            } //catch

            if (ld.isAuthenticated()) {
                ld.disconnect();
                return true;
            } else {
                ld.disconnect();
                return false;
            }
        } catch (1.5.0/docs/api/java/lang/ClassNotFoundException.html">ClassNotFoundException e) {
            logger.error("Logging LDAP",e);
        } catch (1.5.0/docs/api/java/sql/SQLException.html">SQLException e) {
            logger.error("Logging LDAP",e);
        } catch (LDAPException e) {
            logger.error("Logging LDAP",e);
        }
        return false;
    }

   

}