package database;

import java.sql.*;

public class DatabaseManager
{
    // database name and Deriver mananger direcotry.
    public static String JDRIVER = "com.mysql.jdbc.Driver";
    public static String DATABASE_URL = "jdbc:mysql://localhost/airline";
    protected static Connection connect;

    // adding the singleton private member
    public static final DatabaseManager instance = new DatabaseManager();


    // private constructor to prevent clients from instantiating new DatabaseManager
    private DatabaseManager()
    {
        initialize();
    }

    // public method to access the Singleton class
    public static DatabaseManager getInstance()
    {
        return instance;
    }

    public Connection getConnection()
    {
        return connect;
    }


    private static void initialize()
    {
        // connect impelemten
        connect = null;
        try {
                // The newInstance() call is a work around for some
                // broken Java implementations
                Class.forName(JDRIVER);

                //DATABASE_URL = DATABASE_URL + arg[0];

            connect = DriverManager.getConnection(DATABASE_URL, "root" , "");



        }
        catch (SQLException ex) {
         // handle any errors
                System.out.println("SQLException: " + ex.getMessage());
                System.out.println("SQLState: " + ex.getSQLState());
                System.out.println("VendorError: " + ex.getErrorCode());
        }
        catch (ClassNotFoundException classNotFound)
        {
            classNotFound.printStackTrace();
            System.exit(1);
        }

        return;
    }//end of connectToDatabase.


    //public  abstract void updateDatabase();
    //public  abstract void queryDatabase(String query);
}