使用Oracle JDBC驱动

2019-11-18 16:06:46

字体：大中小

来源：转载

供稿：网友

/*
java PRogramming with Oracle JDBC
by Donald Bales
ISBN: 059600088X
Publisher: O'Reilly
*/

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestClassForNameApp {

  public static void main(String args[]) {

    try {
      Class.forName("oracle.jdbc.driver.OracleDriver");
    } catch (ClassNotFoundException e) {
      System.out
          .println("Oops! Can't find class oracle.jdbc.driver.OracleDriver");
      System.exit(1);
    }

    Connection conn = null;
    Statement stmt = null;
    ResultSet rset = null;
    try {
      conn = DriverManager.getConnection(
          "jdbc:oracle:thin:@dssw2k01:1521:orcl", "scott", "tiger");

      stmt = conn.createStatement();
      rset = stmt
          .executeQuery("select 'Hello 'USER'!' result from dual");
      while (rset.next())
        System.out.println(rset.getString(1));
      rset.close();
      rset = null;
      stmt.close();
      stmt = null;
      conn.close();
      conn = null;
    } catch (SQLException e) {
      System.out.println("Darn! A SQL error: " + e.getMessage());
    } finally {
      if (rset != null)
        try {
          rset.close();
        } catch (SQLException ignore) {
        }
      if (stmt != null)
        try {
          stmt.close();
        } catch (SQLException ignore) {
        }
      if (conn != null)
        try {
          conn.close();
        } catch (SQLException ignore) {
        }
    }
  }
}

（出处：http://www.VeVb.com）

上一篇：连接MySQL并执行Select

下一篇：测试MySQL驱动的安装