title: Java JDBC: how to get int size of table, by exectuning SQL query
body: <p>Part of my code looks like this:</p>
  
  <pre><code>int size = 0;
  
          try {
  
              String query = "SELECT count(*) FROM users";
  
              statement = connection.prepareStatement(query);
              statement.execute(query);
  </code></pre>
  
  <p>I don't know what to do to set size of table to my int size.</p>