1个回答

我要回答

• 

  牛叔叔 2020-11-14 17:55

  package com.wanmait.util;
  
  import net.ucanaccess.converters.Metadata;
  
  import java.sql.*;
  
  public class Test {
      @org.junit.Test
      public void test(){
          try {
              Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
              String accessDb = "D:/wanmait.com/demo.mdb";
              String dbURL = "jdbc:ucanaccess://"+accessDb;
              Connection conn = DriverManager.getConnection(dbURL);
              System.out.println(conn);
              DatabaseMetaData metadata = conn.getMetaData();
              ResultSet tables = metadata.getTables(null,null,"%",null);
              while(tables.next()){
                  System.out.println(tables.getString(3));
              }
              tables.close();
              conn.close();
          }
          catch (Exception e){
              e.printStackTrace();
          }
  
  
      }
  }

  
  

  回复 0条回复 0

  点击查看更多留言