小编典典

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

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("ID\tName\t\t\tAge\tMatches");

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();

}

}

}

}

2020-10-09