This tutorial which help you to generating auto no using java and mysql.
Establish the database Connection
1 2 3 4 5 6 7 8 9 10 11 | 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().
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | public void CustNo() { int custno = 1; try { Statement smt = con.createStatement(); ResultSet rs = smt.executeQuery("select count(distinct customerid)+1 from records"); rs.next(); custno = rs.getInt(1); txtno.setText("C000"+custno); rs.close(); } catch (SQLException ex) { } } |
Add Records. after add the record Customer no will be incremented by 1
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 29 30 31 32 33 34 35 | private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { try { String cno = txtno.getText(); String cname = txtname.getText(); pst = con.prepareStatement("insert into records(customerid,custname)values(?,?)"); pst.setString(1, cno); pst.setString(2, cname); int status = pst.executeUpdate(); if(status==1) { JOptionPane.showMessageDialog(this, "New Customer Addedd"); CustNo(); txtname.setText(""); txtname.requestFocus(); } else { JOptionPane.showMessageDialog(this, "New Customer Addedd Failedddd!!!"); } } catch (SQLException ex) { } } |
