How to find out how many rows a query returned?

Question

MySQL

Hello, I wrote a simple program that should just find out how many records are in the database for a specific request, this is what I have:

public class Main {
    public static void main(String[] args) {
        try {
            DriverManager.registerDriver(new Driver());
            Connection c = DriverManager.getConnection("jdbc:mysql://host/dbname", "login", "pass");
            
            Statement s = c.createStatement();
            ResultSet rez = s.executeQuery("SELECT id FROM chel");
            
            
            
            
        } catch (SQLException ex) {
            Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
}

Can you please tell me how to find out how many rows are returned by my request?
Thank you very much in advance!

Answer 1

No way to know.
Or, before the main query, execute SELECT count(*) FROM TABLE