How to create Grocery Inventory System (POS) 18 Adding PAY Invoice Button function TAGALOG

Hello and welcome to this another tutorial, with in this series of videos, you are going to learn

how you can create a grocery inventory system using netbeans or what we can call "Point Of Sales"(POS).

So be sure to watch the completer video tutorial and make your own system just by following my tutorial.

Following Requirements are:

--MySQL Java Connector

--Netbeans and of course a background of programming skills.

You Can Download Complete zip file here: #Mirror1,#Mirror2

#Brand.form codes:

<?xml version="1.0" encoding="UTF-8" ?>

#Brand java codes:

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package grocery_pos_system;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Vector;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

public class Brand extends javax.swing.JFrame {
    private Connection con;
    private PreparedStatement statement;
    private ResultSet rs;
   
    public Brand() throws ClassNotFoundException, SQLException {
        initComponents();
        update_table();

}

/**
 * This method is called from within the constructor to initialize the form.
 * WARNING: Do NOT modify this code. The content of this method is always
 * regenerated by the Form Editor.
 */
 @SuppressWarnings("unchecked")
 // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
 private void initComponents() {

container1 = new javax.swing.JPanel();
        txtCategory = new javax.swing.JLabel();
        txtProduct = new javax.swing.JLabel();
        txtBrand = new javax.swing.JLabel();
        txtPos = new javax.swing.JLabel();
        txtExit = new javax.swing.JLabel();
        txtCashier = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        txtCategory1 = new javax.swing.JLabel();
        jPanel1 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        txtCatfield = new javax.swing.JTextField();
        jLabel2 = new javax.swing.JLabel();
        addBtn = new javax.swing.JButton();
        editBtn = new javax.swing.JButton();
        delete_btn = new javax.swing.JButton();
        statusBox1 = new javax.swing.JComboBox();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

container1.setBackground(new java.awt.Color(255, 102, 0));

txtCategory.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
        txtCategory.setForeground(new java.awt.Color(255, 255, 255));
        txtCategory.setText("Category");
        txtCategory.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                txtCategoryMouseClicked(evt);
            }
        });

txtProduct.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
        txtProduct.setForeground(new java.awt.Color(255, 255, 255));
        txtProduct.setText("Product");
        txtProduct.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                txtProductMouseClicked(evt);
            }
        });

txtBrand.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
        txtBrand.setForeground(new java.awt.Color(255, 255, 255));
        txtBrand.setText("Brand");
        txtBrand.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                txtBrandMouseClicked(evt);
            }
        });

txtPos.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
        txtPos.setForeground(new java.awt.Color(255, 255, 255));
        txtPos.setText("Pos");
        txtPos.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                txtPosMouseClicked(evt);
            }
        });

txtExit.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
        txtExit.setForeground(new java.awt.Color(255, 255, 255));
        txtExit.setText("Exit");
        txtExit.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                txtExitMouseClicked(evt);
            }
        });

txtCashier.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
        txtCashier.setForeground(new java.awt.Color(255, 255, 255));
        txtCashier.setText("Cashier");
        txtCashier.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                txtCashierMouseClicked(evt);
            }
        });

javax.swing.GroupLayout container1Layout = new javax.swing.GroupLayout(container1);
        container1.setLayout(container1Layout);
        container1Layout.setHorizontalGroup(
            container1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(container1Layout.createSequentialGroup()
                .addGap(36, 36, 36)
                .addGroup(container1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(txtCashier, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtExit, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtPos, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtProduct, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtBrand, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtCategory, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap(39, Short.MAX_VALUE))
        );
        container1Layout.setVerticalGroup(
            container1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(container1Layout.createSequentialGroup()
                .addGap(96, 96, 96)
                .addComponent(txtCategory)
                .addGap(45, 45, 45)
                .addComponent(txtBrand)
                .addGap(50, 50, 50)
                .addComponent(txtProduct)
                .addGap(49, 49, 49)
                .addComponent(txtPos)
                .addGap(44, 44, 44)
                .addComponent(txtExit)
                .addGap(44, 44, 44)
                .addComponent(txtCashier)
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

jLabel4.setFont(new java.awt.Font("Tw Cen MT Condensed Extra Bold", 1, 36)); // NOI18N
        jLabel4.setText("Grocery Inventory System");

txtCategory1.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
        txtCategory1.setText("Brand");

jPanel1.setBorder(javax.swing.BorderFactory.createCompoundBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)), javax.swing.BorderFactory.createEmptyBorder(1, 1, 1, 1)));

jLabel1.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel1.setText("Brand");

jLabel2.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel2.setText("Status :");

addBtn.setText("Add");
        addBtn.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                addBtnActionPerformed(evt);
            }
        });

editBtn.setText("Edit");
        editBtn.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                editBtnActionPerformed(evt);
            }
        });

delete_btn.setText("Delete");
        delete_btn.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                delete_btnActionPerformed(evt);
            }
        });

statusBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Activate", "deActivate", " " }));
        statusBox1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                statusBox1ActionPerformed(evt);
            }
        });

jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

},
            new String [] {
                "Id", "Category", "Status"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.Integer.class, java.lang.String.class, java.lang.String.class
            };

public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }
        });
        jTable1.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jTable1MouseClicked(evt);
            }
        });
        jScrollPane1.setViewportView(jTable1);

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addComponent(container1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 419, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(204, 204, 204))
                    .addGroup(layout.createSequentialGroup()
                        .addGap(29, 29, 29)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(txtCategory1, javax.swing.GroupLayout.PREFERRED_SIZE, 127, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addGroup(layout.createSequentialGroup()
                                .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 36, Short.MAX_VALUE)
                                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 406, javax.swing.GroupLayout.PREFERRED_SIZE)))
                        .addGap(56, 56, 56))))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(container1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
            .addGroup(layout.createSequentialGroup()
                .addGap(46, 46, 46)
                .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 54, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(26, 26, 26)
                .addComponent(txtCategory1)
                .addGap(18, 18, 18)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 409, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap(37, Short.MAX_VALUE))
        );

private void editBtnActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_editBtnActionPerformed
          
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
             con = DriverManager.getConnection("jdbc:mysql://localhost/grocery_pos_system", "root","");
             statement = con.prepareStatement("update brand  set brand = ?,status = ? where id = ?");  
             
             rs = statement.getResultSet();
             DefaultTableModel dtm = (DefaultTableModel)jTable1.getModel();
             int index = jTable1.getSelectedRow();
             int id = Integer.parseInt(dtm.getValueAt(index, 0).toString());
             String txt = txtCatfield.getText();
             String status = statusBox1.getSelectedItem().toString();
             statement.setString(1, txt);
             statement.setString(2, status);
             statement.setInt(3,id);
             statement.executeUpdate();
             txtCatfield.setText("");
             txtCatfield.requestFocus();
             statusBox1.setSelectedIndex(0);
             
             update_table();
        } 
        
        catch (ClassNotFoundException ex) {
            Logger.getLogger(Brand.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Brand.class.getName()).log(Level.SEVERE, null, ex);
        }
           
    }//GEN-LAST:event_editBtnActionPerformed

private void delete_btnActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_delete_btnActionPerformed
        try {
            // TODO add your handling code here:
            Class.forName("com.mysql.cj.jdbc.Driver");
             con = DriverManager.getConnection("jdbc:mysql://localhost/grocery_pos_system", "root","");
             statement = con.prepareStatement("delete from brand where id = ? ");  
             DefaultTableModel dtm = (DefaultTableModel)jTable1.getModel();
             int index = jTable1.getSelectedRow();
             int id = Integer.parseInt(dtm.getValueAt(index, 0).toString());
            int dialogMessage = JOptionPane.showConfirmDialog(null, "Do you want to delete this?", "Warning!", JOptionPane.YES_NO_OPTION);
            
            if(dialogMessage == JOptionPane.YES_OPTION){
             statement.setInt(1, id);
             statement.executeUpdate();
             update_table();
            }
             
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Brand.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Brand.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_delete_btnActionPerformed

private void txtBrandMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtBrandMouseClicked
        // TODO add your handling code here:
        
       
    }//GEN-LAST:event_txtBrandMouseClicked

private void txtCategoryMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtCategoryMouseClicked
        // TODO add your handling code here:
        Category c;
        try {
            c = new Category();
             this.hide();
            c.setVisible(true);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Brand.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Brand.class.getName()).log(Level.SEVERE, null, ex);
        }
       
    }//GEN-LAST:event_txtCategoryMouseClicked

private void txtProductMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtProductMouseClicked
        // TODO add your handling code here:
        
         try {
            // TODO add your handling code here:
            Product p = new Product();
            this.hide();
            p.setVisible(true);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_txtProductMouseClicked

txtCatfield.setText(dtm.getValueAt(selectedIndex, 1).toString());
    statusBox1.setSelectedItem(dtm.getValueAt(selectedIndex,2));
    
    }//GEN-LAST:event_jTable1MouseClicked

private void statusBox1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_statusBox1ActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_statusBox1ActionPerformed

private void txtPosMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtPosMouseClicked
        // TODO add your handling code here:
         try {
            Login_form form = new Login_form();
            this.hide();
            form.setVisible(true);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_txtPosMouseClicked

private void txtCashierMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtCashierMouseClicked
        // TODO add your handling code here:
          Cashier cashier;
        try {
            cashier = new Cashier();
            this.hide();
            cashier.setVisible(true);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        }
        
    }//GEN-LAST:event_txtCashierMouseClicked

private void txtExitMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtExitMouseClicked
        // TODO add your handling code here:
        try {
            Brand b = new Brand();
            this.hide();
            b.setDefaultCloseOperation(EXIT_ON_CLOSE);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_txtExitMouseClicked

/**
 * @param args the command line arguments
 */
 public static void main(String args[]) {
 /* Set the Nimbus look and feel */
 //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
 /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
 * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
 */
 try {
 for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
 if ("Nimbus".equals(info.getName())) {
 javax.swing.UIManager.setLookAndFeel(info.getClassName());
 break;
 }
 }
 } catch (ClassNotFoundException ex) {
 java.util.logging.Logger.getLogger(Brand.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (InstantiationException ex) {
 java.util.logging.Logger.getLogger(Brand.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (IllegalAccessException ex) {
 java.util.logging.Logger.getLogger(Brand.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (javax.swing.UnsupportedLookAndFeelException ex) {
 java.util.logging.Logger.getLogger(Brand.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 }
 //</editor-fold>
 //</editor-fold>

/* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                try {
                    new Brand().setVisible(true);
                } 
                catch (ClassNotFoundException ex) {
                    Logger.getLogger(Brand.class.getName()).log(Level.SEVERE, null, ex);
                } catch (SQLException ex) {
                    Logger.getLogger(Brand.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        });
    }

#Cashier.form codes:

<?xml version="1.0" encoding="UTF-8" ?>

#Cashier java codes:

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package grocery_pos_system;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Vector;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

public class Cashier extends javax.swing.JFrame {
    private Connection con;
    private PreparedStatement statement;
    private ResultSet rs;
   
    public Cashier() throws ClassNotFoundException, SQLException {
        initComponents();
        update_table();

}

container1 = new javax.swing.JPanel();
        txtCategory = new javax.swing.JLabel();
        txtProduct = new javax.swing.JLabel();
        txtBrand = new javax.swing.JLabel();
        txtPos = new javax.swing.JLabel();
        txtExit = new javax.swing.JLabel();
        txtCashier = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        txtCategory1 = new javax.swing.JLabel();
        jPanel1 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        txtUsername = new javax.swing.JTextField();
        jLabel2 = new javax.swing.JLabel();
        addBtn = new javax.swing.JButton();
        editBtn = new javax.swing.JButton();
        delete_btn = new javax.swing.JButton();
        statusBox1 = new javax.swing.JComboBox();
        txtPassword = new javax.swing.JPasswordField();
        jLabel3 = new javax.swing.JLabel();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

container1.setBackground(new java.awt.Color(255, 102, 0));

jLabel4.setFont(new java.awt.Font("Tw Cen MT Condensed Extra Bold", 1, 36)); // NOI18N
        jLabel4.setText("Grocery Inventory System");

txtCategory1.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
        txtCategory1.setText("Cashier");

jPanel1.setBorder(javax.swing.BorderFactory.createCompoundBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)), javax.swing.BorderFactory.createEmptyBorder(1, 1, 1, 1)));

jLabel1.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel1.setText("Username :");

jLabel2.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel2.setText("Status :");

jLabel3.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel3.setText("Password :");

jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

},
            new String [] {
                "Id", "Username", "Status"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.Integer.class, java.lang.String.class, java.lang.String.class
            };

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addComponent(container1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 419, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(204, 204, 204))
                    .addGroup(layout.createSequentialGroup()
                        .addGap(29, 29, 29)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(layout.createSequentialGroup()
                                .addComponent(txtCategory1, javax.swing.GroupLayout.PREFERRED_SIZE, 127, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addContainerGap(675, Short.MAX_VALUE))
                            .addGroup(layout.createSequentialGroup()
                                .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 406, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addGap(38, 38, 38))))))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(container1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
            .addGroup(layout.createSequentialGroup()
                .addGap(46, 46, 46)
                .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 54, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(26, 26, 26)
                .addComponent(txtCategory1)
                .addGap(18, 18, 18)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 369, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

private void editBtnActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_editBtnActionPerformed
          
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
             con = DriverManager.getConnection("jdbc:mysql://localhost/grocery_pos_system", "root","");
             statement = con.prepareStatement("update cashier  set username = ?,password = ?,status = ? where id = ?");  
             
             rs = statement.getResultSet();
             DefaultTableModel dtm = (DefaultTableModel)jTable1.getModel();
             int index = jTable1.getSelectedRow();
             int id = Integer.parseInt(dtm.getValueAt(index, 0).toString());
             String user = txtUsername.getText();
              String password = txtUsername.getText();
             String status = statusBox1.getSelectedItem().toString();
             statement.setString(1, user);
             statement.setString(2, password);
              statement.setString(3, status);
             statement.setInt(4,id);
             statement.executeUpdate();
             txtUsername.setText("");
             txtUsername.requestFocus();
             statusBox1.setSelectedIndex(0);
             update_table();
        } 
        
        catch (ClassNotFoundException ex) {
            Logger.getLogger(Cashier.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Cashier.class.getName()).log(Level.SEVERE, null, ex);
        }
           
    }//GEN-LAST:event_editBtnActionPerformed

private void delete_btnActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_delete_btnActionPerformed
        try {
            // TODO add your handling code here:
            Class.forName("com.mysql.cj.jdbc.Driver");
             con = DriverManager.getConnection("jdbc:mysql://localhost/grocery_pos_system", "root","");
             statement = con.prepareStatement("delete from cashier where id = ? ");  
             DefaultTableModel dtm = (DefaultTableModel)jTable1.getModel();
             int index = jTable1.getSelectedRow();
             int id = Integer.parseInt(dtm.getValueAt(index, 0).toString());
            int dialogMessage = JOptionPane.showConfirmDialog(null, "Do you want to delete this?", "Warning!", JOptionPane.YES_NO_OPTION);
            
            if(dialogMessage == JOptionPane.YES_OPTION){
             statement.setInt(1, id);
             statement.executeUpdate();
             update_table();
            }
             
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Cashier.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Cashier.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_delete_btnActionPerformed

private void txtCategoryMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtCategoryMouseClicked
        // TODO add your handling code here:
        Category c;
        try {
            c = new Category();
             this.hide();
            c.setVisible(true);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Cashier.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Cashier.class.getName()).log(Level.SEVERE, null, ex);
        }
       
    }//GEN-LAST:event_txtCategoryMouseClicked

txtUsername.setText(dtm.getValueAt(selectedIndex, 1).toString());
    statusBox1.setSelectedItem(dtm.getValueAt(selectedIndex,2));
    
    }//GEN-LAST:event_jTable1MouseClicked

private void txtPosMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtPosMouseClicked
        // TODO add your handling code here:
        try {
            Login_form form = new Login_form();
            this.hide();
            form.setVisible(true);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        }
      
    }//GEN-LAST:event_txtPosMouseClicked

private void txtExitMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtExitMouseClicked
        // TODO add your handling code here:
    }//GEN-LAST:event_txtExitMouseClicked

/**
 * @param args the command line arguments
 */
 public static void main(String args[]) {
 /* Set the Nimbus look and feel */
 //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
 /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
 * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
 */
 try {
 for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
 if ("Nimbus".equals(info.getName())) {
 javax.swing.UIManager.setLookAndFeel(info.getClassName());
 break;
 }
 }
 } catch (ClassNotFoundException ex) {
 java.util.logging.Logger.getLogger(Cashier.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (InstantiationException ex) {
 java.util.logging.Logger.getLogger(Cashier.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (IllegalAccessException ex) {
 java.util.logging.Logger.getLogger(Cashier.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (javax.swing.UnsupportedLookAndFeelException ex) {
 java.util.logging.Logger.getLogger(Cashier.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 }
 //</editor-fold>
 //</editor-fold>
 //</editor-fold>
 //</editor-fold>

/* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                try {
                    new Cashier().setVisible(true);
                } 
                catch (ClassNotFoundException ex) {
                    Logger.getLogger(Cashier.class.getName()).log(Level.SEVERE, null, ex);
                } catch (SQLException ex) {
                    Logger.getLogger(Cashier.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        });
    }

#Category.form codes:

<?xml version="1.0" encoding="UTF-8" ?>

#Category java codes:

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package grocery_pos_system;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Vector;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

public class Category extends javax.swing.JFrame {
    private Connection con;
    private PreparedStatement statement;
    private ResultSet rs;
   
    public Category() throws ClassNotFoundException, SQLException {
        initComponents();
        update_table();

}

container1 = new javax.swing.JPanel();
 txtCategory = new javax.swing.JLabel();
 txtProduct = new javax.swing.JLabel();
 txtBrand = new javax.swing.JLabel();
 txtPos = new javax.swing.JLabel();
 txtExit = new javax.swing.JLabel();
 txtCashier = new javax.swing.JLabel();
 jLabel4 = new javax.swing.JLabel();
 txtCategory1 = new javax.swing.JLabel();
 jPanel1 = new javax.swing.JPanel();
 jLabel1 = new javax.swing.JLabel();
 txtCatfield = new javax.swing.JTextField();
 jLabel2 = new javax.swing.JLabel();
 addBtn = new javax.swing.JButton();
 editBtn = new javax.swing.JButton();
 delete_btn = new javax.swing.JButton();
 statusBox1 = new javax.swing.JComboBox<>();
 jScrollPane1 = new javax.swing.JScrollPane();
 jTable1 = new javax.swing.JTable();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

container1.setBackground(new java.awt.Color(255, 102, 0));

jLabel4.setFont(new java.awt.Font("Tw Cen MT Condensed Extra Bold", 1, 36)); // NOI18N
        jLabel4.setText("Grocery Inventory System");

txtCategory1.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
        txtCategory1.setText("Category");

jPanel1.setBorder(javax.swing.BorderFactory.createCompoundBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)), javax.swing.BorderFactory.createEmptyBorder(1, 1, 1, 1)));

jLabel1.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel1.setText("Category :");

txtCatfield.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                txtCatfieldActionPerformed(evt);
            }
        });

jLabel2.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel2.setText("Status :");

statusBox1.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Activate", "deActivate", " " }));

jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addComponent(container1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 419, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(204, 204, 204))
                    .addGroup(layout.createSequentialGroup()
                        .addGap(29, 29, 29)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(txtCategory1, javax.swing.GroupLayout.PREFERRED_SIZE, 127, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addGroup(layout.createSequentialGroup()
                                .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 21, Short.MAX_VALUE)
                                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 406, javax.swing.GroupLayout.PREFERRED_SIZE)))
                        .addGap(56, 56, 56))))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(container1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
            .addGroup(layout.createSequentialGroup()
                .addGap(46, 46, 46)
                .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 54, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(26, 26, 26)
                .addComponent(txtCategory1)
                .addGap(18, 18, 18)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 409, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap(37, Short.MAX_VALUE))
        );

private void editBtnActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_editBtnActionPerformed
          
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
             con = DriverManager.getConnection("jdbc:mysql://localhost/grocery_pos_system", "root","");
             statement = con.prepareStatement("update category  set category = ?,status = ? where id = ?");  
             
             rs = statement.getResultSet();
             DefaultTableModel dtm = (DefaultTableModel)jTable1.getModel();
             int index = jTable1.getSelectedRow();
             int id = Integer.parseInt(dtm.getValueAt(index, 0).toString());
             String txt = txtCatfield.getText();
             String status = statusBox1.getSelectedItem().toString();
             statement.setString(1, txt);
             statement.setString(2, status);
             statement.setInt(3,id);
             statement.executeUpdate();
             txtCatfield.setText("");
             txtCatfield.requestFocus();
             statusBox1.setSelectedIndex(0);
             update_table();
        } 
        
        catch (ClassNotFoundException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        }
           
    }//GEN-LAST:event_editBtnActionPerformed

private void delete_btnActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_delete_btnActionPerformed
        try {
            // TODO add your handling code here:
            Class.forName("com.mysql.cj.jdbc.Driver");
             con = DriverManager.getConnection("jdbc:mysql://localhost/grocery_pos_system", "root","");
             statement = con.prepareStatement("delete from category where id = ? ");  
             DefaultTableModel dtm = (DefaultTableModel)jTable1.getModel();
             int index = jTable1.getSelectedRow();
             int id = Integer.parseInt(dtm.getValueAt(index, 0).toString());
            int dialogMessage = JOptionPane.showConfirmDialog(null, "Do you want to delete this?", "Warning!", JOptionPane.YES_NO_OPTION);
            
            if(dialogMessage == JOptionPane.YES_OPTION){
             statement.setInt(1, id);
             statement.executeUpdate();
             update_table();
            }
             
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_delete_btnActionPerformed

private void txtBrandMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtBrandMouseClicked
        try {
            // TODO add your handling code here:
            Brand b = new Brand();
            this.hide();
            b.setVisible(true);
            
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        }
        
       
    }//GEN-LAST:event_txtBrandMouseClicked

private void txtProductMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtProductMouseClicked
        try {
            // TODO add your handling code here:
            Product p = new Product();
            this.hide();
            p.setVisible(true);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_txtProductMouseClicked

private void txtCategoryMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtCategoryMouseClicked
        // TODO add your handling code here:
        
    }//GEN-LAST:event_txtCategoryMouseClicked

private void txtCatfieldActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_txtCatfieldActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_txtCatfieldActionPerformed

private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTable1MouseClicked
    
     DefaultTableModel dtm = (DefaultTableModel)jTable1.getModel();
    int selectedIndex = jTable1.getSelectedRow();
    txtCatfield.setText(dtm.getValueAt(selectedIndex, 1).toString());
    statusBox1.setSelectedItem(dtm.getValueAt(selectedIndex,2));
        
    }//GEN-LAST:event_jTable1MouseClicked

private void txtPosMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtPosMouseClicked
        try {
            Login_form form = new Login_form();
            this.hide();
            form.setVisible(true);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        }
  
    }//GEN-LAST:event_txtPosMouseClicked

private void txtCashierMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtCashierMouseClicked
        // TODO add your handling code here:
        Cashier cashier;
        try {
            cashier = new Cashier();
            this.hide();
            cashier.setVisible(true);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        }
        
    }//GEN-LAST:event_txtCashierMouseClicked

private void txtExitMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtExitMouseClicked
        try {
            Category c = new Category();
            this.hide();
            c.setDefaultCloseOperation(EXIT_ON_CLOSE);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_txtExitMouseClicked

/**
 * @param args the command line arguments
 */
 public static void main(String args[]) {
 /* Set the Nimbus look and feel */
 //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
 /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
 * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
 */
 try {
 for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
 if ("Nimbus".equals(info.getName())) {
 javax.swing.UIManager.setLookAndFeel(info.getClassName());
 break;
 }
 }
 } catch (ClassNotFoundException ex) {
 java.util.logging.Logger.getLogger(Category.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (InstantiationException ex) {
 java.util.logging.Logger.getLogger(Category.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (IllegalAccessException ex) {
 java.util.logging.Logger.getLogger(Category.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (javax.swing.UnsupportedLookAndFeelException ex) {
 java.util.logging.Logger.getLogger(Category.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 }
 //</editor-fold>

/* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                try {
                    new Category().setVisible(true);
                } 
                catch (ClassNotFoundException ex) {
                    Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
                } catch (SQLException ex) {
                    Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        });
    }

#LoginForm.form codes:

<?xml version="1.0" encoding="UTF-8" ?>

#LoginForm java codes:

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package grocery_pos_system;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Vector;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

public class Login_form extends javax.swing.JFrame {
    private Connection con;
    private PreparedStatement statement;
    private ResultSet rs;
   
    public Login_form() throws ClassNotFoundException, SQLException {
        initComponents();

}

jPanel1 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        txtUsername = new javax.swing.JTextField();
        btnLogin = new javax.swing.JButton();
        cancel_btn = new javax.swing.JButton();
        txtPassword = new javax.swing.JPasswordField();
        jLabel3 = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        setUndecorated(true);

jPanel1.setBackground(new java.awt.Color(255, 102, 0));
        jPanel1.setBorder(javax.swing.BorderFactory.createCompoundBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)), javax.swing.BorderFactory.createEmptyBorder(1, 1, 1, 1)));

jLabel1.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel1.setText("Username :");

btnLogin.setText("Login");
        btnLogin.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnLoginActionPerformed(evt);
            }
        });

cancel_btn.setText("Cancel");
        cancel_btn.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cancel_btnActionPerformed(evt);
            }
        });

jLabel3.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel3.setText("Password :");

jLabel4.setFont(new java.awt.Font("Tw Cen MT Condensed Extra Bold", 1, 40)); // NOI18N
        jLabel4.setText("Login System");

pack();
 setLocationRelativeTo(null);
 }// </editor-fold>//GEN-END:initComponents
 
 
 
 private void btnLoginActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnLoginActionPerformed
 try {
 String txtUser = txtUsername.getText();
 String txtPass = txtPassword.getText();
 
 
 Class.forName("com.mysql.cj.jdbc.Driver");
 con = DriverManager.getConnection("jdbc:mysql://localhost/grocery_pos_system", "root","");
 statement = con.prepareStatement("select * from cashier where username = ? and password = ?");
 statement.setString(1, txtUser);
 statement.setString(2, txtPass);
 rs = statement.executeQuery();
 
 if(rs.next()){
 Pos p = new Pos();
 this.hide();
 
 new Pos(txtUsername.getText()).setVisible(true);
 }
 else{
 JOptionPane.showMessageDialog(this, "Username or Password Incorrect!");
 }
 txtUsername.setText("");
 txtPassword.setText("");
 
 } 
 catch (ClassNotFoundException ex) {
 Logger.getLogger(Login_form.class.getName()).log(Level.SEVERE, null, ex);
 } catch (SQLException ex) {
 Logger.getLogger(Login_form.class.getName()).log(Level.SEVERE, null, ex);
 }
 
 }//GEN-LAST:event_btnLoginActionPerformed

private void cancel_btnActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cancel_btnActionPerformed
       Login_form form;
        try {
            form = new Login_form();
            this.hide();
            form.setDefaultCloseOperation(EXIT_ON_CLOSE);
       
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Login_form.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Login_form.class.getName()).log(Level.SEVERE, null, ex);
        }
       
    }//GEN-LAST:event_cancel_btnActionPerformed

/**
 * @param args the command line arguments
 */
 public static void main(String args[]) {
 /* Set the Nimbus look and feel */
 //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
 /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
 * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
 */
 try {
 for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
 if ("Nimbus".equals(info.getName())) {
 javax.swing.UIManager.setLookAndFeel(info.getClassName());
 break;
 }
 }
 } catch (ClassNotFoundException ex) {
 java.util.logging.Logger.getLogger(Login_form.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (InstantiationException ex) {
 java.util.logging.Logger.getLogger(Login_form.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (IllegalAccessException ex) {
 java.util.logging.Logger.getLogger(Login_form.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (javax.swing.UnsupportedLookAndFeelException ex) {
 java.util.logging.Logger.getLogger(Login_form.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 }
 //</editor-fold>
 //</editor-fold>
 //</editor-fold>
 //</editor-fold>
 //</editor-fold>
 //</editor-fold>
 //</editor-fold>
 //</editor-fold>

/* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                try {
                    new Login_form().setVisible(true);
                } 
                catch (ClassNotFoundException ex) {
                    Logger.getLogger(Login_form.class.getName()).log(Level.SEVERE, null, ex);
                } catch (SQLException ex) {
                    Logger.getLogger(Login_form.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        });
    }

// Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JButton btnLogin;
    private javax.swing.JButton cancel_btn;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPasswordField txtPassword;
    private javax.swing.JTextField txtUsername;
    // End of variables declaration//GEN-END:variables
}

#POS.form codes:

<?xml version="1.0" encoding="UTF-8" ?>

#POS java codes:

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package grocery_pos_system;
import java.awt.event.KeyEvent;
import java.awt.print.PrinterException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.Vector;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

public class Pos extends javax.swing.JFrame {
    private Connection con;
    private PreparedStatement statement;
    private ResultSet rs;
   
    public Pos() throws ClassNotFoundException, SQLException {
        initComponents();
         update_table();

}
 String cashiername;
 public Pos(String cashiername) throws ClassNotFoundException, SQLException {
 this.cashiername = cashiername; 
 initComponents();
 update_table();
 txtcashier.setText(cashiername);
 }
 
 
 /**
 * This method is called from within the constructor to initialize the form.
 * WARNING: Do NOT modify this code. The content of this method is always
 * regenerated by the Form Editor.
 */
 @SuppressWarnings("unchecked")
 // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
 private void initComponents() {

jProgressBar1 = new javax.swing.JProgressBar();
        container1 = new javax.swing.JPanel();
        txtCategory = new javax.swing.JLabel();
        txtProduct = new javax.swing.JLabel();
        txtBrand = new javax.swing.JLabel();
        txtPos = new javax.swing.JLabel();
        txtExit = new javax.swing.JLabel();
        txtCashierLabel = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        txtCategory1 = new javax.swing.JLabel();
        jPanel1 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        txtBarcode = new javax.swing.JTextField();
        addBtn = new javax.swing.JButton();
        pay_btn = new javax.swing.JButton();
        delete_btn = new javax.swing.JButton();
        jLabel3 = new javax.swing.JLabel();
        jLabel5 = new javax.swing.JLabel();
        jLabel6 = new javax.swing.JLabel();
        jLabel10 = new javax.swing.JLabel();
        txtProductName = new javax.swing.JTextField();
        txtPrice = new javax.swing.JTextField();
        txtQty = new javax.swing.JTextField();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        txtPay = new javax.swing.JTextField();
        jLabel11 = new javax.swing.JLabel();
        txtSubtotal = new javax.swing.JTextField();
        txtBal = new javax.swing.JTextField();
        jLabel12 = new javax.swing.JLabel();
        txtcashier = new javax.swing.JLabel();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

container1.setBackground(new java.awt.Color(255, 102, 0));

txtCashierLabel.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
        txtCashierLabel.setForeground(new java.awt.Color(255, 255, 255));
        txtCashierLabel.setText("Cashier");
        txtCashierLabel.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                txtCashierLabelMouseClicked(evt);
            }
        });

javax.swing.GroupLayout container1Layout = new javax.swing.GroupLayout(container1);
        container1.setLayout(container1Layout);
        container1Layout.setHorizontalGroup(
            container1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(container1Layout.createSequentialGroup()
                .addGap(36, 36, 36)
                .addGroup(container1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(txtCashierLabel, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtExit, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtPos, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtProduct, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtBrand, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtCategory, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap(39, Short.MAX_VALUE))
        );
        container1Layout.setVerticalGroup(
            container1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(container1Layout.createSequentialGroup()
                .addGap(96, 96, 96)
                .addComponent(txtCategory)
                .addGap(45, 45, 45)
                .addComponent(txtBrand)
                .addGap(50, 50, 50)
                .addComponent(txtProduct)
                .addGap(49, 49, 49)
                .addComponent(txtPos)
                .addGap(44, 44, 44)
                .addComponent(txtExit)
                .addGap(44, 44, 44)
                .addComponent(txtCashierLabel)
                .addContainerGap(125, Short.MAX_VALUE))
        );

jLabel4.setFont(new java.awt.Font("Tw Cen MT Condensed Extra Bold", 1, 36)); // NOI18N
        jLabel4.setText("Grocery Inventory System");

txtCategory1.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
        txtCategory1.setText("Pos");

jPanel1.setBorder(javax.swing.BorderFactory.createCompoundBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)), javax.swing.BorderFactory.createEmptyBorder(1, 1, 1, 1)));

jLabel1.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel1.setText("BarCode :");

txtBarcode.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                txtBarcodeKeyPressed(evt);
            }
        });

pay_btn.setText("Pay Invoice");
        pay_btn.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                pay_btnActionPerformed(evt);
            }
        });

jLabel3.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel3.setText("Product ");

jLabel5.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel5.setText("Price :");

jLabel6.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel6.setText("Qty :");

jLabel10.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel10.setText("SubTotal :");

jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

},
            new String [] {
                "Barcode", "Product", "Price", "Qty", "Total"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.Integer.class, java.lang.String.class, java.lang.Integer.class, java.lang.Integer.class, java.lang.Integer.class
            };

jLabel11.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel11.setText("Balance :");

jLabel12.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel12.setText("Pay :");

javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(18, 18, 18)
                        .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(jPanel1Layout.createSequentialGroup()
                                .addComponent(jLabel1)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                .addComponent(txtBarcode, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addGap(18, 18, 18)
                                .addComponent(jLabel3)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                .addComponent(txtProductName, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addGap(18, 18, 18)
                                .addComponent(jLabel5)
                                .addGap(18, 18, 18)
                                .addComponent(txtPrice, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addGap(18, 18, 18)
                                .addComponent(jLabel6))
                            .addGroup(jPanel1Layout.createSequentialGroup()
                                .addComponent(jLabel10)
                                .addGap(18, 18, 18)
                                .addComponent(txtSubtotal, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                .addComponent(jLabel12)
                                .addGap(18, 18, 18)
                                .addComponent(txtPay, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addGap(29, 29, 29)
                                .addComponent(jLabel11)
                                .addGap(18, 18, 18)
                                .addComponent(txtBal, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE)))
                        .addGap(18, 18, Short.MAX_VALUE))
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
                        .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 583, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)))
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
                        .addComponent(pay_btn, javax.swing.GroupLayout.DEFAULT_SIZE, 104, Short.MAX_VALUE)
                        .addGap(30, 30, 30))
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                            .addComponent(txtQty)
                            .addComponent(addBtn, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(delete_btn, javax.swing.GroupLayout.DEFAULT_SIZE, 104, Short.MAX_VALUE))
                        .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))))
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addGap(21, 21, 21)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel1)
                    .addComponent(txtBarcode, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel3)
                    .addComponent(jLabel5)
                    .addComponent(jLabel6)
                    .addComponent(txtProductName, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtPrice, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtQty, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18)
                .addComponent(addBtn, javax.swing.GroupLayout.PREFERRED_SIZE, 33, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(23, 23, 23)
                        .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 232, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(113, 113, 113)
                        .addComponent(delete_btn, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE)))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 15, Short.MAX_VALUE)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel10)
                    .addComponent(pay_btn, javax.swing.GroupLayout.PREFERRED_SIZE, 33, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtPay, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel11)
                    .addComponent(txtSubtotal, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtBal, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel12))
                .addGap(64, 64, 64))
        );

txtcashier.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        txtcashier.setText("Cashier :");

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addComponent(container1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 195, Short.MAX_VALUE)
                        .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 419, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(204, 204, 204))
                    .addGroup(layout.createSequentialGroup()
                        .addGap(29, 29, 29)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(layout.createSequentialGroup()
                                .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addContainerGap(32, Short.MAX_VALUE))
                            .addGroup(layout.createSequentialGroup()
                                .addComponent(txtCategory1, javax.swing.GroupLayout.PREFERRED_SIZE, 127, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                .addComponent(txtcashier, javax.swing.GroupLayout.PREFERRED_SIZE, 100, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addGap(110, 110, 110))))))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(container1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
            .addGroup(layout.createSequentialGroup()
                .addGap(46, 46, 46)
                .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 54, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(5, 5, 5)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(txtCategory1)
                    .addComponent(txtcashier))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

pack();
 setLocationRelativeTo(null);
 }// </editor-fold>//GEN-END:initComponents
 
 private void update_table() throws ClassNotFoundException, SQLException{
 
 Class.forName("com.mysql.cj.jdbc.Driver");
 con = DriverManager.getConnection("jdbc:mysql://localhost/grocery_pos_system", "root","");
 statement = con.prepareStatement("select * from product_item where barcode = ? ");
 String barcode = txtBarcode.getText();
 statement.setString(1, barcode);
 rs = statement.executeQuery();
 DefaultTableModel dtm = (DefaultTableModel)jTable1.getModel();
 
 while(rs.next()){
 int qty = Integer.valueOf(rs.getString(8));
 int qtyNew = Integer.valueOf(txtQty.getText());
 
 if(qtyNew >= qty){
 JOptionPane.showMessageDialog(this, "Quantity left = "+qty);
 JOptionPane.showMessageDialog(this, "Quantity not enough!");
 }
 
 else{
 int price = Integer.valueOf(txtPrice.getText());
 int total = price * qtyNew;
 Vector v = new Vector();
 v.addElement(barcode);
 v.addElement(txtProductName.getText());
 v.addElement(txtPrice.getText());
 v.addElement(qtyNew);
 v.addElement(total);
 dtm.addRow(v);
 
 int sum = 0;
 for(int i = 0; i<dtm.getRowCount(); i++){
 sum = sum+Integer.parseInt(dtm.getValueAt(i,4).toString());
 
 }
 txtSubtotal.setText(String.valueOf(sum));
 
 }
 txtBarcode.setText("");
 txtProductName.setText("");
 txtPrice.setText("");
 txtQty.setText("");
 }
 
 }
 
 private void addBtnActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_addBtnActionPerformed
 try {
 update_table();
 } catch (ClassNotFoundException ex) {
 Logger.getLogger(Pos.class.getName()).log(Level.SEVERE, null, ex);
 } catch (SQLException ex) {
 Logger.getLogger(Pos.class.getName()).log(Level.SEVERE, null, ex);
 }
 }//GEN-LAST:event_addBtnActionPerformed

private void pay_btnActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_pay_btnActionPerformed
        int subtotal = Integer.valueOf(txtSubtotal.getText());
        int pay = Integer.valueOf(txtPay.getText());
        int balance = pay - subtotal;
        txtBal.setText(Integer.toString(balance));
        pay_invoice();
        printReceift();

}//GEN-LAST:event_pay_btnActionPerformed

private void printReceift(){
 String Subtotal = txtSubtotal.getText();
 String pay = txtPay.getText();
 String balance = txtBal.getText();
 
 try {
 
 new Print_Receift(Subtotal, pay, balance, jTable1).setVisible(true);
 } catch (PrinterException ex) {
 Logger.getLogger(Pos.class.getName()).log(Level.SEVERE, null, ex);
 }
 
 } 
 
 private void pay_invoice(){
 
 DateTimeFormatter dtf = DateTimeFormatter.ofPattern("yyyy/MM/dd/hh/mm/ss");
 LocalDateTime dt = LocalDateTime.now();
 String date = dtf.format(dt);
 String cashier = txtcashier.getText();
 int subtotal = Integer.valueOf(txtSubtotal.getText());
 int pay = Integer.valueOf(txtPay.getText());
 int balance = Integer.valueOf(txtBal.getText());
 int genKey = 0;
 
 try {
 Class.forName("com.mysql.cj.jdbc.Driver");
 con = DriverManager.getConnection("jdbc:mysql://localhost/grocery_pos_system", "root", "");
 String sql1 = "insert into pos(date,cashier,subtotal,pay,balance) values(?,?,?,?,?)";
 
 statement = con.prepareStatement(sql1, statement.RETURN_GENERATED_KEYS);
 statement.setString(1, date);
 statement.setString(2, cashier);
 statement.setInt(3, subtotal);
 statement.setInt(4, pay);
 statement.setInt(5, balance);
 statement.executeUpdate();
 
 ResultSet key = statement.getGeneratedKeys();
 if(key.next()){
 genKey = key.getInt(1);
 }
 
 int row = jTable1.getRowCount();
 String sql2 = "insert into sales_product(barcode,item,sales_id,price,qty,total) values(?,?,?,?,?,?)";
 statement = con.prepareStatement(sql2);
 String barcode = "";
 String product = "";
 String price = "";
 int qty = 0;
 int total = 0;
 
 for(int i = 0; i<row;i++){
 barcode = (String)jTable1.getValueAt(i, 0);
 product = (String)jTable1.getValueAt(i, 1);
 price = (String)jTable1.getValueAt(i, 2);
 qty = (int)jTable1.getValueAt(i, 3);
 total = (int)jTable1.getValueAt(i, 4);
 
 statement.setString(1, barcode);
 statement.setString(2, product);
 statement.setInt(3, genKey);
 statement.setString(4,price);
 statement.setInt(5, qty);
 statement.setInt(6, total);
 statement.executeUpdate();
 }
 
 String sql3 = "update product_item set qty = qty-? where barcode = ?";
 statement = con.prepareStatement(sql3);
 for(int i = 0; i<row; i++){
 barcode = (String)jTable1.getValueAt(i, 0);
 qty = (int)jTable1.getValueAt(i, 3);
 
 statement.setInt(1, qty);
 statement.setString(2, barcode);
 statement.execute();
 }
 statement.addBatch();
 JOptionPane.showMessageDialog(this, "Record Qty Updated!");
 
 
 } 
 catch (ClassNotFoundException ex) {
 Logger.getLogger(Pos.class.getName()).log(Level.SEVERE, null, ex);
 } catch (SQLException ex) {
 Logger.getLogger(Pos.class.getName()).log(Level.SEVERE, null, ex);
 }
 
 }

private void delete_btnActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_delete_btnActionPerformed
 DefaultTableModel dtm = (DefaultTableModel)jTable1.getModel();
 dtm.removeRow(jTable1.getSelectedRow());
 int selectedRow = jTable1.getRowCount();
 int sum = 0;
 
 for(int i = 0; i<selectedRow; i++){
 
 sum = Integer.parseInt(dtm.getValueAt(i, 4).toString());
 
 }
 txtSubtotal.setText(String.valueOf(sum));
 txtBarcode.setText("");
 txtProductName.setText("");
 txtPrice.setText("");
 txtQty.setText("");
 txtPay.setText("");
 txtBal.setText("");
 
 
 }//GEN-LAST:event_delete_btnActionPerformed

private void txtBrandMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtBrandMouseClicked
        // TODO add your handling code here:
         try {
            // TODO add your handling code here:
            Brand b = new Brand();
            this.hide();
            b.setVisible(true);
            
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        }
        
       
    }//GEN-LAST:event_txtBrandMouseClicked

private void txtCategoryMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtCategoryMouseClicked
        // TODO add your handling code here:
        Category c;
        try {
            c = new Category();
             this.hide();
            c.setVisible(true);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Pos.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Pos.class.getName()).log(Level.SEVERE, null, ex);
        }
       
    }//GEN-LAST:event_txtCategoryMouseClicked

private void txtProductMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtProductMouseClicked
        // TODO add your handling code here:
         try {
            // TODO add your handling code here:
            Pos p = new Pos();
            this.hide();
            p.setVisible(true);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_txtProductMouseClicked

private void txtPosMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtPosMouseClicked
        // TODO add your handling code here:
      
    }//GEN-LAST:event_txtPosMouseClicked

private void txtBarcodeKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_txtBarcodeKeyPressed
        // TODO add your handling code here:
        if(evt.getKeyCode() == KeyEvent.VK_ENTER){
            
            try {
                Class.forName("com.mysql.cj.jdbc.Driver");
                con = DriverManager.getConnection("jdbc:mysql://localhost/grocery_pos_system", "root","");
                statement = con.prepareStatement("select * from product_item where barcode = ?");
                String barcode = txtBarcode.getText();
                statement.setString(1, barcode);
                rs = statement.executeQuery();
                
                if(rs.next() == false){
                JOptionPane.showMessageDialog(this, "Barcode not found!");
                }
                
                else{
                txtBarcode.setText(barcode);
                txtProductName.setText(rs.getString(2));
                txtPrice.setText(rs.getString(7));
                }
                
            } catch (ClassNotFoundException ex) {
                Logger.getLogger(Pos.class.getName()).log(Level.SEVERE, null, ex);
            } catch (SQLException ex) {
                Logger.getLogger(Pos.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
    }//GEN-LAST:event_txtBarcodeKeyPressed

private void txtCashierLabelMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtCashierLabelMouseClicked
        // TODO add your handling code here:
      
    }//GEN-LAST:event_txtCashierLabelMouseClicked

private void txtExitMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtExitMouseClicked
        try {
            Pos p = new Pos();
            this.hide();
            p.setDefaultCloseOperation(EXIT_ON_CLOSE);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_txtExitMouseClicked

/**
 * @param args the command line arguments
 */
 public static void main(String args[]) {
 /* Set the Nimbus look and feel */
 //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
 /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
 * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
 */
 try {
 for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
 if ("Nimbus".equals(info.getName())) {
 javax.swing.UIManager.setLookAndFeel(info.getClassName());
 break;
 }
 }
 } catch (ClassNotFoundException ex) {
 java.util.logging.Logger.getLogger(Pos.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (InstantiationException ex) {
 java.util.logging.Logger.getLogger(Pos.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (IllegalAccessException ex) {
 java.util.logging.Logger.getLogger(Pos.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (javax.swing.UnsupportedLookAndFeelException ex) {
 java.util.logging.Logger.getLogger(Pos.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 }

/* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                try {
                    new Pos().setVisible(true);
                } 
                catch (ClassNotFoundException ex) {
                    Logger.getLogger(Pos.class.getName()).log(Level.SEVERE, null, ex);
                } catch (SQLException ex) {
                    Logger.getLogger(Pos.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        });
    }

// Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JButton addBtn;
    private javax.swing.JPanel container1;
    private javax.swing.JButton delete_btn;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JProgressBar jProgressBar1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTable jTable1;
    private javax.swing.JButton pay_btn;
    private javax.swing.JTextField txtBal;
    private javax.swing.JTextField txtBarcode;
    private javax.swing.JLabel txtBrand;
    private javax.swing.JLabel txtCashierLabel;
    private javax.swing.JLabel txtCategory;
    private javax.swing.JLabel txtCategory1;
    private javax.swing.JLabel txtExit;
    private javax.swing.JTextField txtPay;
    private javax.swing.JLabel txtPos;
    private javax.swing.JTextField txtPrice;
    private javax.swing.JLabel txtProduct;
    private javax.swing.JTextField txtProductName;
    private javax.swing.JTextField txtQty;
    private javax.swing.JTextField txtSubtotal;
    private javax.swing.JLabel txtcashier;
    // End of variables declaration//GEN-END:variables
}

#PrintReceift Codes:

<?xml version="1.0" encoding="UTF-8" ?>

#Print Receift java codes:

import java.awt.print.PrinterException;
import javax.swing.JTable;

/**
 *
 * @author Ronaldo
 */
public class Print_Receift extends javax.swing.JFrame {

public Print_Receift() {
        initComponents();
    }
    String subtotal,pay,balance;
    JTable table;
    public Print_Receift(String subtotal, String pay, String balance, JTable table) throws PrinterException{
    initComponents();
    this.subtotal = subtotal;
    this.pay = pay;
    this.balance = balance;
    this.table = table;

for(int i = 0; i<table.getRowCount();i++){
 String barcode = (String)table.getValueAt(i, 0);
 String product = (String)table.getValueAt(i, 1);
 String price= (String)table.getValueAt(i, 2);
 int qty = (int)table.getValueAt(i, 3);
 int total = (int)table.getValueAt(i, 4);
 
 txtPrint.setText(txtPrint.getText()+"***********"+"\n");
 txtPrint.setText(txtPrint.getText()+"****GROCERY POS SYSTEM*****"+"\n"
 +"Barcode : "+barcode +"\n"
 +"Product : "+product +"\n"
 +"Price : " +price+"\n"
 +"Qty : "+qty +"\n"
 +"Total : "+total+"\n");
 
 txtPrint.setText(txtPrint.getText()+"Subtotal : " +subtotal+"\n" 
 +"Pay : " +pay +"\n"
 +"Balance : "+balance +"\n"
 +"****THANK YOU! COME AGAIN...");
 txtPrint.print();
 }

}
 @SuppressWarnings("unchecked")
 // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
 private void initComponents() {

jScrollPane1 = new javax.swing.JScrollPane();
        txtPrint = new javax.swing.JTextArea();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

txtPrint.setColumns(20);
        txtPrint.setRows(5);
        jScrollPane1.setViewportView(txtPrint);

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 186, Short.MAX_VALUE)
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 312, Short.MAX_VALUE)
        );

pack();
 }// </editor-fold>//GEN-END:initComponents

/**
 * @param args the command line arguments
 */
 public static void main(String args[]) {
 /* Set the Nimbus look and feel */
 //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
 /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
 * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
 */
 try {
 for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
 if ("Nimbus".equals(info.getName())) {
 javax.swing.UIManager.setLookAndFeel(info.getClassName());
 break;
 }
 }
 } catch (ClassNotFoundException ex) {
 java.util.logging.Logger.getLogger(Print_Receift.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (InstantiationException ex) {
 java.util.logging.Logger.getLogger(Print_Receift.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (IllegalAccessException ex) {
 java.util.logging.Logger.getLogger(Print_Receift.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (javax.swing.UnsupportedLookAndFeelException ex) {
 java.util.logging.Logger.getLogger(Print_Receift.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 }
 //</editor-fold>

/* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new Print_Receift().setVisible(true);
            }
        });
    }

// Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTextArea txtPrint;
    // End of variables declaration//GEN-END:variables
}

#Product.form codes:

<?xml version="1.0" encoding="UTF-8" ?>

#Products java codes:

public class Product extends javax.swing.JFrame {
    private Connection con;
    private PreparedStatement statement;
    private ResultSet rs;
   
    public Product() throws ClassNotFoundException, SQLException {
        initComponents();
         update_table();
        loadCategoryItem();
        loadBrandItem();

}
 
 public class CategoryItem{
 private int id;
 private String name;
 
 
 public CategoryItem(int id, String name){
 this.id = id;
 this.name = name;
 
 }
 public CategoryItem(){
 
 } 
 public String toString(){
 
 return name;
 }
 }
 
 public class BrandItem{
 private int id;
 private String name;
 
 public BrandItem(int id, String name){
 this.id = id;
 this.name = name;
 
 }
 
 public String toString(){
 
 return name;
 }
 }
 
 private void loadCategoryItem(){
 try {
 Class.forName("com.mysql.cj.jdbc.Driver");
 con = DriverManager.getConnection("jdbc:mysql://localhost/grocery_pos_system", "root","");
 statement = con.prepareStatement("select * from category");
 rs = statement.executeQuery();
 catCombox.removeAllItems();
 while(rs.next()){
 catCombox.addItem(new CategoryItem(rs.getInt(1), rs.getString(2)));
 }
 }
 
 catch (ClassNotFoundException ex) {
 Logger.getLogger(Product.class.getName()).log(Level.SEVERE, null, ex);
 } catch (SQLException ex) {
 Logger.getLogger(Product.class.getName()).log(Level.SEVERE, null, ex);
 }
 }
 
 private void loadBrandItem(){
 try {
 Class.forName("com.mysql.cj.jdbc.Driver");
 con = DriverManager.getConnection("jdbc:mysql://localhost/grocery_pos_system", "root","");
 statement = con.prepareStatement("select * from brand");
 rs = statement.executeQuery();
 brandCombox.removeAllItems();
 while(rs.next()){
 brandCombox.addItem(new BrandItem(rs.getInt(1),rs.getString(2)));
 }
 }
 catch (ClassNotFoundException ex) {
 Logger.getLogger(Product.class.getName()).log(Level.SEVERE, null, ex);
 } catch (SQLException ex) {
 Logger.getLogger(Product.class.getName()).log(Level.SEVERE, null, ex);
 }
 
 }
 
 /**
 * This method is called from within the constructor to initialize the form.
 * WARNING: Do NOT modify this code. The content of this method is always
 * regenerated by the Form Editor.
 */
 @SuppressWarnings("unchecked")
 // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
 private void initComponents() {

jProgressBar1 = new javax.swing.JProgressBar();
 container1 = new javax.swing.JPanel();
 txtCategory = new javax.swing.JLabel();
 txtProduct = new javax.swing.JLabel();
 txtBrand = new javax.swing.JLabel();
 txtPos = new javax.swing.JLabel();
 txtExit = new javax.swing.JLabel();
 txtCashier = new javax.swing.JLabel();
 jLabel4 = new javax.swing.JLabel();
 txtCategory1 = new javax.swing.JLabel();
 jPanel1 = new javax.swing.JPanel();
 jLabel1 = new javax.swing.JLabel();
 txtProducts = new javax.swing.JTextField();
 jLabel2 = new javax.swing.JLabel();
 addBtn = new javax.swing.JButton();
 editBtn = new javax.swing.JButton();
 delete_btn = new javax.swing.JButton();
 statusBox1 = new javax.swing.JComboBox<>();
 txtRPrice = new javax.swing.JTextField();
 jLabel3 = new javax.swing.JLabel();
 txtQty = new javax.swing.JTextField();
 jLabel5 = new javax.swing.JLabel();
 txtBarCode = new javax.swing.JTextField();
 jLabel6 = new javax.swing.JLabel();
 jLabel7 = new javax.swing.JLabel();
 jLabel8 = new javax.swing.JLabel();
 jLabel9 = new javax.swing.JLabel();
 jLabel10 = new javax.swing.JLabel();
 jScrollPane2 = new javax.swing.JScrollPane();
 txtDesc = new javax.swing.JTextArea();
 catCombox = new javax.swing.JComboBox();
 brandCombox = new javax.swing.JComboBox();
 txtCostPrice = new javax.swing.JTextField();
 jScrollPane1 = new javax.swing.JScrollPane();
 jTable1 = new javax.swing.JTable();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

container1.setBackground(new java.awt.Color(255, 102, 0));

jLabel4.setFont(new java.awt.Font("Tw Cen MT Condensed Extra Bold", 1, 36)); // NOI18N
        jLabel4.setText("Grocery Inventory System");

txtCategory1.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
        txtCategory1.setText("Product");

jPanel1.setBorder(javax.swing.BorderFactory.createCompoundBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)), javax.swing.BorderFactory.createEmptyBorder(1, 1, 1, 1)));

jLabel1.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel1.setText("Product :");

jLabel2.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel2.setText("Status :");

statusBox1.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Activate", "deActivate", " " }));

jLabel3.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel3.setText("Retail Price :");

jLabel5.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel5.setText("Qty :");

jLabel6.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel6.setText("Bar Code :");

jLabel7.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel7.setText("Description :");

jLabel8.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel8.setText("Category :");

jLabel9.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel9.setText("Brand :");

jLabel10.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel10.setText("Cost Price :");

txtDesc.setColumns(20);
        txtDesc.setRows(5);
        jScrollPane2.setViewportView(txtDesc);

javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
                .addGap(18, 18, 18)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addComponent(jLabel10)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addComponent(addBtn)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(editBtn)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(delete_btn))
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(jPanel1Layout.createSequentialGroup()
                                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(jLabel1)
                                    .addComponent(jLabel7)
                                    .addComponent(jLabel8))
                                .addGap(28, 28, 28)
                                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(catCombox, javax.swing.GroupLayout.PREFERRED_SIZE, 166, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                                        .addComponent(jScrollPane2, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 157, Short.MAX_VALUE)
                                        .addComponent(txtProducts, javax.swing.GroupLayout.Alignment.LEADING))))
                            .addGroup(jPanel1Layout.createSequentialGroup()
                                .addComponent(jLabel9)
                                .addGap(61, 61, 61)
                                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(brandCombox, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                    .addComponent(txtCostPrice))))
                        .addGap(191, 191, 191)
                        .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
                                        .addComponent(jLabel3)
                                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED))
                                    .addGroup(jPanel1Layout.createSequentialGroup()
                                        .addComponent(jLabel5)
                                        .addGap(56, 56, 56)))
                                .addGroup(jPanel1Layout.createSequentialGroup()
                                    .addComponent(jLabel6)
                                    .addGap(23, 23, 23)))
                            .addGroup(jPanel1Layout.createSequentialGroup()
                                .addComponent(jLabel2)
                                .addGap(37, 37, 37)))
                        .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(statusBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 99, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                                .addComponent(txtQty, javax.swing.GroupLayout.DEFAULT_SIZE, 99, Short.MAX_VALUE)
                                .addComponent(txtRPrice)
                                .addComponent(txtBarCode)))))
                .addGap(97, 97, 97))
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addGap(21, 21, 21)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel1)
                    .addComponent(txtProducts, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel3)
                    .addComponent(txtRPrice, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(41, 41, 41)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(txtQty, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jLabel5)
                            .addComponent(jLabel7))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 47, Short.MAX_VALUE))
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)
                        .addGap(17, 17, 17)))
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel6)
                    .addComponent(txtBarCode, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel8)
                    .addComponent(catCombox, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(40, 40, 40)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(statusBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel2)
                    .addComponent(jLabel9)
                    .addComponent(brandCombox, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(30, 30, 30)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(addBtn)
                    .addComponent(editBtn)
                    .addComponent(delete_btn)
                    .addComponent(jLabel10)
                    .addComponent(txtCostPrice, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(32, 32, 32))
        );

jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

},
            new String [] {
                "Id", "Product", "Description", "Category_ID", "Brand_ID", "CostPrice", "RetailPrice", "Qty", "BarCode", "Status"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.Integer.class, java.lang.String.class, java.lang.String.class, java.lang.Integer.class, java.lang.Integer.class, java.lang.Integer.class, java.lang.Integer.class, java.lang.Integer.class, java.lang.Integer.class, java.lang.String.class
            };

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addComponent(container1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 196, Short.MAX_VALUE)
                        .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 419, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(204, 204, 204))
                    .addGroup(layout.createSequentialGroup()
                        .addGap(29, 29, 29)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                            .addComponent(txtCategory1, javax.swing.GroupLayout.PREFERRED_SIZE, 127, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(jScrollPane1))
                        .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(container1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
            .addGroup(layout.createSequentialGroup()
                .addGap(46, 46, 46)
                .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 54, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(5, 5, 5)
                .addComponent(txtCategory1)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addGap(18, 18, 18)
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 168, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap())
        );

pack();
 setLocationRelativeTo(null);
 }// </editor-fold>//GEN-END:initComponents
 
 private void update_table() throws ClassNotFoundException, SQLException{
 
 int columnCount; 
 Class.forName("com.mysql.cj.jdbc.Driver");
 con = DriverManager.getConnection("jdbc:mysql://localhost/grocery_pos_system", "root","");
 statement = con.prepareStatement("select p.id,p.product,p.description,c.category,b.brand,p.cost_price,p.retail_price,p.qty,p.barcode,p.status from product_item p,category c,brand b where p.category_id = c.id and p.brand_id = b.id");
 statement.executeQuery();
 DefaultTableModel dtm = (DefaultTableModel)jTable1.getModel();
 dtm.setRowCount(0);
 rs = statement.getResultSet();
 ResultSetMetaData rsmd = rs.getMetaData();
 columnCount = rsmd.getColumnCount();
 
 for(int i = 1; i<columnCount; i++){
 while(rs.next()){
 Vector v = new Vector();
 v.add(rs.getString(1));
 v.add(rs.getString(2));
 v.add(rs.getString(3));
 v.add(rs.getString(4));
 v.add(rs.getString(5));
 v.add(rs.getString(6));
 v.add(rs.getString(7));
 v.add(rs.getString(8));
 v.add(rs.getString(9));
 v.add(rs.getString(10));
 dtm.addRow(v);
 }
 }
 }
 
 private void addBtnActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_addBtnActionPerformed
 try {
 String txtProduct = txtProducts.getText();
 String txtDescription= txtDesc.getText();
 CategoryItem item = (CategoryItem)catCombox.getSelectedItem();
 BrandItem bItem = (BrandItem) brandCombox.getSelectedItem();
 String costPrice = txtCostPrice.getText();
 String rPrice = txtRPrice.getText();
 String qty = txtQty.getText();
 String barcode = txtBarCode.getText();
 String status = statusBox1.getSelectedItem().toString();
 Class.forName("com.mysql.cj.jdbc.Driver");
 con = DriverManager.getConnection("jdbc:mysql://localhost/grocery_pos_system", "root","");
 statement = con.prepareStatement("insert into product_item(product,description,category_id,brand_id,cost_price,retail_price,qty,barcode,status) values(?,?,?,?,?,?,?,?,?)");
 statement.setString(1, txtProduct);
 statement.setString(2, txtDescription);
 statement.setInt(3, item.id);
 statement.setInt(4, bItem.id);
 statement.setString(5,costPrice);
 statement.setString(6, rPrice);
 statement.setString(7,qty);
 statement.setString(8, barcode);
 statement.setString(9, status);
 statement.executeUpdate();
 txtProducts.setText("");
 txtDesc.setText("");
 catCombox.setSelectedIndex(0);
 brandCombox.setSelectedIndex(0);
 txtCostPrice.setText("");
 txtRPrice.setText("");
 txtQty.setText("");
 txtBarCode.setText("");
 statusBox1.setSelectedIndex(0);
 update_table();
 } 
 catch (ClassNotFoundException ex) {
 Logger.getLogger(Product.class.getName()).log(Level.SEVERE, null, ex);
 } catch (SQLException ex) {
 Logger.getLogger(Product.class.getName()).log(Level.SEVERE, null, ex);
 }
 
 }//GEN-LAST:event_addBtnActionPerformed

private void editBtnActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_editBtnActionPerformed
          
             DefaultTableModel dtm = (DefaultTableModel)jTable1.getModel();
             int index = jTable1.getSelectedRow();
             int id = Integer.parseInt(dtm.getValueAt(index, 0).toString());
             String txtProduct = txtProducts.getText();
            String txtDescription= txtDesc.getText();
            CategoryItem item = (CategoryItem)catCombox.getSelectedItem();
            BrandItem bItem = (BrandItem)   brandCombox.getSelectedItem();
            String costPrice = txtCostPrice.getText();
            String rPrice = txtRPrice.getText();
            String qty = txtQty.getText();
            String barcode = txtBarCode.getText();
            String status = statusBox1.getSelectedItem().toString();
            
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
             con = DriverManager.getConnection("jdbc:mysql://localhost/grocery_pos_system", "root","");
             statement = con.prepareStatement("update product_item  set product = ?, description = ?, category_id = ?, brand_id = ?,cost_price = ?, retail_price = ?,qty = ?, barcode = ?,status = ? where id = ?");  
            statement.setString(1, txtProduct);
            statement.setString(2, txtDescription);
            statement.setInt(3, item.id);
            statement.setInt(4, bItem.id);
            statement.setString(5,costPrice);
            statement.setString(6, rPrice);
            statement.setString(7,qty);
            statement.setString(8, barcode);
            statement.setString(9, status);
            statement.setInt(10, id);
            statement.executeUpdate();
            txtProducts.setText("");
            txtDesc.setText("");
            catCombox.setSelectedIndex(0);
            brandCombox.setSelectedIndex(0);
            txtCostPrice.setText("");
            txtRPrice.setText("");
            txtQty.setText("");
            txtBarCode.setText("");
            statusBox1.setSelectedIndex(0);
             update_table();
        } 
        
        catch (ClassNotFoundException ex) {
            Logger.getLogger(Product.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Product.class.getName()).log(Level.SEVERE, null, ex);
        }
           
    }//GEN-LAST:event_editBtnActionPerformed

private void delete_btnActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_delete_btnActionPerformed
        try {
            // TODO add your handling code here:
            Class.forName("com.mysql.cj.jdbc.Driver");
             con = DriverManager.getConnection("jdbc:mysql://localhost/grocery_pos_system", "root","");
             statement = con.prepareStatement("delete from product_item where id = ? ");  
             DefaultTableModel dtm = (DefaultTableModel)jTable1.getModel();
             int index = jTable1.getSelectedRow();
             int id = Integer.parseInt(dtm.getValueAt(index, 0).toString());
            int dialogMessage = JOptionPane.showConfirmDialog(null, "Do you want to delete this?", "Warning!", JOptionPane.YES_NO_OPTION);
            
            if(dialogMessage == JOptionPane.YES_OPTION){
             statement.setInt(1, id);
             statement.executeUpdate();
             update_table();
            txtProducts.setText("");
            txtDesc.setText("");
            catCombox.setSelectedIndex(0);
            brandCombox.setSelectedIndex(0);
            txtCostPrice.setText("");
            txtRPrice.setText("");
            txtQty.setText("");
            txtBarCode.setText("");
            statusBox1.setSelectedIndex(0);
             
            }
             
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Product.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Product.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_delete_btnActionPerformed

private void txtCategoryMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtCategoryMouseClicked
        // TODO add your handling code here:
        Category c;
        try {
            c = new Category();
             this.hide();
            c.setVisible(true);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Product.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Product.class.getName()).log(Level.SEVERE, null, ex);
        }
       
    }//GEN-LAST:event_txtCategoryMouseClicked

private void txtProductMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtProductMouseClicked
        // TODO add your handling code here:
         try {
            // TODO add your handling code here:
            Product p = new Product();
            this.hide();
            p.setVisible(true);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_txtProductMouseClicked

private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTable1MouseClicked
        // TODO add your handling code here:
        
     DefaultTableModel dtm = (DefaultTableModel)jTable1.getModel();
     int selectedIndex = jTable1.getSelectedRow();
    txtProducts.setText(dtm.getValueAt(selectedIndex, 1).toString());
     txtDesc.setText(dtm.getValueAt(selectedIndex, 2).toString());
    catCombox.setSelectedItem(dtm.getValueAt(selectedIndex,3).toString());
    brandCombox.setSelectedItem(dtm.getValueAt(selectedIndex,4).toString());
    txtCostPrice.setText(dtm.getValueAt(selectedIndex, 5).toString());
    txtRPrice.setText(dtm.getValueAt(selectedIndex, 6).toString());
    txtQty.setText(dtm.getValueAt(selectedIndex, 7).toString());
    txtBarCode.setText(dtm.getValueAt(selectedIndex, 8).toString());
    statusBox1.setSelectedItem(dtm.getValueAt(selectedIndex,9));
    }//GEN-LAST:event_jTable1MouseClicked

private void txtPosMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtPosMouseClicked
        // TODO add your handling code here:
          try {
            Login_form form = new Login_form();
            this.hide();
            form.setVisible(true);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_txtPosMouseClicked

private void txtExitMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtExitMouseClicked
        // TODO add your handling code here:
          try {
            Product p = new Product();
            this.hide();
            p.setDefaultCloseOperation(EXIT_ON_CLOSE);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Category.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_txtExitMouseClicked

/**
 * @param args the command line arguments
 */
 public static void main(String args[]) {
 /* Set the Nimbus look and feel */
 //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
 /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
 * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
 */
 try {
 for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
 if ("Nimbus".equals(info.getName())) {
 javax.swing.UIManager.setLookAndFeel(info.getClassName());
 break;
 }
 }
 } catch (ClassNotFoundException ex) {
 java.util.logging.Logger.getLogger(Product.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (InstantiationException ex) {
 java.util.logging.Logger.getLogger(Product.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (IllegalAccessException ex) {
 java.util.logging.Logger.getLogger(Product.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 } catch (javax.swing.UnsupportedLookAndFeelException ex) {
 java.util.logging.Logger.getLogger(Product.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
 }

/* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                try {
                    new Product().setVisible(true);
                } 
                catch (ClassNotFoundException ex) {
                    Logger.getLogger(Product.class.getName()).log(Level.SEVERE, null, ex);
                } catch (SQLException ex) {
                    Logger.getLogger(Product.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        });
    }

// Variables declaration - do not modify//GEN-BEGIN:variables
 private javax.swing.JButton addBtn;
 private javax.swing.JComboBox brandCombox;
 private javax.swing.JComboBox catCombox;
 private javax.swing.JPanel container1;
 private javax.swing.JButton delete_btn;
 private javax.swing.JButton editBtn;
 private javax.swing.JLabel jLabel1;
 private javax.swing.JLabel jLabel10;
 private javax.swing.JLabel jLabel2;
 private javax.swing.JLabel jLabel3;
 private javax.swing.JLabel jLabel4;
 private javax.swing.JLabel jLabel5;
 private javax.swing.JLabel jLabel6;
 private javax.swing.JLabel jLabel7;
 private javax.swing.JLabel jLabel8;
 private javax.swing.JLabel jLabel9;
 private javax.swing.JPanel jPanel1;
 private javax.swing.JProgressBar jProgressBar1;
 private javax.swing.JScrollPane jScrollPane1;
 private javax.swing.JScrollPane jScrollPane2;
 private javax.swing.JTable jTable1;
 private javax.swing.JComboBox<String> statusBox1;
 private javax.swing.JTextField txtBarCode;
 private javax.swing.JLabel txtBrand;
 private javax.swing.JLabel txtCashier;
 private javax.swing.JLabel txtCategory;
 private javax.swing.JLabel txtCategory1;
 private javax.swing.JTextField txtCostPrice;
 private javax.swing.JTextArea txtDesc;
 private javax.swing.JLabel txtExit;
 private javax.swing.JLabel txtPos;
 private javax.swing.JLabel txtProduct;
 private javax.swing.JTextField txtProducts;
 private javax.swing.JTextField txtQty;
 private javax.swing.JTextField txtRPrice;
 // End of variables declaration//GEN-END:variables
}

How to create Grocery Inventory System (POS) 18 Adding PAY Invoice Button function TAGALOG

Posted by ninalblog

Post a Comment

0 Comments

Search This Blog

Subscribe Us

Tags

linkvertise

Total Pageviews

Most Popular

Trail Riders: Ultimate Journey

Android Retrofit tutorial All Crypto Currency Signal app using MVVM|COINMARKETCAP API # 9

Download

Categories

How to create Grocery Inventory System (POS) 18 Adding PAY Invoice Button function TAGALOG

Posted by ninalblog

Post a Comment

0 Comments

Search This Blog

Subscribe Us

Tags

linkvertise

Total Pageviews

Most Popular

Trail Riders: Ultimate Journey

Android Retrofit tutorial All Crypto Currency Signal app using MVVM|COINMARKETCAP API # 9

Download

Categories

Footer Social Widget