/**
* Retorna una colección Par_LdapTO
*
* @param parameters Hashtable - parametros para la consulta
* @throws PersistenciaException - capa de persistencia
* @return Collection - resultado Par_Ldap
*/
public java.util.Collection<Object> getPar_Ldap(Hashtable<String, Object> parameters)
throws PersistenciaException {
PreparedStatement stm = null;
ResultSet rs = null;
Connection connection = null;
Collection<Object> result = new ArrayList<Object>();
Par_LdapTO Par_LdapTO = new Par_LdapTO();
Par_LdapTO Par_LdapCollTO = null;
StringBuffer sqlString = new StringBuffer();
int posicion = 1;
try {
sqlString.append(" SELECT ldap_id ");
sqlString.append(" ,ldap_ip ");
sqlString.append(" ,ldap_puerto ");
sqlString.append(" ,ldap_basedn ");
sqlString.append(" ,ldap_usuario ");
sqlString.append(" ,ldap_administrador");
sqlString.append(" ,ldap_password ");
sqlString.append(" FROM siga_parametros.Par_Ldap ");
sqlString.append(" WHERE 1=1 ");
adicionarCondiciones(sqlString, Par_LdapTO, parameters);
connection = super.getConnection(this.objDataSession);
stm = connection.prepareStatement(sqlString.toString());
System.out.println("sql string" + sqlString.toString());
rs = stm.executeQuery();
while (rs.next()) {
Par_LdapCollTO = new Par_LdapTO();
Par_LdapCollTO.setPosicion(posicion++);
poblarTO(rs, Par_LdapCollTO);
result.add(Par_LdapCollTO);
}
} catch (SQLException e) {
e.printStackTrace();
throw new PersistenciaException("Error en getPar_LdapDAO.getPar_Ldap: ", e);
} finally {
super.cerrarConexiones(connection, stm, rs, this.objDataSession);
}
return result;
}
