Example Edit

int ok=JOptionPane.showConfirmDialog(null,"anda ingin memodifikasi data\n dengan Kode Barang = '" + jTextField1.getText() + "'" ,"konfirmasi memodifikasi data",JOptionPane.YES_NO_OPTION);
if (ok == 0){
try{
Connection con = DriverManager.getConnection("jdbc:odbc:kitra", "", "");
String sql = " Update barang set kd_brg=?,nm_brg=?,no_sj=?,tgl_masuk=?,satuan=?,hrg_sat = ?,ket= ? WHERE kd_brg= '" + jTextField1.getText() + "'";
PreparedStatement stat = con.prepareStatement(sql);
try{
String a = jTextField1.getText();
String b = jTextField2.getText();
String c = jTextField3.getText();
String d = jTextField4.getText();
String e = jComboBox1.getSelectedItem().toString();
String f = jTextField5.getText();
String g = jTextField6.getText();

stat.setString(1, a);
stat.setString(2, b);
stat.setString(3, c);
stat.setString(4, d);
stat.setString(5, e);
stat.setString(6, f);
stat.setString(7, g);

stat.executeUpdate();

JOptionPane.showMessageDialog(null,"data berhasil diupdate");

jTextField1.setText("");
jTextField2.setText("");
jComboBox1.setSelectedItem("");
jTextField3.setText("");
jTextField4.setText("");
jTextField5.setText("");
jTextField6.setText("");
}catch(Exception e){}
} catch(Exception e){JOptionPane.showMessageDialog(null,"DATA TIDAK DAPAT DIEDIT");}
}