This tutorial will teach you Simple Sales Inventory System in Java and mysql.this example which will help you to learn the auto no generating using by the code.
FirstStep : we have to establish the database connection
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | Connection con; PreparedStatement pst; public void Connect() { try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost/vmproducts","root",""); } catch (ClassNotFoundException ex) { ex.printStackTrace(); } catch (SQLException ex) { ex.printStackTrace(); } } |
Second Step :- Create the Function getBillNo for generating the Auto ID.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | public int getBillNo() { int billno = 1; try { Statement smt = con.createStatement(); ResultSet rs = smt.executeQuery("select max(billno) from sales"); rs.next(); billno = rs.getInt(1) + 1; // increment by 1 auto ID Set rs.close(); } catch (SQLException ex) { ex.printStackTrace(); } return billno; } |
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 31 32 33 34 35 36 | private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { try { String billno = txtbillno.getText(); String date = txtdate.getText(); String pname = txtpname.getText(); String qty = txtqty.getText(); String customer = txtcustomer.getText(); pst = con.prepareStatement("insert into sales(billno,salesdate,prodname,qty,customer)values(?,?,?,?,?)"); pst.setString(1, billno); pst.setString(2, date); pst.setString(3, pname); pst.setString(4, qty); pst.setString(5, customer); int status = pst.executeUpdate(); if(status==1) { JOptionPane.showMessageDialog(this, "Sales Completedddddd"); txtpname.setText(""); txtqty.setText(""); txtcustomer.setText(""); txtpname.requestFocus(); txtbillno.setText(String.valueOf(getBillNo())); //after sales successfully Auto ID increment by 1 } else { JOptionPane.showMessageDialog(this, "Sales Failedddd!!!"); } } catch (SQLException ex) { ex.printStackTrace(); } } |
I have attached the video tutorial below it will help you to do this step by step.