JAVA连接Oracle的代码

最新做了一个连接Oracle的代码，要配好环境变量：

ClassPath=.;E:\j2sdk14\lib\tools.jar;E:\oracle\ora90\jdbc\lib\classes12.zip

测试的电脑已经装好Oracle客户端，而且用SQLplus可以连接上。
/*

This sample shows how to list all the names from the EMP table
It uses the JDBC THIN driver. See the same program in the
oci8 samples directory to see how to use the other drivers.
*/

// You need to import the java.sql package to use JDBC
import java.sql.*;

class Test
{
public static void main (String args [])
throws SQLException
{
// Load the Oracle JDBC driver
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
/* try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(Exception e){
System.out.println("No Driver!");
}
/
// Connect to the database
// You must put a database name after the @ sign in the connection URL.
// You can use either the fully specified SQLnet syntax or a short cut
// syntax as

 1<host>:<port>:<sid>. The example uses the short cut syntax.   
 2String url = "jdbc:oracle:thin:@172.28.31.85:1521:YIKATONG";   
 3String userName = "scott";   
 4String password = "tiger"; 
 5
 6if (args.length &gt; 0) url = args[0];   
 7if (args.length &gt; 1) userName = args[1];   
 8if (args.length &gt; 2) password = args[2];   
 9System.out.println(url);   
10System.out.println(userName);   
11System.out.println(password);   
12Connection conn =   
13DriverManager.getConnection (url, userName, password); 
14
15// Create a Statement   
16Statement stmt = conn.createStatement (); 
17
18// Select the ENAME column from the EMP table   
19ResultSet rset = stmt.executeQuery ("select * from Test"); 
20
21// Iterate through the result and print the employee names   
22while (rset.next ())   
23System.out.println (rset.getString (1));   
24}   
25}</sid></port></host>