How can I create a data log, see every addition I made to my stock table, am using netbeans and xampp, and have 1 table. Which is stock

Viewed 8

This is just part of the code as am new here and don't know exactly what to do. Just need to add data logs to my panel in netbeans so I can see all new updates I made going to product table that have column "stock". Will need to include data if possible time toenter image description here. Need help.

Am a novice as well. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// SAVE PRODUCT

    String name = p_name.getText();
   
    String qty = p_qty.getText();
   
    
    
    try {
        
        Statement s = db.mycon().createStatement();
        //`pid`, `Product_Name`, `Bar_code`, `Price`, `Qty`, `Sid`
        s.executeUpdate("INSERT INTO product (Product_Name,Qty) VALUES('"+name+"','"+qty+"')");
        JOptionPane.showMessageDialog(null, "Data Saved");
        
    } catch (SQLException e) {
        System.out.println(e);
    }
    
    tb_load();
    
}                                        

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                         
    // search product:

    String search = p_src.getText();
    
    try {
        Statement s = db.mycon().createStatement();
        
        ResultSet rs = s.executeQuery("SELECT * FROM product WHERE pid = '"+search+"'");
        
        if (rs.next()){
            
            
            p_name.setText(rs.getString("Product_Name"));
 
            p_qty.setText(rs.getString("Qty"));
 
    
    
    }
        
        
    } catch (SQLException e) {
        System.out.println(e);
    }
    

    
}                                        

private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {                                         
    // TODO add your handling code here:
    
    String id = p_src.getText();
    String name = p_name.getText();
    String qty = p_qty.getText();
   
   
    
    
    try {
        
        
        Statement s = db.mycon().createStatement();
        
         //pid  Product_Name    Bar_code    Price   Qty     Sid     
        s.executeUpdate("UPDATE product SET Product_Name='"+name+"',Qty='"+qty+"' WHERE pid ='"+id+"' ");
        
        
        JOptionPane.showMessageDialog(null, "Data Updated");
        
        
    } catch (SQLException e) {
    }
    tb_load();
}                                        

private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                         
    // delete btw code:
    
    String id =p_src.getText();
    
    try {
        Statement s = db.mycon().createStatement();
        s.executeUpdate("DELETE FROM product WHERE pid = '"+id+"' ");
        JOptionPane.showMessageDialog(null, "Delect Successfull");
        
    } catch (HeadlessException | SQLException e) {
        System.out.println(e);
    }
    tb_load();
}                                        

private void jTable1KeyPressed(java.awt.event.KeyEvent evt) {                                   
    // TODO add your handling code here
 
    
}                                  

private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {                                     
    // TODO add your handling code here:
    
       
    int r = jTable1.getSelectedRow();
    
    String id =jTable1.getValueAt(r, 0).toString();
    String name =jTable1.getValueAt(r, 1).toString();
   
    String qty =jTable1.getValueAt(r, 5).toString();
   
    
    
    p_src.setText(id);
    p_name.setText(name);
    p_qty.setText(qty);

    
}                                    

private void c_search_tbActionPerformed(java.awt.event.ActionEvent evt) {                                            
    // TODO add your handling code here:
}                                           

private void c_search_tbKeyReleased(java.awt.event.KeyEvent evt) {                                        

        String name = c_search_tb.getText();
    
    try {
        
     
        
        
        DefaultTableModel dt = (DefaultTableModel) jTable1.getModel();
        dt.setRowCount(0);
        Statement s = db.mycon().createStatement();
        
        ResultSet rs = s.executeQuery("SELECT * FROM product WHERE Product_Name LIKE '%"+name+"%' ");
        
        while (rs.next()) {
            Vector v = new Vector();
        
            v.add(rs.getString(1));
            v.add(rs.getString(2));
            v.add(rs.getString(3));
            
            dt.addRow(v);
             
            
            
            
        }
        
    } catch (SQLException e) {
        tb_load();
    }
}             
0 Answers
Related