package fr.limayrac.m1cpi.yvanm.sql;

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

public class GetConnection {
	public static Connection getCo() {

		final String HOSTNAME = "localhost";
		final String PORT = "3306";
		final String USER = "root";
		final String PWD = "";
		final String DBNAME = "gestion";

		Connection connection = null;

		try {
			Class.forName("com.mysql.jdbc.Driver");

			System.out.println("Tentative de connection SQL en cours ...");
		} catch (ClassNotFoundException e1) {
			e1.printStackTrace();
		}

		String url = "jdbc:mysql://" + HOSTNAME + ":" + PORT + "/" + DBNAME;

		try {
			connection = DriverManager.getConnection(url, USER, PWD);

			System.out.println("Connexion SQL réussie !");
	    } catch (SQLException e) {
	    	e.printStackTrace();
			System.out.println("Erreur lors de l'établissement de la connexion");
	    }

		return connection;
	}
}