我是java的初学者,使用控制台来编译和运行我的程序。我正在尝试用ucanaccess驱动程序从MS Access .accdb文件中读取数据。因为我已经在C:\Program java.lang.ClassNotFoundException:net.ucanaccess.jdbc.ucanaccessDriver.中添加了5个ucanaccess文件,但仍然收到异常Files\Java\jdk1.8.0_60\jre\lib\ext这是我的代码。
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);
}
}
}
发布于 2015-12-11 16:00:24
请将JDBC驱动程序jar添加到lib文件夹。下载URL download jar
https://stackoverflow.com/questions/34218552
复制相似问题