How to Count all row in the table using java and mysql

Question

I want to Count all the rows in the table using java and display the count of all the rows in the textfield. I need the count of employee from the table. I have attached below the code and the query used to achieve this. I received the error of the below code Column 'id' not found. error displayed

public void Customer()
{
    try {
         pst = con.prepareStatement("SELECT COUNT(*) FROM customer");
         ResultSet rs = pst.executeQuery(); 
         while(rs.next())
         {
         String id1 = rs.getString("id");
            txtmsg.setText(id1);
         } 
    } catch (SQLException ex) {
        Logger.getLogger(gsm.class.getName()).log(Level.SEVERE, null, ex);
    }
}

Amongalen · Accepted Answer · 2020-06-08 10:04:02Z

1

There clearly is no "id" column in your select. You could either get the result by column number like so:

int count = rs.getInt(1);

Or you could use an alias for the column and get result by that name, eg.:

pst = con.prepareStatement("SELECT COUNT(*) AS customerCount FROM customer");
int count = rs.getInt("customerCount");

answered Jun 8, 2020 at 10:04

Amongalen

3,11817 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Count all row in the table using java and mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related