[quote=nbluis]Posta o código da tua classe ConsClientes.
Ela tem um construtor publico sem parâmetro (mesmo que implicito) ?
DICA: Tente usar nomes reais em seus objetos ConsClientes não é lá muito sugestivo.[/quote]
OK, segue o código, ConsClientes (Consulta Cliente) (jDialog)
/*
* ConsClientes.java
*
* Created on 29 de Abril de 2008, 21:14
*/
package adminofcv4;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
/**
*
* @author renato
*/
public class ConsClientes extends javax.swing.JDialog {
/** Creates new form ConsClientes */
public ConsClientes(java.awt.Frame parent, boolean modal) {
super(parent, modal);
initComponents();
}
/** 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.
*/
// <editor-fold defaultstate="collapsed" desc=" Código Gerado ">//GEN-BEGIN:initComponents
private void initComponents() {
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
cNome = new javax.swing.JTextField();
cCPF = new javax.swing.JTextField();
jLabel1 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jButton1 = new javax.swing.JButton();
bFiltrar = new javax.swing.JButton();
LabelReg = new javax.swing.JLabel();
setDefaultCloseOperation(javax.swing.WindowConstants.DO_NOTHING_ON_CLOSE);
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowOpened(java.awt.event.WindowEvent evt) {
formWindowOpened(evt);
}
});
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
},
new String [] {
"ID", "Nome", "Telefone", "Email", "Bairro", "Endereço"
}
) {
boolean[] canEdit = new boolean [] {
false, false, false, false, false, false
};
public boolean isCellEditable(int rowIndex, int columnIndex) {
return canEdit [columnIndex];
}
});
jScrollPane1.setViewportView(jTable1);
cNome.addFocusListener(new java.awt.event.FocusAdapter() {
public void focusLost(java.awt.event.FocusEvent evt) {
cNomeFocusLost(evt);
}
});
cNome.addPropertyChangeListener(new java.beans.PropertyChangeListener() {
public void propertyChange(java.beans.PropertyChangeEvent evt) {
cNomePropertyChange(evt);
}
});
cNome.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
cNomeKeyPressed(evt);
}
});
cCPF.addFocusListener(new java.awt.event.FocusAdapter() {
public void focusLost(java.awt.event.FocusEvent evt) {
cCPFFocusLost(evt);
}
});
cCPF.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
cCPFKeyPressed(evt);
}
});
jLabel1.setText("Primeiro e/ou segundo nome do cliente");
jLabel3.setText("CPF/CNPJ");
jButton1.setText("OK");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
bFiltrar.setText("jButton3");
bFiltrar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
bFiltrarActionPerformed(evt);
}
});
LabelReg.setFont(new java.awt.Font("Tahoma", 0, 9));
LabelReg.setForeground(new java.awt.Color(102, 102, 255));
LabelReg.setText(".");
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)
.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 586, Short.MAX_VALUE)
.addComponent(LabelReg, javax.swing.GroupLayout.PREFERRED_SIZE, 99, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel1)
.addComponent(cNome, javax.swing.GroupLayout.PREFERRED_SIZE, 276, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(cCPF, javax.swing.GroupLayout.PREFERRED_SIZE, 111, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(bFiltrar, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(95, 95, 95)
.addComponent(jButton1, javax.swing.GroupLayout.DEFAULT_SIZE, 69, Short.MAX_VALUE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED))
.addComponent(jLabel3))))
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addContainerGap()
.addComponent(LabelReg, javax.swing.GroupLayout.PREFERRED_SIZE, 11, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 269, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 9, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1)
.addComponent(jLabel3))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton1)
.addComponent(bFiltrar, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(cCPF, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(cNome, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap())
);
pack();
}// </editor-fold>//GEN-END:initComponents
private void cCPFKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_cCPFKeyPressed
if(evt.getKeyCode() == 10 ){
jTable1.requestFocus();
}
}//GEN-LAST:event_cCPFKeyPressed
private void cCPFFocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_cCPFFocusLost
if (!cCPF.getText().trim().equals("")) {
modelo = (javax.swing.table.DefaultTableModel)jTable1.getModel();
cNome.setText("");
/*
for(int i=0; i < modelo.getRowCount(); i++ ){
modelo.removeRow(i);
//modelo.e((SimplesTableModel)modelo.getModel()).fireTableRowsDeleted(i);}
}
*/
ConectaDB banco = new ConectaDB();
banco.Conectar();
AbreTabela Clientes = new AbreTabela(banco.con);
// filtro pelo CPF ou cgc!
Clientes.Abrir("select \"Cli_ID\",\"Cli_Nome\",\"Cli_Telefone1\",\"Cli_Email1\",\"Cli_Bairro\",\"Cli_Endereco\" from \"Clientes\" WHERE \"Cli_CPF_CNPJ\" = '"+cCPF.getText()+"' ORDER BY \"Cli_Nome\" desc" );
if (!Clientes.Next()){
LabelReg.setText("0 Registro(s) encontrado(s)");
banco.Desconectar();
cCPF.requestFocus();
return;
}
Clientes.Last();
do{
Object[] args = {Clientes.FieldByName("Cli_ID"),Clientes.FieldByName("Cli_Nome"),Clientes.FieldByName("Cli_Telefone1"),Clientes.FieldByName("Cli_Email1"),Clientes.FieldByName("Cli_Bairro"),Clientes.FieldByName("Cli_Endereco")};
modelo.addRow(args);
}while(Clientes.Prev());
LabelReg.setText(modelo.getRowCount()+" Registro(s) encontrado(s)");
banco.Desconectar();
jTable1.requestFocus();
}
}//GEN-LAST:event_cCPFFocusLost
private void formWindowOpened(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_formWindowOpened
// TODO adicione seu código de manipulação aqui:
cNome.requestFocus();
}//GEN-LAST:event_formWindowOpened
private void cNomePropertyChange(java.beans.PropertyChangeEvent evt) {//GEN-FIRST:event_cNomePropertyChange
// TODO adicione seu código de manipulação aqui:
}//GEN-LAST:event_cNomePropertyChange
private void bFiltrarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_bFiltrarActionPerformed
if (cNome.getText().trim().equals("") && cCPF.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null,"Informe o nome ou CPF/CNPJ","Atenção", JOptionPane.INFORMATION_MESSAGE);
cNome.requestFocus();
return ;
}
if (!cNome.getText().trim().equals("")) {
cCPF.setText("");
}
modelo = (javax.swing.table.DefaultTableModel)jTable1.getModel();
/*
for(int i=0; i < modelo.getRowCount(); i++ ){
modelo.removeRow(i);
//modelo.e((SimplesTableModel)modelo.getModel()).fireTableRowsDeleted(i);}
}
*/
ConectaDB banco = new ConectaDB();
banco.Conectar();
AbreTabela Clientes = new AbreTabela(banco.con);
if (!cNome.getText().trim().equals("")) {
// filtro pelo nome
Clientes.Abrir("select \"Cli_ID\",\"Cli_Nome\",\"Cli_Telefone1\",\"Cli_Email1\",\"Cli_Bairro\",\"Cli_Endereco\" from \"Clientes\" WHERE \"Cli_Nome\" LIKE '%"+cNome.getText()+"%' ORDER BY \"Cli_Nome\" desc" );
}else{
// filtro pelo CPF ou cgc!
Clientes.Abrir("select \"Cli_ID\",\"Cli_Nome\",\"Cli_Telefone1\",\"Cli_Email1\",\"Cli_Bairro\",\"Cli_Endereco\" from \"Clientes\" WHERE \"Cli_CPF_CNPJ\" = '"+cCPF.getText()+"' ORDER BY \"Cli_Nome\" desc" );
}
if (!Clientes.Next()){
LabelReg.setText("0 Registro(s) encontrado(s)");
banco.Desconectar();
cNome.requestFocus();
return;
}
Clientes.Last();
do{
Object[] args = {Clientes.FieldByName("Cli_ID"),Clientes.FieldByName("Cli_Nome"),Clientes.FieldByName("Cli_Telefone1"),Clientes.FieldByName("Cli_Email1"),Clientes.FieldByName("Cli_Bairro"),Clientes.FieldByName("Cli_Endereco")};
modelo.addRow(args);
}while(Clientes.Prev());
LabelReg.setText(modelo.getRowCount()+" Registro(s) encontrado(s)");
banco.Desconectar();
}//GEN-LAST:event_bFiltrarActionPerformed
private void cNomeKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_cNomeKeyPressed
if(evt.getKeyCode() == 10 ){
cCPF.requestFocus();
}
}//GEN-LAST:event_cNomeKeyPressed
private void cNomeFocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_cNomeFocusLost
cNome.setText(cNome.getText().toUpperCase());
if (!cNome.getText().trim().equals("")) {
cCPF.setText("");
modelo = (javax.swing.table.DefaultTableModel)jTable1.getModel();
JOptionPane.showMessageDialog(null,"Total de Regs: "+modelo.getRowCount(),"Aviso",JOptionPane.ERROR_MESSAGE );
if (modelo.getRowCount() > 0) {
for(int i= 0; i <= modelo.getRowCount(); i++ ){
modelo.removeRow (i);
}
}
ConectaDB banco = new ConectaDB();
banco.Conectar();
AbreTabela Clientes = new AbreTabela(banco.con);
// filtro pelo nome
Clientes.Abrir("select \"Cli_ID\",\"Cli_Nome\",\"Cli_Telefone1\",\"Cli_Email1\",\"Cli_Bairro\",\"Cli_Endereco\" from \"Clientes\" WHERE \"Cli_Nome\" LIKE '%"+cNome.getText()+"%' ORDER BY \"Cli_Nome\" desc" );
if (!Clientes.Next()){
LabelReg.setText("0 Registro(s) encontrado(s)");
banco.Desconectar();
cNome.requestFocus();
return;
}
Clientes.Last();
do{
Object[] args = {Clientes.FieldByName("Cli_ID"),Clientes.FieldByName("Cli_Nome"),Clientes.FieldByName("Cli_Telefone1"),Clientes.FieldByName("Cli_Email1"),Clientes.FieldByName("Cli_Bairro"),Clientes.FieldByName("Cli_Endereco")};
modelo.addRow(args);
}while(Clientes.Prev());
LabelReg.setText(modelo.getRowCount()+" Registro(s) encontrado(s)");
banco.Desconectar();
jTable1.requestFocus();
}
}//GEN-LAST:event_cNomeFocusLost
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
this.dispose();
}//GEN-LAST:event_jButton1ActionPerformed
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new ConsClientes(new javax.swing.JFrame(), true).setVisible(true);
}
});
}
// Declaração de variáveis - não modifique//GEN-BEGIN:variables
private javax.swing.JLabel LabelReg;
private javax.swing.JButton bFiltrar;
private javax.swing.JTextField cCPF;
private javax.swing.JTextField cNome;
private javax.swing.JButton jButton1;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel3;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable jTable1;
// Fim da declaração de variáveis//GEN-END:variables
private DefaultTableModel modelo;
}
e valeu pela dica!!!
at+