本文共 3056 字，大约阅读时间需要 10 分钟。

Java Web 网络商城案例演示二十二

查询订单

d.add('0105','01','订单管理');		d.add('010501','0105','订单管理','${pageContext.request.contextPath}/AdminOrderServlet?method=findOrders','','mainFrame');		d.add('010502','0105','未付款的订单','${pageContext.request.contextPath}/AdminOrderServlet?method=findOrders&state=1','','mainFrame');		d.add('010503','0105','已付款订单','${pageContext.request.contextPath}/AdminOrderServlet?method=findOrders&state=2','','mainFrame');		d.add('010504','0105','已发货的订单','${pageContext.request.contextPath}/AdminOrderServlet?method=findOrders&state=3','','mainFrame');		d.add('010505','0105','已完成的订单','${pageContext.request.contextPath}/AdminOrderServlet?method=findOrders&state=4','','mainFrame');

public class AdminOrderServlet extends BaseServlet {
   	OrderService orderService = new OrderServiceImpl();	// findOrders	public String findOrders(HttpServletRequest request, HttpServletResponse response) throws Exception {
   		String st = request.getParameter("state");		List
   
     list = null;		if (null == st || "".equals(st)) {
   			// 获取到全部的订单			list = orderService.findAllOrders();		}else {
   						list = orderService.findAllOrders(st);		}		// 将全部的订单放入到request		request.setAttribute("allOrders", list);		// 转发到/admin/order/list.jsp		return "/admin/order/list.jsp";	}}
   

OrderService

public interface OrderService {
   	List
   
     findAllOrders() throws Exception;	List
    
      findAllOrders(String st) throws Exception;}
    
   

OrderServiceImpl

public class OrderServiceImpl implements OrderService {
   	OrderDao orderDao = new OrderDaoImpl();	@Override	public List
   
     findAllOrders() throws Exception {
   		return 	orderDao.findAllOrders();	}	@Override	public List
    
      findAllOrders(String st) throws Exception {
   		// TODO Auto-generated method stub		return 	orderDao.findAllOrders(st);	}}
    
   

OrderDao

public interface OrderDao {
   	List
   
     findAllOrders() throws Exception;	List
    
      findAllOrders(String st) throws Exception;}
    
   

OrderDaoImpl

public class OrderDaoImpl implements OrderDao {
   	@Override	public List
   
     findAllOrders() throws Exception {
   		String sql = "select * from orders";		QueryRunner qr = new QueryRunner(JDBCUtils.getDataSource());		return qr.query(sql, new BeanListHandler
    
     (Order.class));	}	@Override	public List
     
       findAllOrders(String st) throws Exception {
   		String sql = "select * from orders where state = ?";		QueryRunner qr = new QueryRunner(JDBCUtils.getDataSource());		return qr.query(sql, new BeanListHandler
      
       (Order.class),st);	}}
      
     
    
   

3、在/admin/order/list.jsp下获取全部的订单信息完成响应

<%@ page language="java" contentType="text/html; charset=UTF-8"	pageEncoding="UTF-8"%><%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
   
   
   	
	
   
		
    
			     
				      
					       
订单列表					
				      
				      
					       
						
         
        
        
          
          
            
序号
            
订单编号
            
订单金额
            
收货人
            
订单状态
            
订单详情
           
           
            
${ status.count }
            
${ o.oid }
            
${ o.total }
            
${ o.name }
            
 
            
             未付款
             
             
             发货 
             
            
             已发货
             
            
             订单完成
             
            
 
            
           
           
        
					
				      
				      
					       
				      
			     
		    
	
   

转载地址：https://code100.blog.csdn.net/article/details/105327545 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！