如何将Java连接到MS Access数据库

您可以使用ucanacess.jar连接Aceess女士数据库

在此处显示一些示例http://www.benchresources.net/jdbc-msaccess-database-connection-
steps-in-java-8/

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class MsAccessDatabaseConnectionInJava8 {    public static void main(String[] args) {        // variables        Connection connection = null;        Statement statement = null;        ResultSet resultSet = null;        // Step 1: Loading or registering Oracle JDBC driver class        try { Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");        }        catch(ClassNotFoundException cnfex) { System.out.println("Problem in loading or "         + "registering MS Access JDBC driver"); cnfex.printStackTrace();        }        // Step 2: Opening database connection        try { String msAccDB = "D:/WORKSPACE/TEST_WORKSPACE/Java-JDBC/Player.accdb"; String dbURL = "jdbc:ucanaccess://" + msAccDB; // Step 2.A: Create and get connection using DriverManager class connection = DriverManager.getConnection(dbURL); // Step 2.B: Creating JDBC Statement  statement = connection.createStatement(); // Step 2.C: Executing SQL & retrieve data into ResultSet resultSet = statement.executeQuery("SELECt * FROM PLAYER"); System.out.println("IDtNametttAgetMatches"); System.out.println("==t================t===t======="); // processing returned data and printing into console while(resultSet.next()) {     System.out.println(resultSet.getInt(1) + "t" +   resultSet.getString(2) + "t" +   resultSet.getString(3) + "t" +  resultSet.getString(4)); }        }        catch(SQLException sqlex){ sqlex.printStackTrace();        }        finally { // Step 3: Closing database connection try {     if(null != connection) {         // cleanup resources, once after processing         resultSet.close();         statement.close();         // and then finally close connection         connection.close();     } } catch (SQLException sqlex) {     sqlex.printStackTrace(); }        }    }}