Java SE
eclipes中java连oracle的问题
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区小弟刚开始学Java,刚把eclipse配好,用java连oracle的时候,报如下错误:
数据库驱动文件错误.ClassNotFoundException : oracle.jdbc.driver.OracleDriver
无法连接数据库.SQLException :No suitable driver
源程序如下:
可是在cmd窗口运行,就可以通过:
load Successful
Connnect Successfully
import java.sql.*;
//Establishing a Connection
public 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 Connection
public 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();
}
}
...全文
