dbconfig

package com.cigna.etl.email.config;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import com.cigna.etl.email.content.Contents;

public class DBConfig
{
 private static final String DB_DRIVER = Config.getConfig(Contents.DB_DRIVER);

 public static Connection getConn(String url,String user,String password) throws Exception
 {
     Class.forName(DB_DRIVER).newInstance();
    
     System.out.println(Class.forName(DB_DRIVER).newInstance());
    
     return DriverManager.getConnection(url,user,password);
    
 }

 public static void close(Connection conn,Statement statement,ResultSet rs)  throws Exception
 {
  if( rs != null )
  {
   rs.close();
  }
  if( statement != null )
  {
   statement.close();
  }
  if( conn != null )
  {
   conn.close();
  }
 }

}