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

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

今日热点

ProManageAction.java

//实例化商品逻辑对象

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

String type=request.getParameter(\else if(type.equals(\

ProductBean pb=new ProductBean();

int proId = Integer.parseInt(request.getParameter(\ //获取订购数量 int orderAmount = Integer.parseInt(request.getParameter(\ //如果购物车已有商品就读取出来 System.out.print(orderAmount); ArrayList al = (ArrayList)request.getSession().getAttribute(\ boolean bt=true;

//购物车里没有商品实例化一个对象，有数据的话继续插入数据 if(al==null){

al=new ArrayList();

pb=pl.amendProductInfo(proId,orderAmount); al.add(pb); }else{

for(int i=0;i

//如果插入同样的数据的话就累加数量，不增加商品 if(pb.getProId()==proId){

int orderAmountPlus=(pb.getOrderAmount()+orderAmount); System.out.println(\数量：\

- 18 -

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

}

pb=pl.amendProductInfo(proId,orderAmountPlus); al.set(i, pb); bt=false; } }

if(bt){

pb=pl.amendProductInfo(proId,orderAmount); al.add(pb); } }

request.getSession().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));

- 19 -

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

}

pb.setProPrice(rs.getInt(3)); pb.setProPicUrl(rs.getString(4)); pb.setProAmount(rs.getInt(5)); al.add(pb); }

} catch (SQLException e) {

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

return al; }

public int countAllProduct() { int result=0;

Statement stm = DBConnection.getStatement(); String sql = \

ResultSet rs =null; try {

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

result=rs.getInt(1); }

} catch (SQLException e) {

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

return result; }

DBConnection.java

package com.ns.struts.util;

import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement;

public class DBConnection { /**

* 主要是连接数据库 **/

public static Statement getStatement() {

- 20 -

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

Statement stm = null; try {

//驱动

Class.forName(\ //连接数据库 Connection conn = DriverManager.getConnection(\);

//创建操作数据库对象

stm=conn.createStatement();

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

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

return stm; } }

ProBean.java

/*

* Generated by MyEclipse Struts

* Template path: templates/java/JavaClass.vtl */

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;

- 21 -

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

}

/** proName property */ private String proName; /** proAmount property */ private int proAmount;

public String getProId() { return proId; }

public void setProId(String proId) { this.proId = proId; }

public String getProPicUrl() { return proPicUrl; }

public void setProPicUrl(String proPicUrl) { this.proPicUrl = proPicUrl; }

public int getProPrice() { return proPrice; }

public void setProPrice(int proPrice) { this.proPrice = proPrice; }

public String getProName() { return proName; }

public void setProName(String proName) { this.proName = proName; }

public int getProAmount() { return proAmount; }

public void setProAmount(int proAmount) { this.proAmount = proAmount; }

- 22 -