我的ORACLE8I数据库安装在SOLIAS上，我如何用JAVA语句直接连接到数据库

[xpxxp]

我的ORACLE8I数据库安装在SOLIAS上，我如何用JAVA语句直接连接到数据库

[ddtqfly]

用oracle8i 自带的jdbc(classes11.zip)

首先，必须设置classpath=.;d:\lib\classes1.2.zip;%classpath%
其次：
String driverClassName=” oracle.jdbc.driver.OracleDriver”;
String URL = “jdbc:oracle:thin:@172.16.58.160:1521:orc1”
String user =”test2”;
String password =”test2”;
try { //注册数据库驱动
Driver driver = (Driver)
Class.forName(driverClassName).newInstance();
DriverManager.registerDriver(driver);
drivers.addElement(driver);
log("Registered JDBC driver " + driverClassName);
}
catch (Exception e) {
log("Can't register JDBC driver: " +
driverClassName + ", Exception: " + e);
}

try { //创建连接
if (user == null) {
con = DriverManager.getConnection(URL);
}
else {
con = DriverManager.getConnection(URL,user,password);
}
log("Created a new connection in pool " + name);
}
catch (SQLException e) {
log(e, "Can't create a new connection for " + URL);
return null;
}

[ddtqfly]

补：
String URL = “jdbc:oracle:thin:@172.16.58.160:1521:orc1”
中172.16.58.160 用Oracle 所在服务器地址代替
1521 伟端口号
orc1 为连接串

[yanchang]

通过jdbc如下：
private String driver="oracle.jdbc.driver.OracleDriver";
private String url="jdbc:oracle:thin:@192.168.0.1:1521:orcl";
private String user="scott";
private String password="tiger";

try
{
Class.forName(driver);}
catch (Exception e)
{System.out.println(""+e);}

try {
if (conn==null)
{
conn=DriverManager.getConnection(url, user, password);}
} catch (Exception e) { System.out.println(""+e);}

不用jdbc的我不会