Advertisement
dirham_yord

03 frame part 2 - button simpan

May 2nd, 2024 (edited)
583
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.10 KB | Software | 0 0
  1.     private void btn_simpanActionPerformed(java.awt.event.ActionEvent evt) {                                          
  2.         Pert3_NPM connect = new Pert3_NPM();
  3.         String kodebarang = txt_kodebarang.getText(); //txt_barang adalah nama variabel untuk jtextfield input kode barang, sesuaikan dengan yang anda buat
  4.         String namabarang = txt_namabarang.getText();
  5.         int harga = Integer.parseInt(txt_harga.getText());
  6.         int stok = Integer.parseInt(txt_stok.getText());
  7.        
  8.         String query="insert into barang(kd_barang, nama_brg, harga_brg, stok_brg) values('"+kodebarang+"','"+namabarang+"',"+harga+","+stok+")";
  9.        
  10.         try{
  11.             connect.getStatement().executeUpdate(query);
  12.             txt_kodebarang.setText("");
  13.             txt_namabarang.setText("");
  14.             txt_harga.setText("");
  15.             txt_stok.setText("");
  16.             btn_refreshActionPerformed(null);
  17.             JOptionPane.showMessageDialog(null, "insert berhasil");
  18.         }catch(SQLException e){
  19.             JOptionPane.showMessageDialog(null, "insert gagal");
  20.         }
  21.     }  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement