selectsomethingaction.java

基本分数查询功能,自己的毕业设计作品!希望能给大家一点帮助!

package org.xk.action;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.LinkedList;
import java.util.List;

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

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;
import org.xk.domain.Page;
import org.xk.po.StudentUser;
import org.xk.util.CreateCSVFile;
import org.xk.util.NumberUtil;
import org.xk.util.ServiceUtil;
import org.xk.util.StringUtil;

public class SelectSomethingAction extends DispatchAction {
	public ActionForward selectClass(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws SQLException {

		if (request.getSession().getAttribute("port") == null
				|| request.getSession().getAttribute("teacher") == null) {
			return mapping.findForward("teacher_login");
		}
		int teacher_id = Integer.parseInt(request.getParameter("teacher_id"));

		int pageCount = 1;
		if (request.getParameter("pageCount") != null) {
			pageCount = NumberUtil.removeIntNull(request
					.getParameter("pageCount"));
		}
		int pageSize = 7;
		List ls = ServiceUtil.getSelectSomethingService().getClassInfo(
				teacher_id);

		Page p = new Page(pageSize, pageCount, ls);
		String pageStr = "";
		if (pageCount > 1) {
			pageStr += "&nbsp;<a class='pageFont' href='selectClass.do?a=selectClass&teacher_id="
					+ teacher_id
					+ "&pageCount="
					+ (pageCount - 1)
					+ "'>上一页</a>";
		} else {
			pageStr += "&nbsp;<span class='pageFont' >上一页</span>";
		}
		if (pageCount < p.getAllPage()) {
			pageStr += "&nbsp;<a class='pageFont' href='selectClass.do?a=selectClass&teacher_id="
					+ teacher_id
					+ "&pageCount="
					+ (pageCount + 1)
					+ "'>下一页</a>";
		} else {
			pageStr += "&nbsp;<span class='pageFont'>下一页</span>";
		}
		if (ls.size() > 0) {
			pageStr += "&nbsp;<span class='pageFont'>第" + pageCount + "页/共"
					+ p.getAllPage() + "页</span>";
		}
		request.setAttribute("ls", p.getPageList());
		request.setAttribute("pageStr", pageStr);
		return mapping.findForward("list");

	}

	public ActionForward selectStudent(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws SQLException {
		if (request.getSession().getAttribute("port") == null
				|| request.getSession().getAttribute("teacher") == null) {
			return mapping.findForward("teacher_login");
		}
		int class_id = Integer.parseInt(request.getParameter("class_id"));

		int pageCount = 1;
		if (request.getParameter("pageCount") != null) {
			pageCount = NumberUtil.removeIntNull(request
					.getParameter("pageCount"));
		}
		int pageSize = 12;
		List ls = ServiceUtil.getSelectSomethingService().getStudentInfo(
				class_id);
		if (ls.size() > 0) {
			request.setAttribute("active", "1");
		} else {
			request.setAttribute("active", "0");
		}
		List ls1 = ServiceUtil.getSelectSomethingService().getYearsInfo();
		Page p = new Page(pageSize, pageCount, ls);
		String pageStr = "";
		if (pageCount > 1) {
			pageStr += "&nbsp;<a class='pageFont' href='selectStudent.do?a=selectStudent&class_id="
					+ class_id + "&pageCount=" + (pageCount - 1) + "'>上一页</a>";
		} else {
			pageStr += "&nbsp;<span class='pageFont' >上一页</span>";
		}
		if (pageCount < p.getAllPage()) {
			pageStr += "&nbsp;<a class='pageFont' href='selectStudent.do?a=selectStudent&class_id="
					+ class_id + "&pageCount=" + (pageCount + 1) + "'>下一页</a>";
		} else {
			pageStr += "&nbsp;<span class='pageFont'>下一页</span>";
		}
		if (ls.size() > 0) {
			pageStr += "&nbsp;<span class='pageFont'>第" + pageCount + "页/共"
					+ p.getAllPage() + "页</span>";
		}
		request.setAttribute("ls", p.getPageList());
		request.setAttribute("pageStr", pageStr);
		request.setAttribute("ls1", ls1);
		return mapping.findForward("selectStudent");

	}

	public ActionForward selectTeacherMessage(ActionMapping mapping,
			ActionForm form, HttpServletRequest request,
			HttpServletResponse response) throws SQLException {
		if (request.getSession().getAttribute("admin") == null) {
			return mapping.findForward("admin_login");
		}
		int port_id = Integer.parseInt(request.getParameter("port_id"));
		HashMap hm = ServiceUtil.getSelectSomethingService().getPort(port_id);
		int pageCount = 1;
		if (request.getParameter("pageCount") != null) {
			pageCount = NumberUtil.removeIntNull(request
					.getParameter("pageCount"));
		}
		int pageSize = 7;
		List ls = ServiceUtil.getSelectSomethingService().getTeacherByDp(
				port_id);
		if (ls.size() > 0) {
			request.setAttribute("active", "1");
		} else {
			request.setAttribute("active", "0");
		}
		Page p = new Page(pageSize, pageCount, ls);
		String pageStr = "";
		if (pageCount > 1) {
			pageStr += "&nbsp;<a class='pageFont' href='selectTeacherMessage.do?a=selectTeacherMessage&port_id="
					+ port_id + "&pageCount=" + (pageCount - 1) + "'>上一页</a>";
		} else {
			pageStr += "&nbsp;<span class='pageFont' >上一页</span>";
		}
		if (pageCount < p.getAllPage()) {
			pageStr += "&nbsp;<a class='pageFont' href='selectTeacherMessage.do?a=selectTeacherMessage&port_id="
					+ port_id + "&pageCount=" + (pageCount + 1) + "'>下一页</a>";
		} else {
			pageStr += "&nbsp;<span class='pageFont'>下一页</span>";
		}
		if (ls.size() > 0) {
			pageStr += "&nbsp;<span class='pageFont'>第" + pageCount + "页/共"
					+ p.getAllPage() + "页</span>";
		}
		request.setAttribute("teacherList", p.getPageList());
		request.setAttribute("pageStr", pageStr);
		request.setAttribute("dp", hm);
		return mapping.findForward("selectTeacherMessage");

	}

	public ActionForward selectPort(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws SQLException {
		if (request.getSession().getAttribute("admin") == null) {
			return mapping.findForward("admin_login");
		}
		int pageCount = 1;
		if (request.getParameter("pageCount") != null) {
			pageCount = NumberUtil.removeIntNull(request
					.getParameter("pageCount"));
		}
		int pageSize = 7;
		List ls = ServiceUtil.getSelectSomethingService().getPortInfo();

		Page p = new Page(pageSize, pageCount, ls);
		String pageStr = "";
		if (pageCount > 1) {
			pageStr += "&nbsp;<a class='pageFont' href='portManager.do?a=selectPort"
					+ "&pageCount=" + (pageCount - 1) + "'>上一页</a>";
		} else {
			pageStr += "&nbsp;<span class='pageFont' >上一页</span>";
		}
		if (pageCount < p.getAllPage()) {
			pageStr += "&nbsp;<a class='pageFont' href='portManager.do?a=selectPort"
					+ "&pageCount=" + (pageCount + 1) + "'>下一页</a>";
		} else {
			pageStr += "&nbsp;<span class='pageFont'>下一页</span>";
		}
		if (ls.size() > 0) {
			pageStr += "&nbsp;<span class='pageFont'>第" + pageCount + "页/共"
					+ p.getAllPage() + "页</span>";
		}
		request.setAttribute("portList", p.getPageList());
		request.setAttribute("pageStr", pageStr);
		return mapping.findForward("selectPort");

	}

	public ActionForward addStu(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws SQLException {
		if (request.getSession().getAttribute("port") == null
				|| request.getSession().getAttribute("teacher") == null) {
			return mapping.findForward("teacher_login");
		}
		int teacher_id = Integer.parseInt(request.getParameter("teacher_id"));
		List ls = ServiceUtil.getSelectSomethingService().getClassInfo(
				teacher_id);
		request.setAttribute("ls", ls);

		return mapping.findForward("addStu");

	}

	public ActionForward selectAdmin(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws SQLException {
		if (request.getSession().getAttribute("admin") == null) {
			return mapping.findForward("admin_login");
		}

		int pageCount = 1;
		if (request.getParameter("pageCount") != null) {
			pageCount = NumberUtil.removeIntNull(request
					.getParameter("pageCount"));
		}
		int pageSize = 7;
		List ls = ServiceUtil.getSelectSomethingService().getAdminInfo();
		if (ls.size() > 0) {
			request.setAttribute("active", "1");
		} else {
			request.setAttribute("active", "0");
		}
		Page p = new Page(pageSize, pageCount, ls);
		String pageStr = "";
		if (pageCount > 1) {
			pageStr += "&nbsp;<a class='pageFont' href='selectTeacherMessage.do?a=selectTeacherMessage&"
					+ "&pageCount=" + (pageCount - 1) + "'>上一页</a>";
		} else {
			pageStr += "&nbsp;<span class='pageFont' >上一页</span>";
		}
		if (pageCount < p.getAllPage()) {
			pageStr += "&nbsp;<a class='pageFont' href='selectTeacherMessage.do?a=selectTeacherMessage&port_id="
					+ "&pageCount=" + (pageCount + 1) + "'>下一页</a>";
		} else {
			pageStr += "&nbsp;<span class='pageFont'>下一页</span>";
		}
		if (ls.size() > 0) {
			pageStr += "&nbsp;<span class='pageFont'>第" + pageCount + "页/共"
					+ p.getAllPage() + "页</span>";
		}
		request.setAttribute("adminList", p.getPageList());
		request.setAttribute("pageStr", pageStr);
		return mapping.findForward("selectAdmin");

	}

	public ActionForward addSubject(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws SQLException {
		if (request.getSession().getAttribute("port") == null
				|| request.getSession().getAttribute("teacher") == null) {
			return mapping.findForward("teacher_login");
		}
		int teacher_id = Integer.parseInt(request.getParameter("teacher_id"));

		List ls = ServiceUtil.getSelectSomethingService().getClassInfo(
				teacher_id);
		request.setAttribute("ls", ls);

		List ls1 = ServiceUtil.getSelectSomethingService().getYearsInfo();
		request.setAttribute("ls1", ls1);
		return mapping.findForward("addSubject");

	}

	public ActionForward updateStu(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws SQLException {
		if (request.getSession().getAttribute("port") == null
				|| request.getSession().getAttribute("teacher") == null) {
			return mapping.findForward("teacher_login");
		}
		String stu_number = StringUtil.toUtf8Code(request
				.getParameter("stu_number"));
		List ls = ServiceUtil.getSelectSomethingService().getStudentInfo1(
				stu_number);