平台建设三级项目-案例 - 图文(9)

销售蔬菜水果的子系统的设计实现 南松

href=\%>\title=\src=\

href=\%>\title=\src=\ <% }%>

ProManageAction.java

//实例化商品逻辑对象

ProductLogical pl = new ProductLogical(); //获取要进行的操作类型 /**

* 删除商品信息 **/

else if(type.equals(\

int proId = Integer.parseInt(request.getParameter(\ //商品id号来从数据库中删除商品 pl.deleteProductInfo(proId);

return mapping.findForward(\} /**

* 修改商品信息的读取数据已便修改 **/

else if(type.equals(\

ProductBean pb=new ProductBean();

int proId = Integer.parseInt(request.getParameter(\ System.out.print(proId); //获取商品id号来查询数据

pb=pl.amendProductInfo(proId,0); //放入一个容器的操作

request.setAttribute(\ return mapping.findForward(\} /**

* 修改数据库商品信息

- 28 -

销售蔬菜水果的子系统的设计实现 南松

**/

else if(type.equals(\

ProductBean pb=new ProductBean();

pb.setProId(Integer.parseInt(request.getParameter(\ pb.setProName(request.getParameter(\

pb.setProPrice(Integer.parseInt(request.getParameter(\ pb.setProPicUrl(request.getParameter(\

pb.setProAmount(Integer.parseInt(request.getParameter(\ //获取新数据把数据修改 pl.amendedProductInfo(pb);

return mapping.findForward(\ }

/**

* 商品分页显示 **/

else if(type.equals(\ ArrayList al = new ArrayList(); /*

* 定义页面传过来的动作，如点\下一页\并因为这动作而决定处理 */

String pageDo = request.getParameter(\ if(pageDo==null){ pageDo=\ } /*

* 定义获取页面传过来的当前页getCurr */ int getCurr;

String curr_page = request.getParameter(\ if (curr_page == null || curr_page.equals(\ getCurr = 1; } else {

getCurr = Integer.parseInt(request.getParameter(\ System.out.println(\当前页\ } /*

* 实例化PageBean对象

* PageBean有几个构造器，不过都要传送一句获取数据库行数的SQL语句 * getCurr是传送一个当前页给PageBean的构造器， * 2是定义每页显示几行数据 */

PageBean pb = new PageBean(getCurr,12);

- 29 -

销售蔬菜水果的子系统的设计实现 南松

}

// 定义查询数据库的SQL语句，格式如下 String sql;

sql = pb.pageDeal(pageDo);

// 定义ArrayList获取数据库所查询得到的数据

al = PageDaoFactory.getPageDaoIntanse().getProduct(sql); // 把值传给客户端

request.setAttribute(\request.setAttribute(\return mapping.findForward(\

ProLogical.java

package com.ns.struts.logical;

import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList;

import com.ns.struts.bean.ProductBean; import com.ns.struts.bean.UserBean; import com.ns.struts.util.DBConnection;

public class ProductLogical {

public ArrayList detailProductInfo(String limit) { Statement stm = DBConnection.getStatement(); if(limit==null || limit.equals(\ limit=\ }

String sql = \ System.out.print(sql);

ArrayList al=new ArrayList(); ProductBean pb=null; ResultSet rs =null; try {

rs = stm.executeQuery(sql); while(rs.next()){

pb=new ProductBean();

pb.setProId(rs.getInt(1));

pb.setProName(rs.getString(2)); pb.setProPrice(rs.getInt(3)); pb.setProPicUrl(rs.getString(4)); pb.setProAmount(rs.getInt(5));

- 30 -

销售蔬菜水果的子系统的设计实现 南松

al.add(pb); }

} catch (SQLException e) {

// TODO Auto-generated catch block e.printStackTrace(); }

return al; }

public ProductBean amendProductInfo(int proId,int orderAmount) { Statement stm = DBConnection.getStatement();

String sql = \ System.out.print(sql); ProductBean pb=null; ResultSet rs =null; try {

rs = stm.executeQuery(sql); while(rs.next()){

pb=new ProductBean();

pb.setProId(rs.getInt(1));

pb.setProName(rs.getString(2)); pb.setProPrice(rs.getInt(3)); pb.setProPicUrl(rs.getString(4)); pb.setProAmount(rs.getInt(5)); pb.setOrderAmount(orderAmount); }

} catch (SQLException e) {

// TODO Auto-generated catch block e.printStackTrace(); }

return pb; }

public boolean amendedProductInfo(ProductBean pb) { boolean bt = false;

Statement stm = DBConnection.getStatement(); String sql = \product set proName='\tProPicUrl()+\where proId='\ System.out.print(sql); try {

int br = stm.executeUpdate(sql); if(br>0){

bt = true;

- 31 -

销售蔬菜水果的子系统的设计实现 南松

}

}

}

} catch (SQLException e) {

// TODO Auto-generated catch block e.printStackTrace(); }

return bt;

ProForm.java

package com.ns.struts.form;

import javax.servlet.http.HttpServletRequest; import org.apache.struts.action.ActionErrors; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionMapping;

public class ProductForm extends ActionForm {

/** proId property */ private String proId;

/** proPicUrl property */ private String proPicUrl;

/** proPrice property */ private int proPrice;

/** proName property */ private String proName;

/** proAmoun …… 此处隐藏：2442字，全部文档内容请下载后查看。喜欢就下载吧 ……