Advertisement
dirham_yord

04 frame part 3 - button refresh

May 2nd, 2024 (edited)
589
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.31 KB | Software | 0 0
  1.     private void btn_refreshActionPerformed(java.awt.event.ActionEvent evt) {                                            
  2.         Pert3_NPM connect = new Pert3_NPM();
  3.         ResultSet data = null;
  4.         int jumbaris = 0;
  5.         int i = 0;
  6.        
  7.         String query="select * from barang";
  8.         try{
  9.             data=connect.getStatement().executeQuery(query);
  10.             while(data.next()){
  11.                 jumbaris++;
  12.             }
  13.         }catch(SQLException ex){
  14.            
  15.         }
  16.         String isi[][]=new String[jumbaris][5];
  17.         try{
  18.             data=connect.getStatement().executeQuery(query);
  19.             while(data.next()){
  20.                 isi[i][0]=data.getString("kd_barang"); //kd_barang adalah nama field pada table barang di database gudang
  21.                 isi[i][1]=data.getString("nama_brg");
  22.                 isi[i][2]=data.getString("harga_brg");
  23.                 isi[i][3]=data.getString("stok_brg");
  24.                 i++;
  25.             }
  26.         }catch(SQLException ex){
  27.            
  28.         }
  29.         String namakolom[]={"Kode","Nama_Barang","Harga","Jml_Stok"}; //penamaan kolom header tabel
  30.         DefaultTableModel model = new DefaultTableModel(isi,namakolom){};
  31.         tbl_gudang.setModel(model); //tbl_gudang adalah nama variabel dari JTable untuk menampilkan data
  32.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement