oracledatasource.java

来自「JAVA高级编程第2版书中所有的源代码,因为我有这本书觉得很不错,所以上传上来,」· Java 代码 · 共 104 行

import java.io.PrintWriter;
import java.sql.*;
import javax.sql.*;

public class OracleDataSource implements DataSource {

  static {
    new oracle.jdbc.driver.OracleDriver();
  }

  protected boolean usingThinDriver;

  protected String description = "Oracle Data Source";
  protected String serverName;
  protected int portNumber;
  protected String databaseName;

  public OracleDataSource(String host, int port, String sid) {
    setServerName(host);
    setPortNumber(port);
    setDatabaseName(sid);
    usingThinDriver = true;
  }

  public OracleDataSource(String sid) {
    setDatabaseName(sid);
    usingThinDriver = false;
  }

  public boolean isUsingThinDriver() {
    return usingThinDriver;
  }

  public void setUsingThinDriver(boolean thin) {
    usingThinDriver = thin;
  }

  public String getDescription() {
    return description;
  }

  public void setDescription(String desc) {
    description = desc;
  }

  public String getServerName() {
    return serverName;
  }

  public void setServerName(String name) {
    serverName = name;
  }

  public int getPortNumber() {
    return portNumber;
  }

  public void setPortNumber(int port) {
    portNumber = port;
  }

  public String getDatabaseName() {
    return databaseName;
  }

  public void setDatabaseName(String name) {
    databaseName = name;
  }

  public Connection getConnection() throws SQLException{
    return getConnection(null, null);
  }

  public Connection getConnection(String userid, String password)
      throws SQLException {
    String url = "jdbc:oracle:" + getSubname();
    return DriverManager.getConnection(url, userid, password);
  }

  protected String getSubname() {
    return (isUsingThinDriver() 
            ? "thin:@" + getServerName() + ":" + getPortNumber() + ":" +
              getDatabaseName() 
            : "oci8:@" + getDatabaseName());
  }

  public int getLoginTimeout() throws SQLException {
    return DriverManager.getLoginTimeout();
  }

  public PrintWriter getLogWriter() throws SQLException {
    return DriverManager.getLogWriter();
  }

  public void setLoginTimeout(int timeout) throws SQLException {
    DriverManager.setLoginTimeout(timeout);
  }

  public void setLogWriter(PrintWriter writer) throws SQLException {
    DriverManager.setLogWriter(writer);
  }

}