⚠ 注意:Java 8 起移除 sun.jdbc.odbc.JdbcOdbcDriver,僅供維護舊專案參考。
ReportDemo.mdb (Access 2003) 或 .accdb (Access 2007+)src/main/resources/data/MyAccessDSN,選擇資料庫檔案import java.sql.*;
public class AccessJdbcOdbc {
public static void main(String[] args) {
String url = "jdbc:odbc:MyAccessDSN"; // 使用系統 DSN
// 或無 DSN 連接字串 (需絕對路徑)
// String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:/path/ReportDemo.accdb;";
try (Connection conn = DriverManager.getConnection(url, "", "");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM Users")) {
while (rs.next()) {
System.out.println(rs.getInt("id") + " | " + rs.getString("name"));
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
<dependency>
<groupId>net.sf.ucanaccess</groupId>
<artifactId>ucanaccess</artifactId>
<version>5.0.2</version> <!-- 檢查最新版 -->
</dependency>
import java.sql.*;
import java.io.File;
public class AccessUCanAccess {
public static void main(String[] args) {
// 專案相對路徑
File dbFile = new File("src/main/resources/data/ReportDemo.accdb");
String url = "jdbc:ucanaccess://" + dbFile.getAbsolutePath();
try (Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM Users")) {
while (rs.next()) {
System.out.println(rs.getInt("id") + " | " + rs.getString("name"));
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
.accdb (Access 2007+)import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;
import javax.sql.DataSource;
public class AccessDataSource {
private static final DataSource DATA_SOURCE;
static {
HikariConfig config = new HikariConfig();
File dbFile = new File("src/main/resources/data/ReportDemo.accdb");
config.setJdbcUrl("jdbc:ucanaccess://" + dbFile.getAbsolutePath());
config.setMaximumPoolSize(5);
config.setConnectionTestQuery("SELECT 1");
DATA_SOURCE = new HikariDataSource(config);
}
public static Connection getConnection() throws SQLException {
return DATA_SOURCE.getConnection();
}
}
| 錯誤 | 原因 | 解決 |
|---|---|---|
No suitable driver found | 驅動未載入 / URL 格式錯誤 | 檢查 Maven 依賴、URL 協議 jdbc:ucanaccess:// |
File not found | 相對路徑錯誤 | 用 File.getAbsolutePath()、或置於 classpath 用 classpath:data/ReportDemo.accdb (UCanAccess 支援) |
鎖定錯誤 .laccdb | Access 開啟中 / 另一進程未關閉連接 | 關閉 Access、確保連接池正確關閉、啟用 ;ignoreCase=true |
| 中文亂碼 | 字符編碼不匹配 | URL 加 ;charset=UTF-8、資料庫欄位設為 Unicode 壓縮 |
Access 適合輕量級桌面/小型 Web,若專案增長建議遷移至:
Flyway / Liquibase 管理 Schema 版本