您可以使用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(); } } }}
