连接access

最新推荐文章于 2022-09-22 19:55:53 发布

weixin_38696601

最新推荐文章于 2022-09-22 19:55:53 发布

阅读量205

点赞数

本文链接：https://blog.csdn.net/weixin_38696601/article/details/86998081

版权

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

       try {
           Connection con=null;
           Statement st=null;
           ResultSet rs=null;
          Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");

   // mdb 数据库路径
          con=DriverManager.getConnection("jdbc:ucanaccess://C:\\Users\\Administrator\\Desktop\\210782北镇市\\权属数据\\2107822018.mdb");
   st=con.createStatement();
   rs = st.executeQuery("SELECT * FROM CBDKXX");
   ResultSetMetaData data=rs.getMetaData();
   int i = 0;
   while (rs.next()) {
       i = i+1;
       System.out.println("sdsds"+rs.getString("DKBM"));
   }

   rs.close();
   st.close();
   con.close();
       } catch (SQLException e) {
           e.printStackTrace();
       } catch (ClassNotFoundException e) {
           e.printStackTrace();
       }