How to find count(*) using JDBC in MySQL?

Question

I want to find the count of the occurence of a name in a mysql table using the query:

select count(*) from employeedetails

How do I fetch the result to a java integer variable?

Answer 1

You can use ResultSet#getInt(int) to return the integer value of a queried column by its ordinal place (i.e., first column is 1, second column is 2, etc):

try (Connection con = /* connect to the database */;
     Statement s = conn.createStatement();
     ResultSet rs = s.executeQuery("select count(*) from employeedetails") {

     // This query returns at most only one row
     if (rs.next()) {
         int numEmployees = rs.getInt(1);
         // Do something with numEmployees
     }
}