package com.subin.common;

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

public class ConnectionManager
{

private String userId = "username";
private String passWord = "password";
private String url = "complete_url"; // e.g         jdbc:oracle:thin:@host:port:SID
private String driver = "oracle.jdbc.driver.OracleDriver";

private static ConnectionManager instance;

private String getUrl()
{
return url;
}

private String getUserId()
{
return userId;
}

private String getPassWord()
{
return passWord;
}

public static ConnectionManager getInstance()
{
if (instance == null)
{
instance = new ConnectionManager();
}
return instance;
}

private ConnectionManager()
{
try
{
Class.forName(driver);
}
catch (Exception e)
{
e.printStackTrace();
}
}

public static Connection getConnection() throws java.sql.SQLException
{
return DriverManager.getConnection(getInstance().getUrl(),
getInstance().getUserId(), getInstance().getPassWord());
}

public static void closeConnection(Connection c)
{
try
{
if (c != null)
{
c.close();
}
}
catch (SQLException e)
{
e.printStackTrace();
}
}

}