读书人

最简略的Java连oracle方法

发布时间: 2012-12-22 12:05:05 作者: rapoo

最简单的Java连oracle方法

package com.sun.ATest;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class Main {    private Connection conn = null;    private Statement stmt = null;    private ResultSet Rs = null;    public void test() {        // 创建数据库连接        try {            Class.forName("oracle.jdbc.driver.OracleDriver");            //DriverManager.getConnection(url, userName, password);            conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "test",  "wangjj");            stmt = conn.createStatement();            Rs = stmt.executeQuery("select sysdate from dual");            if (Rs.next()) {                 System.out.println(Rs.getString("SYSDATE")); //SYSDATE 不区分大小写                // System.out.println(Rs.getString(1)); //索引从 1 开始            }        } catch (ClassNotFoundException e) {            e.printStackTrace();        } catch (SQLException e) {            e.printStackTrace();        }               //关闭操作 数据集 会话 连接        try {            Rs.close();            stmt.close();            conn.close();        } catch (SQLException e) {            e.printStackTrace();        }    }    public static void main(String[] args) {        new Main().test();    }}

读书人网 >编程

热点推荐