mfahuoaction.java

来自「采用struts+hibernet+javabean+jsp 些得shop购物网」· Java 代码 · 共 37 行

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

import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.hnzt.dao.Dao;

public class MfahuoAction extends Action {

	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {


		String number = request.getSession().getAttribute("number").toString();
		
		Dao dao = new Dao();
		
		List l = new ArrayList();

		String hql = "SELECT proNumber, manufactoryPronumber, SUM(quantity) from Orders where manufactorynumber = '"+ number +"' and stat=2 GROUP BY proNumber, manufactoryPronumber";
		
		l = dao.Bbport(hql);
		request.setAttribute("order", l);
		return mapping.findForward("success");
	}
}