Advertisement
Guest User

ConexionBD MySQL

a guest
Nov 22nd, 2014
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.96 KB | None | 0 0
  1. public class ConexionBD implements Serializable {
  2.  
  3.     public static String user = "root";
  4.     public static String password = "S1GdMySqL123";
  5.     public static String url = "jdbc:mysql://localhost:3306/sigd";
  6.     public static String className = "com.mysql.jdbc.Driver";
  7.  
  8.     public Connection conn = null;
  9.  
  10.     public ConexionBD() {
  11.         try {
  12.             Class.forName(className);
  13.             conn = DriverManager.getConnection(url, user, password);
  14.             if (conn != null) {
  15.                 System.out.println("Si se pudo conectar a la BD");
  16.             }
  17.         } catch (SQLException | ClassNotFoundException ex) {
  18.             System.err.println("No se pudo conectar a la BD, error: " + ex.toString());
  19.         }
  20.     }
  21.  
  22.     public Connection getConexion() {
  23.         return conn;
  24.     }
  25.  
  26.     public void desconectar() throws SQLException {
  27.         System.out.println("Se desconectó de la BD");
  28.         conn.close();
  29.         conn = null;
  30.     }
  31. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement