package modelo.conexion;

import java.sql.*;

public class Connect
{
    private Connection conn;
    private String host;
    private String db;
    private String username;
    private String password;

    private static Connect connect;

    public Connect()
    {
    	host = "localhost";
    	db = "conacad";
    	username = "root";
    	password = "Inside09";
        try			//regresa un objeto del tipo especificado, com.mysql.jdbc.Driver es la clase que implementa java.sql.Driver
        {
		Class.forName("com.mysql.jdbc.Driver").newInstance();
		//Intentamos conectarnos a la base de Datos en este caso una base llamada temp
		System.out.println("Conectando a la base...");
		String url ="jdbc:mysql://"+host+"/"+db;
		conn = DriverManager.getConnection(url, username, password);
		System.out.println("Conexion a BD establecida");
	} catch(SQLException ex) {
		System.out.println("Error de mysql"+ex.getMessage());
	} catch (ClassNotFoundException e) {
                e.printStackTrace();
	} catch(Exception e) {
		System.out.println("Se produjo un error inesperado: "+e.getMessage());

	}

	connect = this;
    }

    public Connect(String host, String db, String username, String password) throws ClassNotFoundException, SQLException
    {
            Class.forName("com.mysql.jdbc.Driver");
            this.host = host;
            this.db = db;
            this.username = username;
            this.password = password;
            conn = DriverManager.getConnection ("jdbc:mysql://" + host +"/"+db,username,password);
            connect = this;
    }

    public String getHost() {
 	   return host;
    }

    public void setHost(String host) {
 	   this.host = host;
    }

    public String getDb() {
 	   return db;
    }

    public void setDb(String db) {
 	   this.db = db;
    }

    public String getUsername() {
 	   return username;
    }

    public void setUsername(String username) {
 	   this.username = username;
    }

    public String getPassword() {
 	   return password;
    }

    public void setPassword(String password) {
 	   this.password = password;
    }

    public Connection connection() {
 	   try
 	   {
 	       return conn;
 	   }
 	   finally
 	   {

 	   }
    }

    public void close() {
 	   try
 	   {
 		   conn.close();
 	   }
 	   catch (SQLException e)
 	   {
 	       System.err.println ("Error: " + e.getMessage () + "\n" + e.getErrorCode ());
 	   }
    }

	public static Connect getConnect() {
		return connect;
	}

	public static void setConnect(Connect connect) {
		Connect.connect = connect;
	}
}