closeConnection();
  public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException  {    Integer page;    Integer nbOfItems;    String  value = request.getParameter("category");;    Integer categoryId;    String  categoryName = request.getParameter("categoryName");    sp = new ServletPrinter(response, "SearchItemsByCategory");    if ((value == null) || (value.equals("")))    {      printError("You must provide a category identifier!<br>");      return ;    }    else      categoryId = new Integer(value);    value = request.getParameter("page");    if ((value == null) || (value.equals("")))      page = new Integer(0);    else      page = new Integer(value);    value = request.getParameter("nbOfItems");    if ((value == null) || (value.equals("")))      nbOfItems = new Integer(25);    else      nbOfItems = new Integer(value);    if (categoryName == null)    {      sp.printHTMLheader("RUBiS: Missing category name");      sp.printHTML("<h2>Items in this category</h2><br><br>");    }    else    {      sp.printHTMLheader("RUBiS: Items in category "+categoryName);      sp.printHTML("<h2>Items in category "+categoryName+"</h2><br><br>");    }    itemList(categoryId, categoryName, page.intValue(), nbOfItems.intValue());		    sp.printHTMLfooter();  }