电子商城源代码（java+struts项目）

/* * Generated by MyEclipse Struts * Template path: templates/java/JavaClass.vtl */ package com.struts.action; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.sql.SQLException; import java.util.ArrayList; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import org.apache.struts.actions.DispatchAction; import org.apache.struts.upload.FormFile; import com.struts.core.GetTime; import com.struts.dao.AdminDAO; import com.struts.db.DBAccess; import com.struts.form.ProductForm; import com.struts.form.SortForm; /** * MyEclipse Struts Creation date: 07-15-2008 */ public class ManageProductAction extends DispatchAction { /* * Generated Methods */ // 添加商品信息 public ActionForward addProduct(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { ProductForm productForm = (ProductForm) form; int sort_id = productForm.getSort_id(); String product_name = productForm.getProduct_name(); int product_price = productForm.getProduct_price(); int product_saleprice = productForm.getProduct_saleprice(); String product_descript = productForm.getProduct_descript(); String product_contents = productForm.getProduct_contents(); FormFile image_file = (FormFile) productForm.getImage_file(); String image = null; if (!image_file.getFileName().equals("")) { InputStream is; try { is = image_file.getInputStream(); String filePath = request.getRealPath("/"); image = "/image/" + image_file.getFileName(); OutputStream os = new FileOutputStream(filePath + "image" + image_file.getFileName()); int bytes = 0; byte[] buffer = new byte[8192]; while ((bytes = is.read(buffer, 0, 8192)) != -1) { os.write(buffer); } os.close(); is.close(); } catch (FileNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } String sql = "insert into tb_product values(sequence_product.nextval," + sort_id + ",'" + product_name + "'," + product_price + "," + product_saleprice + ",'" + product_descript + "','" + product_contents + "',sysdate," + 0 + ",'" + image + "'" + ")"; DBAccess db = new DBAccess(); try { int row = db.executeDmlSql(sql); } catch (SQLException e) { e.printStackTrace(); } db.closeDbAccess(); } return mapping.findForward("sucessSubmit"); } // 商品类别，用于显示动态的下拉列表 public ActionForward getSortList(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { SortForm sortForm = null; AdminDAO adminDAO = new AdminDAO(); ArrayList<SortForm> sortList = new ArrayList<SortForm>(); ArrayList list = new ArrayList(); try { list = adminDAO.getSortList(); Object[] obj = null; for (int i = 0; i < list.size(); i++) { sortForm = new SortForm(); obj = (Object[]) list.get(i); int sort_id = Integer.parseInt(obj[0].toString().trim()); String sort_name = obj[1].toString().trim(); sortForm.setSort_id(sort_id); sortForm.setSort_name(sort_name); sortList.add(sortForm); } request.setAttribute("sortList", sortList); } catch (SQLException e) { e.printStackTrace(); } return mapping.findForward("addProduct"); } // 显示所有商品信息 public ActionForward getAllProductInfo(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { ProductForm productForm = null; AdminDAO adminDAO = new AdminDAO(); ArrayList<ProductForm> productList = new ArrayList<ProductForm>(); ArrayList list = new ArrayList(); try { list = adminDAO.getAllProductInfo(); Object[] obj = null; for (int i = 0; i < list.size(); i++) { productForm = new ProductForm(); obj = (Object[]) list.get(i); int product_id = Integer.parseInt(obj[0].toString().trim()); int sort_id = Integer.parseInt(obj[1].toString().trim()); String product_name = obj[2].toString().trim(); int product_price = Integer.parseInt(obj[3].toString().trim()); int product_saleprice = Integer.parseInt(obj[4].toString() .trim()); String product_descript = obj[5].toString().trim(); String product_contents = obj[6].toString().trim(); // String product_saledate = (obj[7].toString().trim()); int product_salecount = Integer.parseInt(obj[8].toString() .trim()); String product_image = obj[9].toString().trim(); productForm.setProduct_id(product_id); productForm.setSort_id(sort_id); productForm.setProduct_name(product_name); productForm.setProduct_price(product_price); productForm.setProduct_saleprice(product_saleprice); productForm.setProduct_descript(product_descript); productForm.setProduct_contents(product_contents); // productForm.setProduct_saledate(product_saledate); productForm.setProduct_salecount(product_salecount); productForm.setProduct_image(product_image); productList.add(productForm); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } request.setAttribute("productList", productList); return mapping.findForward("manageProduct"); } // 输入商品名称关键字搜索 public ActionForward selectProductByName(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { ProductForm productForm = (ProductForm) form; AdminDAO adminDAO = new AdminDAO(); ArrayList<ProductForm> productList = new ArrayList<ProductForm>(); ArrayList list = new ArrayList(); String product_name = productForm.getProduct_name(); try { list = adminDAO.selectProductByName(product_name); Object[] obj = null; for (int i = 0; i < list.size(); i++) { productForm = new ProductForm(); obj = (Object[]) list.get(i); int product_id = Integer.parseInt(obj[0].toString().trim()); int sort_id = Integer.parseInt(obj[1].toString().trim()); product_name = obj[2].toString().trim(); int product_price = Integer.parseInt(obj[3].toString().trim()); int product_saleprice = Integer.parseInt(obj[4].toString() .trim()); String product_descript = obj[5].toString().trim(); String product_contents = obj[6].toString().trim(); // Date product_saledate = // (Date)(Object)(obj[7].toString().trim()); int product_salecount = Integer.parseInt(obj[8].toString() .trim()); String product_image = obj[9].toString().trim(); productForm.setProduct_id(product_id); productForm.setSort_id(sort_id); productForm.setProduct_name(product_name); productForm.setProduct_price(product_price); productForm.setProduct_saleprice(product_saleprice); productForm.setProduct_descript(product_descript); productForm.setProduct_contents(product_contents); // productForm.setProduct_saledate(product_saledate); productForm.setProduct_salecount(product_salecount); productForm.setProduct_image(product_image); productList.add(productForm); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } request.setAttribute("productList", productList); return mapping.findForward("manageProduct"); } //得到一个商品的信息 public ActionForward getOneProductInfo(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { Product