Bom dia turma do bem!!
Galera como ainda novato e aqui o melhor lugar pra se tirar duvidas estou com um problema que ja pesquisei ja procurei todas soluções e nada de encontrar ou ate mesmo de selecionar meu problema então quero ver com voces caros colegas se podem me auxiliar
tenho um JFrame1 e tenho outro Jframe2 com uma jtable que criei como se fosse uma pesquisa, mais nao seta por nada na minha jFrame1 e dar sempre um erro ao clicar no botão importar, vou postar os códigos e se puderem ajudar agradeço, estou usando o Netbeans 7.0.1 e BD MySql.
abaixo segue os codigos:
jFrame 1
package br.com.amconsu;
import br.com.amconsu.acessodb.Conexao;
import java.sql.SQLException;
import javax.swing.*;
/**
*
* @author Edvan
*/
public class Carnee extends javax.swing.JFrame {
//MaskFormatter formCpf, formCnpj, formDtnasc, formCep, formTfx, formTcel, formTtrab, formTCeptb;
public static Carnee ca;
int navega = 0;
Conexao con_carne;
//PesquisaCliente pesquisa;
detalheCarne listar;
/**
* Creates new form Clientes
*/
public Carnee() {
initComponents();
setLocationRelativeTo(null);
con_carne = new Conexao();
con_carne.conecta();
con_carne.executeSQL("SELECT * FROM CARNE");
//habilitarCampos();
try{
con_carne.resultset.last();
mostrar_dados();
}catch(SQLException erro){
JOptionPane.showMessageDialog(null, "Não foi possível localizar dados! "+erro);
}
}
buscCli busca;
/**
* 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() {
jSeparator2 = new javax.swing.JSeparator();
jLCadClient = new javax.swing.JLabel();
jPanel2 = new javax.swing.JPanel();
jPanel4 = new javax.swing.JPanel();
jBVolta = new javax.swing.JButton();
jBUltimo = new javax.swing.JButton();
jBAvanca = new javax.swing.JButton();
jBPrimeiro = new javax.swing.JButton();
codCarne = new javax.swing.JLabel();
Ndoc = new javax.swing.JTextField();
CodClie = new javax.swing.JLabel();
CodCli = new javax.swing.JTextField();
nomecli = new javax.swing.JLabel();
cliNome = new javax.swing.JTextField();
codVend = new javax.swing.JLabel();
codVende = new javax.swing.JTextField();
nomeVend = new javax.swing.JLabel();
vendnome = new javax.swing.JTextField();
jPanel5 = new javax.swing.JPanel();
parcela1 = new javax.swing.JLabel();
parcela2 = new javax.swing.JLabel();
parcela3 = new javax.swing.JLabel();
parcela4 = new javax.swing.JLabel();
parc1 = new javax.swing.JTextField();
parc2 = new javax.swing.JTextField();
parc3 = new javax.swing.JTextField();
parc4 = new javax.swing.JTextField();
situacaoPag1 = new javax.swing.JLabel();
situacaoPag2 = new javax.swing.JLabel();
situacaoPag3 = new javax.swing.JLabel();
situacaoPag4 = new javax.swing.JLabel();
Sit1 = new javax.swing.JComboBox();
Sit2 = new javax.swing.JComboBox();
Sit3 = new javax.swing.JComboBox();
Sit4 = new javax.swing.JComboBox();
parcela5 = new javax.swing.JLabel();
Vlr1 = new javax.swing.JTextField();
parcela6 = new javax.swing.JLabel();
Vlr2 = new javax.swing.JTextField();
parcela7 = new javax.swing.JLabel();
Vlr3 = new javax.swing.JTextField();
parcela8 = new javax.swing.JLabel();
Vlr4 = new javax.swing.JTextField();
jButton1 = new javax.swing.JButton();
jPanel1 = new javax.swing.JPanel();
jBNovo = new javax.swing.JButton();
jBAlterar = new javax.swing.JButton();
jBSalvar = new javax.swing.JButton();
jBCancelar = new javax.swing.JButton();
jBExcluir = new javax.swing.JButton();
setTitle("Contas à Receber");
setPreferredSize(new java.awt.Dimension(690, 545));
setResizable(false);
jLCadClient.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
jLCadClient.setText("Gerar Carnê");
jBVolta.setIcon(new javax.swing.ImageIcon("C:\\Users\\Edvan\\Documents\\NetBeansProjects\\Amigos do Consumidor\\Imagens\\imgBotoes\\registro_anterior.gif")); // NOI18N
jBVolta.setToolTipText("Voltar Registro");
jBVolta.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBVoltaActionPerformed(evt);
}
});
jBUltimo.setIcon(new javax.swing.ImageIcon("C:\\Users\\Edvan\\Documents\\NetBeansProjects\\Amigos do Consumidor\\Imagens\\imgBotoes\\ultimo_registro.gif")); // NOI18N
jBUltimo.setToolTipText("Último Registro");
jBUltimo.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBUltimoActionPerformed(evt);
}
});
jBAvanca.setIcon(new javax.swing.ImageIcon("C:\\Users\\Edvan\\Documents\\NetBeansProjects\\Amigos do Consumidor\\Imagens\\imgBotoes\\proximo_registro.gif")); // NOI18N
jBAvanca.setToolTipText("Próximo Registro");
jBAvanca.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBAvancaActionPerformed(evt);
}
});
jBPrimeiro.setIcon(new javax.swing.ImageIcon("C:\\Users\\Edvan\\Documents\\NetBeansProjects\\Amigos do Consumidor\\Imagens\\imgBotoes\\primeiro_registro.gif")); // NOI18N
jBPrimeiro.setToolTipText("Primeiro Registro");
jBPrimeiro.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBPrimeiroActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
jPanel4.setLayout(jPanel4Layout);
jPanel4Layout.setHorizontalGroup(
jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jBVolta, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jBAvanca, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jBUltimo, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jBPrimeiro, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)
);
jPanel4Layout.setVerticalGroup(
jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addComponent(jBPrimeiro, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jBVolta, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jBAvanca, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jBUltimo, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE))
);
codCarne.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
codCarne.setText("Nº Documento:");
Ndoc.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
CodClie.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
CodClie.setText("Cod. Cliente:");
CodCli.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
nomecli.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
nomecli.setText("Cliente:");
cliNome.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
codVend.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
codVend.setText("Cod. Vendedor:");
codVende.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
nomeVend.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
nomeVend.setText("Vendedor:");
vendnome.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
jPanel5.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Dados Vencimento", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Arial", 1, 14))); // NOI18N
parcela1.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
parcela1.setText("1ª Parcela:");
parcela2.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
parcela2.setText("2ª Parcela:");
parcela3.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
parcela3.setText("3ª Parcela:");
parcela4.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
parcela4.setText("4ª Parcela:");
parc1.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
parc2.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
parc3.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
parc4.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
situacaoPag1.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
situacaoPag1.setText("Situacao:");
situacaoPag2.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
situacaoPag2.setText("Situacao:");
situacaoPag3.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
situacaoPag3.setText("Situacao:");
situacaoPag4.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
situacaoPag4.setText("Situacao:");
Sit1.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
Sit1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "À RECEBER", "RECEBIDO" }));
Sit2.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
Sit2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "À RECEBER", "RECEBIDO" }));
Sit3.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
Sit3.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "À RECEBER", "RECEBIDO" }));
Sit4.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
Sit4.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "À RECEBER", "RECEBIDO" }));
parcela5.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
parcela5.setText("R$:");
Vlr1.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
parcela6.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
parcela6.setText("R$:");
Vlr2.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
parcela7.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
parcela7.setText("R$:");
Vlr3.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
parcela8.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
parcela8.setText("R$:");
Vlr4.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
javax.swing.GroupLayout jPanel5Layout = new javax.swing.GroupLayout(jPanel5);
jPanel5.setLayout(jPanel5Layout);
jPanel5Layout.setHorizontalGroup(
jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel5Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(parcela2)
.addComponent(parcela3)
.addComponent(parcela4)
.addComponent(parcela1))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(parc1, javax.swing.GroupLayout.PREFERRED_SIZE, 127, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(parc2, javax.swing.GroupLayout.PREFERRED_SIZE, 127, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(parc4, javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(parc3, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.PREFERRED_SIZE, 127, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGap(18, 18, 18)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(parcela6)
.addComponent(parcela7)
.addComponent(parcela8)
.addComponent(parcela5))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(Vlr3, javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(Vlr2, javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(Vlr1, javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(Vlr4, javax.swing.GroupLayout.PREFERRED_SIZE, 82, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 63, Short.MAX_VALUE)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel5Layout.createSequentialGroup()
.addComponent(situacaoPag1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(Sit1, javax.swing.GroupLayout.PREFERRED_SIZE, 120, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel5Layout.createSequentialGroup()
.addComponent(situacaoPag2)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(Sit2, javax.swing.GroupLayout.PREFERRED_SIZE, 120, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel5Layout.createSequentialGroup()
.addComponent(situacaoPag4)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(Sit4, javax.swing.GroupLayout.PREFERRED_SIZE, 120, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel5Layout.createSequentialGroup()
.addComponent(situacaoPag3)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(Sit3, javax.swing.GroupLayout.PREFERRED_SIZE, 120, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addContainerGap())
);
jPanel5Layout.setVerticalGroup(
jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel5Layout.createSequentialGroup()
.addContainerGap(24, Short.MAX_VALUE)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel5Layout.createSequentialGroup()
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(parcela5)
.addComponent(Vlr1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(parcela6)
.addComponent(Vlr2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(parcela7)
.addComponent(Vlr3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(parcela8)
.addComponent(Vlr4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(jPanel5Layout.createSequentialGroup()
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(parcela1)
.addComponent(parc1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(situacaoPag1)
.addComponent(Sit1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(parcela2)
.addComponent(parc2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(situacaoPag2)
.addComponent(Sit2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(parcela3)
.addComponent(parc3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(situacaoPag3)
.addComponent(Sit3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(parcela4)
.addComponent(parc4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(situacaoPag4)
.addComponent(Sit4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))))
.addGap(32, 32, 32))
);
jButton1.setText("...");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
jPanel2.setLayout(jPanel2Layout);
jPanel2Layout.setHorizontalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(CodClie)
.addComponent(nomecli)
.addComponent(nomeVend)
.addComponent(codCarne)
.addComponent(codVend))
.addGap(7, 7, 7)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(codVende, javax.swing.GroupLayout.PREFERRED_SIZE, 88, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel2Layout.createSequentialGroup()
.addComponent(CodCli, javax.swing.GroupLayout.PREFERRED_SIZE, 90, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButton1))
.addComponent(Ndoc, javax.swing.GroupLayout.PREFERRED_SIZE, 127, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(cliNome, javax.swing.GroupLayout.DEFAULT_SIZE, 479, Short.MAX_VALUE)
.addComponent(vendnome))
.addGap(26, 26, 26)
.addComponent(jPanel4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel2Layout.createSequentialGroup()
.addGap(22, 22, 22)
.addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addContainerGap(24, Short.MAX_VALUE))
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(jPanel4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(codCarne)
.addComponent(Ndoc, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(CodClie)
.addComponent(CodCli, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton1))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(nomecli)
.addComponent(cliNome, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(4, 4, 4)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(codVend)
.addComponent(codVende, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(nomeVend)
.addComponent(vendnome, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addGap(18, 18, 18)
.addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(74, Short.MAX_VALUE))
);
jBNovo.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
jBNovo.setText("Novo");
jBNovo.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBNovoActionPerformed(evt);
}
});
jBAlterar.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
jBAlterar.setText("Alterar");
jBAlterar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBAlterarActionPerformed(evt);
}
});
jBSalvar.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
jBSalvar.setText("Salvar");
jBSalvar.setEnabled(false);
jBSalvar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBSalvarActionPerformed(evt);
}
});
jBCancelar.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
jBCancelar.setText("Listar Todos Clientes");
jBCancelar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBCancelarActionPerformed(evt);
}
});
jBExcluir.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
jBExcluir.setText("Excluir");
jBExcluir.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBExcluirActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jBNovo, javax.swing.GroupLayout.PREFERRED_SIZE, 58, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jBAlterar)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jBSalvar, javax.swing.GroupLayout.PREFERRED_SIZE, 81, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jBCancelar, javax.swing.GroupLayout.PREFERRED_SIZE, 151, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jBExcluir)
.addContainerGap())
);
jPanel1Layout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new java.awt.Component[] {jBAlterar, jBExcluir, jBNovo, jBSalvar});
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE, false)
.addComponent(jBNovo, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jBAlterar, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jBCancelar, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jBExcluir, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jBSalvar, javax.swing.GroupLayout.PREFERRED_SIZE, 45, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jPanel1Layout.linkSize(javax.swing.SwingConstants.VERTICAL, new java.awt.Component[] {jBAlterar, jBCancelar, jBExcluir, jBNovo, jBSalvar});
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()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jSeparator2, javax.swing.GroupLayout.PREFERRED_SIZE, 1, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLCadClient))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(24, 24, 24))
.addGroup(layout.createSequentialGroup()
.addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(17, Short.MAX_VALUE))))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLCadClient, javax.swing.GroupLayout.PREFERRED_SIZE, 38, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jSeparator2, javax.swing.GroupLayout.PREFERRED_SIZE, 2, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(26, 26, 26))
.addGroup(layout.createSequentialGroup()
.addGap(20, 20, 20)
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
pack();
}// </editor-fold>
private void novoCarne(){
habilitarCampos();
Ndoc.setText("");
CodCli.setText("");
cliNome.setText("");
codVende.setText("");
vendnome.setText("");
parc1.setText("");
parc2.setText("");
parc3.setText("");
parc4.setText("");
Vlr1.setText("14.99");
Vlr2.setText("14.99");
Vlr3.setText("14.99");
Vlr4.setText("14.99");
Sit1.setSelectedItem("À RECEBER");
Sit2.setSelectedItem("À RECEBER");
Sit3.setSelectedItem("À RECEBER");
Sit4.setSelectedItem("À RECEBER");
CodCli.requestFocus();
}
private boolean verificarCampos(){
if(!cliNome.getText().trim().equals("") ){
return true;
}
return false;
}
private void habilitarCampos(){
//Ndoc.setEditable(true);
CodCli.setEditable(true);
cliNome.setEditable(true);
codVende.setEditable(true);
vendnome.setEditable(true);
parc1.setEditable(true);
parc2.setEditable(true);
parc3.setEditable(true);
parc4.setEditable(true);
Vlr1.setEditable(true);
Vlr2.setEditable(true);
Vlr3.setEditable(true);
Vlr4.setEditable(true);
Sit1.setEnabled(true);
Sit2.setEnabled(true);
Sit3.setEnabled(true);
Sit4.setEnabled(true);
jBSalvar.setEnabled(true);
}
private void jBNovoActionPerformed(java.awt.event.ActionEvent evt) {
novoCarne();
}
private void jBSalvarActionPerformed(java.awt.event.ActionEvent evt) {
try{
String sql = "",tipo="";
if (Ndoc.getText().equals(""))
{
sql = "INSERT INTO CARNE (cliente_cod_cliente, cliente_nome, "
+ "vendedor_codVend, vendedor_nomeVend, 1parcela, vlr1, "
+ "situacaoPag1, 2parcela, vlr2, situacaoPag2, "
+ "3parcela, vlr3, situacaoPag3, 4parcela, vlr4, situacaoPag4) values ('"+
CodCli.getText()+"','"+
cliNome.getText()+"','"+
codVende.getText()+"','"+
vendnome.getText()+"','"+
parc1.getText()+"','"+
Vlr1.getText()+"','"+
Sit1.getSelectedItem()+"','"+
parc2.getText()+"','"+
Vlr2.getText()+"','"+
Sit2.getSelectedItem()+"','"+
parc3.getText()+"','"+
Vlr3.getText()+"','"+
Sit3.getSelectedItem()+"','"+
parc4.getText()+"','"+
Vlr4.getText()+"','"+
Sit4.getSelectedItem()+"')";
tipo= "Gravação de Novo registro ";
}
else
{
sql ="UPDATE carne SET cliente_cod_cliente = '"+CodCli.getText()+"', "
+ "cliente_nome = '"+cliNome.getText()+ "',"
+ " vendedor_codVend = '"+codVende.getText()+"', vendedor_nomeVend = '"+vendnome.getText()+"', "
+ "1parcela = '"+parc1.getText()+"',2parcela = '"+parc2.getText()+"', "
+ "3parcela = '"+parc3.getText()+"', 4parcela = '"+parc4.getText()+"',"
+ " vlr1 = '"+Vlr1.getText()+"', vlr2 = '"+Vlr2.getText()+"',"
+ " vlr3 = '"+Vlr3.getText()+"', vlr4 = '"+Vlr4.getText()+"',"
+ " situacaoPag1 = '"+Sit1.getSelectedItem()+"', situacaoPag2 = '"+Sit2.getSelectedItem()+"',"
+ " situacaoPag3 = '"+Sit3.getSelectedItem()+"', situacaoPag4 = '"+Sit4.getSelectedItem()+"' where codCarne = "+Ndoc.getText();
tipo= "Alteração de registro ";
}
con_carne.statement.executeUpdate(sql);
JOptionPane.showMessageDialog(null,tipo + "realizada com sucesso!");
con_carne.resultset = con_carne.statement.executeQuery("SELECT * FROM carne");
con_carne.resultset.first();
mostrar_dados();
}catch(SQLException erro){
JOptionPane.showMessageDialog(null, "Erro ao tentar gravar registro!");
}
}
private void jBExcluirActionPerformed(java.awt.event.ActionEvent evt) {
try{
String sql = "SELECT * FROM CARNE WHERE codCarne = "+Ndoc.getText();
con_carne.executeSQL(sql);
con_carne.resultset.next();
String nome = "Excluir o documento : "+con_carne.resultset.getString("cliente_nome")+" ?";
int opcao_escolhida = JOptionPane.showConfirmDialog(null,nome,"Exclusão ",JOptionPane.YES_NO_CANCEL_OPTION);
if (opcao_escolhida == JOptionPane.YES_OPTION)
{
sql = "DELETE FROM carne WHERE codCarne ="+Ndoc.getText();
int conseguiu_excluir = con_carne.statement.executeUpdate(sql);
if (conseguiu_excluir == 1)
{
JOptionPane.showMessageDialog(null, "Exclusão realizada com sucesso");
con_carne.executeSQL("SELECT * FROM carne");
con_carne.resultset.next();
mostrar_dados();
}
}else
return;
}catch(SQLException erro){
JOptionPane.showMessageDialog(null, "Erro ao tentar excluir registro...");
}
}
private void jBAlterarActionPerformed(java.awt.event.ActionEvent evt) {
habilitarCampos();
}
private void mostrarListar(){
if (listar == null);{
listar = new detalheCarne();
listar.setVisible(true);
}
}
private void jBCancelarActionPerformed(java.awt.event.ActionEvent evt) {
mostrarListar();
}
private void jBPrimeiroActionPerformed(java.awt.event.ActionEvent evt) {
try {
con_carne.resultset.first();
mostrar_dados();
} catch (SQLException erro) {
JOptionPane.showMessageDialog(null, "Não foi possível localizar primeiro registro! " + erro);
}
}
private void jBAvancaActionPerformed(java.awt.event.ActionEvent evt) {
try {
con_carne.resultset.next();
mostrar_dados();
navega = 2;
} catch (SQLException erro) {
JOptionPane.showMessageDialog(null, "Não foi possível localizar próximo registro! " + erro);
}
}
private void jBUltimoActionPerformed(java.awt.event.ActionEvent evt) {
try {
con_carne.resultset.last();
mostrar_dados();
} catch (SQLException erro) {
JOptionPane.showMessageDialog(null, "Não foi possível localizar último registro! " + erro);
}
}
private void jBVoltaActionPerformed(java.awt.event.ActionEvent evt) {
try {
con_carne.resultset.previous();
mostrar_dados();
navega = 1;
} catch (SQLException erro) {
JOptionPane.showMessageDialog(null, "Não foi possível localizar registro anterior! " + erro);
}
}
private void mostrarbuscCli(){
if (busca == null);{
busca = new buscCli();
busca.setVisible(true);
} // else {
//clientes.setVisible(true);
//}
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
//mostrarbuscCli();
//buscCli bc = new buscCli();
//bc.recebeObjeto(ca);
//bc.setVisible(true);
String args[] = new String [1];
args[0] = "Busca Cliente e Importa dados";
buscCli.main(args);
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
/*
* Set the Nimbus look and feel
*/
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/*
* If Nimbus (introduced in Java SE 6) is not available, stay with the
* default look and feel. For details see
* http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(Carnee.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(Carnee.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(Carnee.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(Carnee.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
/*
* Create and display the form
*/
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
ca = new Carnee();
new Carnee().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JTextField CodCli;
private javax.swing.JLabel CodClie;
private javax.swing.JTextField Ndoc;
private javax.swing.JComboBox Sit1;
private javax.swing.JComboBox Sit2;
private javax.swing.JComboBox Sit3;
private javax.swing.JComboBox Sit4;
private javax.swing.JTextField Vlr1;
private javax.swing.JTextField Vlr2;
private javax.swing.JTextField Vlr3;
private javax.swing.JTextField Vlr4;
private javax.swing.JTextField cliNome;
private javax.swing.JLabel codCarne;
private javax.swing.JLabel codVend;
private javax.swing.JTextField codVende;
private javax.swing.JButton jBAlterar;
private javax.swing.JButton jBAvanca;
private javax.swing.JButton jBCancelar;
private javax.swing.JButton jBExcluir;
private javax.swing.JButton jBNovo;
private javax.swing.JButton jBPrimeiro;
private javax.swing.JButton jBSalvar;
private javax.swing.JButton jBUltimo;
private javax.swing.JButton jBVolta;
private javax.swing.JButton jButton1;
private javax.swing.JLabel jLCadClient;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JPanel jPanel4;
private javax.swing.JPanel jPanel5;
private javax.swing.JSeparator jSeparator2;
private javax.swing.JLabel nomeVend;
private javax.swing.JLabel nomecli;
private javax.swing.JTextField parc1;
private javax.swing.JTextField parc2;
private javax.swing.JTextField parc3;
private javax.swing.JTextField parc4;
private javax.swing.JLabel parcela1;
private javax.swing.JLabel parcela2;
private javax.swing.JLabel parcela3;
private javax.swing.JLabel parcela4;
private javax.swing.JLabel parcela5;
private javax.swing.JLabel parcela6;
private javax.swing.JLabel parcela7;
private javax.swing.JLabel parcela8;
private javax.swing.JLabel situacaoPag1;
private javax.swing.JLabel situacaoPag2;
private javax.swing.JLabel situacaoPag3;
private javax.swing.JLabel situacaoPag4;
private javax.swing.JTextField vendnome;
// End of variables declaration
public void mostrar_dados(){
try{
Ndoc.setText(con_carne.resultset.getString("codCarne"));
CodCli.setText(con_carne.resultset.getString("cliente_cod_cliente"));
cliNome.setText(con_carne.resultset.getString("cliente_nome"));
codVende.setText(con_carne.resultset.getString("vendedor_codVend"));
vendnome.setText(con_carne.resultset.getString("vendedor_nomeVend"));
parc1.setText(con_carne.resultset.getString("1parcela"));
parc2.setText(con_carne.resultset.getString("2parcela"));
parc3.setText(con_carne.resultset.getString("3parcela"));
parc4.setText(con_carne.resultset.getString("4parcela"));
Vlr1.setText(con_carne.resultset.getString("vlr1"));
Vlr2.setText(con_carne.resultset.getString("vlr2"));
Vlr3.setText(con_carne.resultset.getString("vlr3"));
Vlr4.setText(con_carne.resultset.getString("vlr4"));
Sit1.setSelectedItem(con_carne.resultset.getString("situacaoPag1"));
Sit2.setSelectedItem(con_carne.resultset.getString("situacaoPag2"));
Sit3.setSelectedItem(con_carne.resultset.getString("situacaoPag3"));
Sit4.setSelectedItem(con_carne.resultset.getString("situacaoPag4"));
}catch(SQLException erro){
if (navega == 1)
JOptionPane.showMessageDialog(null, "Você já está no primeiro registro");
else if (navega == 2)
JOptionPane.showMessageDialog(null, "Você já está no último registro");
else
JOptionPane.showMessageDialog(null, "Não foi possível localizar dados! "+erro);
} navega = 0;
}
/**
* @param cliNome the cliNome to set
*/
public void setcliNome(String cliNome) {
this.cliNome.setText(cliNome);
}
/**
* @param CodCli the CodCli to set
*/
public void setcodCli(String CodCli) {
this.CodCli.setText(CodCli);
}
}
jFrame2
package br.com.amconsu;
import br.com.amconsu.acessodb.Conexao;
import br.com.amconsu.Carnee;
import java.sql.SQLException;
import java.util.List;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
/**
*
* @author Edvan
*/
public class buscCli extends javax.swing.JFrame {
/**
* Creates new form buscCli
*/
Conexao con_carne;
public buscCli() {
initComponents();
setLocationRelativeTo(null);
con_carne =new Conexao();
con_carne.conecta();
con_carne.executeSQL("select * from cliente");
preencher_tab();
}
/**
* 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() {
bindingGroup = new org.jdesktop.beansbinding.BindingGroup();
rowSorterToStringConverter1 = new br.com.amconsu.convert.RowSorterToStringConverter();
jLabel1 = new javax.swing.JLabel();
jTextField1 = new javax.swing.JTextField();
jButton1 = new javax.swing.JButton();
jScrollPane2 = new javax.swing.JScrollPane();
TabBC = new javax.swing.JTable();
rowSorterToStringConverter1.setTable(TabBC);
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
jLabel1.setText("Localizar:");
jTextField1.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
org.jdesktop.beansbinding.Binding binding = org.jdesktop.beansbinding.Bindings.createAutoBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, TabBC, org.jdesktop.beansbinding.ELProperty.create("${rowSorter}"), jTextField1, org.jdesktop.beansbinding.BeanProperty.create("text"), "");
binding.setConverter(rowSorterToStringConverter1);
bindingGroup.addBinding(binding);
jButton1.setText("Importar");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
TabBC.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
},
new String [] {
"Código", "Nome", "CPF", "CNPJ", "Endereço"
}
) {
Class[] types = new Class [] {
java.lang.Integer.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class
};
public Class getColumnClass(int columnIndex) {
return types [columnIndex];
}
});
TabBC.setAutoResizeMode(javax.swing.JTable.AUTO_RESIZE_OFF);
jScrollPane2.setViewportView(TabBC);
TabBC.getColumnModel().getColumn(0).setPreferredWidth(80);
TabBC.getColumnModel().getColumn(1).setPreferredWidth(250);
TabBC.getColumnModel().getColumn(2).setPreferredWidth(150);
TabBC.getColumnModel().getColumn(3).setPreferredWidth(150);
TabBC.getColumnModel().getColumn(4).setPreferredWidth(300);
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()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jTextField1, javax.swing.GroupLayout.DEFAULT_SIZE, 450, Short.MAX_VALUE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButton1))
.addComponent(jScrollPane2))
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 300, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 39, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1)
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton1))
.addGap(27, 27, 27))
);
bindingGroup.bind();
pack();
}// </editor-fold>
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
Carnee.ca.setcodCli((String)TabBC.getValueAt(TabBC.getSelectedRow(), 0));
Carnee.ca.setcliNome((String)TabBC.getValueAt(TabBC.getSelectedRow(), 1));
dispose();
}
/**
* @param args the command line arguments
*/
public static void main(final String args[]) {
/*
* Set the Nimbus look and feel
*/
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/*
* If Nimbus (introduced in Java SE 6) is not available, stay with the
* default look and feel. For details see
* http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(buscCli.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(buscCli.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(buscCli.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(buscCli.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
/*
* Create and display the form
*/
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new buscCli().setVisible(true);
//setTitle(args[0]);
}
});
}
// Variables declaration - do not modify
private javax.swing.JTable TabBC;
private javax.swing.JButton jButton1;
private javax.swing.JLabel jLabel1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JTextField jTextField1;
private br.com.amconsu.convert.RowSorterToStringConverter rowSorterToStringConverter1;
private org.jdesktop.beansbinding.BindingGroup bindingGroup;
// End of variables declaration
public void preencher_tab(){
TabBC.getColumnModel().getColumn(0).setPreferredWidth(80);
TabBC.getColumnModel().getColumn(1).setPreferredWidth(250);
TabBC.getColumnModel().getColumn(2).setPreferredWidth(150);
TabBC.getColumnModel().getColumn(3).setPreferredWidth(150);
TabBC.getColumnModel().getColumn(4).setPreferredWidth(300);
DefaultTableModel modelo = (DefaultTableModel)TabBC.getModel();
modelo.setNumRows(0);
try{
while (con_carne.resultset.next())
modelo.addRow(new Object[]{con_carne.resultset.getString("cod_cliente"),
con_carne.resultset.getString("nome"), con_carne.resultset.getString("cpf"),
con_carne.resultset.getString("cnpj"), con_carne.resultset.getString("endereco")});
}catch(SQLException erro){
JOptionPane.showMessageDialog(null, "Erro ao listar dados!"+erro);
}
}
/**private br.com.amconsu.Carnee ca;
void recebeObjeto(br.com.amconsu.Carnee ca){
this.ca = ca;
}*/
//void recebeObjeto() {
//this.bc = bc;
//}
}
erro é esse:
Exception in thread “AWT-EventQueue-0” java.lang.NullPointerException
at br.com.amconsu.buscCli.jButton1ActionPerformed(buscCli.java:130)
at br.com.amconsu.buscCli.access$000(buscCli.java:17)
at br.com.amconsu.buscCli$1.actionPerformed(buscCli.java:66)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6505)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
at java.awt.Component.processEvent(Component.java:6270)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.dispatchEventImpl(Component.java:4861)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEvent(Component.java:4687)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
at java.awt.Container.dispatchEventImpl(Container.java:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2719)
at java.awt.Component.dispatchEvent(Component.java:4687)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:703)
at java.awt.EventQueue.access$000(EventQueue.java:102)
at java.awt.EventQueue$3.run(EventQueue.java:662)
at java.awt.EventQueue$3.run(EventQueue.java:660)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:676)
at java.awt.EventQueue$4.run(EventQueue.java:674)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:673)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:244)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:147)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:139)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:97)
como ainda sou novato aqui no Forum ainda estou pegando o jeito de postar as duvidas, de ja agradeço a todos
se puderem ajudar agradeço muito