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);
        }
    }
}

SELECT COUNT(*) FROM chel;

int x = rez.getCount();

ResultSet rez = s.executeQuery("SELECT COUNT(*) FROM chel");

while(rez.next()){
System.out.println(rez.getInt(1));
}