1 packagecom.sanqing.action;2
3 importjava.util.ArrayList;4 importjava.util.List;5
6 importjavax.annotation.Resource;7 importjavax.servlet.http.HttpServletRequest;8
9 importorg.apache.struts2.ServletActionContext;10 importorg.springframework.context.annotation.Scope;11 importorg.springframework.stereotype.Controller;12
13 importcom.sanqing.po.Product;14 importcom.sanqing.service.ProductService;15 importcom.sanqing.util.PageView;16 /**
17 * 显示产品18 */
19 @Controller("productAction")20 @Scope("prototype")21 public class ProductAction extendsBaseAction {22 @Resource23 privateProductService productService;24 /*产品编号*/
25 privateString productNO;26 //产品类型编号
27 privateString producttypeNO;28 //产品类型名称
29 privateString producttypeName;30 /*产品名称*/
31 privateString productName;32 /*产品所在区域*/
33 privateString productArea;34 /*产品所有者*/
35 privateString productOwner;36 /*产品单位*/
37 privateString unit;38 /*产品价格*/
39 private doubleprice;40 /*产品数量*/
41 private intquantity;42 /*其他信息*/
43 privateString otherInfo;44
45 @Override46 public String execute() throwsException {47 PageView pageView = new PageView(5, getPage());48 StringBuffer jpql = new StringBuffer("");49 List params = new ArrayList();50 if("true".equals(getQuery())) {51 if(productNO!=null && !"".equals(productNO.trim())) {52 if(params.size()>0) jpql.append(" and ");53 jpql.append(" o.productNO=?").append(params.size()+1);54 params.add(productNO);55 }56 if(producttypeName!=null && !"".equals(producttypeName.trim())) {57 if(params.size()>0)jpql.append(" and ");58 jpql.append(" o.productType.producttypeName like ?").append(params.size()+1);59 params.add(producttypeName);60 }61 if(productName!=null && !"".equals(productName.trim())) {62 if(params.size()>0)jpql.append(" and ");63 jpql.append(" o.productName like ?").append(params.size()+1);64 params.add(productName);65 }66 if(productArea!=null && !"".equals(productArea.trim())) {67 if(params.size()>0)jpql.append(" and ");68 jpql.append(" o.productArea like ?").append(params.size()+1);69 params.add(productArea);70 }71 if(productOwner!=null && !"".equals(productOwner.trim())) {72 if(params.size()>0)jpql.append(" and ");73 jpql.append(" o.productOwner like ?").append(params.size()+1);74 params.add(productOwner);75 }76 if(unit!=null && !"".equals(unit.trim())) {77 if(params.size()>0)jpql.append(" and ");78 jpql.append(" o.unit like ?").append(params.size()+1);79 params.add(unit);80 }81 if(price>0) {82 if(params.size()>0)jpql.append(" and ");83 jpql.append(" o.price=?").append(params.size()+1);84 params.add(price);85 }86 if(quantity>0) {87 if(params.size()>0)jpql.append(" and ");88 jpql.append(" o.quantity=?").append(params.size()+1);89 params.add(quantity);90 }91 if(otherInfo!=null && !"".equals(otherInfo.trim())) {92 if(params.size()>0)jpql.append(" and ");93 jpql.append(" o.otherInfo like ?").append(params.size()+1);94 params.add(otherInfo);95 }96 pageView.setQueryResult(productService.getScrollData(pageView.getFirstResult(), pageView.getMaxresult(),jpql.toString(), params.toArray()));97 }else{98 pageView.setQueryResult(productService.getScrollData(pageView.getFirstResult(), pageView.getMaxresult()));99 }100 HttpServletRequest request =ServletActionContext.getRequest();101 request.setAttribute("pageView", pageView);102 return this.SUCCESS;103 }104 publicString getProductNO() {105 returnproductNO;106 }107 public voidsetProductNO(String productNO) {108 this.productNO =productNO;109 }110 publicString getProductName() {111 returnproductName;112 }113 public voidsetProductName(String productName) {114 this.productName =productName;115 }116 publicString getProductArea() {117 returnproductArea;118 }119 public voidsetProductArea(String productArea) {120 this.productArea =productArea;121 }122 publicString getProductOwner() {123 returnproductOwner;124 }125 public voidsetProductOwner(String productOwner) {126 this.productOwner =productOwner;127 }128 publicString getUnit() {129 returnunit;130 }131 public voidsetUnit(String unit) {132 this.unit =unit;133 }134 public doublegetPrice() {135 returnprice;136 }137 public void setPrice(doubleprice) {138 this.price =price;139 }140 public intgetQuantity() {141 returnquantity;142 }143 public void setQuantity(intquantity) {144 this.quantity =quantity;145 }146 publicString getOtherInfo() {147 returnotherInfo;148 }149 public voidsetOtherInfo(String otherInfo) {150 this.otherInfo =otherInfo;151 }152 publicString getProducttypeNO() {153 returnproducttypeNO;154 }155 public voidsetProducttypeNO(String producttypeNO) {156 this.producttypeNO =producttypeNO;157 }158 publicString getProducttypeName() {159 returnproducttypeName;160 }161 public voidsetProducttypeName(String producttypeName) {162 this.producttypeName =producttypeName;163 }164
165 }