meetroom.java

oa办公管理系统。一些小型的企业办公管理用的系统。一个月废寝忘食的结果。

package com.soft.meetroom.control;

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

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

import com.soft.deptmgr.dao.DeptInfoDAO;
import com.soft.meetroom.dao.MeetroomDAO;
import com.soft.vo.DepartmentInfo;
import com.soft.vo.MeetroomInfo;

public class Meetroom extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public Meetroom() {
		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 {

		doPost(request,response);
	}

	/**
	 * 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 {
		String methodCode = request.getParameter("methodCode");
		System.out.println(methodCode);
		
		if(methodCode.equals("addNewMeetRoom"))
		 {
			int meetingroomid=Integer.parseInt(request.getParameter("meetingroomid"));
			String meetingroomname=request.getParameter("meetingroomname");
			int maxpeople=Integer.parseInt(request.getParameter("maxpeople"));
			String meetingroomlocation=request.getParameter("meetingroomlocation");
			meetingroomname=new  String(meetingroomname.getBytes( "ISO8859_1"), "utf-8");
			meetingroomlocation=new  String(meetingroomlocation.getBytes( "ISO8859_1"), "utf-8");
			
			MeetroomDAO  dif=new MeetroomDAO();
			
			int i = dif.addNewMeetRoom(meetingroomid,meetingroomname,maxpeople,meetingroomlocation);
			if(i>0)
			{   
				request.getSession().setAttribute("flag","succ");
				request.getRequestDispatcher("add_meeting_room.jsp").forward(request,response);
			}
			else
			{
				request.getSession().setAttribute("flag","fail");
				request.getRequestDispatcher("add_meeting_room.jsp").forward(request,response);
			}
		}
		else if(methodCode.equals("modifyMeetRoom"))
		{
			int iscanapply=0;
			int meetingroomid=Integer.parseInt(request.getParameter("meetingroomid"));
			String meetingroomname=request.getParameter("meetingroomname");
			int maxpeople=Integer.parseInt(request.getParameter("maxpeople"));
			String roomlocation=request.getParameter("roomlocation");
			String iscanapplystr=request.getParameter("iscanapply");
			meetingroomname=new  String(meetingroomname.getBytes( "ISO8859_1"), "utf-8");
			roomlocation=new  String(roomlocation.getBytes( "ISO8859_1"), "utf-8");
			iscanapplystr=new  String(iscanapplystr.getBytes( "ISO8859_1"), "utf-8");
			if(iscanapplystr.equals("取消预约"))
				iscanapply=1;
			if(iscanapplystr.equals("预约"))
				iscanapply=0;
			MeetroomDAO  mif=new MeetroomDAO();
			
			
			int i  = mif.updateMeetRoom(meetingroomid, meetingroomname, maxpeople, roomlocation,iscanapply);
			
			if(i>0)
			{   
				List lt=mif.searchMeetRoom(meetingroomid);
				request.setAttribute("meetroomInfo",(MeetroomInfo)lt.get(0));
				request.getSession().setAttribute("flag","succ");
				request.getRequestDispatcher("modify_meeting_room.jsp").forward(request,response);
			}
			else
			{
				
				request.getSession().setAttribute("flag","fail");
				request.getRequestDispatcher("edit_meeting_room.jsp").forward(request,response);
			}
		}
		else if(methodCode.equals("search"))
		{
			int page=1;
			int p=1;
			int pagecount=1;
			try{
				
				pagecount=Integer.parseInt(request.getAttribute("pagecount").toString());
			}
			catch(Exception e1){}
		try{
			String strPage=request.getParameter("curpage");
			 p=Integer.parseInt(strPage);
		
			System.out.println("当前："+p);
			}catch(Exception e){
				e.printStackTrace();
			}
	
		if(p>1)
		 page=p;
		
			
	        System.out.println("要转到的页面"+page);
	     
	        MeetroomDAO  mif=new MeetroomDAO();
			 
				mif.setCurPage(page);
				
				
				List lt = mif.getAllRoom();
				
				System.out.println("总页数"+mif.getPageCount());
				System.out.println("总记录数"+mif.getRowsCount());
				System.out.println("每页显示记录数："+mif.getPageSize());
				System.out.println("当前页记录数："+mif.getPageRowsCount());
				if(lt.size()>0)
			    {
				  request.setAttribute("meetroomList",lt);
			      request.setAttribute("curpage",page);
				  request.setAttribute("pagecount",mif.getPageCount());
				  request.setAttribute("rowscount",mif.getPageRowsCount());
				  request.getRequestDispatcher("meeting_room_list.jsp").forward(request,response);
			     

				}
			
				
		}
		if(methodCode.equals("del"))
		{
			int page=Integer.parseInt(request.getParameter("curpage"));
			int rowscount=Integer.parseInt(request.getParameter("rowscount"));
			String meetingroomid = request.getParameter("meetingroomid");
			if(rowscount==1)//当所在页面的记录为一条时，转向上一页
				page=page-1;
			MeetroomDAO  mif=new MeetroomDAO();
			int i = mif.delMeetRoom(Integer.parseInt(meetingroomid));
			mif.setCurPage(page);
			List lt=mif.getAllRoom();
			request.setAttribute("curpage",page);
			request.setAttribute("pagecount",mif.getPageCount());
			request.setAttribute("meetroomList", lt);
			if(i>0)
			{   
				request.getSession().setAttribute("flag","succ");
				request.getRequestDispatcher("meeting_room_list.jsp").forward(request,response);
			}
			else
			{
				request.getSession().setAttribute("flag","fail");
				request.getRequestDispatcher("meeting_room_list.jsp").forward(request,response);
			}
		}

		else if(methodCode.equals("update"))
		{
			String meetingroomid = request.getParameter("meetingroomid");
			MeetroomDAO  mif=new MeetroomDAO();
			
			List lt=mif.searchMeetRoom(Integer.parseInt(meetingroomid));
			request.setAttribute("meetroomInfo",(MeetroomInfo)lt.get(0));
			
			request.getRequestDispatcher("modify_meeting_room.jsp").forward(request,response);
		}
	}

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

}