JavaPaste

package cadteste;

import java.sql.*;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.Connection;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;


public class Conexão_BD{
  public Connection con;
  public Statement stmt;
  public ResultSet rs;
  private final String driver = "org.postgresql.Driver";
  private final String caminho = "jdbc:postgresql://localhost:5432/BDCadTeste";
  private final String usuario = "postgres";
  private final String senha = "618892";

  public Connection getConnection(){return con;}
   public void setConnection(Connection con){this.con = con;}
     public void Conecta_BD(){
      try{
          Class.forName(driver);
          con = DriverManager.getConnection(caminho, usuario, senha);
          stmt = con.createStatement();
          }catch(ClassNotFoundException e){JOptionPane.showMessageDialog(null, "Erro na carga da classe. Erro: " + e.getMessage(), "Cadastro de Clientes",JOptionPane.ERROR_MESSAGE);System.out.println("Erro na carga da classe. Erro: " + e.getMessage());}
          catch(SQLException e){JOptionPane.showMessageDialog(null, "Erro na conexao. Erro: " + e.getMessage(), "Cadastro de Clientess",JOptionPane.ERROR_MESSAGE);}
          catch(NoClassDefFoundError e){JOptionPane.showMessageDialog(null, "Erro: " + e.getMessage(), "Cadastro de Clientes", JOptionPane.ERROR_MESSAGE);}

                               }
        public void Encerra_BD(){
          try{con.close();}catch(SQLException ex){Logger.getLogger(Conexão_BD.class.getName()).log(Level.SEVERE, null, ex);}
                             }
            public void executaSQL(String sql){
               try{
                 stmt = con.createStatement(rs.TYPE_SCROLL_SENSITIVE, rs.CONCUR_READ_ONLY);
                 rs = stmt.executeQuery(sql);
                  }catch (SQLException e){JOptionPane.showMessageDialog(null, "Erro no executaSQL!\nErro: " + e.getMessage());}
                                                }
                               }