package  com.xxx.db;

 import  java.util.* ;
 import  java.sql.* ;
 import  java.io.* ;

 import  java.lang.*;

 public   class  DBHandler  extends  java.lang.Object
{

     private  Connection m_Connection ;

     private  Driver m_Driver ;

     private  Properties m_HandlerProperties ;

     private  String m_PropertiesFileName ;

     private  String m_Catalog ;

     private   boolean  m_IsInit ;
    

    /*static final private String DRIVER_CLASS_NAME   = "com.ibm.as400.access.AS400JDBCDriver" ;
    static final private String DB_CON_URL          = "jdbc:as400://66.16.63.51" ;//52
    static final private String USERNAME            = "handy" ;
    static final private String PASSWORD            = "handy" ;*/

    /*static final private String DRIVER_CLASS_NAME   = "org.gjt.mm.mysql.Driver" ;
    static final private String DB_CON_URL          = "jdbc:mysql://208.242.198.33/Transactions";
    static final private String USERNAME            = "root" ;
    static final private String PASSWORD            = "altoids176" ; */

    /*static final private String DRIVER_CLASS_NAME   = "oracle.jdbc.driver.OracleDriver" ;
    static final private String DB_CON_URL          = "jdbc:oracle:thin:@208.242.198.13:1521:ORCL";
    static final private String USERNAME            = "beckmanrenders" ;
    static final private String PASSWORD            = "beckman" ;*/

    /*static final private String DRIVER_CLASS_NAME   = "sun.jdbc.odbc.JdbcOdbcDriver" ;
    static final private String DB_CON_URL          = "jdbc:odbc:HandyTransactions" ;
    static final private String USERNAME            = "" ;
    static final private String PASSWORD            = "" ;*/
    
     static   final   private  String DRIVER_CLASS_NAME   = "CLASSNAME" ;
     static   final   private  String DB_CON_URL          = "DB.CONNECTION.URL" ;
     static   final   private  String USERNAME            = "USERNAME" ;
     static   final   private  String PASSWORD            = "PASSWORD" ;
    
     private  String m_driverClassName =  null  ;
     private  String m_dbConnetctionURL =  null  ;
     private  String m_userName =  null  ;
     private  String m_password =  null  ;
    
    
     static   final   private  String DEFAULT_PROPERTIES_FILE     = "dbtool.properties" ;

     public  DBHandler()
    {
        m_Connection =  null  ;
        m_Driver =  null  ;
        m_Catalog = "" ;
        m_HandlerProperties =  new  Properties () ;
        m_PropertiesFileName = DEFAULT_PROPERTIES_FILE ;
        m_IsInit = false ;
    }

     public  String getPropertiesFileName()
    {
         return  m_PropertiesFileName ;
    }

     public   void  setPropertiesFileName( String fileName )
    {
        m_PropertiesFileName = fileName ;
    }

     public   void  loadProperties() 
    {
         if  ( ( m_PropertiesFileName !=  null  ) && ( m_PropertiesFileName.length() >  0  )  )
        {
           InputStream fin =  null  ;
            try  
           {            
                //m_PropertiesFileName ;
                m_HandlerProperties =  new  Properties() ;
                fin =  new  FileInputStream( m_PropertiesFileName ) ;            
                m_HandlerProperties.load( fin ) ;

                m_driverClassName = m_HandlerProperties.getProperty( DRIVER_CLASS_NAME ) ;
                m_dbConnetctionURL = m_HandlerProperties.getProperty( DB_CON_URL ) ;
                m_userName = m_HandlerProperties.getProperty( USERNAME ) ;
                m_password = m_HandlerProperties.getProperty( PASSWORD ) ;
            }
             catch  ( FileNotFoundException nf )
            {
                System.out.println( "File was not found : " + m_PropertiesFileName ) ;                
            }
             catch  (IOException ioe )
            {
                System.out.println( "Can not read from file : " + m_PropertiesFileName ) ;
            }
            
             finally  
            {
                 try  
                {
                     if ( fin !=  null  )
                        fin.close();
                }
                 catch (IOException e)
                {
                    e.printStackTrace( System.err ) ;
                }
            }
         } 
    }
    
     public   void  init()
    {
        loadProperties() ;
         try 
        {
             if  ( !m_IsInit || m_Connection ==  null  )
            {
                m_IsInit = true ;
                 Class .forName( m_driverClassName ) ;
                m_Driver = DriverManager.getDriver( m_dbConnetctionURL ) ;

                 if  ( m_Driver !=  null  )
                {
                    String drvVersion = m_Driver.getMajorVersion() + "." + m_Driver.getMinorVersion() ;
                    m_HandlerProperties.put( "Version" , drvVersion ) ;

    //                DriverPropertyInfo[] dPropInfo = m_Driver.getPropertyInfo( DB_CON_URL ) ;
                    m_Connection = DriverManager.getConnection( m_dbConnetctionURL, m_userName, m_password ) ;
                    m_Catalog = m_Connection.getCatalog() ;

                }

                System.out.println("Driver Class: " + DRIVER_CLASS_NAME ) ;
                System.out.println("Con URL: " + DB_CON_URL ) ;
            }
        }
         catch  (ClassNotFoundException e1)
        {
            System.out.println( "Error: Driver class can't be found!" ) ;
            System.out.println( "Message: " + e1.getMessage() ) ;
            e1.printStackTrace() ;
        }
        catch (SQLException e2)
        {
            System.out.println( "Error: Driver can't be found!" ) ;
            System.out.println( "Message: " + e2.getMessage() ) ;
            e2.printStackTrace() ;
        }

         catch  (Exception e3)
        {
            System.out.println( "Error: Unknown Exception" ) ;
            System.out.println( "Message: " + e3.getMessage() ) ;
            e3.printStackTrace() ;
        }

   }

    public  Connection getConnection()
   {
         return  m_Connection ;
   }

    public  String getCatalog()
   {
         return  m_Catalog ;
   }

    public   void  destroy()
   {
         try 
        {
             if  (m_Connection !=  null  )
                m_Connection.close() ;
        }
         catch  (SQLException e)
        {
            System.out.println( "Error: can't close the connection" ) ;
            System.out.println( "Message: " + e.getMessage() ) ;
            e.printStackTrace() ;
        }
   }
}

# Name of JDBC driver  class  to be used
CLASSNAME=sun.jdbc.odbc.JdbcOdbcDriver
# Connect String  for  JDBC driver
DB.CONNECTION.URL=jdbc:odbc:CDTransactionDatabase
USERNAME=
PASSWORD=