用JDBC连接Oracle并读取数据的例子

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

/**
* 用JDBC连接Oracle并读取数据的例子。
*
* 
*/
public class jdbc {
String dbUrl = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";

String theUser = "scott";

String thePw = "tiger";

Connection c = null;

Statement conn;

ResultSet rs = null;

public jdbc() {
    try {
      Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
      c = DriverManager.getConnection(dbUrl, theUser, thePw);
      conn = c.createStatement();
    } catch (Exception e) {
      e.printStackTrace();
    }
}

public boolean executeUpdate(String sql) {
    try {
      conn.executeUpdate(sql);
      return true;
    } catch (SQLException e) {
      e.printStackTrace();
      return false;
    }
}

public ResultSet executeQuery(String sql) {
    rs = null;
    try {
      rs = conn.executeQuery(sql);
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return rs;
}

public void close() {
    try {
      conn.close();
      c.close();
    } catch (Exception e) {
      e.printStackTrace();
    }
}

public static void main(String[] args) {
    ResultSet rs;
    jdbc conn = new jdbc();
    rs = conn.executeQuery("select * from test");
    try {
      while (rs.next()) {
        System.out.println(rs.getString("id"));
        System.out.println(rs.getString("name"));
      }
    } catch (Exception e) {
      e.printStackTrace();
    }
}
}