import java.sql.*; public class utileCBD { public static Connection getConnection(String url, String usr, String pwd) { Connection cnn = null; try { Class.forName("com.mysql.jdbc.Driver"); cnn = DriverManager.getConnection("jdbc:mysql://" + url, usr, pwd); cnn.setAutoCommit(true); System.out.println("connection a la base reussie"); } catch (SQLException e) { System.out.println("Echec connection à la base !!!"); String v = "URL:[" + url +"] Utilisateur :[" + usr + "] Mot de passe:[********]\n" ; javax.swing.JOptionPane.showMessageDialog(null, v+ e.getMessage()); System.exit( -1); } catch (ClassNotFoundException e) { javax.swing.JOptionPane.showMessageDialog(null, e.getMessage()); System.exit( -1); } return cnn; } }
|