Problema com Java Prostgre
Venho Tendo problema com netbeans eo postgre ao fazer conexao do java com postgre o codigo correto nao apresenta nem um erro classe principal foi chamada so quando executo projeto todo postgre da erro de drive sendo que drive ja foi adicionado na biblioteca quando executoso arquivo de conexao apareçe sem classe principal como resolvo ?ja troquei versao do postgre ja baixei outros drive jdbc e nada erro continua.
codigo para conexao:package ConexaoBanco;
import java.sql.Connection;
import java.sql.ResultSetMetaData;
import java.sql.*;
import javax.swing.JOptionPane;
public class Conexão
{
public Statement stm;
public ResultSetMetaData rs;
private final String drive = "org.postgresql.Driver";
private final String caminho = "jdbc:postgresql://localhost:5432/estoque";
private final String Usuario = "postgres";
private final String Senha = "flb902312";
public Connection con;
public void conexao ()
{
try {
System.setProperty("jdbc.Drivers", drive);
con=DriverManager.getConnection(Usuario, Senha, caminho);
JOptionPane.showMessageDialog(null, "Banco Conectou com sucesso!");
} catch (SQLException ex) {
JOptionPane.showMessageDialog(null, "Erro de Conexão!\n Erro"+ex.getMessage());
}
}
public void desconecta ()
{
try {
con.close();
JOptionPane.showMessageDialog(null, "Desconectado com sucesso!");
} catch (SQLException ex) {
JOptionPane.showMessageDialog(null, "Erro ao fechar a Conexão!\n Erro"+ex.getMessage());
}
}
}
erro ao excuta : Erro de Conexao erro no suitable drive found for postgre.
codigo tela principal:package ultilitarios;
import ConexaoBanco.Conexão;
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
/**
*
* @author Barlera
*/
public class Telaprincipal extends javax.swing.JFrame {
Conexão conecta = new Conexão();
data mostra_data;
/**
* Creates new form Telaprincipal
*/
public Telaprincipal() {
initComponents();
conecta.conexao();
mostra_data = new data();
mostra_data.le_data();
label_data.setText("Data :"+mostra_data.dia+","+mostra_data.dia_semana+","+mostra_data.mes+","+mostra_data.ano);
mostra_data.le_hora();
label_hora.setText("Hora :"+mostra_data.hora);
timer1.start();
}
/**
* This method is called from within the constructor to initialize the form.
* WARNING: Do NOT modify this code. The content of this method is always
* regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jMenu1 = new javax.swing.JMenu();
timer1 = new org.netbeans.examples.lib.timerbean.Timer();
label_data = new javax.swing.JLabel();
label_hora = new javax.swing.JLabel();
jMenuBar1 = new javax.swing.JMenuBar();
Cadastro = new javax.swing.JMenu();
Clientes = new javax.swing.JMenuItem();
jSeparator2 = new javax.swing.JPopupMenu.Separator();
Funcionário = new javax.swing.JMenuItem();
jSeparator3 = new javax.swing.JPopupMenu.Separator();
Cidade = new javax.swing.JMenuItem();
jSeparator4 = new javax.swing.JPopupMenu.Separator();
Bairro = new javax.swing.JMenuItem();
jSeparator5 = new javax.swing.JPopupMenu.Separator();
Cargo = new javax.swing.JMenuItem();
jSeparator6 = new javax.swing.JPopupMenu.Separator();
Fornecedor = new javax.swing.JMenuItem();
jSeparator7 = new javax.swing.JPopupMenu.Separator();
Saiir = new javax.swing.JMenuItem();
Menu_estoque = new javax.swing.JMenu();
MenuItem_Implantacao = new javax.swing.JMenuItem();
Separador = new javax.swing.JPopupMenu.Separator();
MenuItem_Entrada = new javax.swing.JMenuItem();
jSeparator1 = new javax.swing.JPopupMenu.Separator();
MunuItem_Saida = new javax.swing.JMenuItem();
Consultas = new javax.swing.JMenu();
Relatorio = new javax.swing.JMenu();
Utilitarios = new javax.swing.JMenu();
Sair = new javax.swing.JMenu();
jMenu1.setText("jMenu1");
timer1.addTimerListener(new org.netbeans.examples.lib.timerbean.TimerListener() {
public void onTime(java.awt.event.ActionEvent evt) {
timer1OnTime(evt);
}
});
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setTitle("Monster Sistema de Estoque");
label_data.setBackground(new java.awt.Color(51, 51, 51));
label_data.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
label_data.setText("Data :");
label_hora.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
label_hora.setText("Hora :");
Cadastro.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\Cadastro.gif")); // NOI18N
Cadastro.setMnemonic('c');
Cadastro.setText("Cadastro");
Clientes.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\Clintes.gif")); // NOI18N
Clientes.setText("Clientes");
Cadastro.add(Clientes);
Cadastro.add(jSeparator2);
Funcionário.setText("Funcionários");
Cadastro.add(Funcionário);
Cadastro.add(jSeparator3);
Cidade.setText("Cidade");
Cidade.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
CidadeMouseClicked(evt);
}
});
Cidade.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
CidadeActionPerformed(evt);
}
});
Cadastro.add(Cidade);
Cadastro.add(jSeparator4);
Bairro.setText("Bairro");
Cadastro.add(Bairro);
Cadastro.add(jSeparator5);
Cargo.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\Cargo.gif")); // NOI18N
Cargo.setText("Cargo");
Cadastro.add(Cargo);
Cadastro.add(jSeparator6);
Fornecedor.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\fornecedor.gif")); // NOI18N
Fornecedor.setText("Fornecedores");
Cadastro.add(Fornecedor);
Cadastro.add(jSeparator7);
Saiir.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\Sair.gif")); // NOI18N
Saiir.setText("Sair");
Saiir.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
SaiirMouseClicked(evt);
}
public void mouseEntered(java.awt.event.MouseEvent evt) {
SaiirMouseEntered(evt);
}
});
Cadastro.add(Saiir);
jMenuBar1.add(Cadastro);
Menu_estoque.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\estoque.gif")); // NOI18N
Menu_estoque.setMnemonic('e');
Menu_estoque.setText("Estoque");
MenuItem_Implantacao.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\implantacao.gif")); // NOI18N
MenuItem_Implantacao.setText("Implantação");
Menu_estoque.add(MenuItem_Implantacao);
Menu_estoque.add(Separador);
MenuItem_Entrada.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\Entrar.gif")); // NOI18N
MenuItem_Entrada.setText("Entrada");
Menu_estoque.add(MenuItem_Entrada);
Menu_estoque.add(jSeparator1);
MunuItem_Saida.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\Sair.gif")); // NOI18N
MunuItem_Saida.setText("Saída");
Menu_estoque.add(MunuItem_Saida);
jMenuBar1.add(Menu_estoque);
Consultas.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\Consulta.gif")); // NOI18N
Consultas.setMnemonic('n');
Consultas.setText("Consultas");
jMenuBar1.add(Consultas);
Relatorio.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\relatorio.gif")); // NOI18N
Relatorio.setMnemonic('r');
Relatorio.setText("Relatórios");
jMenuBar1.add(Relatorio);
Utilitarios.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\Utilitarios.gif")); // NOI18N
Utilitarios.setMnemonic('u');
Utilitarios.setText("Utilitarios");
jMenuBar1.add(Utilitarios);
Sair.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\Sair.gif")); // NOI18N
Sair.setMnemonic('s');
Sair.setText("Sair");
Sair.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
SairMouseClicked(evt);
}
});
Sair.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
SairActionPerformed(evt);
}
});
jMenuBar1.add(Sair);
setJMenuBar(jMenuBar1);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(label_data)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 418, Short.MAX_VALUE)
.addComponent(label_hora)
.addGap(268, 268, 268))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addContainerGap(326, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(label_data)
.addComponent(label_hora))
.addContainerGap())
);
setBounds(0, 0, 800, 600);
}// </editor-fold>
private void timer1OnTime(java.awt.event.ActionEvent evt) {
mostra_data.le_hora();
label_hora.setText("Hora :"+mostra_data.hora); // TODO add your handling code here:
}
private void SairActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void SairMouseClicked(java.awt.event.MouseEvent evt) {
conecta.desconecta();
System.exit(0); // TODO add your
codigo para conexao:package ConexaoBanco;
import java.sql.Connection;
import java.sql.ResultSetMetaData;
import java.sql.*;
import javax.swing.JOptionPane;
public class Conexão
{
public Statement stm;
public ResultSetMetaData rs;
private final String drive = "org.postgresql.Driver";
private final String caminho = "jdbc:postgresql://localhost:5432/estoque";
private final String Usuario = "postgres";
private final String Senha = "flb902312";
public Connection con;
public void conexao ()
{
try {
System.setProperty("jdbc.Drivers", drive);
con=DriverManager.getConnection(Usuario, Senha, caminho);
JOptionPane.showMessageDialog(null, "Banco Conectou com sucesso!");
} catch (SQLException ex) {
JOptionPane.showMessageDialog(null, "Erro de Conexão!\n Erro"+ex.getMessage());
}
}
public void desconecta ()
{
try {
con.close();
JOptionPane.showMessageDialog(null, "Desconectado com sucesso!");
} catch (SQLException ex) {
JOptionPane.showMessageDialog(null, "Erro ao fechar a Conexão!\n Erro"+ex.getMessage());
}
}
}
erro ao excuta : Erro de Conexao erro no suitable drive found for postgre.
codigo tela principal:package ultilitarios;
import ConexaoBanco.Conexão;
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
/**
*
* @author Barlera
*/
public class Telaprincipal extends javax.swing.JFrame {
Conexão conecta = new Conexão();
data mostra_data;
/**
* Creates new form Telaprincipal
*/
public Telaprincipal() {
initComponents();
conecta.conexao();
mostra_data = new data();
mostra_data.le_data();
label_data.setText("Data :"+mostra_data.dia+","+mostra_data.dia_semana+","+mostra_data.mes+","+mostra_data.ano);
mostra_data.le_hora();
label_hora.setText("Hora :"+mostra_data.hora);
timer1.start();
}
/**
* This method is called from within the constructor to initialize the form.
* WARNING: Do NOT modify this code. The content of this method is always
* regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jMenu1 = new javax.swing.JMenu();
timer1 = new org.netbeans.examples.lib.timerbean.Timer();
label_data = new javax.swing.JLabel();
label_hora = new javax.swing.JLabel();
jMenuBar1 = new javax.swing.JMenuBar();
Cadastro = new javax.swing.JMenu();
Clientes = new javax.swing.JMenuItem();
jSeparator2 = new javax.swing.JPopupMenu.Separator();
Funcionário = new javax.swing.JMenuItem();
jSeparator3 = new javax.swing.JPopupMenu.Separator();
Cidade = new javax.swing.JMenuItem();
jSeparator4 = new javax.swing.JPopupMenu.Separator();
Bairro = new javax.swing.JMenuItem();
jSeparator5 = new javax.swing.JPopupMenu.Separator();
Cargo = new javax.swing.JMenuItem();
jSeparator6 = new javax.swing.JPopupMenu.Separator();
Fornecedor = new javax.swing.JMenuItem();
jSeparator7 = new javax.swing.JPopupMenu.Separator();
Saiir = new javax.swing.JMenuItem();
Menu_estoque = new javax.swing.JMenu();
MenuItem_Implantacao = new javax.swing.JMenuItem();
Separador = new javax.swing.JPopupMenu.Separator();
MenuItem_Entrada = new javax.swing.JMenuItem();
jSeparator1 = new javax.swing.JPopupMenu.Separator();
MunuItem_Saida = new javax.swing.JMenuItem();
Consultas = new javax.swing.JMenu();
Relatorio = new javax.swing.JMenu();
Utilitarios = new javax.swing.JMenu();
Sair = new javax.swing.JMenu();
jMenu1.setText("jMenu1");
timer1.addTimerListener(new org.netbeans.examples.lib.timerbean.TimerListener() {
public void onTime(java.awt.event.ActionEvent evt) {
timer1OnTime(evt);
}
});
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setTitle("Monster Sistema de Estoque");
label_data.setBackground(new java.awt.Color(51, 51, 51));
label_data.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
label_data.setText("Data :");
label_hora.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
label_hora.setText("Hora :");
Cadastro.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\Cadastro.gif")); // NOI18N
Cadastro.setMnemonic('c');
Cadastro.setText("Cadastro");
Clientes.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\Clintes.gif")); // NOI18N
Clientes.setText("Clientes");
Cadastro.add(Clientes);
Cadastro.add(jSeparator2);
Funcionário.setText("Funcionários");
Cadastro.add(Funcionário);
Cadastro.add(jSeparator3);
Cidade.setText("Cidade");
Cidade.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
CidadeMouseClicked(evt);
}
});
Cidade.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
CidadeActionPerformed(evt);
}
});
Cadastro.add(Cidade);
Cadastro.add(jSeparator4);
Bairro.setText("Bairro");
Cadastro.add(Bairro);
Cadastro.add(jSeparator5);
Cargo.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\Cargo.gif")); // NOI18N
Cargo.setText("Cargo");
Cadastro.add(Cargo);
Cadastro.add(jSeparator6);
Fornecedor.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\fornecedor.gif")); // NOI18N
Fornecedor.setText("Fornecedores");
Cadastro.add(Fornecedor);
Cadastro.add(jSeparator7);
Saiir.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\Sair.gif")); // NOI18N
Saiir.setText("Sair");
Saiir.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
SaiirMouseClicked(evt);
}
public void mouseEntered(java.awt.event.MouseEvent evt) {
SaiirMouseEntered(evt);
}
});
Cadastro.add(Saiir);
jMenuBar1.add(Cadastro);
Menu_estoque.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\estoque.gif")); // NOI18N
Menu_estoque.setMnemonic('e');
Menu_estoque.setText("Estoque");
MenuItem_Implantacao.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\implantacao.gif")); // NOI18N
MenuItem_Implantacao.setText("Implantação");
Menu_estoque.add(MenuItem_Implantacao);
Menu_estoque.add(Separador);
MenuItem_Entrada.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\Entrar.gif")); // NOI18N
MenuItem_Entrada.setText("Entrada");
Menu_estoque.add(MenuItem_Entrada);
Menu_estoque.add(jSeparator1);
MunuItem_Saida.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\Sair.gif")); // NOI18N
MunuItem_Saida.setText("Saída");
Menu_estoque.add(MunuItem_Saida);
jMenuBar1.add(Menu_estoque);
Consultas.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\Consulta.gif")); // NOI18N
Consultas.setMnemonic('n');
Consultas.setText("Consultas");
jMenuBar1.add(Consultas);
Relatorio.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\relatorio.gif")); // NOI18N
Relatorio.setMnemonic('r');
Relatorio.setText("Relatórios");
jMenuBar1.add(Relatorio);
Utilitarios.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\Utilitarios.gif")); // NOI18N
Utilitarios.setMnemonic('u');
Utilitarios.setText("Utilitarios");
jMenuBar1.add(Utilitarios);
Sair.setIcon(new javax.swing.ImageIcon("C:\\Users\\Barlera\\Documents\\NetBeansProjects\\Estoque\\Imagens\\Sair.gif")); // NOI18N
Sair.setMnemonic('s');
Sair.setText("Sair");
Sair.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
SairMouseClicked(evt);
}
});
Sair.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
SairActionPerformed(evt);
}
});
jMenuBar1.add(Sair);
setJMenuBar(jMenuBar1);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(label_data)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 418, Short.MAX_VALUE)
.addComponent(label_hora)
.addGap(268, 268, 268))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addContainerGap(326, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(label_data)
.addComponent(label_hora))
.addContainerGap())
);
setBounds(0, 0, 800, 600);
}// </editor-fold>
private void timer1OnTime(java.awt.event.ActionEvent evt) {
mostra_data.le_hora();
label_hora.setText("Hora :"+mostra_data.hora); // TODO add your handling code here:
}
private void SairActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void SairMouseClicked(java.awt.event.MouseEvent evt) {
conecta.desconecta();
System.exit(0); // TODO add your
Felipe Barlera
Curtidas 0