A minha classe não ta salvando no banco de dados.
Roda normalmente, mas qdo vou ao banco e dou um select * from nomedatabela, aparece vazio.
private void gravarActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
if ((jTextField1.getText().trim().equals(""))||(jTextField2.getText().trim().equals("")))
{
jLabel23.setText(“Status: Registro possui campo(s) vazio(s).”);
jTextField1.grabFocus();
}
else
{
if (operacao.trim().equals(“I”))
{
int con_codi;
String con_nome, con_cpf, con_rg, con_ende, con_bair, con_cida, con_esta;
String con_natu, con_dtnc, con_eciv, con_rend, con_tele, con_sexo, con_empr;
String con_emai, con_gins, con_cart, con_moti, con_rpca, con_obs, con_cep;
String comando = "insert into contribuinte (con_codi, con_nome, con_cpf, con_rg, " +
"con_ende, con_bair, con_cida, con_esta, con_natu, con_dtnc, con_eciv, con_rend, " +
"con_tele, con_sexo, con_empr, con_emai, con_gins, con_cart, con_moti, " +
“con_rpca, con_obs, con_cep) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)”;
String comando1 = “”;
Connection con = Conector.getTestConnection();
stmt = null;
stmt1 = null;
try
{
con_codi = Integer.parseInt (jTextField1.getText());
con_nome = jTextField2.getText();
con_cpf = jFormattedTextField1.getText();
con_rg = jFormattedTextField2.getText();
con_eciv = jComboBox1.getSelectedItem().toString();
con_ende = jTextField3.getText();
con_cida = jTextField4.getText();
con_esta = jComboBox2.getSelectedItem().toString();
con_bair = jTextField5.getText();
con_cep = jFormattedTextField3.getText();
con_tele = jFormattedTextField4.getText();
con_sexo = jComboBox3.getSelectedItem().toString();
con_dtnc = jFormattedTextField5.getText();
con_gins = jComboBox4.getSelectedItem().toString();
con_rend = jFormattedTextField6.getText();
con_rpca = jFormattedTextField7.getText();
con_natu = jTextField6.getText();
con_emai = jTextField7.getText();
con_cart = jTextField8.getText();
con_empr = jTextField9.getText();
con_moti = jTextField10.getText();
con_obs = jTextArea1.getText();
if (verificarseexiste(con_codi) == false)
{
stmt = con.prepareStatement(comando);
stmt.setInt (1, con_codi);
stmt.setString (2, con_nome);
stmt.setString (3, con_cpf);
stmt.setString (4, con_rg);
stmt.setString (5, con_eciv);
stmt.setString (6, con_ende);
stmt.setString (7, con_cida);
stmt.setString (8, con_esta);
stmt.setString (9, con_bair);
stmt.setString (10, con_cep);
stmt.setString (11, con_tele);
stmt.setString (12, con_sexo);
stmt.setString (13, con_dtnc);
stmt.setString (14, con_gins);
stmt.setString (15, con_rend);
stmt.setString (16, con_rpca);
stmt.setString (17, con_natu);
stmt.setString (18, con_emai);
stmt.setString (19, con_cart);
stmt.setString (20, con_empr);
stmt.setString (21, con_moti);
stmt.setString (22, con_obs);
stmt.executeUpdate();
//
stmt1.executeUpdate();
con.close();
//
limpar();
}
}
catch (Exception ex)
{
ex.printStackTrace();
}
}
}
if (operacao.trim().equals(“A”))
{
int con_codi;
String con_nome, con_cpf, con_rg, con_ende, con_bair, con_cida, con_esta;
String con_natu, con_dtnc, con_eciv, con_rend, con_tele, con_sexo, con_empr;
String con_emai, con_gins, con_cart, con_moti, con_rpca, con_obs, con_cep;
String comando = “update contribuinte set con_nome = ? where con_codi = ?”;
Connection con = Conector.getTestConnection();
stmt = null;
try
{
con_codi = Integer.parseInt (jTextField1.getText());
con_nome = jTextField2.getText();
con_cpf = jFormattedTextField1.getText();
con_rg = jFormattedTextField2.getText();
con_eciv = jComboBox1.getSelectedItem().toString();
con_ende = jTextField3.getText();
con_cida = jTextField4.getText();
con_esta = jComboBox2.getSelectedItem().toString();
con_bair = jTextField5.getText();
con_cep = jFormattedTextField3.getText();
con_tele = jFormattedTextField4.getText();
con_sexo = jComboBox3.getSelectedItem().toString();
con_dtnc = jFormattedTextField5.getText();
con_gins = jComboBox4.getSelectedItem().toString();
con_rend = jFormattedTextField6.getText();
con_rpca = jFormattedTextField7.getText();
con_natu = jTextField6.getText();
con_emai = jTextField7.getText();
con_cart = jTextField8.getText();
con_empr = jTextField9.getText();
con_moti = jTextField10.getText();
con_obs = jTextArea1.getText();
stmt.setInt (1, con_codi);
stmt.setString (2, con_nome);
stmt.setString (3, con_cpf);
stmt.setString (4, con_rg);
stmt.setString (5, con_eciv);
stmt.setString (6, con_ende);
stmt.setString (7, con_cida);
stmt.setString (8, con_esta);
stmt.setString (9, con_bair);
stmt.setString (10, con_cep);
stmt.setString (11, con_tele);
stmt.setString (12, con_sexo);
stmt.setString (13, con_dtnc);
stmt.setString (14, con_gins);
stmt.setString (15, con_rend);
stmt.setString (16, con_rpca);
stmt.setString (17, con_natu);
stmt.setString (18, con_emai);
stmt.setString (19, con_cart);
stmt.setString (20, con_empr);
stmt.setString (21, con_moti);
stmt.setString (22, con_obs);
stmt.executeUpdate();
con.close();
bloqueio(true);
operacao = "";
}
catch (Exception ex)
{
ex.printStackTrace();
}
}
}
Alguém me ajude, por favor.