productaction.java

用SPRING做的一个企业信息系统网站

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.enterpriseweb.struts.action;

import java.util.List;

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 com.enterpriseweb.bean.DaoSupport;
import com.enterpriseweb.bean.PageBean;
import com.enterpriseweb.bean.UploadBean;
import com.enterpriseweb.struts.form.ProductForm;
import com.enterpriseweb.util.Constants;

/** 
 * MyEclipse Struts
 * Creation date: 11-14-2007
 * 
 * XDoclet definition:
 * @struts.action path="/product" name="productForm" scope="request" validate="true"
 * @struts.action-forward name="produce_user" path="/produce_user.jsp" contextRelative="true"
 * @struts.action-forward name="produce_jj" path="/produce_jj.jsp" contextRelative="true"
 * @struts.action-forward name="listallproductsmodi" path="/managerview/product_modi_list.jsp" contextRelative="true"
 * @struts.action-forward name="product_detail" path="/produce_detail.jsp" contextRelative="true"
 * @struts.action-forward name="produce_zs" path="/produce_zs.jsp" contextRelative="true"
 * @struts.action-forward name="delelistproducts" path="/managerview/sendforward.jsp" contextRelative="true"
 * @struts.action-forward name="addsucess" path="/managerview/sendforward.jsp" contextRelative="true"
 * @struts.action-forward name="listproducts" path="/managerview/product_modi_save.jsp" contextRelative="true"
 * @struts.action-forward name="listallproductsdele" path="/managerview/product_dele_list.jsp" contextRelative="true"
 * @struts.action-forward name="modiupdateproducts" path="/managerview/sendforward.jsp" contextRelative="true"
 */
public class ProductAction extends DispatchAction {
	/*
	 * Generated Methods
	 */
	private DaoSupport dao = null;
	private ProductForm productform = null;
	
	public DaoSupport getDao() {
		return dao;
	}

	public void setDao(DaoSupport dao) {
		this.dao = dao;
	}

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	//增加产品
	public ActionForward addProduct(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		productform = (ProductForm) form;// TODO Auto-generated method stub
		String dir = servlet.getServletContext().getRealPath("/uploadImage");
		UploadBean upbean = new UploadBean();
		try{
			if(upbean.upload(dir, productform, "ProductForm")){
				request.setAttribute("name", "overSise");
				return mapping.findForward("addsucess");
			}
		}catch(Exception e){
			e.printStackTrace();
		}
		String sql = "insert into product(pname,introduce,temperature,pressure,imagepath) " +
					 "values('"+productform.getPname()+"'," +
					 "'"+productform.getIntroduce()+"'," +
					 "'"+productform.getTemperature()+"'," +
					 "'"+productform.getPressure()+"'," +
					"'"+productform.getImagepath()+"')";
		this.dao.saveObject(sql);
		request.setAttribute("name", "add");
		return mapping.findForward("addsucess");
	}
	
	//修改产品
	public ActionForward updateProduct(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		productform = (ProductForm) form;// TODO Auto-generated method stub
		String dir = servlet.getServletContext().getRealPath("/uploadImage");
		UploadBean upb = new UploadBean();
		try {
			// 通过该方法上传图片并将图片名称及大小存放到form中
			upb.upload(dir, productform, "productForm");
		} catch (Exception ex) {
			ex.printStackTrace();
		}
		String addSql = "update tb_products set pname = '"
				+ productform.getPname().trim() + "',introduce ='"
				+ productform.getIntroduce().trim() + "',temperature = "
				+ productform.getTemperature() + ",pressure = "
				+ productform.getPressure() + ",imagepath = '"
				+ upb.getFileName(productform, "ProductForm") + "' where ID = "
				+ productform.getId();

		System.out.println("addSql:" + addSql);
		dao.updateObject(addSql);
		request.setAttribute("name", "update");
		return mapping.findForward("modiupdateproducts");
	}
	
	//删除产品
	public ActionForward deleteProduct(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String id = request.getParameter("id");
		String sql = "delete from product where ID = '"+id+"'";
		this.dao.deleteObject(sql);
		request.setAttribute("name", "dele");
		return mapping.findForward("delelistproducts");
	}
	
	//获得所有产品信息
	public ActionForward listAllProduct(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String sql = "selsct * from product";
		List listproducts = dao.getObjectList(sql);
		System.out.println("数据库中的记录数 " + listproducts.size());
		request.setAttribute("ListProducts", listproducts);
		String name = request.getParameter("name");

		if (name.equals("modi")) {
			return mapping.findForward("listallproductsmodi");
		} else if (name.equals("dele")) {
			return mapping.findForward("listallproductsdele");
		} else {
			return null;
		}
	}
	
	//通过ID获得产品信息
	public ActionForward listProduct(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		System.out.println("listProduct");
		String id = request.getParameter("id");

		String selectSql = "Select * from product where ID = '" + id + "'";
		System.out.println("selectSql:" + selectSql);
		List listproducts = dao.getObjectList(selectSql);

		request.setAttribute("Product", listproducts);
		return mapping.findForward("listproducts");
	}
	
	//动态分页
	public ActionForward view(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
//		 获取跳转的页面
		String action = request.getParameter("action");
		System.out.println("页面跳转变量 " + action);
		/* 获取参数值：跳转到的页码编号 */
		int curPage;
		String pageNum = request.getParameter("jumpPage");
		if (pageNum == null || pageNum.equals("")) {
			curPage = 1;
		} else {
			curPage = Integer.parseInt(pageNum);
		}
		System.out.println("过去所有的记录");
		int maxRowCount = dao.getTotalPage("SELECT count(*) FROM product");
		System.out.println(" view():页面跳转第" + curPage + "页!!!");
		try {
			System.out.println("将查询的值存入request中!");
			if(curPage>1){
			PageBean pb=dao.getPageBean(
					Constants.Product_sql1, Constants.Product_sql2,
					Constants.Product_sql3, Constants.Product_sql4,Constants.Product_sql5, Constants.Products, curPage,
					maxRowCount);
			System.out.println(pb.getMaxRowCount());
			request.setAttribute("PageBean", pb);
			}else{
				String sql = "SELECT top " + Constants.PAGE_LENGTH + " ID, pname, introduce, temperature, pressure, imagepath FROM tb_products";
				PageBean pb=dao.getPageBean1(sql, curPage, maxRowCount);
				request.setAttribute("PageBean", pb);
			}
		} catch (Exception e) {
			System.out.println("view " + e.getMessage());
		}
		if (action.equals("zs")) {
			return mapping.findForward("produce_zs");
		} else {
			if (action.equals("jj")) {
				return mapping.findForward("produce_jj");
			} else {
				return mapping.findForward("produce_user");
			}

		}
	}
	
	public ActionForward getDetail(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		System.out.println("获取要查询的产品id");
		String id = request.getParameter("id");
		String selectSql = "Select * from product where ID = '" + id + "'";
		System.out.println("selectSql:" + selectSql);
		List listproducts = dao.getObjectList(selectSql);
		System.out.println("getDetail is start!!!!!!!!!");
		System.out.println(listproducts);
		request.setAttribute("Product", listproducts);
		return mapping.findForward("product_detail");
	}
}