oracle_test.java~42~

来自「oracle的一些详细资料oracle的一些详细资料 看看吧~~」· JAVA~42~ 代码 · 共 36 行

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) {} finally {
            System.out.println();
        }

    }

    public static void main(String[] args) {

    }
}