closeConnection();
  public void doPost(HttpServletRequest request, HttpServletResponse response)    throws IOException, ServletException  {    String value = request.getParameter("userId");    Integer userId;    ResultSet rs = null;    sp = new ServletPrinter(response, "ViewUserInfo");    if ((value == null) || (value.equals("")))    {      sp.printHTMLheader("RUBiS ERROR: View user information");      sp.printHTML("<h3>You must provide a user identifier !<br></h3>");      closeConnection();      sp.printHTMLfooter();      return;    }    else      userId = new Integer(value);    sp.printHTMLheader("RUBiS: View user information");    // Try to find the user corresponding to the userId    try    {      conn = getConnection();      stmt = conn.prepareStatement("SELECT * FROM users WHERE id=?");      stmt.setInt(1, userId.intValue());      rs = stmt.executeQuery();    }    catch (Exception e)    {      sp.printHTML("Failed to execute Query for user: " + e);      closeConnection();      sp.printHTMLfooter();      return;    }    try    {      if (!rs.first())      {        sp.printHTML("<h2>This user does not exist!</h2>");        closeConnection();        sp.printHTMLfooter();        return;      }      String firstname = rs.getString("firstname");      String lastname = rs.getString("lastname");      String nickname = rs.getString("nickname");      String email = rs.getString("email");      String date = rs.getString("creation_date");      int rating = rs.getInt("rating");      String result = new String();      result = result + "<h2>Information about " + nickname + "<br></h2>";      result =        result + "Real life name : " + firstname + " " + lastname + "<br>";      result = result + "Email address  : " + email + "<br>";      result = result + "User since     : " + date + "<br>";      result = result + "Current rating : <b>" + rating + "</b><br>";      sp.printHTML(result);    }    catch (SQLException s)    {      sp.printHTML("Failed to get general information about the user: " + s);      closeConnection();      sp.printHTMLfooter();      return;    }    commentList(userId);    sp.printHTMLfooter();    closeConnection();  }