mapaction.java

仓库管理系统毕业设计论文最好的参考资料！

package com.qhit.action;

import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;
import com.qhit.UseException;
import com.qhit.Utils;
import com.qhit.db.instance.DbMap;
import com.qhit.po.Map;
import com.qhit.vo.PageObj;

public class MapAction {
	private DbMap dbb;
	//构造方法初始化与数据库的操作类:DbMap
	public MapAction() throws UseException{
		dbb = new DbMap();
	}
	
	public void query(HttpServletRequest request,HttpServletResponse response)throws Exception{
		String tj = request.getParameter("tj");
		int sum = 0;
		try{
			//获取MAPTAB的参数值,当不存在时返回空
			String mpid = Utils.getNotNull(request.getParameter("mpid"));
			String mpname = Utils.getNotNull(request.getParameter("mpname"));
			int mpnum = Utils.getNotNull0(request.getParameter("mpnum"));
			String mpdes=Utils.getNotNull(request.getParameter("mpdes"));
			
			//获取出入库的时间,以YYYY-MM-DD形式输入
			java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat(
			"yyyy-MM-dd");
			String todaystr = sdf.format(new java.util.Date());
			java.sql.Date outindate = java.sql.Date.valueOf(todaystr);

			
			String cpagestr = request.getParameter("currpage");
			if(cpagestr == null)cpagestr = "1";
			int currpage = Integer.valueOf(cpagestr);
			
			//获取MAPTAB的值
			Map m = new Map();
			m.setMpid(mpid);
			m.setMpname(mpname);
			m.setMpnum(mpnum);
			m.setMpdes(mpdes);
			
			List list = dbb.query(m);
			PageObj po = new PageObj();
			po.setCurrpage(currpage);
			po.setList(list);
			request.setAttribute("po", po);
			sum = dbb.querysum(m);
		}catch(Exception e){
			request.setAttribute("error", "查询出错！原因：" + e.getMessage());
		}finally{
			dbb.closeAll();
			if("1".equals(tj)){
				request.setAttribute("sum", sum);
				request.getRequestDispatcher("tjmapquery.jsp").forward(request, response);
			}else{
				request.getRequestDispatcher("mapquery.jsp").forward(request, response);
			}
		}
	}
	
	
	public void save(HttpServletRequest request,HttpServletResponse response)throws Exception{
		try{
			//带图片上传功能
			DiskFileItemFactory dfif = new DiskFileItemFactory();
			ServletFileUpload sfu = new ServletFileUpload(dfif);
			List list = sfu.parseRequest(request);
			
			//得到新加的总记录数
			String addcountstr = (String)Utils.getFieldValue(list, "addcount");
			if(addcountstr == null || "".equals(addcountstr)){
				addcountstr = "0";
			}
			int addcount = Integer.valueOf(addcountstr);
			
			String mpids = "";
			
			for(int i=1;i<=addcount;i++){
				String mpid = Utils.getFieldValue(list,"mpid" + i)==null?"":(String)Utils.getFieldValue(list,"mpid" + i);
				String mpname = Utils.getFieldValue(list,"mpname" + i)==null?"":(String)Utils.getFieldValue(list,"mpname" + i);
				if(mpid.equals("")||mpname.equals(""))continue;
				
				String mpnumstr = (String)Utils.getFieldValue(list,"mpnum" + i);
				int mpnum = Integer.valueOf(mpnumstr);
				String mpunit = (String)Utils.getFieldValue(list,"mpunit" + i);
				String mpdes = (String)Utils.getFieldValue(list,"mpdes" + i);
				
				Map m = new Map();
				m.setMpid(mpid);
				m.setMpname(mpname);
				m.setMpnum(mpnum);
				m.setMpunit(mpunit);
				m.setMpdes(mpdes);
				
				dbb.insert(m);
				
				//保存上传的图片
				byte by[] = (byte[])Utils.getFieldValue(list,"pic" + i);
				if(by != null){
					String realPath = request.getRealPath("uploadpic");
					java.io.OutputStream os = new java.io.FileOutputStream(realPath + "/" + mpid + ".jpg");
					os.write(by);
					os.close();
				}
				
				mpids = mpids + mpid + " , ";
			}
			request.setAttribute("message", "插入产品成功，编号：" + mpids);
		}catch(Exception e){
			e.printStackTrace();
			request.setAttribute("error", "保存出错！原因：" + e.getMessage());
		}finally{
			request.getRequestDispatcher("MapAction.query.do").forward(request, response);
		}
	}
	
	public void update(HttpServletRequest request,HttpServletResponse response)throws Exception{
		String mpid = "";
		try{
			//带图片上传功能
			DiskFileItemFactory dfif = new DiskFileItemFactory();
			ServletFileUpload sfu = new ServletFileUpload(dfif);
			List list = sfu.parseRequest(request);
			
				
			mpid = Utils.getFieldValue(list,"mpid")==null?"":(String)Utils.getFieldValue(list,"mpid");
			String mpname = Utils.getFieldValue(list,"mpname")==null?"":(String)Utils.getFieldValue(list,"mpname");
			if(mpid.equals("")||mpname.equals("")){
				throw new Exception("要更改的产品编号不能为空!");
			}
			
			String mpnumstr = (String)Utils.getFieldValue(list,"mpnum");
			int mpnum = Integer.valueOf(mpnumstr);
			String mpunit = (String)Utils.getFieldValue(list,"mpunit");
			String mpdes = (String)Utils.getFieldValue(list,"mpdes");
			
			Map m = new Map();
			m.setMpid(mpid);
			m.setMpname(mpname);
			m.setMpnum(mpnum);
			m.setMpunit(mpunit);
			m.setMpdes(mpdes);
			
			dbb.update(m);
			
			//保存上传的图片
			byte by[] = (byte[])Utils.getFieldValue(list,"pic");
			if(by != null && by.length != 0){
				java.io.OutputStream os = new java.io.FileOutputStream(request.getRealPath("uploadpic") + "/" + mpid + ".jpg");
				os.write(by);
				os.close();
			}
			
			request.setAttribute("message", "更改产品成功，编号：" + mpid);
		}catch(Exception e){
			e.printStackTrace();
			request.setAttribute("error", "更改保存出错！原因：" + e.getMessage());
		}finally{
			request.getRequestDispatcher("MapAction.get.do?modmpid=" + mpid).forward(request, response);
		}
	}
	
	public void get(HttpServletRequest request,HttpServletResponse response)throws Exception{
		String mpid = request.getParameter("modmpid");
		try{
			mpid = Utils.getNotNull(mpid);
			if("".equals(mpid)){
				throw new Exception("要查询的产品编号不能为空！");
			}
			Map m = new Map();
			m.setMpid(mpid);
			
			Map map = dbb.get(m);
			request.setAttribute("map", map);
		}catch(Exception e){
			e.printStackTrace();
			request.setAttribute("error", "查询记录:" + mpid + "出错!原因:" + e.getMessage());
		}finally{
			dbb.closeAll();
			request.getRequestDispatcher("mapmod.jsp").forward(request, response);
		}
	}
	
	public void delete(HttpServletRequest request,HttpServletResponse response)throws Exception{
		String mpid = request.getParameter("delmpid");
		try{
			mpid = Utils.getNotNull(mpid);
			if("".equals(mpid)){
				throw new Exception("要删除的产品编号不能为空！");
			}
			Map m = new Map();
			m.setMpid(mpid);
			int ret = dbb.delete(m);
			if(ret == 0){
				throw new Exception("产品可能已经被调用！");
			}
			request.setAttribute("message", "删除" + mpid + "成功！");
		}catch(Exception e){
			e.printStackTrace();
			request.setAttribute("error", "删除" + mpid + "出错！原因：" + e.getMessage());
		}finally{
			request.getRequestDispatcher("MapAction.query.do").forward(request, response);
		}
	}
}