title: Java prepared statement in try-with-resources not working
body: <p>Yesterday multiple people on Stack recommended using try-with-resources. I am doing this for all my database operations now. Today I wanted to change Statement to PreparedStatement to make the queries more secure. But when I try to use a prepared statement in try-with-resources I keep getting errors like 'identifier expected' or ';' or ')'.</p>
  
  <p>What am I doing wrong? Or isnt this possible? This is my code:</p>
  
  <pre><code>    try (Connection conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);
          PreparedStatement stmt = conn.prepareStatement("SELECT id FROM users WHERE id = ? LIMIT 1");
          stmt.setInt(1, user);
          ResultSet rs = stmt.executeQuery()) {
  
          // if no record found
          if(!rs.isBeforeFirst()) {
             return false;
          }
          // if record found
          else {
              return true;
          }
  
      } catch (SQLException e) {
          // log error but dont do anything, maybe later
          String error = "SQLException: " + e.getMessage() + "\nSQLState: " + e.getSQLState() + "\nVendorError: " + e.getErrorCode();
          return false;
  
      }
  </code></pre>