我正在学习jdbc,并通过编写这段简单的代码来使用Oracle数据库。我使用的IDE是MyEclips。但问题是,当我在命令提示符下编译和运行该程序时,它正常工作,但当我试图在IDE中编译和运行该程序时,即通过错误消息MyEclips它:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
import java.sql.*;
class OracleCon{
public static void main(String args[])
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = null;
String URL = "jdbc:oracle:thin:@localhost:1521:xe";
String UN = "HR";
String PASS = "12345";
con = DriverManager.getConnection(URL,UN,PASS);
Statement stmt = con.createStatement();
String sql = "SELECT * FROM EMPLOYEES";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next())
{
System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3));
}
}
catch (Exception e)
{
System.out.println(e);
}
}
}我还在环境变量.环境变量片段中设置了类路径。
发布于 2016-09-22 07:20:40
https://stackoverflow.com/questions/39632607
复制相似问题