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) …