To get the number of rows returned by a MySQL query, I do this:
public static void main(String[] args) throws Exception
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection = DriverManager.getConnection(url, user, password);
Statement statement = connection.createStatement();
String query = "SELECT * FROM users";
ResultSet rs = statement.executeQuery(query);
int number = statement.getFetchSize();
connection.close();
System.out.print(number);
}
which returns 0 even though I have 7 users. What am I doing wrong?