Source Code : implements DataSource

Java Is Open Source Programming Language You Can Download From Java and Java Libraries From http://www.oracle.com. Click Here to download
We provide this code related to title for you to solve your developing problem easily. Libraries which is import in this program you can download from http://www.oracle.com. Click Here or search from google with Libraries Name you get jar file related it

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

}

   
  

Thank with us