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.LineItemDAO;public class LineItemProxy {  LineItemDAO dao = null;  public LineItemProxy(){    dao = new LineItemDAO();  }  public ArrayList queryLineItem(LineItemModel model,Pager pager) throws Exception{    ArrayList lList = new ArrayList();    lList = dao.query(model);    return Utility.generatePager(lList,pager);  }  public ArrayList queryLineItem(LineItemModel model) throws Exception{    return dao.query(model);  }  public ArrayList queryLineItemById(int orderId,Pager pager) throws Exception{    ArrayList lList = new ArrayList();    lList = dao.queryById(orderId);    return Utility.generatePager(lList,pager);  }  public ArrayList queryLineItem(int orderId) throws Exception{    return dao.queryById(orderId);  }  public LineItemModel queryLineItemByOrderIdAndLineIndex(int orderId, String lineIndex) throws Exception{     return dao.queryLineItemByOrderIdAndLineIndex(orderId, lineIndex);  }  public void insertLineItem(LineItemModel model) throws Exception{      dao.insert(model);  }  public void insertLocalLineItem(ArrayList list, String productId)  {  }  public void updateLineItem(LineItemModel model) throws Exception{      dao.update(model);  }  public void deleteLineItem(int orderId, String lineIndex) throws Exception{      dao.delete(orderId, lineIndex);  }  public void deleteLineItemByOrderId(int orderId) throws Exception{    dao.deleteByOrderId(orderId);  }}