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
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.
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();
}
}After fill the productname,price click addbutton record will be added in to the database.
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.
