try {
conn = getConnection();
CategoryDAO categoryDAO = new CategoryDAO();
categoryDAO.setConnection(conn);
List<Entity> categories = categoryDAO.list();
request.setAttribute("categories", categories);
ProductDAO productDAO = new ProductDAO();
productDAO.setConnection(conn);
List<Entity> bestSellers = productDAO.findRecentBestSellers(20);