package java_call_oracle;

//JAVA操作ORACLE  基本用法上還是用的sql包
import java.sql.*;

//import oracle.jdbc.driver.OracleDriver; //驅動類
public class Oracle_Test {
    private Connection conn = null;
    private Statement stmt = null;
    private ResultSet rs = null;
    public Oracle_Test() {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            //jdbc:oracle:thin:@主機:端口:數據庫名稱
            conn = DriverManager.getConnection(
                    "jdbc:oracle:thin:@localhost:1521:ORAC", "scott", "tiger");
            stmt = conn.createStatement();
            rs = stmt.executeQuery("select * from dept");
            while (rs.next()) {
                String str1 = rs.getString(1);
                String str2 = rs.getString(2);
                String str3 = rs.getString(3);
                System.out.println(str1 + "   " + str2 + "   " + str3);
            }

        } catch (Exception e)
        {
                        System.out.println(e.getMessage());
        }
        finally
        {

        }

    }

    public static void main(String[] args) {

    }
    public void safeClose()
    {
        try
        {

        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }
        if(conn!=null)
        {
            conn.close();
        }
        else if(stmt!=null)
        {
            stmt.close();
        }
        else if(rs!=null)
        {
            stmt.close();
        }
    }
}