Codigo de Conector
package sisbalcones;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Conector {
// Driver de JDBC y La URL de la Base de Datos MySQL
private final String DRIVER = "com.mysql.jdbc.Driver";
private final String DATABASE_URL = "jdbc:mysql://localhost:3306/bdbalcones2";
private final String USUARIO = "root";
private final String PASSWRD = "123456";
private Connection cn = null;
public Conector(){
registraConector();
try{
cn = DriverManager.getConnection(DATABASE_URL,USUARIO,PASSWRD);
}
catch(SQLException ex){
System.err.print(ex.getSQLState());
}
}
private void registraConector(){
try{
Class.forName(DRIVER).newInstance();
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
} catch (InstantiationException ex) {
System.err.println("Error de Instanciacion"+ex.getMessage());
} catch (IllegalAccessException ex) {
System.err.println("Error de Acceso Ilegal"+ex.getMessage());
}catch(ClassNotFoundException cnfe){
System.err.println("Error No existe la clase"+cnfe.getMessage());
}catch(java.sql.SQLException sqlex){
System.err.println("Error SQLException"+sqlex.getSQLState());
}
}
public Connection getConector(){
return cn;
}
public void closeConector(){
try{
cn.close();
}
catch(SQLException sqlex){
System.err.print("SQL Error: "+sqlex.getSQLState());
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Conector {
// Driver de JDBC y La URL de la Base de Datos MySQL
private final String DRIVER = "com.mysql.jdbc.Driver";
private final String DATABASE_URL = "jdbc:mysql://localhost:3306/bdbalcones2";
private final String USUARIO = "root";
private final String PASSWRD = "123456";
private Connection cn = null;
public Conector(){
registraConector();
try{
cn = DriverManager.getConnection(DATABASE_URL,USUARIO,PASSWRD);
}
catch(SQLException ex){
System.err.print(ex.getSQLState());
}
}
private void registraConector(){
try{
Class.forName(DRIVER).newInstance();
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
} catch (InstantiationException ex) {
System.err.println("Error de Instanciacion"+ex.getMessage());
} catch (IllegalAccessException ex) {
System.err.println("Error de Acceso Ilegal"+ex.getMessage());
}catch(ClassNotFoundException cnfe){
System.err.println("Error No existe la clase"+cnfe.getMessage());
}catch(java.sql.SQLException sqlex){
System.err.println("Error SQLException"+sqlex.getSQLState());
}
}
public Connection getConector(){
return cn;
}
public void closeConector(){
try{
cn.close();
}
catch(SQLException sqlex){
System.err.print("SQL Error: "+sqlex.getSQLState());
}
}
}
Comentarios
Publicar un comentario