This tutorial will teach you how to generating Auto Invoice No using Java and Mysql.this example will important for developing the inventory management system project.
FirstStep : we have to establish the database connection
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | Connection con; PreparedStatement pst; public void Connect() { try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost/mcafe", "root", ""); } catch (ClassNotFoundException ex) { ex.printStackTrace(); } catch (SQLException ex) { ex.printStackTrace(); } } |
Second Step :- Create the Function invoiceid paste code.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | public void invoiceid() { try { Statement s = con.createStatement(); ResultSet rs = s.executeQuery("SELECT MAX(invoiceid) FROM sales"); rs.next(); rs.getString("MAX(invoiceid)"); if (rs.getString("MAX(invoiceid)") == null) { txtid.setText("E-0000001"); } else { long id = Long.parseLong(rs.getString("MAX(invoiceid)").substring(2, rs.getString("MAX(invoiceid)").length())); id++; txtid.setText("E-" + String.format("%07d", id)); } } catch (Exception ex) { ex.printStackTrace(); } } |
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 jButton1ActionPerformed(java.awt.event.ActionEvent evt) { String id =txtid.getText(); String fname =txtname.getText(); String price =txtprice.getText(); try { pst = con.prepareStatement("insert into sales(invoiceid,prodname,price)values(?,?,?)"); pst.setString(1,id); pst.setString(2,fname); pst.setString(3,price); pst.executeUpdate(); JOptionPane.showMessageDialog(this, "order completed"); invoiceid(); txtname.setText(""); txtprice.setText(""); txtname.requestFocus(); } catch (SQLException ex) { Logger.getLogger(invoice.class.getName()).log(Level.SEVERE, null, ex); } } |
I have attached the video tutorial below it will help you to do this step by step.
