基于Java、mysql的OA办公系统课设或者毕业设计

//Created by MyEclipse Struts // XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.1.1/xslt/JavaClass.xsl package com.struts.action.empdept; import java.io.IOException; import java.io.OutputStreamWriter; import java.io.PrintWriter; import java.io.UnsupportedEncodingException; import java.text.DateFormat; import java.util.Date; import java.util.HashMap; 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 com.empdept.employee.EmployeeDAO; import com.empdept.employee.EmployeeHbn; import com.global.CalendarConvert; import com.global.Constants; import com.global.TableInfo; import com.hibernate.pojo.Employee; import com.hibernate.pojo.Instantcommunicateuserinfo; import com.instantcommunicate.InstantCommunicateUserInfoDAO; import com.instantcommunicate.InstantCommunicateUserInfoImp; import com.struts.form.empdept.EmpForm; /** * MyEclipse Struts Creation date: 08-12-2006 * * XDoclet definition: * * @struts.action path="/emp" name="empForm" input="/form/emp.jsp" * parameter="method" scope="request" */ public class EmpAction extends DispatchAction { private int startRecord = 0;// 利用Hibernate从第几条开始分页 private static EmployeeDAO emp = new EmployeeHbn(); private String empCode; private String empName; private String empSex; private String empJoindate; private String empBirth; private String empAddress; private String empEmail; private String empPhone; private int currentPage = 1; private HashMap hashMap; private List list; private int recordCount;// 查询到的记录的数量 private String empPwd; private String empDescription; private Integer deptId; private PrintWriter out; private Integer empId; /** * 这是一个按多条件查询的方法 * * @param mapping * @param form * @param request * @param response * @return */ public ActionForward queryEmp(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { System.out.println("sdfs"); EmpForm empForm = (EmpForm) form; /* * 如果是queryEmp.jsp页面提交过来的查询条件放到executeQueryEmpSubmit(request, * empForm)方法中处理 方法中将查询的条件信息保存到HashMap中，以备下次从empQueryResult.jsp提交过来的查询用 */ executeQueryEmpSubmit(request, empForm); /* * 如果是从页面empQueryResult.jsp提交过来的各种数据 * 则将数据传到executeEmpQueryResultSubmit(request)方法中处理 */ executeEmpQueryResultSubmit(request); /* 执行查询 */ list = emp.query(empCode, empName, empSex, CalendarConvert .toDate(empJoindate), CalendarConvert.toDate(empBirth), empAddress, empEmail, empPhone, startRecord); if (list == null || list.size() == 0) list = null; // 得到记录总数 recordCount = (Integer) TableInfo.getSaveRecordCountInstance().get( "EmployeeByQBE"); // System.out.println("总记录数：" + recordCount); // 得到总页数，保存 request.setAttribute("TotalPage", this.getTotalPage()); // 将总的记录数保存到request中 request.setAttribute("RecordCount", recordCount); // 将当前是在第几页保存在request中 request.setAttribute("CurrentPage", currentPage); /* 转发到结果页面显示 */ request.setAttribute("emps", list); return mapping.findForward("empQueryResult"); } /** * 如果是从页面empQueryResult.jsp提交过来的各种数据 则将数据传到该方法中处理 * * @param request */ /** * @param request */ private void executeEmpQueryResultSubmit(HttpServletRequest request) { if (request.getParameter("empQueryResult") != null && request.getParameter("empQueryResult").equals( "empQueryResult")) { empCode = hashMap.get("empCode").toString(); empName = hashMap.get("empName").toString(); empSex = hashMap.get("empSex").toString(); if (hashMap.get("empJoindate") != null && hashMap.get("empJoindate").toString().trim().length() > 0) { empJoindate = hashMap.get("empJoindate").toString(); } else { empJoindate = null; } if (hashMap.get("empBirth") != null && hashMap.get("empBirth").toString().trim().length() > 0) { empBirth = hashMap.get("empBirth").toString(); } else { empBirth = null; } empAddress = hashMap.get("empAddress").toString(); empEmail = hashMap.get("empEmail").toString(); next(request);// 跳到下一页 privious(request);// 执行上一页查询 request.setAttribute("hashMap", hashMap);// 再次将查询条件保存到hashMap中，以备下次查询 } } /** * 得到总页数 */ public int getTotalPage() { int result = recordCount / Constants.PAGE_RECORD_SHOW_COUNT; if ((recordCount % Constants.PAGE_RECORD_SHOW_COUNT) > 0) result = result + 1; return result; } /** * 执行上一页查询的方法 * * @param request */ private void privious(HttpServletRequest request) { if ((request.getParameter("previous") != null) && (request.getParameter("previous").equals("previous"))) { startRecord = startRecord - Constants.PAGE_RECORD_SHOW_COUNT; if (startRecord < 0) startRecord = 0; currentPage = currentPage - 1; if (currentPage <= 1) { currentPage = 1; } } } /** * 执行下一页的查询 * * @param request */ private void next(HttpServletRequest request) { if ((request.getParameter("next") != null) && (request.getParameter("next").equals("next"))) { startRecord = startRecord + Constants.PAGE_RECORD_SHOW_COUNT; if (startRecord > recordCount) startRecord = startRecord - Constants.PAGE_RECORD_SHOW_COUNT; currentPage = currentPage + 1; if (currentPage > this.getTotalPage()) { currentPage = this.getTotalPage(); } } } /** * 如果是queryEmp.jsp页面提交过来的查询条件放到该方法中处理 * 方法中将查询的条件信息保存到HashMap中，以备下次从empQueryResult.jsp提交过来的查询用 * * @param request * @param empForm */ private void executeQueryEmpSubmit(HttpServletRequest request, EmpForm empForm) { if (request.getParameter("jspPage") != null && request.getParameter("jspPage").equals("queryEmp")) { hashMap = new HashMap(); empCode = empForm.getEmpCode(); empName = empForm.getEmpName(); empSex = empForm.getEmpSex(); if (empForm.getEmpJoindate() == null || empForm.getEmpJoindate().trim() == "") empJoindate = null; else empJoindate = empForm.getEmpJoindate().trim(); if (empForm.getEmpBirth() == null || empForm.getEmpBirth() == "") empBirth = null; else empBirth = empForm.getEmpBirth().trim(); empAddress = empForm.getEmpAddress(); empEmail = empForm.getEmpEmail(); empPhone = empForm.getEmpPhone(); // System.out.println("executeQueryEmpSubmit方法中:" + "empCode:" // + empCode + "|" + "empName:" + empName + "|" + "empSex:" // + empSex + "|" + "empJoindate:" + empJoindate + "|" // + "empBirth:" + empBirth + "|" + "empAddress:" + empAddress // + "|" + "empEmail:" + empEmail + "|" + "empPhone:" // + empPhone + "|" + "startRecord:" + startRecord); /* 将上面的查询条件保存起来 */ hashMap.put("empCode", empCode); hashMap.put("empName", empName); hashMap.put("empSex", empSex); hashMap.put("empJoindate", empJoindate); hashMap.put("empBirth", empBirth); hashMap.put("empAddress", empAddress); hashMap.put("empEmail", empEmail); hashMap.put("empPhone", empPhone); startRecord = 0;// 第一次提交查询信息过来将查询的开始页面数置0 recordCount = 0;// 初始化 currentPage = 1;// 初始化 request.setAttribute("hashMap", hashMap); } } /** * 添加员工 * * @param mapping * @param form * @param request * @param response * @return */ public ActionForward addEmp(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { EmpForm empForm = (EmpForm) form; empCode = empForm.getEmpCode();