package pqConexion;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Conexion {
private Connection conexion;
public Conexion() {
this.conexion = conecta();
}
protected Connection conecta() {
if (this.conexion != null) {
try {
this.conexion.close();
} catch (SQLException e) {
System.out.println("Error al cerrar la conexion");
System.out.println(e.getMessage());
}
}
conexion = null;
if (this.conexion == null) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:xe";
//String user = "prueba";
String user = "SYSTEM";
String pass = "prueba";
this.conexion = DriverManager.getConnection(url, user, pass);
System.out.println("Conexion establecida!!!");
} catch (SQLException | ClassNotFoundException e) {
System.out.println("Error en la conexión de la base de datos");
System.out.println(e.getMessage());
}
}
return conexion;
}
public Connection getConexion() {
//this.conexion = conecta();
return this.conexion;
}
}
No hay comentarios.:
Publicar un comentario