Como editar um cadastro

xandebassget · Abril 23, 2008, 10:33am

com faço para editar um cadastro quando eu clicar num botão permitr altera este cadastro

colored · Abril 23, 2008, 10:34am

Que cadastro ? -]

colored · Abril 23, 2008, 10:35am

posta a parte do codigo e especifica um pk melhor o problema

xandebassget · Abril 23, 2008, 10:40am

eu estou usando o netbeans 5.5

como criar um botão de editar
quando clicar nele permitir altera os dados
do programa

RobsonFagundes · Abril 23, 2008, 10:46am

[quote=xandebassget]eu estou usando o netbeans 5.5

como criar um botão de editar
quando clicar nele permitir altera os dados
do programa[/quote]

Caro xandebassget, pelo q entendi vc tem esses dados percistidos em algum Banco certo ???
vc faz uma consulta disso e seta eles na sua tela é isso???
ta e vc quer percisti-los novamente depois de “alterados” no banco certo?
cara vc tera q criar um metodo ALTERAR no seu Dao ou sei la a classe q vc ta usando pra percistir esses objetos.
ou vc nao fez nada disso nao sabe nem como gravar no BD ???
seja mais claro Colega
Abraço

xandebassget · Abril 23, 2008, 10:49am

package cadastro;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
import oracle.toplink.essentials.internal.expressions.SQLInsertStatement;
import ultilitario.conexao;

/**
*

@author Administrador
*/
public class cidade extends javax.swing.JFrame {

conexao con_cidade;

/** Creates new form cidade */
public cidade() {
initComponents();
```
 con_cidade = new conexao();
 con_cidade.conecta();
 con_cidade.executeSQL("select * FROM cidade");
  
 try
{
 con_cidade.resultset.first();
 codigo.setText(con_cidade.resultset.getString("codigo"));
 nome.setText(con_cidade.resultset.getString("nome"));
 uf.setSelectedItem(con_cidade.resultset.getString("uf"));
 codigo.setEditable(false);
 nome.setEditable(false);
```
}
catch(SQLException erro)
{
JOptionPane.showMessageDialog(null,“Não localizou dados”+erro);
}
preencher_table();
}

/** 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.
  */
  //
  private void initComponents() {
  jTabbedPane1 = new javax.swing.JTabbedPane();
  jPanel4 = new javax.swing.JPanel();
  jScrollPane1 = new javax.swing.JScrollPane();
  jTable1 = new javax.swing.JTable();
  jPanel5 = new javax.swing.JPanel();
  jPanel1 = new javax.swing.JPanel();
  jLabel1 = new javax.swing.JLabel();
  jTextField1 = new javax.swing.JTextField();
  jTextField2 = new javax.swing.JTextField();
  jPanel3 = new javax.swing.JPanel();
  jButton1 = new javax.swing.JButton();
  jButton2 = new javax.swing.JButton();
  jButton3 = new javax.swing.JButton();
  jButton4 = new javax.swing.JButton();
  jButton5 = new javax.swing.JButton();
  jButton6 = new javax.swing.JButton();
  jButton7 = new javax.swing.JButton();
  jButton8 = new javax.swing.JButton();
  jButton9 = new javax.swing.JButton();
  jPanel2 = new javax.swing.JPanel();
  jLabel4 = new javax.swing.JLabel();
  uf = new javax.swing.JComboBox();
  jLabel2 = new javax.swing.JLabel();
  jLabel3 = new javax.swing.JLabel();
  nome = new javax.swing.JTextField();
  codigo = new javax.swing.JTextField();
  
  setTitle(“Cadastro de Cidades”);
  setResizable(false);
  jTabbedPane1.setBorder(javax.swing.BorderFactory.createEtchedBorder());
  jTabbedPane1.setPreferredSize(new java.awt.Dimension(440, 670));
  jPanel4.setBorder(javax.swing.BorderFactory.createEmptyBorder(1, 1, 1, 1));
  jTable1.setModel(new javax.swing.table.DefaultTableModel(
  new Object [][] {
  {null, null, null},
  {null, null, null},
  {null, null, null},
  {null, null, null}
  },
  new String [] {
  “Codigo”, “Nome”, “UF”
  }
  ));
  jScrollPane1.setViewportView(jTable1);
  
  org.jdesktop.layout.GroupLayout jPanel4Layout = new org.jdesktop.layout.GroupLayout(jPanel4);
  jPanel4.setLayout(jPanel4Layout);
  jPanel4Layout.setHorizontalGroup(
  jPanel4Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
  .add(jPanel4Layout.createSequentialGroup()
  .addContainerGap()
  .add(jScrollPane1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 656, Short.MAX_VALUE)
  .addContainerGap())
  );
  jPanel4Layout.setVerticalGroup(
  jPanel4Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
  .add(jPanel4Layout.createSequentialGroup()
  .addContainerGap()
  .add(jScrollPane1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 402, Short.MAX_VALUE)
  .addContainerGap())
  );
  jTabbedPane1.addTab(“Pesquisa”, jPanel4);
  
  jPanel5.setBorder(javax.swing.BorderFactory.createEtchedBorder());
  jPanel1.setBorder(javax.swing.BorderFactory.createEtchedBorder());
  jPanel1.setPreferredSize(new java.awt.Dimension(0, 0));
  jLabel1.setText(“Pesquisar:”);
  
  org.jdesktop.layout.GroupLayout jPanel1Layout = new org.jdesktop.layout.GroupLayout(jPanel1);
  jPanel1.setLayout(jPanel1Layout);
  jPanel1Layout.setHorizontalGroup(
  jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
  .add(jPanel1Layout.createSequentialGroup()
  .addContainerGap()
  .add(jLabel1)
  .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
  .add(jTextField1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 412, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
  .add(jTextField2, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 162, Short.MAX_VALUE)
  .addContainerGap())
  );
  jPanel1Layout.setVerticalGroup(
  jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
  .add(jPanel1Layout.createSequentialGroup()
  .addContainerGap()
  .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
  .add(jLabel1)
  .add(jTextField1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .add(jTextField2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
  .addContainerGap(org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  );
  
  jPanel3.setBorder(javax.swing.BorderFactory.createEtchedBorder());
  jPanel3.setPreferredSize(new java.awt.Dimension(656, 0));
  jButton1.setIcon(new javax.swing.ImageIcon(“C:\Documents and Settings\suporte\Desktop\estoque\icones\botoes\anterior.png”));
  jButton1.setPreferredSize(new java.awt.Dimension(65, 25));
  jButton1.addActionListener(new java.awt.event.ActionListener() {
  public void actionPerformed(java.awt.event.ActionEvent evt) {
  jButton1ActionPerformed(evt);
  }
  });
  
  jButton2.setIcon(new javax.swing.ImageIcon(“C:\Documents and Settings\suporte\Desktop\estoque\icones\botoes\primeiro.png”));
  jButton2.setPreferredSize(new java.awt.Dimension(65, 25));
  jButton2.addActionListener(new java.awt.event.ActionListener() {
  public void actionPerformed(java.awt.event.ActionEvent evt) {
  jButton2ActionPerformed(evt);
  }
  });
  
  jButton3.setIcon(new javax.swing.ImageIcon(“C:\Documents and Settings\suporte\Desktop\estoque\icones\botoes\ultimo.png”));
  jButton3.setPreferredSize(new java.awt.Dimension(65, 25));
  jButton3.addActionListener(new java.awt.event.ActionListener() {
  public void actionPerformed(java.awt.event.ActionEvent evt) {
  jButton3ActionPerformed(evt);
  }
  });
  
  jButton4.setIcon(new javax.swing.ImageIcon(“C:\Documents and Settings\suporte\Desktop\estoque\icones\botoes\proximo.png”));
  jButton4.setPreferredSize(new java.awt.Dimension(65, 25));
  jButton4.addActionListener(new java.awt.event.ActionListener() {
  public void actionPerformed(java.awt.event.ActionEvent evt) {
  jButton4ActionPerformed(evt);
  }
  });
  
  jButton5.setIcon(new javax.swing.ImageIcon(“C:\Documents and Settings\suporte\Desktop\estoque\icones\botoes\novo.png”));
  jButton5.setPreferredSize(new java.awt.Dimension(65, 25));
  jButton5.addActionListener(new java.awt.event.ActionListener() {
  public void actionPerformed(java.awt.event.ActionEvent evt) {
  jButton5ActionPerformed(evt);
  }
  });
  
  jButton6.setIcon(new javax.swing.ImageIcon(“C:\Documents and Settings\suporte\Desktop\estoque\icones\botoes\gravar.png”));
  jButton6.setPreferredSize(new java.awt.Dimension(65, 25));
  jButton6.addActionListener(new java.awt.event.ActionListener() {
  public void actionPerformed(java.awt.event.ActionEvent evt) {
  jButton6ActionPerformed(evt);
  }
  });
  
  jButton7.setIcon(new javax.swing.ImageIcon(“D:\icone\iconeEditar28.gif”));
  jButton7.setPreferredSize(new java.awt.Dimension(65, 25));
  
  jButton8.setIcon(new javax.swing.ImageIcon(“C:\Documents and Settings\suporte\Desktop\estoque\icones\botoes\cancelar.png”));
  jButton8.setPreferredSize(new java.awt.Dimension(65, 25));
  
  jButton9.setIcon(new javax.swing.ImageIcon(“C:\Documents and Settings\suporte\Desktop\estoque\icones\botoes\excluir.png”));
  jButton9.setPreferredSize(new java.awt.Dimension(65, 25));
  
  org.jdesktop.layout.GroupLayout jPanel3Layout = new org.jdesktop.layout.GroupLayout(jPanel3);
  jPanel3.setLayout(jPanel3Layout);
  jPanel3Layout.setHorizontalGroup(
  jPanel3Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
  .add(jPanel3Layout.createSequentialGroup()
  .addContainerGap(org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  .add(jButton1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
  .add(jButton2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
  .add(jButton3, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
  .add(jButton4, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
  .add(jButton5, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
  .add(jButton6, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
  .add(jButton7, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
  .add(jButton8, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
  .add(jButton9, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .add(37, 37, 37))
  );
  jPanel3Layout.setVerticalGroup(
  jPanel3Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
  .add(jPanel3Layout.createSequentialGroup()
  .addContainerGap()
  .add(jPanel3Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
  .add(jButton9, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .add(jPanel3Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
  .add(jButton1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .add(jButton2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .add(jButton3, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .add(jButton4, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .add(jButton5, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .add(jButton6, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .add(jButton7, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .add(jButton8, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)))
  .addContainerGap(org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  );
  
  jPanel2.setBorder(javax.swing.BorderFactory.createEtchedBorder());
  jPanel2.setPreferredSize(new java.awt.Dimension(0, 0));
  jLabel4.setText(“UF”);
  
  uf.setModel(new javax.swing.DefaultComboBoxModel(new String[] { “AC”, “AL”, “AP”, “AM”, “BA”, “CE”, “DF”, “ES”, “GO”, “MA”, “MT”, “MS”, “MG”, “PA”, “PB”, “PR”, “PE”, “PI”, “RJ”, “RN”, “RS”, “RO”, “RR”, “SC”, “SP”, “SE”, “TO” }));
  uf.setPreferredSize(new java.awt.Dimension(100, 25));
  
  jLabel2.setText(“C\u00f3digo”);
  
  jLabel3.setText(“Nome”);
  
  nome.setPreferredSize(new java.awt.Dimension(6, 25));
  
  codigo.setMinimumSize(new java.awt.Dimension(15, 25));
  codigo.setPreferredSize(new java.awt.Dimension(100, 25));
  
  org.jdesktop.layout.GroupLayout jPanel2Layout = new org.jdesktop.layout.GroupLayout(jPanel2);
  jPanel2.setLayout(jPanel2Layout);
  jPanel2Layout.setHorizontalGroup(
  jPanel2Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
  .add(jPanel2Layout.createSequentialGroup()
  .addContainerGap()
  .add(jPanel2Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
  .add(jLabel4)
  .add(jLabel3)
  .add(jLabel2)
  .add(uf, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .add(nome, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 295, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .add(codigo, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
  .addContainerGap(347, Short.MAX_VALUE))
  );
  jPanel2Layout.setVerticalGroup(
  jPanel2Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
  .add(jPanel2Layout.createSequentialGroup()
  .add(51, 51, 51)
  .add(jLabel2)
  .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
  .add(codigo, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
  .add(jLabel3)
  .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
  .add(nome, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
  .add(jLabel4)
  .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
  .add(uf, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .addContainerGap(88, Short.MAX_VALUE))
  );
  
  org.jdesktop.layout.GroupLayout jPanel5Layout = new org.jdesktop.layout.GroupLayout(jPanel5);
  jPanel5.setLayout(jPanel5Layout);
  jPanel5Layout.setHorizontalGroup(
  jPanel5Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
  .add(jPanel5Layout.createSequentialGroup()
  .addContainerGap()
  .add(jPanel5Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
  .add(jPanel5Layout.createSequentialGroup()
  .add(jPanel1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 658, Short.MAX_VALUE)
  .add(8, 8, 8))
  .add(jPanel5Layout.createSequentialGroup()
  .add(jPanel2, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 656, Short.MAX_VALUE)
  .addContainerGap())
  .add(jPanel5Layout.createSequentialGroup()
  .add(jPanel3, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 656, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .addContainerGap(org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))))
  );
  jPanel5Layout.setVerticalGroup(
  jPanel5Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
  .add(jPanel5Layout.createSequentialGroup()
  .addContainerGap()
  .add(jPanel1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 42, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
  .add(jPanel2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 290, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
  .add(jPanel3, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 51, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .addContainerGap(16, Short.MAX_VALUE))
  );
  jTabbedPane1.addTab(“Cadastro”, jPanel5);
  
  org.jdesktop.layout.GroupLayout layout = new org.jdesktop.layout.GroupLayout(getContentPane());
  getContentPane().setLayout(layout);
  layout.setHorizontalGroup(
  layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
  .add(layout.createSequentialGroup()
  .addContainerGap()
  .add(jTabbedPane1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 687, Short.MAX_VALUE)
  .addContainerGap())
  );
  layout.setVerticalGroup(
  layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
  .add(layout.createSequentialGroup()
  .addContainerGap()
  .add(jTabbedPane1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 455, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
  .addContainerGap(org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  );
  java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
  setBounds((screenSize.width-715)/2, (screenSize.height-504)/2, 715, 504);
  }//
private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
codigo.setText("");
nome.setText("");
uf.setSelectedItem(“AC”);
nome.requestFocus();
codigo.setEditable(false);
nome.setEditable(true);
}

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
try
{
con_cidade.resultset.previous();
mostrar_dados();
}
catch(SQLException erro)
{
JOptionPane.showMessageDialog(null,“Não localizou dados”+erro);
}
}

private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
try {
con_cidade.resultset.last();
mostrar_dados();
}
catch(SQLException erro)
{
JOptionPane.showMessageDialog(null,“Não localizou dados”+erro);
}
}

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
try {
con_cidade.resultset.first();
mostrar_dados();
} catch(SQLException erro) {
JOptionPane.showMessageDialog(null,“Não localizou dados”+erro);
}
}

private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
try
{
String sqlinsert =“insert into cidade (nome,uf) values (’”+
nome.getText()+"’,’"+
uf.getSelectedItem()+"’)";
con_cidade.statement.executeUpdate(sqlinsert);
JOptionPane.showMessageDialog(null,“Gravação realizado com sucesso!”);
```
 con_cidade.executeSQL("Select * from cidade");
 con_cidade.resultset.first();
 nome.setEditable(false);
 mostrar_dados();
}
```
catch(SQLException erro)
{
JOptionPane.showMessageDialog(null,“Erro a tentar Gravar o Registros”+erro);
}
}

private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
try {
con_cidade.resultset.next();
mostrar_dados();
} catch(SQLException erro) {
JOptionPane.showMessageDialog(null,“Não localizou dados”+erro);
}
}

/**
- @param args the command line arguments
  */
  public static void main(String args[]) {
  java.awt.EventQueue.invokeLater(new Runnable() {
  public void run() {
  new cidade().setVisible(true);
  }
  });
  }
// Declaração de variáveis - não modifique
private javax.swing.JTextField codigo;
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
private javax.swing.JButton jButton3;
private javax.swing.JButton jButton4;
private javax.swing.JButton jButton5;
private javax.swing.JButton jButton6;
private javax.swing.JButton jButton7;
private javax.swing.JButton jButton8;
private javax.swing.JButton jButton9;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JPanel jPanel3;
private javax.swing.JPanel jPanel4;
private javax.swing.JPanel jPanel5;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTabbedPane jTabbedPane1;
private javax.swing.JTable jTable1;
private javax.swing.JTextField jTextField1;
private javax.swing.JTextField jTextField2;
private javax.swing.JTextField nome;
private javax.swing.JComboBox uf;
// Fim da declaração de variáveis

public void mostrar_dados()
{
try
{
codigo.setText(con_cidade.resultset.getString(“codigo”));
nome.setText(con_cidade.resultset.getString(“nome”));
uf.setSelectedItem(con_cidade.resultset.getString(“uf”));
}
catch(SQLException erro)
{
JOptionPane.showMessageDialog(null,“Não localizou dados”+erro);
}
}

public void preencher_table()
{
jTable1.getColumnModel().getColumn(0).setPreferredWidth(20);
jTable1.getColumnModel().getColumn(1).setPreferredWidth(150);
jTable1.getColumnModel().getColumn(2).setPreferredWidth(20);
```
 DefaultTableModel modelo = (DefaultTableModel)jTable1.getModel();
 modelo.setNumRows(0);
 
 try
 {
     while (con_cidade.resultset.next())
     modelo.addRow(new Object [] {con_cidade.resultset.getString("codigo"),con_cidade.resultset.getString("nome"),con_cidade.resultset.getString("uf")});
     
 }
 
 catch(SQLException erro)
 {
     JOptionPane.showMessageDialog(null,"Erro ao lista"+erro);
 }
```
}
}

esta ai a minha class

RobsonFagundes · Abril 23, 2008, 10:55am

Cara no eh por nada nao mais isso ta uma zona
é tela com metodos de percistencia cara se tem fazer umas coisa meio diferente ai
sepera este seu cod ai. Cria um Classe DAO por ex ja te ajudaria muito…

Ta veio pra entender melhor isso ai coloca seu cod entre as Tags
code /code q tem no menu ali cima tipo assim ó

package cadastro; import java.sql.SQLException; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import oracle.toplink.essentials.internal.expressions.SQLInsertStatement; import ultilitario.conexao;
Coloca ai q depois do almoço te ajudo
Abraços

system · Dezembro 23, 2015, 10:19pm

Como editar um cadastro

Cursos de Mobile

Cursos de Programação

Cursos de Front-end

Cursos de DevOps

Cursos de Design & UX

Cursos de Business

Cursos de Data & BI