/**
 * JDBCTest.java
 * 编译脚本
cd/
cd D:/JavaHome/temp
d:
javac JDBCTest.java
java  JDBCTest
pause
*/
import java.sql.*;
// WindowsXP使用JDBC连接Oracle10g数据库
// Oracle10g 客户端安装在: "D:/OraClient10g"
public class JDBCTest {
    public static void main(String args[ ]) {
        Connection connection = null;
        Statement statement = null;
        
        try {
            // Load the JDBC Driver
            // 必须在系统环境变量 CLASSPATH 添加 "D:/OraClient10g/jdbc/lib/classes12.zip"
            String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
            // 找到 "D:/OraClient10g/NETWORK/ADMIN/tnsnames.ora" 文件, 将 (DESCRIPTION=...)拷贝到下面
            String URL = "jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = mine)(PORT = 1521)) )(CONNECT_DATA =(SID = cheung)(SERVER = DEDICATED)))";
            Class.forName(DBDRIVER).newInstance();
    
            // Connect to the database
            connection = DriverManager.getConnection(URL, "scott", "tiger");
            // Obtain a statement object
            statement = connection.createStatement();
            
            // Execute the SQL
            String sql = "select * from JDBC_TEST";
            ResultSet rs = statement.executeQuery(sql);
            while (rs.next())
            {
                System.out.println(rs.getString(1));  // 列的索引: 1-based
            }
            rs.close();
        }
        // Don't try this at home, catch SQLException and all others
        catch( Exception e ) {
            e.printStackTrace();
        }
        finally {
            // Time to close everthing up.
            if( statement != null ) {
                try {
                    statement.close();
                }
                catch( SQLException e ){
                } // nothing we can do
            }
        
            if( connection != null ) {
                try {
                    connection.close();
                }
                catch( SQLException e ){
                } // nothing we can do
            }
        }
    }
}