This tutorial which help you to generating auto no using java and mysql. Establish the database Connection public void Connect() { try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost/gshop","root",""); } catch (ClassNotFoundException ex) { } catch (SQLException ex) { } } Auto no generator.create the function Custno(). public void CustNo() { int custno = 1; try { Statement smt = con.createStatement(); ResultSet …