Java使用UCanAccess連接配接mdb資料庫

話不多說，直接上代碼：

Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");

String url = UcanaccessDriver.URL_PREFIX + "F:\\db1.mdb;newDatabaseVersion=V2003";

Connection connection = DriverManager.getConnection(url, username, password);

Statement statement = connection.createStatement();

ResultSet result = statement.executeQuery("SELECT * FROM M_PERSON");

while (result.next()) {

    System.out.print(result.getString("PSNSN") + "\t");

    System.out.print(result.getString("CORPSN") + "\t");

    System.out.print(result.getString("IDCARD") + "\t");

    System.out.print(result.getString("SSN") + "\t");

    System.out.print(result.getString("NAME") + "\t");

    System.out.print(result.getString("SEX") + "\t");

    System.out.println();

}

注：如果是在linux下連接配接，需要設定檔案的操作執行權限。