1. GoodsRecommendListServlet
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { int type = Integer.parseInt(request.getParameter("type")); int pageNo = 1; if(request.getParameter("pageNo") != null) { pageNo = Integer.parseInt(request.getParameter("pageNo")); } }
2. GoodsDao
public List<Goods> selectGoodsRecommend(int type,int pageNo, int pageSize) throws SQLException { QueryRunner r = new QueryRunner(DBUtil.getDataSource()); String sql = "select g.id,g.name,g.cover,g.image1,g,image2,g.intro,g.price,g.stock from goods g, type t where g.id=t.goods_id and t.type=? limit ?,?"; return r.query(sql, new BeanListHandler<Goods>(Goods.class),type,(pageNo-1)*pageSize,pageSize); }
public int selectGoodsRecommendCount(int type) throws SQLException {
QueryRunner r = new QueryRunner(DBUtil.getDataSource());
String sql = "select count(*) from recommend type=? ";
return r.query(sql, new ScalarHandler<Long>(),type).intValue();
}
3. GoodsService
public Page getGoodsRecommendPage(int type, int pageNo) { // 获得pageNo Page p = new Page(); p.setPageNo(pageNo); // 获得总页数 int totalCount = 0; try { totalCount = gDao.selectGoodsRecommendCount(type); } catch (SQLException e) { e.printStackTrace(); } p.setPageSizeAndTotalCount(8, totalCount); // 获得对应页的商品数据 List list = null; try { list = gDao.selectGoodsRecommend(type,pageNo,8); // 每1页显示8条数据 } catch (SQLException e) { e.printStackTrace(); } p.setList(list); return p; }
4. GoodsRecommendServlet
@WebServlet("/goodsrecommend_list") public class GoodsRecommendListServlet extends HttpServlet { private GoodsService gService = new GoodsService(); protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { int type = Integer.parseInt(request.getParameter("type")); int pageNo = 1; if(request.getParameter("pageNo") != null) { pageNo = Integer.parseInt(request.getParameter("pageNo")); } Page p = gService.getGoodsRecommendPage(type, pageNo); request.setAttribute("p", p); request.getRequestDispatcher("goodsrecommend_list.jsp").forward(request, response); } }
5. 编写 goodsrecommend_list.jsp
效果: