The Point of sales System is developed using Java and mysql. The project is built to manage items and transactions. To make a new transaction, fields such as: product name, qty and payment needs to be selected. If you like to learn point of sales systems step by step, this is the right place to learn from the beginning.
First we have to search the barcode select the Textfield and select Event keyReleased
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | private void txtidKeyReleased(java.awt.event.KeyEvent evt) { try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost/rbc","root",""); String id = txtid.getText(); pst = con.prepareStatement("select id,barcode,product,price from product where barcode = ?"); pst.setString(1, id); ResultSet rs = pst.executeQuery(); if(rs.next()==true) { String prodname = rs.getString(3); String price = rs.getString(4); txtpname.setText(prodname); txtprice.setText(price); } else { txtpname.setText(""); txtprice.setText(""); } } catch (ClassNotFoundException ex) { Logger.getLogger(find.class.getName()).log(Level.SEVERE, null, ex); } catch (SQLException ex) { Logger.getLogger(find.class.getName()).log(Level.SEVERE, null, ex); } } |
After receiving the product name and price where the user has the option to add the qty by clicking the add button to see all Products details which will be shown in the below table.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 | String panme = (txtpname.getText()); int price = Integer.parseInt(txtprice.getText()); int qty = Integer.parseInt(txtqty.getText()); int tot = qty * price; model = (DefaultTableModel)jTable1.getModel(); model.addRow(new Object[] { panme , price, qty, tot, }); int sum = 0; for(int i = 0; i<jTable1.getRowCount(); i++) { sum = sum + Integer.parseInt(jTable1.getValueAt(i, 3).toString()); } txtotal.setText(Integer.toString(sum)); txtid.setText(""); txtpname.setText(""); txtprice.setText(""); txtqty.setText(""); txtid.requestFocus(); |
Bill Design
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 | public void bill() { String total = txtotal.getText(); DefaultTableModel model = new DefaultTableModel(); model = (DefaultTableModel)jTable1.getModel(); txtbill.setText(txtbill.getText() + "******************************************************\n"); txtbill.setText(txtbill.getText() + " POSBILL \n"); txtbill.setFont(txtbill.getFont().deriveFont(Font.BOLD, 13f)); txtbill.setText(txtbill.getText() + "*******************************************************\n"); //Heading txtbill.setText(txtbill.getText() + "Product" + "\t" + "Price" + "\t" + "Amount" + "\n" ); for(int i = 0; i < model.getRowCount(); i++) { String pname = (String)model.getValueAt(i, 0); int price = (Integer)model.getValueAt(i, 1); int amount = (Integer)model.getValueAt(i, 3); txtbill.setText(txtbill.getText() + pname + "\t" + price + "\t" + amount + "\n" ); } txtbill.setText(txtbill.getText() + "\n"); txtbill.setText(txtbill.getText() + "\t" + "Subtotal : " + total + "\n"); txtbill.setText(txtbill.getText() + "\n"); txtbill.setText(txtbill.getText() + "*******************************************************\n"); txtbill.setText(txtbill.getText() + " THANK YOU COME AGAIN \n"); } |
i have attached the video link below. which will do this tutorials step by step.