Tutusfunny

This  tutorial will teach you how to generator autono using java mysql Autono generator  is very important thing in the programming.we will teach you step by step.

Creating a function autono() add the following code inside the function.i shown below.

 public void autoID()
    {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost/lob","root","");
            Statement s = con.createStatement();
            
            ResultSet rs = s.executeQuery("select Max(id) from customer");
            rs.next();
            
            rs.getString("Max(id)");
            
            
            if(rs.getString("Max(id)")==null)
            {
                
                txtno.setText("C0001");
            }
            else
            {
                Long id = Long.parseLong(rs.getString("Max(id)").substring(2,rs.getString("Max(id)").length()));
                id++;
                txtno.setText("C0" + String.format("%03d", id));
            }
   
        } catch (ClassNotFoundException ex) {

        } catch (SQLException ex) {
          
        }
    }

Call the function inside the constructor of class.

public autoIn() {
        initComponents();
        autoID();
        
    }

Insert the Records

after inserted the record autono generator itself.paste the code inside the add button.

       try {
            String no = txtno.getText();
            String name = txtname.getText();

            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost/lob","root","");
            pst = con.prepareStatement("insert into customer (id,name)values(?,?)");
            pst.setString(1, no);
            pst.setString(2, name);
            pst.executeUpdate();
            
            JOptionPane.showMessageDialog(this,"Record Addedd");
            
              autoID();
              
              txtname.setText("");
              txtname.requestFocus();   
            
        } catch (ClassNotFoundException ex) {
           
        } catch (SQLException ex) {
          
        }

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

Download Here