selectpointservlet.java

java高级引用管理综合朝鲜经java高级引用管理综合朝鲜经java高级引用管理综合朝鲜经java高级引用管理综合朝鲜经

package com.selectpoint;

import java.io.IOException;

import javax.servlet.RequestDispatcher;
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 java.util.*;
import com.login.UserDBOperation;
import com.login.UserInforBean;

public class SelectPointServlet extends HttpServlet {

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws IOException, ServletException {
		doPost(request, response);
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws IOException, ServletException {
		request.setCharacterEncoding("UTF-8");
		String year = request.getParameter("year");
		String month = request.getParameter("month");
		request.setAttribute("year", year);
		request.setAttribute("month", month);
		String pname = request.getParameter("pname");
		String role = request.getParameter("role");
		SelectPointDBOperation dbo = null;
		HttpSession session = request.getSession();
		try {
			dbo = new SelectPointDBOperation();
			if (role.equals("rsb")) {
				Collection deptspart = dbo.getDeptPoint(year, month, pname);
				// Collection personspart = dbo.getPersonPoint(year, month,
				// pname);
				String assesperson = request.getParameter("assesperson");
				Collection depts = null;
				if (assesperson.equals("") || assesperson == null) {
					depts = dbo.getDeptPoint(year, month);
				} else {
					depts = dbo.getDeptPoint(year, month, assesperson);
				}

				// Collection persons = dbo.getPersonPoint(year, month);
				session.setAttribute("depts", depts);// 显示
				// session.setAttribute("persons", persons);
				session.setAttribute("deptspart", deptspart);// 报表
				// session.setAttribute("personspart", personspart);
			} else {
				Collection depts = dbo.getDeptPoint(year, month, pname);
				// Collection persons = dbo.getPersonPoint(year, month, pname);
				session.setAttribute("depts", depts);// 显示
				// session.setAttribute("persons", persons);
				session.setAttribute("deptspart", depts);// 报表
				// session.setAttribute("personspart", persons);
			}
			dbo.closeConn();
			// request.setAttribute("loginwarn", "登录时，密码输入不正确！");
			RequestDispatcher requestDispatcher = request
					.getRequestDispatcher("/selectpoint/selectpoint.jsp");
			requestDispatcher.forward(request, response);
		} catch (Exception e) {
			// request.setAttribute("loginwarn", "登录时，密码输入不正确！");
			RequestDispatcher requestDispatcher = request
					.getRequestDispatcher("/selectpoint/selectpoint.jsp");
			requestDispatcher.forward(request, response);
		} finally {
			try {
				dbo.closeConn();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
	}

}