明日科技OA系统,简单的系统

package com.office.action; import java.sql.ResultSet; import java.util.ArrayList; import java.util.Date; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import org.apache.struts.action.Action; import org.apache.struts.action.ActionError; import org.apache.struts.action.ActionErrors; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import com.office.actionform.LogonForm; import com.office.actionform.SearchForm; import com.office.actionform.UserForm; import com.office.dao.Content; import com.office.dao.DB; import com.office.officemenu.Searchtypelist; import com.office.tools.Change; import com.office.tools.CheckUserAble; public class UserAction extends Action { public ActionForward execute(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response) { HttpSession session=request.getSession(); LogonForm logonuser=(LogonForm)session.getAttribute("logonuser"); if(logonuser==null){ ActionErrors errors=new ActionErrors(); errors.add(ActionErrors.GLOBAL_ERROR,new ActionError("office.logon.notallow")); saveErrors(request,errors); return mapping.findForward("notallowlogon"); } String mark = mapping.getParameter(); ActionForward forward = new ActionForward(); if (mark.equals("person_look")) forward = executePersonLook(mapping, form, request, response); if (mark.equals("person_sigle_look")) forward = executePersonSigleLook(mapping, form, request, response); if (mark.equals("person_myself_look")) forward = executePersonMyselfLook(mapping, form, request, response); if (mark.equals("person_add")) forward = executePersonAdd(mapping, form, request, response); if (mark.equals("person_update")) forward = executePersonUpdate(mapping, form, request, response); if (mark.equals("person_myself_update")) forward = executeMyUpdate(mapping, form, request, response); if (mark.equals("person_del")) forward = executePersonDel(mapping, form, request, response); if (mark.equals("person_good")) forward = executePersonGood(mapping, form, request, response); return forward; } public ActionForward executePersonLook(ActionMapping mapping,ActionForm form, HttpServletRequest request,HttpServletResponse response) { ActionErrors errors = new ActionErrors(); HttpSession session = request.getSession(); LogonForm logonuser=(LogonForm)session.getAttribute("logonuser"); if(!CheckUserAble.check(logonuser)){ session.setAttribute("selectmenu2", ""); errors.add(ActionErrors.GLOBAL_ERROR,new ActionError("office.user.noallow")); saveErrors(request,errors); return mapping.findForward("notallow"); } session.setAttribute("selectmenu2", "person_look"); SearchForm searchform = (SearchForm) form; String sql = ""; String subsql = searchform.getSubsql(); String subsqlvalue = searchform.getSubsqlvalue(); if (subsql == null || subsql.equals("")) subsql = "all"; if (subsql.equals("all")){ subsqlvalue=""; sql = "select * from " + Content.TB_USER; } else if (subsql.equals("user_good")) { session.setAttribute("selectmenu2", "person_good"); searchform.setSubsql(subsql); if (subsqlvalue == null || subsqlvalue.equals("")) { sql = "select * from " + Content.TB_USER + " where user_good='1'"; } else { sql = "select * from " + Content.TB_USER + " where "+ Content.USERNAME + "='" + subsqlvalue + "' and user_good='1'"; } } else if(subsql.equals("user_able")){ if (subsqlvalue == null || subsqlvalue.equals("")) { errors.add(ActionErrors.GLOBAL_ERROR, new ActionError("office.search.notiaojian.error")); saveErrors(request, errors); return mapping.findForward("false"); } int subsqlvalue1=-1; if(subsqlvalue.equals("游客"))subsqlvalue1=0; else if(subsqlvalue.equals("普通管理员"))subsqlvalue1=1; else if(subsqlvalue.equals("系统管理员"))subsqlvalue1=2; sql = "select * from " + Content.TB_USER + " where user_able=" + subsqlvalue1; } else { if (subsqlvalue == null || subsqlvalue.equals("")) { errors.add(ActionErrors.GLOBAL_ERROR, new ActionError("office.search.notiaojian.error")); saveErrors(request, errors); return mapping.findForward("false"); } sql = "select * from " + Content.TB_USER + " where " + subsql+ "='" + subsqlvalue + "'"; } String str_currentpage=request.getParameter("page"); if(str_currentpage==null||str_currentpage.equals("")) str_currentpage="0"; int currentpage=Change.strtoint(str_currentpage); if(currentpage<=0) currentpage=1; DB db = new DB(); ArrayList personlist = db.getallpersonlist(sql,currentpage); session.setAttribute("numrs",Integer.toString(db.getNumrs())); session.setAttribute("numper", Integer.toString(db.getNumper())); session.setAttribute("currentpage",Integer.toString(db.getCurrentPage())); session.setAttribute("numpages", Integer.toString(db.getNumPages())); session.setAttribute("personlist", personlist); searchform.setSubsqlvalue(subsqlvalue); return mapping.findForward("success"); } public ActionForward executePersonGood(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { ActionErrors errors=new ActionErrors(); HttpSession session=request.getSession(); LogonForm logonuser=(LogonForm)session.getAttribute("logonuser"); if(!CheckUserAble.check(logonuser)){ session.setAttribute("selectmenu2", ""); errors.add(ActionErrors.GLOBAL_ERROR,new ActionError("office.user.noallow")); saveErrors(request,errors); return mapping.findForward("notallow"); } SearchForm searchform=(SearchForm)form; searchform.setSubsql(Content.USERGOOD); executePersonLook(mapping, form, request, response); return mapping.findForward("success"); } public ActionForward executePersonSigleLook(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { ActionErrors errors=new ActionErrors(); HttpSession session=request.getSession(); LogonForm logonuser=(LogonForm)session.getAttribute("logonuser"); if(!CheckUserAble.check(logonuser)){ session.setAttribute("selectmenu2", ""); errors.add(ActionErrors.GLOBAL_ERROR,new ActionError("office.user.noallow")); saveErrors(request,errors); return mapping.findForward("notallow"); } UserForm userform=(UserForm)form; String lookid1=request.getParameter("id"); if(lookid1==null||lookid1.equals(""))lookid1="0"; int lookid=Change.strtoint(lookid1); ArrayList personlist=(ArrayList)session.getAttribute("personlist"); boolean flag=false; for(int i=0;i<personlist.size();i++){ UserForm personsigleform=(UserForm)personlist.get(i); if(lookid==personsigleform.getUserid()){ flag=true; userform.setUsername(personsigleform.getUsername()); userform.setUsertruename(personsigleform.getUsertruename()); userform.setUserable(personsigleform.getUserable()); userform.setUsergood(personsigleform.getUsergood()); userform.setUserbranch(personsigleform.getUserbranch()); userform.setUserjob(personsigleform.getUserjob()); userform.setUsersex(personsigleform.getUsersex()); userform.setUseremail(personsigleform.getUseremail()); userform.setUsertel(personsigleform.getUsertel()); userform.setUseraddress(personsigleform.getUseraddress()); userform.setUseraccesstimes(personsigleform.getUseraccesstimes()); userform.setUserfoundtime(personsigleform.getUserfoundtime()); break; } } if(!flag){ errors.add(ActionErrors.GLOBAL_ERRO