Java8 连接Access数据库---UCanAccess

1、Java8 中JDK1.8中不再包含access桥接驱动，因此不再支持jdbcodbc桥接方式。

2、maven

<!--AccessDB 数据库  驱动--><dependency><groupId>net.sf.ucanaccess</groupId><artifactId>ucanaccess</artifactId><version>4.0.1</version></dependency>

import java.sql.*;public class AccessDBUtils {private static final String dbURL = "jdbc:ucanaccess://D:\\hyman.mdb";/** 加载驱动*/static {try {// Step 1: Loading or registering Oracle JDBC driver classClass.forName("net.ucanaccess.jdbc.UcanaccessDriver");} catch (ClassNotFoundException cnfex) {System.out.println("Problem in loading or registering MS Access JDBC driver");cnfex.printStackTrace();}}//建立连接public static Connection getConn() {try {// Step 2: Opening database connection// Step 2.A: Create and get connection using DriverManager classreturn DriverManager.getConnection(dbURL);} catch (Exception e) {System.out.println("AccessDB connection fail");e.printStackTrace();}return null;}// 关闭资源public static void close(Connection con, PreparedStatement ps, ResultSet rs) {try {if (rs != null)rs.close();// 这里出现异常了，rs关闭了吗？，如果没有怎么解决,ps , con也是一样的。} catch (SQLException e) {e.printStackTrace();} finally {try {if (ps != null)ps.close();} catch (SQLException e) {e.printStackTrace();} finally {if (con != null)try {con.close();} catch (Exception e) {e.printStackTrace();}}}}
}