CShop Project 08: 开发条幅商品在首页的展示
1. GoodsDao.java
public Map<String, Object> getScrollGoods() throws SQLException { QueryRunner r = new QueryRunner(DBUtil.getDataSource()); String sql = "select g.id,g.name,g.cover,g.price from recommend r,goods g where type=1 and r.goods_id=g.id "; return r.query(sql,new MapHandler()); }
2. GoodsService.java
public Map<String, Object> getScrollGoods(){ Map<String, Object> map = null; try { map = gDao.getScrollGoods(); } catch (SQLException e) { e.printStackTrace(); } return map; }
3. IndexServlet.java
doGet(){ // 取得条幅商品 Map<String,Object> scrollGoods = gService.getScrollGoods(); request.setAttribute("scroll", scrollGoods); }
4. index.jsp
<!--banner--> <div class="banner"> <div class="container"> <h2 class="hdng"><a href="detail.action?goodid=7">${scroll.name }</a><span></span></h2> <p>今日精选推荐</p> <a class="banner_a" href="javascript:;" onclick="buy(7)">立刻购买</a> <div class="banner-text"> <a href="detail.action?goodid=7"> <img src="${pageContext.request.contextPath }${scroll.cover}" alt="${scroll.name }" width="350" height="350"> </a> </div> </div> </div> <!--//banner-->
效果: