package?action;


import?java.io.IOException;
import?java.util.List;
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?pojo.User;
import?pojo.Clazz;
import?pojo.Major;
import?pojo.Office;
import?pojo.Borrow;
import?dao.UserDao;
import?dao.ClazzDao;
import?dao.MajorDao;
import?dao.OfficeDao;
import?dao.BorrowDao;
import?dao.DAOFactory;

public?class?BorrowAction?extends?HttpServlet{
	protected?void?doGet（HttpServletRequest?req?HttpServletResponse?resp）?throws?ServletException?IOException?{
		doPost（req?resp）;
	};


	
	protected?void?doPost（HttpServletRequest?req?HttpServletResponse?resp）
			throws?ServletException?IOException?{
		req.setCharacterEncoding（“UTF-8“）;
		String?s?=?req.getParameter（“action“）;
		int?action?=?Integer.parseInt（s）;
		/*
		?*?1:進入借閱查詢頁面
		?*?2:顯示查詢結果
		?*?3:修改指定信息
		?*?4:更新修改的信息
		?*?5:刪除
		?*?6:進入新增（申請）頁面
		?*?7:提交借閱
		?*?8:進入審核頁面
		?*?9:審核通過
		?*?10:進入文件歸還查詢頁面
		?*?11:進入歸還提交頁面
		?*?12:提交歸還信息
		?*/??
		
		switch（action）{
		case?1:
			BorrowDao?bdao?=?DAOFactory.getInstance（）.getBorrowDao（）;
		????UserDao?udao?=?DAOFactory.getInstance（）.getUserDao（）;
		????List?borrowlist=null;
		????List?ulist?=?udao.getAllAdmin（）;
		????HttpSession?session?=?req.getSession（）;
			User?user?=?（User）?session.getAttribute（“user“）;
		????int?role=user.getRole（）;
		????if（role==1）{
			????req.setAttribute（“adminlist“?ulist）;	????
				req.getRequestDispatcher（“borrowmanager/Borrow_search.jsp“）.forward（req?resp）;????	
		????}else{
			????borrowlist?=?bdao.getByUserId（user.getId（））;
			????req.setAttribute（“borrowlist“?borrowlist）;
		????	req.getRequestDispatcher（“borrowmanager/Borrow_search_oneself.jsp“）.forward（req?resp）;
		????}
			break;
		case?2:
		????String?userId?=?req.getParameter（“userId“）;
		????String?passuserId?=?req.getParameter（“passuserId“）;
		????String?backuserId?=?req.getParameter（“backuserId“）;
			String?pagestr=req.getParameter（“page“）;
			req.setAttribute（“userId“userId）;
			req.setAttribute（“passuserId“passuserId）;
			req.setAttribute（“backuserId“backuserId）;
			UserDao?usdao?=?DAOFactory.getInstance（）.getUserDao（）;
		????req.setAttribute（“adminlist“?usdao.getAllAdmin（））;			
			int?page=0;
			try?{
				page=Integer.parseInt（pagestr）;
			}?catch?（NumberFormatException?e）?{
				page=1;
			}
			boolean?flag=false;
		????String?sql=“select?*?from?borrow?where“;
		????String?numsql=“select?count（*）?from?borrow?where“;
		????if（!（userId==null||““.equals（userId）））{
		????	sql=sql+“?and?userId=‘“+userId+“‘“;
				numsql+=“?and?userId=‘“+userId+“‘“;
				flag=true;
		????}
		????if（!“-1“.equals（passuserId）&&passuserId!=null）{
		????	sql=sql+“?and?passuserId=‘“+passuserId+“‘“;
				numsql+=“?and?passuserId=‘“+passuserId+“‘“;
				flag=true;
		????}
		?

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-06-20?15:34??kys\
?????文件?????????896??2012-06-19?21:07??kys\.classpath
?????目錄???????????0??2012-04-06?13:18??kys\.myeclipse\
?????文件?????????282??2012-06-23?20:53??kys\.mymetadata
?????文件????????1409??2012-04-06?13:18??kys\.project
?????目錄???????????0??2012-06-20?15:34??kys\.settings\
?????文件?????????500??2012-04-06?13:18??kys\.settings\.jsdtscope
?????文件?????????330??2012-04-06?13:18??kys\.settings\org.eclipse.jdt.core.prefs
?????文件??????????49??2012-04-06?13:18??kys\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2012-04-06?13:18??kys\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2012-06-20?15:34??kys\src\
?????目錄???????????0??2012-06-20?15:34??kys\src\action\
?????文件????????9414??2012-06-25?14:59??kys\src\action\BorrowAction.java
?????文件????????7560??2012-06-25?22:33??kys\src\action\FileAction.java
?????文件????????1972??2012-06-19?21:04??kys\src\action\FileUpAction.java
?????文件????????3112??2012-06-20?15:02??kys\src\action\LogAction.java
?????文件????????1501??2012-06-14?15:24??kys\src\action\MenuAction.java
?????文件????????8814??2012-06-20?11:52??kys\src\action\UserAction.java
?????目錄???????????0??2012-06-20?15:34??kys\src\dao\
?????文件?????????127??2012-05-12?14:25??kys\src\dao\ClazzDao.java
?????文件?????????447??2012-04-06?13:18??kys\src\dao\DAO.java
?????文件?????????787??2012-06-25?22:33??kys\src\dao\DAOFactory.java
?????文件?????????590??2012-06-15?16:38??kys\src\dao\FileDao.java
?????目錄???????????0??2012-06-20?15:34??kys\src\dao\imp\
?????文件?????????932??2012-05-12?21:07??kys\src\dao\imp\ClazzDaoImp.java
?????文件????????5607??2012-06-15?16:40??kys\src\dao\imp\FileDaoImp.java
?????文件?????????907??2012-06-04?19:50??kys\src\dao\imp\KindDaoImp.java
?????文件????????1888??2012-06-20?14:47??kys\src\dao\imp\LogDaoImp.java
?????文件?????????920??2012-05-12?21:10??kys\src\dao\imp\MajorDaoImp.java
?????文件????????2914??2012-06-20?15:07??kys\src\dao\imp\MenuDaoImp.java
?????文件?????????927??2012-06-04?19:41??kys\src\dao\imp\OfficeDaoImp.java
............此處省略129個文件信息