Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void btn_cariActionPerformed(java.awt.event.ActionEvent evt) {
- Pert3_NPM connect = new Pert3_NPM();
- ResultSet data=null;
- PreparedStatement pst=null;
- String kodebarang = txt_carikodebarang.getText(); //txt_carikodebarang adalah nama variabel jtextfield untuk input kode barang, sesuaikan dengan variabel yang anda buat
- String namabarang, harga, stok;
- String query="select * from barang where kd_barang='"+kodebarang+"';";
- try{
- data = connect.getStatement().executeQuery(query);
- if(data.next()){
- namabarang=data.getString("nama_brg");
- harga=data.getString("harga_brg");
- stok=data.getString("stok_brg");
- JOptionPane.showMessageDialog(null, "Kode Barang : "+kodebarang+"\nNama Barang : "+namabarang+"\nHarga : "+harga+"\nStok : "+stok);
- }
- txt_kodebarang.setText("");
- txt_namabarang.setText("");
- txt_harga.setText("");
- txt_stok.setText("");
- }catch(SQLException e){
- JOptionPane.showMessageDialog(null, "tidak ditemukan");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement