import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class BDD {
	private String serveur, bdd, user, mdp;
	private Connection maConnexion;

	public BDD (String serveur, String bdd, String user, String mdp){
		this.serveur = serveur;
		this.bdd = bdd;
		this.user = user;
		this.mdp = mdp;
		this.maConnexion = null;
	}

	public void chargerPilote() {
		//verification de l'import du pilote Mysql
		try{
			Class.forName("com.mysql.jdbc.Driver");
		}
		catch (ClassNotFoundException exp) {
			System.out.println("Erreur de chargement de pilote !");
		}
	}

	public void seConnecter() {
		this.chargerPilote();
		String url = "jdbc:mysql://"+this.serveur+"/"+this.bdd;
		try{
			this.maConnexion = DriverManager.getConnection(url,this.user,this.mdp);
		}
		catch(SQLException exp){
			System.out.println("Erreur de connexion au "+url);
		}
	}

	public void seDeconnecter() {
		try {
			if (this.maConnexion != null)
			{
				this.maConnexion.close();
			}
		}
		catch (SQLException exp)
		{
			System.out.println("Erreur de deconnexion !");
		}
	}

	public Connection getMaConnexion() {
		return maConnexion;
	}

	public void setMaConnexion(Connection maConnexion) {
		this.maConnexion = maConnexion;
	}



}