package com.publish.shop.order.javabeans;import java.sql.Connection;import java.util.ArrayList;import com.publish.shop.util.javabeans.*;import com.publish.shop.order.dao.OrderDAO;public class OrderProxy {  OrderDAO dao = null;  public OrderProxy(){    dao = new OrderDAO();  }  public ArrayList queryOrder(OrderModel model,Pager pager) throws Exception{    ArrayList lList = new ArrayList();    lList = dao.query(model);    return Utility.generatePager(lList,pager);  }  public ArrayList queryOrder(OrderModel model) throws Exception{    return dao.query(model);  }  public OrderModel queryOrderById(int orderId) throws Exception{     return dao.queryOrderByOrderId(orderId);  }  public int insertOrder(OrderModel model) throws Exception{      return dao.insert(model);  }  public void updateOrder(OrderModel model) throws Exception{      dao.update(model);  }  public void confirmOrder(int orderId) throws Exception{      dao.confirm(orderId);  }  public void SendOrder(int orderId) throws Exception{      dao.send(orderId);  }  public void deleteOrder(int productId) throws Exception{      dao.delete(productId);  }}