import java.sql.*;
import java.util.*;



public class Verzeichniss {

	public static void main(String[] args) {

		String dbUrl = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)} ;DBQ=h:/Eigene Dateien/Microsoft Office/Access/SQL-Test.mdb";
		int zahl = 0;
		try	{

			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection conn = DriverManager.getConnection( dbUrl, "login", "password");
			System.out.println("Connected");
			Statement stmt = conn.createStatement();
			stmt = conn.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE );
			String sqlQuery = "SELECT Title, UId, FolderId FROM dbo_Entries";
			ResultSet rSet = stmt.executeQuery( sqlQuery );
			ResultSet rSetKopie = rSet;

			String Title = null, UID = null, FolderID = null;
			String tmp= null;
			int zaehler = 0;

			rSet.last();
			int rows = rSet.getRow();
			rSet.beforeFirst();

			String[] verz = new String[rows];
			System.out.println("\nHier bin ich: " + rows);

			while ( rSet.next() ){
				try	{

					verz[zaehler] = getueberOrdner(rSet.getString(3), rSetKopie) + rSet.getString(1);
					zaehler++;


				}
				catch (Exception e) {


				}
			}

			rSet.close();
            stmt.close();
			conn.close();
		}
		catch (Exception e)	{

			e.printStackTrace();
		}
	}
}


static String getueberOrdner(String FolderID, ResultSet rSet)	{
	if ( FolderID == "") {
		while ( rSet.next() )	{
			if ( rSet.getBytes(2).equals(FolderID))
				return ( getueberOrdner()+ "/" + rSet.getString(1));
		}
	}
	return ("");
}