implements DataSource : DataSource « Database SQL JDBC « Java

1. Java
2. Database SQL JDBC
3. DataSource

implements DataSource

 

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);
  }

}

   
  

Related examples in the same category