小弟刚开始学Java,刚把eclipse配好,用java连oracle的时候,报如下错误:
数据库驱动文件错误.ClassNotFoundException : oracle.jdbc.driver.OracleDriver
无法连接数据库.SQLException :No suitable driver
源程序如下:可是在cmd窗口运行,就可以通过:
load Successful
Connnect Successfully
import java.sql.*;
//Establishing a Connectionpublic class ConnectDB {
String DBDriver = "oracle.jdbc.driver.OracleDriver";
Connection Conn = null;
ResultSet rs = null;
Statement stmt = null;
boolean result = false; //Loading Drivers
public ConnectDB(){
try{
Class.forName(DBDriver);
System.out.println("load Successful");
}
catch(ClassNotFoundException ex){
System.err.print("数据库驱动文件错误.ClassNotFoundException : ");
System.err.println(ex.getMessage());
}
}
//Making the Connection
public Connection getConnection(){
String Url = "jdbc:oracle:thin:@localhost:1521:orcl";
String UserName = "TEST_ADMIN";
String PassWord = "admin";
try{
Conn = DriverManager.getConnection(Url,UserName,PassWord);
System.out.println("Connnect Successfully")
}
catch(SQLException ex){
System.err.print("无法连接数据库:SQLException :");
System.err.println(ex.getMessage());
}
return Conn;
} public static void main(String[] args) {
ConnectDB c = new ConnectDB();
c.getConnection();
}}
数据库驱动文件错误.ClassNotFoundException : oracle.jdbc.driver.OracleDriver
无法连接数据库.SQLException :No suitable driver
源程序如下:可是在cmd窗口运行,就可以通过:
load Successful
Connnect Successfully
import java.sql.*;
//Establishing a Connectionpublic class ConnectDB {
String DBDriver = "oracle.jdbc.driver.OracleDriver";
Connection Conn = null;
ResultSet rs = null;
Statement stmt = null;
boolean result = false; //Loading Drivers
public ConnectDB(){
try{
Class.forName(DBDriver);
System.out.println("load Successful");
}
catch(ClassNotFoundException ex){
System.err.print("数据库驱动文件错误.ClassNotFoundException : ");
System.err.println(ex.getMessage());
}
}
//Making the Connection
public Connection getConnection(){
String Url = "jdbc:oracle:thin:@localhost:1521:orcl";
String UserName = "TEST_ADMIN";
String PassWord = "admin";
try{
Conn = DriverManager.getConnection(Url,UserName,PassWord);
System.out.println("Connnect Successfully")
}
catch(SQLException ex){
System.err.print("无法连接数据库:SQLException :");
System.err.println(ex.getMessage());
}
return Conn;
} public static void main(String[] args) {
ConnectDB c = new ConnectDB();
c.getConnection();
}}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货