jdk1.8 读取 mdb 获取数据

引入

<dependency>
   <groupId>net.sf.ucanaccess</groupId>
   <artifactId>ucanaccess</artifactId>
   <version>4.0.4</version>
</dependency>

 

作为连接mdb数据库的类

 

 

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class AccessTest {

    public static void main(String[] args) throws Exception {
        Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");

        String mdbPath = "xxx.mdb";

        Connection conn = DriverManager.getConnection("jdbc:ucanaccess://" + mdbPath);

        Statement stmt = conn.createStatement();

        ResultSet rs = stmt.executeQuery("SELECT * FROM xx");

        while (rs.next()) {

            long id = rs.getLong("xx");
            String name = rs.getString("xx");

            System.out.println("-------------"+id +"---------"+name);
        }

        rs.close();


     

        stmt.close();
        conn.close();

    }


}