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

public class Connexion {
	
	private String url ="jdbc:mysql://localhost:3306/projet_jdbc";
	private String user ="root";
	private String password ="root";
	private static Connection con = null;
	
	private Connexion() {
		
			try {
				Class.forName("com.mysql.jdbc.Driver");
				con = DriverManager.getConnection(url, user, password);
			} catch (SQLException e) {
				e.printStackTrace();
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			}	
	}
	
	public static Connection getInstance(){
		if(con == null){
			new Connexion();
			System.out.println("Vous etes connecte!");
		} 
		return con;	
	}
	
	public static void closeCon() {
		if(con == null) {
		} else {
			try {
				con.close();
				System.out.println("Vous etes deconnecte.");
				con = null;
			} catch (SQLException e) {
				e.printStackTrace();	
			}
		}
	}
		
}