package Test_Conexion;
import java.sql.*;
public class Clase_Conexion {
private Connection conexion=null;
private String servidor="";
private String database="";
private String usuario="";
private String password="";
private String url="";
public Clase_Conexion(String servidor, String database, String usuario, String password){
try {
this.servidor = servidor;
this.database = database;
Class.forName("com.mysql.jdbc.Driver");
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
url="jdbc:mysql://"+servidor+"/"+database;
conexion=DriverManager.getConnection(url, usuario, password);
System.out.println("Conexion a Base de Datos "+url+" . . . . .Ok");
}
catch (SQLException ex) {
System.out.println(ex);
}
catch (ClassNotFoundException ex) {
System.out.println(ex);
}
}
public Connection getConexion(){
return conexion;
}
public Connection cerrarConexion(){
try {
conexion.close();
System.out.println("Cerrando conexion a "+url+" . . . . . Ok");
} catch (SQLException ex) {
System.out.println(ex);
}
conexion=null;
return conexion;
}
}