kare2122

package proyecto; import java.sql.*; public class DatosBD { static String baseDatos = "nombreBD"; static String puerto = "5432"; static String usuario = "postgres"; static String clave = "contraaseña"; static String ip = "localhost"; public static ResultSet consultar (String consulta) throws Exception { ResultSet reg = null; Connection conex = null; Statement SQL = null; try { conex=conexion(); SQL = conex.createStatement (ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); reg = SQL.executeQuery(consulta); } catch (Exception e){} return reg; } public static Connection conexion() { Connection conex = null; String URL = "jdbc:postgresql://localhost:5432/nombreBD"; try { Class.forName("org.postgresql.Driver" ;. conex = DriverManager.getConnection(URL,"postgres", "contraseña" ;. } catch (ClassNotFoundException ex) {System.out.println(ex.getMessage());} catch(SQLException ex){System.out.println(ex.getMessage());} return conex; } public int ejecutar(String consulta) { int conclusion = -1; Connection conex;Statement sql = null; try { conex = conexion(); sql = conex.createStatement(); sql.executeUpdate(consulta); sql.close();conex.close(); conclusion = 1; }catch(SQLException ex){System.out.println(ex.getMessage());} catch(Exception ex){System.out.println(ex.getMessage());} return conclusion; } public static boolean verificar(String x, String campo, String tabla) { ResultSet reg; try { String consulta = "Select count ("+campo+" ) from "+tabla+" where "+campo+" = '"+x+"'"; reg = consultar(consulta); reg.first(); int n = reg.getInt(1); if (n>0) { return true; } else { return false;} }catch(Exception e){} return false; } public ResultSet Registros(String consulta) { ResultSet reg=null;Connection conex=null; Statement sql=null; try { conex=conexion(); sql=conex.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); reg=sql.executeQuery(consulta); }catch(Exception e){} return reg; } }