首页 > 数据库技术 > 详细

【JDBC】Extra04 Mirosoft-Access-JDBC

时间:2020-09-29 15:58:54      阅读:45      评论:0      收藏:0      [点我收藏+]

MS没提供Jdbc驱动,有一个第三方的UcanAcess驱动包

<!-- https://mvnrepository.com/artifact/net.sf.ucanaccess/ucanaccess -->
<dependency>
    <groupId>net.sf.ucanaccess</groupId>
    <artifactId>ucanaccess</artifactId>
    <version>5.0.0</version>
</dependency>

连接单元测试:

    @Test
    public void connectionTest() throws Exception {
        Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
        final String microSoftAccessDataBaseLocation = "C:\\Users\\Administrator\\Documents\\sample.accdb";
        final String UcanAccessConnectUrl = "jdbc:ucanaccess://" + microSoftAccessDataBaseLocation;
        Connection connection = DriverManager.getConnection(UcanAccessConnectUrl);
        System.out.println(connection);
        connection.close();
    }

打印结果:

13:33:50.933 [main] DEBUG com.healthmarketscience.jackcess.Index - unsupported collating sort order SortOrder[2052(0)] for text index (Db=sample.accdb;Table=MSysObjects;Index=0), making read-only
13:33:50.950 [main] DEBUG com.healthmarketscience.jackcess.impl.DatabaseImpl - Could not find expected index on table MSysObjects (Db=sample.accdb)
13:33:50.968 [main] DEBUG com.healthmarketscience.jackcess.impl.DatabaseImpl - Finished reading system catalog.  Tables: [user] (Db=sample.accdb)
net.ucanaccess.jdbc.UcanaccessConnection@5b03b9fe[C:\Users\Administrator\Documents\sample.accdb]

 

【JDBC】Extra04 Mirosoft-Access-JDBC

原文:https://www.cnblogs.com/mindzone/p/13749238.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!