Untitled

package package_jul;
import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
 *
 * @author Julien
 */
public class ConnectBD {
    public static Connection ouvrirCon() {
try {
Connection con;
Class.forName("com.mysql.jdbc.Driver");
String dataBaseURL = "jdbc:mysql://crpilamp.insa-strasbourg.fr:3306/4pastjul";
String user = "4pastjul";
String pass = "ProjetInfo"; //dans mysql.txt
con = DriverManager.getConnection(dataBaseURL,user,pass);
return(con);
}
catch (Exception ex)
{
throw new Error(ex);
}
}
    public static void fermerCon(Connection con) {
try {
con.close();
}
catch (Exception ex)
{
throw new Error(ex);
}
}

}