查询所有订单

单击“订单管理”，发送“/findOrders”，由FindOrdersServlet处理

//查找所有订单
public class FindOrdersServlet extends HttpServlet {
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doPost(request, response);
	}
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// 创建Service层对象
		OrderService service = new OrderService();
		// 调用Service层对象的findAllOrder()方法查询订单列表
		List orders = service.findAllOrder();
		//将查询到的订单信息添加到request作用域
		request.setAttribute("orders", orders);
		// 将请求转发到list.jsp页面
		request.getRequestDispatcher("/admin/orders/list.jsp").forward(request,response);
	}
}

// 查找所有订单                            
public List findAllOrder() {  
	List orders = null;       
	try {                            
		// 查找出订单信息                   
		orders = odao.findAllOrder();
	} catch (SQLException e) {       
		e.printStackTrace();         
	}                                
	return orders;                   
}                                    

                                                                              
public List findAllOrder() throws SQLException {                          
	//1.创建sql                                                                    
	String sql = "select orders.*,user.* "                                       
			+ "from orders,user "                                                
			+ "where user.id=orders.user_id "                                    
			+ "order by orders.user_id";                                         
	//2.创建QueryRunner对象                                                          
	QueryRunner runner = new QueryRunner(DataSourceUtils.getDataSource());       
    //3.返回QueryRunner对象query()方法的查询结果                                            
	return runner.query(sql, new ResultSetHandler>() {			     
		public List handle(ResultSet rs) throws SQLException {            
			//创建订单集合                                                             
			List orders = new ArrayList();                         
            //循环遍历订单和用户信息                                                        
			while (rs.next()) {                                                  
				Order order = new Order();                                       
				order.setId(rs.getString("orders.id"));                          
				order.setMoney(rs.getDouble("orders.money"));                    
				order.setOrdertime(rs.getDate("orders.ordertime"));              
				order.setPaystate(rs.getInt("orders.paystate"));                 
				order.setReceiverAddress(rs.getString("orders.receiverAddress"));
				order.setReceiverName(rs.getString("orders.receiverName"));      
				order.setReceiverPhone(rs.getString("orders.receiverPhone"));    
				orders.add(order);                                               
                                                                                 
				User user = new User();                                          
				user.setId(rs.getInt("user.id"));                                
				user.setEmail(rs.getString("user.email"));                       
				user.setGender(rs.getString("user.gender"));                     
				user.setActiveCode(rs.getString("user.activecode"));             
				user.setIntroduce(rs.getString("user.introduce"));               
				user.setPassword(rs.getString("user.password"));                 
				user.setRegistTime(rs.getDate("user.registtime"));               
				user.setRole(rs.getString("user.role"));                         
				user.setState(rs.getInt("user.state"));                          
				user.setTelephone(rs.getString("user.telephone"));               
				user.setUsername(rs.getString("user.username"));                 
				order.setUser(user);                                             
			}                                                                    
			return orders;                                                       
		}                                                                        
	});                                                                          
}                                                                                

<%@ page language="java" pageEncoding="UTF-8"%>                                                                                                                                                                                                                           
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>                                                                                                                                                                                                            
                                                                                                                                                                                                                                                                    
                                                                                                                                                                                                                                                                    
	                                                                                                                                                                                                                  
	                                                                                                                                                                                                   
	                                                                                                                                                               
	                                                                                                                                                                   
	                                                                                                                                                                                                                                                             
                                                                                                                                                                                                                                                                   
                                                                                                                                                                                                                                                                    
	
                                                                                                                                                                                                                                                                
	
                                                                                                                                                     
		
                                                                                                                                                                  
			
                                                                                                                                                                                                                                                       
				
                                                                                                                                                                                                                                                      
					
                                                                                                                                                                                                   
						查 询 条 件                                                                                                                                                                                                                          
					
                                                                                                                                                                                                                                                 
				
                                                                                                                                                                                                                                                     
				
                                                                                                                                                                                                                                                      
					
                                                                                                                                                                                                                                                  
						
                                                                                                                                                                                   
							
                                                                                                                                                                                                                                          
								
                                                                                                                                                                           
									订单编号
                                                                                                                                                                                                                             
								
                                                                                                                                                                                                      
									                                                                                                                                                     
								
                                                                                                                                                                                                                                     
								
                                                                                                                                                                           
									收件人：
                                                                                                                                                                                                                             
								
                                                                                                                                                                                                      
									                                                                                                                                           
								
                                                                                                                                                                                                                                     
							
                                                                                                                                                                                                                                         
							
                                                                                                                                                                                                                                          
								
                                                                                                                                                          
								
                                                                                                                                                                                                      
									                                                                                                                                                                                              
								
                                                                                                                                                                                                                                     
								
                                                                                                                                                                                        
									

                                                                                                                                                                                                                          
								
                                                                                                                                                                                                                                     
								
                                                                                                                                                                                        
									                                                                                                                                         
										查询                                                                                                                                                                                                                  
									                                                                                                                                                                                                    
									                                                                                                                                                      
								
                                                                                                                                                                                                                                     
							
                                                                                                                                                                                                                                         
						
                                                                                                                                                                                                                                          
					
                                                                                                                                                                                                                                                 
				
                                                                                                                                                                                                                                                     
				
                                                                                                                                                                                                                                                      
					
                                                                                                                                                                                                   
						订 单 列 表                                                                                                                                                                                                                          
					
                                                                                                                                                                                                                                                 
				
                                                                                                                                                                                                                                                     
				
                                                                                                                                                                                                                                                      
					
                                                                                                                                                                                                                 
				
                                                                                                                                                                                                                                                     
				
                                                                                                                                                                                                                                                      
					
                                                                                                                                                                                                   
						                                                                                                                                                                                                     
								

							
                                                                                                                                                      
								
订单编号
                                                                                                                                                                                                  
								
收件人
                                                                                                                                                                                                   
								
地址
                                                                                                                                                                                                    
								
联系电话
                                                                                                                                                                                                  
								
总价
                                                                                                                                                                                                    
								
所属用户
                                                                                                                                                                                                   
								
订单状态
                                                                                                                                                                                                  
								
查看
                                                                                                                                                                                                     
								
删除
                                                                                                                                                                                                     
							
                                                                                                                                                                                                                                         
							
                                                                                                                                                                                 
									
${order.id}
                                                                                                                                                    
									
${order.receiverName}
                                                                                                                                          
									
${order.receiverAddress }
                                                                                                                                      
									
${order.receiverPhone }
                                                                                                                                        
									
${order.money}
                                                                                                                                                             
									
${order.user.username}
                                                                                                                                                                             
									
${order.paystate==0?"未支付":"已支付"}