dailyrecorddo.java

简单的餐厅管理系统

package controller.dailyRecord;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.Hashtable;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;




import beans.Bill;
import beans.DailyRecord;

public class DailyRecordDo extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public DailyRecordDo() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		response.setContentType("text/html");
		request.setCharacterEncoding("GBK");
		HttpSession mySession = request.getSession();
		String action = (String)request.getParameter("action");
		int type = 0;
		if(mySession.getAttribute("type")!= null){
			type = Integer.parseInt(mySession.getAttribute("type").toString());
		}
		if(action == null){
			action = "";
		}
		if(type != 1){
			mySession.setAttribute("errorMsg", "您不具有操作权限");
			RequestDispatcher rd = getServletContext().getRequestDispatcher("/main.jsp");
			rd.forward(request, response);
			return;
		}
			
			
			
			if(action.equals("MainQuery")){
				String queryMethod = (String)request.getParameter("queryMethod");
				if(queryMethod == null){
					mySession.setAttribute("errorMsg", "操作出错");
					RequestDispatcher rd = getServletContext().getRequestDispatcher("/main.jsp");
					rd.forward(request, response);
					return;
				}
				if(queryMethod.equals("queryByMoney")){
					
					doQueryByMoney(request,response);
					return;
				}
				if(queryMethod.equals("queryByBill")){
					
					doQueryByBill(request,response);
					return;
				}
				if(queryMethod.equals("queryByPeople")){
					
					doQueryByPeople(request,response);
					return;
				}
				if(queryMethod.equals("queryByMaterial")){
					
					doQueryByMaterial(request,response);
					return;
				}
			}
			if(action.equals("queryOneBill")){
				doQueryOneBill(request,response);
				return;
			}
			if(action.equals("queryOneMaterial")){
				doQueryOneMaterial(request,response);
				return;
			}
	
			mySession.setAttribute("errorMsg", "错误的操作");
			RequestDispatcher rd = getServletContext().getRequestDispatcher("/main.jsp");
			rd.forward(request, response);
			return;
	}

	private void doQueryOneMaterial(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		HttpSession mySession = request.getSession();
		int year = 0;
		if(request.getParameter("year") != null){
			year = Integer.parseInt(request.getParameter("year"));
			System.out.print(year);
		}
	
		int month = 0;
		if(request.getParameter("month") != null){
			month = Integer.parseInt(request.getParameter("month"));
			System.out.print(month);
		}
		
		int day = 1;
		if(request.getParameter("day") != null&&!request.getParameter("day").equals("")){
			day = Integer.parseInt(request.getParameter("day"));
			System.out.print(day);
		}
		
		String materialName = request.getParameter("materialName");
		
		byte[] bytes = materialName.getBytes("iso-8859-1");
	    String result = new String(bytes, "gb2312");

		DailyRecord query = new DailyRecord();
		query.setYear(year);
		query.setMonth(month);
		query.setDay(day);
		String errorMsg = query.getDetailMaterialUsed(result);
		
		Hashtable h = query.getH();
		
		//设置request的时间属性
		request.setAttribute("year", year);
		request.setAttribute("month", month);
		request.setAttribute("day", day);
		request.setAttribute("materialName", result);
		request.setAttribute("queryMethod","queryByMaterial");
		

		request.setAttribute("materialNumbers", h.get("materialNumbers"));
		
		mySession.setAttribute("errorMsg", errorMsg);
		RequestDispatcher rd = getServletContext().getRequestDispatcher("/admin/dailyReport/material.jsp");
		rd.forward(request, response);
		return;
	}

	private void doQueryOneBill(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		HttpSession mySession = request.getSession();
		int year = 0;
		if(request.getParameter("year") != null){
			year = Integer.parseInt(request.getParameter("year"));
			System.out.print(year);
		}
	
		int month = 0;
		if(request.getParameter("month") != null){
			month = Integer.parseInt(request.getParameter("month"));
			System.out.print(month);
		}
		
		int day = 1;
		if(request.getParameter("day") != null&&!request.getParameter("day").equals("")){
			day = Integer.parseInt(request.getParameter("day"));
			System.out.print(day);
		}
		String billID = (String)request.getParameter("billID");
		if(billID != null){
			Bill show = new Bill();
			String errorMsg = show.getData(billID);
			request.setAttribute("year", year);
			request.setAttribute("month", month);
			request.setAttribute("day", day);
			request.setAttribute("totalMoney", show.getPrice());
			request.setAttribute("bill", show);
			
			mySession.setAttribute("errorMsg", errorMsg);
			RequestDispatcher rd = getServletContext().getRequestDispatcher("/admin/dailyReport/bill.jsp");
			rd.forward(request, response);
			return;
		}
		mySession.setAttribute("errorMsg", "出错");
		RequestDispatcher rd = getServletContext().getRequestDispatcher("/main.jsp");
		rd.forward(request, response);
		return;
	}

	private void doQueryByMaterial(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		HttpSession mySession = request.getSession();
		int year = 0;
		if(request.getParameter("year") != null){
			year = Integer.parseInt(request.getParameter("year"));
			System.out.print(year);
		}
	
		int month = 0;
		if(request.getParameter("month") != null){
			month = Integer.parseInt(request.getParameter("month"));
			System.out.print(month);
		}
		
		int day = 1;
		if(request.getParameter("day") != null&&!request.getParameter("day").equals("")){
			day = Integer.parseInt(request.getParameter("day"));
			System.out.print(day);
		}
		DailyRecord query = new DailyRecord();
		query.setYear(year);
		query.setMonth(month);
		query.setDay(day);
		String errorMsg = query.getDailyBillMain();
		
		Hashtable h = query.getH();
		
		//设置request的时间属性
		request.setAttribute("year", year);
		request.setAttribute("month", month);
		request.setAttribute("day", day);
		request.setAttribute("queryMethod","queryByMaterial");
		

		request.setAttribute("materials", h.get("materials"));
		
		mySession.setAttribute("errorMsg", errorMsg);
		RequestDispatcher rd = getServletContext().getRequestDispatcher("/admin/dailyReport/dayReport.jsp");
		rd.forward(request, response);
		return;
	}

	private void doQueryByBill(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		HttpSession mySession = request.getSession();
		int year = 0;
		if(request.getParameter("year") != null){
			year = Integer.parseInt(request.getParameter("year"));
			System.out.print(year);
		}
	
		int month = 1;
		if(request.getParameter("month") != null){
			month = Integer.parseInt(request.getParameter("month"));
			System.out.print(month);
		}
		
		int day = 1;
		if(request.getParameter("day") != null&&!request.getParameter("day").toString().equals("")){
			day = Integer.parseInt(request.getParameter("day").toString());
			System.out.print(day);
		}
		DailyRecord query = new DailyRecord();
		query.setYear(year);
		query.setMonth(month);
		query.setDay(day);
		String errorMsg = query.getDailyBillMain();
		
		Hashtable h = query.getH();
		
		//设置request的时间属性
		request.setAttribute("year", year);
		request.setAttribute("month", month);
		request.setAttribute("day", day);
		request.setAttribute("queryMethod","queryByBill");
		
		request.setAttribute("totalMoney", h.get("totalMoney"));
		request.setAttribute("totalPeople", h.get("totalNumberOfMan"));
		request.setAttribute("materials", h.get("materials"));
		
		mySession.setAttribute("errorMsg", errorMsg);
		RequestDispatcher rd = getServletContext().getRequestDispatcher("/admin/dailyReport/dayReport.jsp");
		rd.forward(request, response);
		return;
	}

	private void doQueryByPeople(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		HttpSession mySession = request.getSession();
		int year = 0;
		if(request.getParameter("year") != null){
			year = Integer.parseInt(request.getParameter("year"));
			System.out.print(year);
		}
	
		int month = 0;
		if(request.getParameter("month") != null){
			month = Integer.parseInt(request.getParameter("month"));
			System.out.print(month);
		}
		
		int day = 1;
		if(request.getParameter("day") != null&&!request.getParameter("day").equals("")){
			day = Integer.parseInt(request.getParameter("day"));
			System.out.print(day);
		}
		DailyRecord query = new DailyRecord();
		query.setYear(year);
		query.setMonth(month);
		query.setDay(day);
		String errorMsg = query.getDailyPeople();
		Hashtable h = query.getH();
		
		//设置request的时间属性
		request.setAttribute("year", year);
		request.setAttribute("month", month);
		request.setAttribute("day", day);
		request.setAttribute("queryMethod","queryByPeople");
		
		request.setAttribute("totalMoney", h.get("totalMoney"));
		request.setAttribute("totalPeople", h.get("totalNumberOfMan"));
		request.setAttribute("bills",  h.get("bills"));
		
		mySession.setAttribute("errorMsg", errorMsg);
		RequestDispatcher rd = getServletContext().getRequestDispatcher("/admin/dailyReport/dayReport.jsp");
		rd.forward(request, response);
		return;
	}

	private void doQueryByMoney(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		
		HttpSession mySession = request.getSession();
		int year = 0;
		if(request.getParameter("year") != null){
			year = Integer.parseInt(request.getParameter("year"));
			System.out.print(year);
		}
	
		int month = 0;
		if(request.getParameter("month") != null){
			month = Integer.parseInt(request.getParameter("month"));
			System.out.print(month);
		}
		
		int day = 1;
		if(request.getParameter("day") != null&&!request.getParameter("day").equals("")){
			day = Integer.parseInt(request.getParameter("day"));
			System.out.print(day);
		}
		DailyRecord query = new DailyRecord();
		query.setYear(year);
		query.setMonth(month);
		query.setDay(day);
		String errorMsg = query.getDailyMoney();
		Hashtable h = query.getH();
		
		//设置request的时间属性
		request.setAttribute("year", year);
		request.setAttribute("month", month);
		request.setAttribute("day", day);
		request.setAttribute("queryMethod","queryByMoney");
		
		request.setAttribute("totalMoney", h.get("totalMoney"));
		request.setAttribute("totalPeople", h.get("totalNumberOfMan"));
		request.setAttribute("bills", h.get("bills"));
		
		mySession.setAttribute("errorMsg", errorMsg);
		RequestDispatcher rd = getServletContext().getRequestDispatcher("/admin/dailyReport/dayReport.jsp");
		rd.forward(request, response);
		return;
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doGet(request,response);
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occurs
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}