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