Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 ("");
- }
Add Comment
Please, Sign In to add comment