/**
 *
 * @author pthreat
 */

package Domain;

import java.sql.*;
import java.util.Iterator;
import java.util.ArrayList;

public class Db {

    private static Db instance=null;
    private String database;
    private String hostname;
    private String username;
    private String password;
    private Connection connection;


    private void Db(){

    }

    public static Db getInstance(String hostname, String username, String password, String database){

        if(instance!=null){

            instance = new Db ();

            try {

                instance.setHostname(hostname);
                instance.setUsername(username);
                instance.setPassword(password);
                instance.setDatabase(database);
                instance.connect();

        }catch (Exception e){

            e.printStackTrace();

        }

            System.out.println("instance");
        }

        return instance;

    }

    public void connect(){

        if(this.connection!=null){

            return;

        }

        try {

            DriverManager.registerDriver(new org.gjt.mm.mysql.Driver());
            String connectStr = "jdbc:mysql://"+this.hostname+"/"+this.database;
            this.connection = DriverManager.getConnection ( connectStr,this.username,this.password);

        } catch(SQLException e){

            e.printStackTrace();

        }

    }

    public ArrayList query(String sql){

        ArrayList array = new ArrayList();

        try{

            Statement s = this.connection.createStatement();
            ResultSet rs = s.executeQuery(sql);

            int columns = 0;

            ResultSetMetaData rmd = rs.getMetaData();
            columns = rmd.getColumnCount();

            while (rs.next()){

                for(int i=0;i<columns;i++){

                    array.add(rs.getArray(i));

                }

            }

        }catch (SQLException e){

            e.printStackTrace();

        }

        return array;

    }

    public static void main(String[] args){

        Db db = Db.getInstance("localhost:3306","root", "blah", "crap");

        ArrayList result;

        result = db.query("SELECT * FROM table");
        Iterator iterator = result.iterator();

        while(iterator.hasNext()){

            System.out.println(iterator.toString());

        }

    }

    private void setConnection(Connection connection){
        this.connection = connection;
    }

    private Connection getConnection(){

       return  this.connection;

    }


   /**
    * @return the database
    */
   public String getDatabase() {
      return database;
   }

   /**
    * @param database the database to set
    */
   public void setDatabase(String database) {
      this.database = database;
   }

   /**
    * @return the hostname
    */
   public String getHostname() {
      return hostname;
   }

   /**
    * @param hostname the hostname to set
    */
   public void setHostname(String hostname) {
      this.hostname = hostname;
   }

   /**
    * @return the username
    */
   public String getUsername() {
      return username;
   }

   /**
    * @param username the username to set
    */
   public void setUsername(String username) {
      this.username = username;
   }

   /**
    * @return the password
    */
   public String getPassword() {
      return password;
   }

   /**
    * @param password the password to set
    */
   public void setPassword(String password) {
      this.password = password;
   }

   @Override

   public String toString(){

        String info = "Db: "+this.database;
        info += "Hostname: "+this.hostname;
        info += "User: "+this.username;
        info += "Password: "+this.password;

        return info;

   }

}