queryaction.java

中应用程序的访问权限对Java Web Console 中应用程序的访问权限 成功登录 Web 控制台后,可能无法自动访问在该控制台中注册的所有应用程序。通常,必须安装应用程序,才能让所有的用户在控制

/**s
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package edu.yinhe.mis.control;
import java.io.IOException;
import java.io.PrintWriter;
import java.lang.reflect.InvocationTargetException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.commons.beanutils.BeanUtils;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import edu.yinhe.mis.dto.QueryDTO;
import edu.yinhe.mis.vo.QueryVO;
import edu.yinhe.system.common.AppException;
import edu.yinhe.system.control.BaseAction;
import edu.yinhe.system.common.GlobalNames;
/** 
 * MyEclipse Struts
 * Creation date: 04-01-2008
 * 
 * XDoclet definition:
 */
public class QueryAction extends BaseAction {
	/*
	 * Generated Methods
	 */

	/**
	 * author 王熙亮
	 */
	/**
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	  public ActionForward query(ActionMapping mapping, ActionForm form,
				HttpServletRequest request, HttpServletResponse response){
			 QueryForm queryForm = (QueryForm) form;
		       QueryDTO dto = new QueryDTO();
		       QueryVO vo = new QueryVO();
			 ArrayList list = null;
			 List list1 = new ArrayList();
			 String classno = null;
			 ActionForward forword = mapping.findForward("query");
			 try {
				 int currentPage = 1;
				 int rowperPage = GlobalNames.PAGE_RECORDS;
				 int totalPage = 0;
				 String PageNum = request.getParameter("pageNum");
				 list1 = (ArrayList) session.getAttribute("studentlogin");	
				  if(list1 != null){
					  vo = (QueryVO) list1.get(0);
					  
				  }
				  classno = vo.getClass_no();
				  if(PageNum==null){
					 PageNum = "1";
				 }
				 classno = vo.getClass_no();
				 currentPage = Integer.parseInt(PageNum);
				 dto.setClass_no(classno);
			     dto.setCurrentPage(String.valueOf(currentPage));
			     dto.setRowperPage(String.valueOf(rowperPage));
			     BeanUtils.copyProperties(dto, queryForm);
				 service.setDataSource(getDataSource(request,"mydatasource"));
				 Object[] obj = (Object[]) service.list(dto);
				 int total = ((Integer) obj[0]).intValue();
				 totalPage = (total/rowperPage)+((total%rowperPage>0)?1:0);
				 request.setAttribute("pageNum",currentPage );
				 request.setAttribute("total",total);
				 request.setAttribute("totalPage", totalPage);
				 list = (ArrayList) obj[1];
				 if(list.size()>0){
					 request.setAttribute("query", list);
					forword = mapping.findForward("query");
				 }else if (list.size()==0){
					forword = mapping.findForward("main");
				 }
			} catch (AppException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (IllegalAccessException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (InvocationTargetException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			 return forword; 
	  }
	  
	  public ActionForward queryall(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		   QueryForm queryForm = (QueryForm) form;
		   QueryDTO queryDTO = new QueryDTO();
		    ArrayList list = null;
		    ActionForward forword = mapping.findForward("queryall");
		    try {
		    	int currentPage = 1;//页
		        int rowperPage = GlobalNames.PAGE_RECORDS;//每页共行数
		        int totalPage = 0;//总页
		        String PageNum = request.getParameter("pageNum");
		        String classno = request.getParameter("classno");
		        String classroom = request.getParameter("classroom");
		        String schoolno = request.getParameter("schoolno");
		        if(PageNum==null){
		        	PageNum = "1";
		        }
		        currentPage = Integer.parseInt(PageNum);
		        queryDTO.setClass_no(classno);
		        queryDTO.setClassroom_no(classroom);
		        queryDTO.setSchool_no(schoolno);
		        queryDTO.setCurrentPage(String.valueOf(currentPage));
		        queryDTO.setRowperPage(String.valueOf(rowperPage));
		        BeanUtils.copyProperties(queryDTO,queryForm);
				service.setDataSource(getDataSource(request,"mydatasource"));
				Object[] obj = (Object[]) service.alllist(queryDTO);
				int total = ((Integer)obj[0]).intValue();//当前页总行数
			    totalPage = (total/rowperPage)+((total%rowperPage>0)?1:0);
			    request.setAttribute("pageNum",currentPage);
			    request.setAttribute("total",total);
			    request.setAttribute("totalPage",totalPage);
			    request.setAttribute("classno",classno);
			    request.setAttribute("classroom",classroom);
			    request.setAttribute("schoolno", schoolno);
			    list = (ArrayList)obj[1];
				if(list.size()>0){
					request.setAttribute("queryDTO", queryDTO);
					request.setAttribute("queryall", list);
					forword = mapping.findForward("queryall");
				}else if(list.size()==0){
					forword = mapping.findForward("successd");
				}
		    } catch (IllegalAccessException e) {
				// TODO Auto-generated catch block
			
				e.printStackTrace();
		
			} catch (InvocationTargetException e) {
				// TODO Auto-generated catch block
			
				e.printStackTrace();
		
			} catch (AppException e) {
				// TODO Auto-generated catch block
			
				e.printStackTrace();
			
			}
			
			return forword;
		 
	  }
	  public ActionForward personal(ActionMapping mapping, ActionForm form,
				HttpServletRequest request, HttpServletResponse response) {
		  QueryForm queryForm = (QueryForm) form;
			QueryDTO dto = new QueryDTO();
			ActionForward forword = mapping.findForward("personal");
			ArrayList list = null;
			String teacherno = request.getParameter("teacherno");
			String dates = request.getParameter("dates");
			try {
				int currentPage = 1;//页
				int rowperPage = GlobalNames.PAGE_RECORDS;//每页共行数
				int totalPage = 0;//总页
				String PageNum = request.getParameter("pageNum");
	
				if(PageNum==null){
					PageNum="1";
				}
				currentPage = Integer.parseInt(PageNum);
				dto.setTeacher_no(teacherno);
				dto.setHour_date(dates);
				dto.setCurrentPage(String.valueOf(currentPage));
				dto.setRowperPage(String.valueOf(rowperPage));
				BeanUtils.copyProperties(dto,queryForm);
				service.setDataSource(getDataSource(request,"mydatasource"));
				Object[] obj = (Object[])service.load(dto);
				int total = ((Integer)obj[0]).intValue();//当前页总行数
				totalPage = (total/rowperPage)+((total%rowperPage>0)?1:0);
				request.setAttribute("pageNum",currentPage);
			    request.setAttribute("total",total);
			    request.setAttribute("totalPage",totalPage);
			    request.setAttribute("teacherno",teacherno);
			    request.setAttribute("dates", dates);
				list = (ArrayList) obj[1];
				if(list.size()>0){
					request.setAttribute("personal", list); 
					forword = mapping.findForward("personal");
				}else if(list.size()==0){
					forword = mapping.findForward("error");
				}
			} catch (IllegalAccessException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (InvocationTargetException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (AppException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		  return forword;
	  }
	  public ActionForward login(ActionMapping mapping, ActionForm form,
				HttpServletRequest request, HttpServletResponse response){
		       QueryDTO dto = new QueryDTO();
			 ArrayList list = null;
			 ActionForward forword = mapping.findForward("main");
			 try {
				 ;
				 String stuNo = request.getParameter("stuNo");
				 String classNo = request.getParameter("classNo");
				 String password = request.getParameter("password");
				 dto.setStuNo(stuNo);
				 dto.setClass_no(classNo);
				 dto.setPassword(password);
			    service.setDataSource(getDataSource(request,"mydatasource"));
			      list= (ArrayList) service.findById(dto);
			      
				 if(list.size()>0){
					 session.setAttribute("studentlogin", list);
					forword = mapping.findForward("main");
				 }else if (list.size()==0){
					forword = mapping.findForward("login");
				 }
			} catch (AppException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			 return forword; 
	  }
	  
	  /**
	   * 验证密码
	   * @param mapping
	   * @param form
	   * @param request
	   * @param response
	   * @return
	   */
	  public ActionForward validate(ActionMapping mapping, ActionForm form,
				HttpServletRequest request, HttpServletResponse response){
		       QueryDTO dto = new QueryDTO();
			 ArrayList list = null;
			 ActionForward forword = mapping.findForward("main");
			 try {
				 PrintWriter pw=response.getWriter();
				 String oldpwd = request.getParameter("oldpwd");
				 list=(ArrayList)session.getAttribute("studentlogin");
				 QueryVO vo=(QueryVO)list.get(0);
				 String classno=vo.getClass_no();
				 String studentno=vo.getStuNo();
				 
				 dto.setStuNo(studentno);
				 dto.setClass_no(classno);
				 dto.setPassword(oldpwd);
			    service.setDataSource(getDataSource(request,"mydatasource"));
			      list= (ArrayList) service.findById(dto);
			      
				 if(list.size()>0){
					 pw.print("1");
				 }else if (list.size()==0){
					 pw.print("0");
				 }
				 pw.flush();
				 pw.close();
			} catch (AppException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			 return null; 
	  }
	  public ActionForward updatepwd(ActionMapping mapping, ActionForm form,
				HttpServletRequest request, HttpServletResponse response){
		   ArrayList list = new ArrayList();
		   List list1 = new ArrayList();
		   QueryVO vo = new QueryVO();
		   QueryDTO dto = new QueryDTO();
		   String strNo = null;
		   boolean flag = false;
		  ActionForward forword = mapping.findForward("success");
		    try {
		    	list = (ArrayList) session.getAttribute("studentlogin");
		    	String newpwd = request.getParameter("newpwd");
		    	if(list!=null){
		    		vo = (QueryVO) list.get(0);
		    	}
		    	strNo = vo.getStuNo();
		    	dto.setStuNo(strNo);
		    	dto.setNewpwd(newpwd);
				service.setDataSource(getDataSource(request,"mydatasource"));
				flag = (Boolean) service.create(dto);
				if(flag==true){
					forword = mapping.findForward("success");
				}else
				{
					forword = mapping.findForward("update");
				}
			} catch (AppException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		  return forword; 
	  }
}