searchreservations.java

基于java的医院门诊管理系统

package crqs.servlets.doctor;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;

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 crqs.dboperation.Administrator;
import crqs.dboperation.Doctor;
import crqs.exceptions.RecordsNotExistException;
import crqs.util.DateConvert;
import crqs.util.NavBar;
import crqs.util.Page;
import crqs.util.StringConvert;

public class SearchReservations extends HttpServlet {

	/**
	 * 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 {

		HttpSession hs = request.getSession();
		String message = null;
		Doctor dctr = (Doctor) hs.getAttribute("validUser");
		String fyear=request.getParameter("fyear");
		String fmonth=request.getParameter("fmonth");
		String fdate=request.getParameter("fdate");
		String tyear=request.getParameter("tyear");
		String tmonth=request.getParameter("tmonth");
		String tdate=request.getParameter("tdate");
		Date from=DateConvert.parse(fyear+"-"+fmonth+"-"+fdate);
		Date to=DateConvert.parse(tyear+"-"+tmonth+"-"+tdate);
		String index = request.getParameter("index");
		NavBar nb=new NavBar();	
		nb.to("<a href='/CRQS/doctor/SearchReservations?fyear="
				+fyear+"&fmonth="+fmonth+"&fdate="+fdate
				+"&tyear="+tyear+"&tmonth="+tmonth+"&tdate="+tdate+((index==null)?"":("&index="+index))+
				"' class='left'>预约查询</a>");
		hs.setAttribute("navbar", nb);
		try {
			Page rs = dctr.getReservation(from, to);
			rs.setLines(5);
			
			ArrayList results = null;
			if (index == null)
				results = rs.gotoFirst();
			else
				results = rs.indexof(Integer.parseInt(index));
			request.setAttribute("results", results);
			request.setAttribute("count", new Integer(rs.getPages()));
			request.setAttribute("current", new Integer(rs
					.getCurrentPage()));
			request.setAttribute("display", "y");
			request.getRequestDispatcher("searchreservation.jsp").forward(request, response);
			return;
		} catch (RecordsNotExistException e) {
			request.setAttribute("count", new Integer(0));
			request.setAttribute("display", "y");
			request.getRequestDispatcher("searchreservation.jsp").forward(request, response);
			return;
		} catch (SQLException e) {
			message = "数据库出错!";
		}
		hs.setAttribute("message", message);
		hs.setAttribute("url", "/CRQS/doctor/searchreservation.jsp");
		response.sendRedirect(response.encodeRedirectURL("/CRQS/message.jsp"));
	}

}