java.lang.ClassNotFoundException:net.ucanaccess.jdbc.ucanaccessDriver

问题描述

我是Java的初学者，并使用控制台来编译和运行我的程序.我正在尝试使用ucanaccess驱动程序从MS Access .accdb文件读取数据.由于我已经将5个ucanaccess文件添加到C:\ Program Files \ Java \ jdk1.8.0_60 \ jre \ lib \ ext，但是仍然出现异常java.lang.ClassNotFoundException:net.ucanaccess.jdbc.ucanaccessDriver.这是我的代码.

I'm beginner with java and using console to compile and run my programs. I'm trying to read data from MS Access .accdb file with ucanaccess driver. As i have added 5 ucanaccess files to C:\Program Files\Java\jdk1.8.0_60\jre\lib\ext, but still getting Exception java.lang.ClassNotFoundException:net.ucanaccess.jdbc.ucanaccessDriver.Here is my code.

import java.sql.*;
public class jdbcTest
{
    public static void main(String[] args)
    {
        try
        {
            Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
            String url = "jdbc:ucanaccess://C:javawork/PersonInfoDB/PersonInfo.accdb";
            Connection conctn = DriverManager.getConnection(url);
            Statement statmnt = conctn.createStatement();
            String sql = "SELECT * FROM person";
            ResultSet rsltSet = statmnt.executeQuery(sql);
            while(rsltSet.next())
            {
                String name = rsltSet.getString("name-");
                String address = rsltSet.getString("address");
                String phoneNum = rsltSet.getString("phoneNumber");

                System.out.println(name + " " + address + " " + phoneNum);
            }
            conctn.close();
        }
        catch(Exception sqlExcptn)
        {
            System.out.println(sqlExcptn);
        }
    }
}

推荐答案

请将JDBC驱动程序jar添加到lib文件夹中.下载URL 下载jar

Please add JDBC driver jar to lib folder.Download URL download jar

这篇关于java.lang.ClassNotFoundException:net.ucanaccess.jdbc.ucanaccessDriver的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！