package modeloConection;

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


public class ConexaoBD {

    public Statement stm;
    public ResultSet rs;
    private String driver = "org.postgresql.Driver";
    private String caminho = "jdbc:postgresql://localhost:5432/nome do banco";
    private String usuario = "postgres";
    private String senha = "seu senha";
    public Connection con;

    public void conexao(){
        System.setProperty("jdbc.Drivers",driver);
        try {
            con =DriverManager.getConnection(caminho,usuario,senha);

        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(null,"Erro ao conectar com o Banco de Dados"+ex.getMessage());

        }
    }
     public void executaSql(String sql){
        try {
            stm = con.createStatement(rs.TYPE_SCROLL_INSENSITIVE,rs.CONCUR_READ_ONLY);
            rs = stm.executeQuery(sql);
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(null,"Erro Executa Sql:"+ex.getMessage());
        }


     }

     public void desconecta(){
     try{
         con.close();

     }catch(SQLException ex){
         Logger.getLogger(ConexaoBD.class.getName()).log(Level.SEVERE,null,ex);

     }
    }
}