Tutusfunny

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

 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) {
           
        }
        
        
        
    }

I have attached the video tutorial below it will help you  to do this  step by step.