商品逻辑接口

public interface IGoodsBiz {
     ListgetAll(int page);
  
	 //查询单个
	 Goods getOne(Integer id);
 
	  //查询所有数量
	 int getRowCount();

实现商品逻辑接口

public class GoodsBizImpl implements IGoodsBiz {
 
	private IGoodsDao goodsDao=new GoodsDaoImpl();
	
	@Override
	public List getAll(int page) {
		return goodsDao.getAll(page); 
	}
   
	@Override
	public Goods getOne(Integer id) {
		return goodsDao.getOne(id);
	}
	
	@Override
	public int getRowCount() {
		return goodsDao.getRowCount();
	}
	}

商品数据访问接口

public interface IGoodsDao {
 
	//查询所有
	 ListgetAll(int page);
	 
	 //查询单个
	 Goods getOne(Integer id);
 
	//查询页数
	 int getRowCount();
 
}

实现 商品数据访问接口

public class GoodsDaoImpl implements IGoodsDao{
 
	
	private Connection con;
	private PreparedStatement ps;
	private ResultSet rs;
	
	
	@Override
	public List getAll(int page) {
		int size=4;
		int begin=(page-1)*size+1;
		int end=page*size;
		Listlist=new ArrayList();
		try {
			  con=DBHelper.getCon();
			  ps=con.prepareStatement("select*from(select a.*,rownum myr from shop_goods a)b where myr between ? and ?");
			  ps.setInt(1, begin);
			  ps.setInt(2, end);
			  rs=ps.executeQuery();
			  while(rs.next()) {
				  Goods goods=new Goods();
				  goods.setId(rs.getInt(1));
				  goods.setName(rs.getString(2));
				  goods.setPrice(rs.getInt(3));
				  goods.setInfo(rs.getString(4));
	              list.add(goods);
			   }
			  return list;
			} catch (Exception e) {
	          e.printStackTrace();
			}finally {
				DBHelper.close(con, ps, rs);
			}
		return list;
	}
 
	
	@Override
	public Goods getOne(Integer id) {
 
		try {
			  con=DBHelper.getCon();
			  ps=con.prepareStatement("select * from shop_goods where id=? ");
			 ps.setInt(1, id);
			  rs=ps.executeQuery();
			  if(rs.next()) {
				  Goods goods=new Goods();
				  goods.setId(rs.getInt(1));
				  goods.setName(rs.getString(2));
				  goods.setPrice(rs.getInt(3));
				  goods.setInfo(rs.getString(4));
			      return goods; 
			  }
			 
			} catch (Exception e) {
	          e.printStackTrace();
			}finally {
				DBHelper.close(con, ps, rs);
			}
		return null;
	}
	
   
    public int getRowCount() {
 
		try {
			  con=DBHelper.getCon();
			  ps=con.prepareStatement("select count(1) from shop_goods ");
			  rs=ps.executeQuery();
			  if(rs.next()) {
				return rs.getInt(1);
			  }
			 
			} catch (Exception e) {
	          e.printStackTrace();
			}finally {
				DBHelper.close(con, ps, rs);
			}
		return 0;
    }
	
	
}

首页

<%@page import="com.zking.pojo.Goods"%>
<%@page import="com.zking.biz.impl.GoodsBizImpl"%>
<%@page import="com.zking.biz.IGoodsBiz"%>
<%@page import="com.zking.pojo.User"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>



  
  
  
  
  
  
  

 

 

     


     

    
        
            欢迎光临苡桉SuperMarket
            
尊贵的${user.account}
            
        
    
   
    
        

        

            
商品序号
            
商品名称
            
商品单价
            
商品描述
            
操作
        
       
       

            
${g.id}
            
${g.name}
            
${g.price}
            
${g.info}
            

               
                    添加购物车
                 
            
        
       
    
    
     

    

      
        «
      
    
    
   
   
${i}
   
    

      
        »
      
    
  
    
    

处理主页

<%@page import="com.zking.biz.impl.GoodsBizImpl"%>
<%@page import="com.zking.biz.IGoodsBiz"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%
     String parameter=request.getParameter("ipage");
     int ipage=1;//默认第一页
     if(parameter!=null){
    	 ipage=Integer.parseInt(parameter);
     }
     //得到商品的biz
     IGoodsBiz goodsBiz=new GoodsBizImpl();
     //将商品查询出来 并且放到请求域当中
     request.setAttribute("goods", goodsBiz.getAll(ipage));
     //算出页数 带到index.jsp
     int row=goodsBiz.getRowCount();
     request.setAttribute("maxPage", (int)Math.ceil(row*1.0/4));
     request.setAttribute("ipage", ipage);
     //希望他能把数据携带到index.jsp
     request.getRequestDispatcher("index.jsp").forward(request, response);
     
     
%>

购物车界面

<%@page import="com.zking.vo.CarItem"%>
<%@page import="java.util.List"%>
<%@page import="com.zking.pojo.User"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>


 










     

 

	
		
			欢迎光临购物车
			
尊贵的${user.account }
		    

		       退出登录
		    
		
	

	
		

		

			
商品序号
			
商品名称
			
商品个数
			
商品总价
			
操作
		
		

			
${c.goods.id}
			
${c.goods.name}
			

				
					
						-
					  
						+
					
				
			
			
${c.sum}
			

				删除
			
		
       
 
	
    
    
	

		<%-- 当前购物车总价 <%=sum %> --%>
		点我结算