Tutusfunny

This tutorial will teach you how to create customer count using java mysql.this program help you find no of customers.

• The user shall be able to register the customer.
• The user shall be able to count the no of customer.

Establish the Database Connection

public void Connect()
    {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost/gsm", "root", "");
            
            
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        } catch (SQLException ex) {
           ex.printStackTrace();
        }
        
    }

Add Records

  private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         

        String name = txtname.getText();
        String address = txtaddress.getText();
        String phone = txtphone.getText();  
        
        try {
            pst = con.prepareStatement("insert into customer(name,address,phone)values(?,?,?)");
            pst.setString(1, name);
            pst.setString(2, address);
            pst.setString(3, phone);
            int k = pst.executeUpdate();
            
            if(k==1)
            {
                JOptionPane.showMessageDialog(this, "Record Adddeddd");
                txtname.setText("");
                txtaddress.setText("");
                txtphone.setText("");
                txtname.requestFocus();  
                Customer();
            }
            
            else
            {
                JOptionPane.showMessageDialog(this, "Record Failed");
            }   
            
        } catch (SQLException ex) {
           ex.printstacktrace();
        }
        
        
    }

Count the No of Customers

         public void Customer()
    {
        try 
        {  
             pst = con.prepareStatement("SELECT COUNT(*) AS customerCount FROM customer");
             ResultSet rs = pst.executeQuery(); 
             while(rs.next())
             {
              int count = rs.getInt("customerCount");
              //  int count = rs.getInt(1);

                txtmsg.setText(String.valueOf(count));
             } 
        }
           catch (SQLException ex) 
          {
            ex.printstacktrace();
           }
    }

i attached the video link. watch this video this help you create System step by step.