Advertisement
RyanRain

Edit

Dec 30th, 2018
172
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.72 KB | None | 0 0
  1. // Edit Data
  2.         try {
  3.             String sql ="UPDATE mhs SET nama = '"+txtnama.getText()+"', nim = '"+txtnim.getText()+"', jurusan = '"+jComboBox1.getSelectedItem()+"',alamat= '"+txtalamat.getText()+"',telp= '"+txttelp.getText()+"' WHERE nim = '"+txtnim.getText()+"'";
  4.             java.sql.Connection conn=(Connection)Config.configDB();
  5.             java.sql.PreparedStatement pst=conn.prepareStatement(sql);
  6.             pst.execute();
  7.             JOptionPane.showMessageDialog(null, "data berhasil di edit");
  8.         } catch (Exception e) {
  9.             JOptionPane.showMessageDialog(null, "Perubahan Data Gagal"+e.getMessage());
  10.         }
  11.         load_table(); //load isi table
  12.         kosong(); //kosongkan isi text
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement