closeConnection();
  public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException  {    Integer  categoryId, regionId;    Integer page;    Integer nbOfItems;    sp = new ServletPrinter(response, "SearchItemsByRegion");    String value = request.getParameter("category");    if ((value == null) || (value.equals("")))    {      printError("You must provide a category!<br>");      return ;    }    else      categoryId = new Integer(value);    value = request.getParameter("region");    if ((value == null) || (value.equals("")))    {      printError("You must provide a region!<br>");      return ;    }    else      regionId = 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);    sp.printHTMLheader("RUBiS: Search items by region");    itemList(categoryId, regionId, page.intValue(), nbOfItems.intValue());    sp.printHTMLfooter();  }