小人用j2sdk1.4.2_15,oracle版本是8i,设置了D:\j2sdk1.4.2_15\lib;D:\j2sdk1.4.2_15\lib\ojdbc14.jar
程序如下:
import java.io.*;
import java.sql.*;
import oracle.jdbc.driver.*;public class TestOracle
{
public void main(String [] args)
{
try
{ //加载一个Oracle驱动
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
//使用OCI8连接到数据库
conn=DriverManager.getConnection(
"jdbc:oracle:oci8:@(DESCRIPTION ="+
"(ADDRESS_LIST ="+
"(ADDRESS = (PROTOCOL = TCP)(HOST = 134.202.22.6)(PORT = 1521)))"+
"(CONNECT_DATA ="+
"(SERVICE_NAME = lzjf)",
"lzjf",
"ptt2004d");
return 1;
}
catch(SQLException e) //捕捉SQL违例
{ System.out.println("Ora8iConnect在连接oracle8数据库时捕获");
while (e!=null)
{ System.out.println("SQLState:"+e.getSQLState());
System.out.println("Message :"+e.getMessage());
System.out.println("Vendor :"+e.getErrorCode());
e=e.getNextException();
System.out.println(" ");
}
conn=null;
return 0;
} }
}
编译提示‘oracle.jdbc.driver包不存在’,小人实在是没辙了,各位大大指点一下吧
程序如下:
import java.io.*;
import java.sql.*;
import oracle.jdbc.driver.*;public class TestOracle
{
public void main(String [] args)
{
try
{ //加载一个Oracle驱动
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
//使用OCI8连接到数据库
conn=DriverManager.getConnection(
"jdbc:oracle:oci8:@(DESCRIPTION ="+
"(ADDRESS_LIST ="+
"(ADDRESS = (PROTOCOL = TCP)(HOST = 134.202.22.6)(PORT = 1521)))"+
"(CONNECT_DATA ="+
"(SERVICE_NAME = lzjf)",
"lzjf",
"ptt2004d");
return 1;
}
catch(SQLException e) //捕捉SQL违例
{ System.out.println("Ora8iConnect在连接oracle8数据库时捕获");
while (e!=null)
{ System.out.println("SQLState:"+e.getSQLState());
System.out.println("Message :"+e.getMessage());
System.out.println("Vendor :"+e.getErrorCode());
e=e.getNextException();
System.out.println(" ");
}
conn=null;
return 0;
} }
}
编译提示‘oracle.jdbc.driver包不存在’,小人实在是没辙了,各位大大指点一下吧
jdbc应该是很简单的东西,就那点套路。。
把它解压开是否存在oracle.jdbc.driver这样的目录层次结构
如果不是,那么确认里面的Driver的路径
替换你的oracle.jdbc.driver路径
或者更换jar包