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.
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(); } }
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; }
After fill the productname,salesqty,customer click addbutton record will be added in to the database.
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(); } }
In this tutorial will teach Laravel 11 Api MVC with Repository Pattern Crud Application step…
In this tutorial will teach Laravel 11 CRUD Application step by step. Laravel 11 CRUD…
in this tutorials we will be talk about how to make a times table in…
In this tutorials will teach How to add two numbers in Laravel 10. (more…)
In this tutorial, we will teach the process of building a full-stack application using Node.js,…
In this tutorial, we will explin you through the process of building a Hospital Management…