oracle_test.java~50~

oracle的一些详细资料oracle的一些详细资料 看看吧~~

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 {
            safeClose();
        }

    }

    public static void main(String[] args) {

    }

    public void safeClose() {
        try {
            if (conn != null) {
                conn.close();
            } else if (stmt != null) {
                stmt.close();
            } else if (rs != null) {
                stmt.close();
            }

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