gzrzservlet.java

企业进销存源码

package com.web.servlet;

import java.io.IOException;
import java.util.HashMap;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.common.util.Chinese;
import com.dao.util.DaoImp;
import com.web.util.WebTools;

public class GzrzServlet extends BaseServlet {

	public void work(HttpServletRequest req, HttpServletResponse resp)
			throws IOException, ServletException, Exception {
		try {
			DaoImp dao = new DaoImp();
			if(req.getParameter("actionType").equals("add")){
				String str=
					"insert into gzrz(dates,gzrz,memo) values('"
					+ Chinese.toChinese(
						WebTools.showEx(req.getParameter("dates")))
					+ "','"
					+ Chinese.toChinese(
						WebTools.showEx(req.getParameter("gzrz")))
					+ "','"
					+ Chinese.toChinese(
						WebTools.showEx(req.getParameter("memo")))
					+ "')";
				dao.insert(str);
				pManage.setCurrentPageUrl("/worklog/gzrz_add.jsp");
				pManage.setMessagePageUrl(successUrl);
				pManage.addPageEntity("返回列表页面", "/worklog/gzrz_plan.jsp", "", "");
				req.getSession().setAttribute("SYSTEM_SUCCESS", "工作日志添加成功");
				
			}
			if (req.getParameter("actionType").equals("edit")) {
				String str =
					"update ck set dates='"
						+ Chinese.toChinese(
							WebTools.showEx(req.getParameter("dates")))
						+ "',gzrz='"
						+ Chinese.toChinese(
							WebTools.showEx(req.getParameter("gzrz")))
							+ "',memo='"
						+ Chinese.toChinese(
							WebTools.showEx(req.getParameter("memo")))
				        + "' where id = "
						+ WebTools.showEx(req.getParameter("id"));
				dao.update(str);
				pManage.setCurrentPageUrl(
					"/worklog/gzrz_edit.jsp?key="
						+ WebTools.showEx(req.getParameter("id")));
				pManage.setMessagePageUrl(successUrl);
				pManage.addPageEntity(
					"返回列表页面",
					"/worklog/gzrz_plan.jsp",
					"",
					"");
				req.getSession().setAttribute("SYSTEM_SUCCESS", "工作日志修改成功");
			}

			if(req.getParameter("actionType").equals("del")){			
				for(int i=0;i<req.getParameterValues("id").length;i++){
					dao.delete("delete from gzrz where id = "+req.getParameterValues("id")[i]);
				}
				
				pManage.setCurrentPageUrl("/worklog/gzrz_plan.jsp");
				pManage.setMessagePageUrl(successUrl);				
				req.getSession().setAttribute("SYSTEM_SUCCESS","工作日志删除成功");
			}
		} catch (Exception e) {
			if (req.getParameter("actionType").equals("add")) {				
				pManage.setCurrentPageUrl("/worklog/gzrz_add.jsp");
				pManage.setMessagePageUrl(failureUrl);
				pManage.addPageEntity("返回列表页面", "/worklog/gzrz_plan.jsp", "", "");
				req.getSession().setAttribute("SYSTEM_FAILURE", "工作日志添加失败");
			}	
			
			if(req.getParameter("actionType").equals("del")){	
				pManage.setCurrentPageUrl("/worklog/gzrz_plan.jsp");
				pManage.setMessagePageUrl(successUrl);				
				req.getSession().setAttribute("SYSTEM_FAILURE","工作日志删除失败");
			}
			throw e;			
		}

	}

}