employeemanage.java

本系统是基于JAVA语言的办公系统

package org.pan.web;

import java.sql.*;
import java.util.Vector;
import java.util.Calendar;
import org.pan.util.*;
import javax.servlet.http.HttpServletRequest;
import org.pan.web.employee;

/**
 * Title:       员工信息管理类
 * Description:
 * Copyright:    Copyright (c) 2008
 * @author:		 双鱼林
 * @version 1.0
 */

public class employeeManage extends DataBase {
	private employee oneEmployee = new employee();	//新的一个员工
	private javax.servlet.http.HttpServletRequest request; //建立页面请求
	private boolean sqlflag = true ;		//对接收到的数据是否正确
	private Vector employeelist;				//显示员工列表向量数组
	private int page = 1;					//显示的页码
	private int pageSize=5;				//每页显示的图书数
	private int pageCount =0;				//页面总数
	private long recordCount =0;			//查询的记录总数
  public String errorMessage = "";           //保存出错信息
  public String sqlStr = "";

	
	public employeeManage() throws Exception{
		super();
	}

	public Vector getEmployeelist() {
		return employeelist;
	}

	public boolean getSqlflag() {
		return sqlflag;
	}

	public String getGbk( String str) {
		try
		{
			return new String(str.getBytes("ISO8859-1"));
		}
		catch (Exception e)
		{
			return str;
		}
	}
	
	//将页面表单传来的资料分解并保存到员工类的各个字段中
	public boolean getRequest(javax.servlet.http.HttpServletRequest newrequest) {
		boolean flag = false;
		try
		{	
			request = newrequest;
			String employeeId = request.getParameter("employeeId");
			if(null == employeeId || employeeId.equals("")) {
				employeeId = "";
				sqlflag = false;
			}
			oneEmployee.setEmployeeId(getGbk(employeeId));
			
			String name = request.getParameter("name");
			if (name==null || name.equals("")) {
				name = "";
				sqlflag = false;
			}
			oneEmployee.setName(getGbk(name));
			
			String cardNumber = request.getParameter("cardNumber");
			if(null == cardNumber || cardNumber.equals("")) {
				cardNumber = "";
			}
			oneEmployee.setCardNumber(getGbk(cardNumber));
			
			String nation = request.getParameter("nation");
			if(null == nation || nation.equals("")) {
				nation = "";
			}
			oneEmployee.setNation(getGbk(nation));
			
			String sex = request.getParameter("sex");
			if(null == sex || sex.equals("")) {
				sex = "";
			}
			oneEmployee.setSex(getGbk(sex));
			
			String birthday = request.getParameter("birthday");
			if(null == birthday || birthday.equals("")) {
				birthday = ""; 
			}
			oneEmployee.setBirthday(getGbk(birthday));
			
		  String graduateSchool = request.getParameter("graduateSchool");
			if(null == graduateSchool || graduateSchool.equals("")) {
				graduateSchool = "";
			}
			oneEmployee.setGraduateSchool(getGbk(graduateSchool));
			
			String schoolRecord = request.getParameter("schoolRecord");
			if(null == schoolRecord || schoolRecord.equals("")) {
				schoolRecord = "";
			}
			oneEmployee.setSchoolRecord(getGbk(schoolRecord));
			
		  String department = request.getParameter("department");
		  if (department == null || department.equals("")) {
		  	department = "";sqlflag=false;
		  }
		  oneEmployee.setDepartment(getGbk(department));
		 
		  String positionName = request.getParameter("positionName");
		  if (positionName == null || positionName.equals("")) {
		  	positionName = "";
		  }
		  oneEmployee.setPositionName(getGbk(positionName));
		  
		  String telephone = request.getParameter("telephone");
		  if (telephone == null || telephone.equals("")) {
		  	telephone = "";
		  }
		  oneEmployee.setTelephone(getGbk(telephone));
		  
		  String email = request.getParameter("email");
		  if(null == email || email.equals("")) {
		  	email = "";
		  }
		  oneEmployee.setEmail(getGbk(email));
		  
		  String memo = request.getParameter("memo");
		  if(null == memo || memo.equals("")) {
		  	memo = "";
		  }
		  oneEmployee.setMemo(getGbk(memo));
		  
			if (sqlflag){
				flag = true;
			}
			return flag;					
		}
		catch (Exception e)
		{
			return flag;
		}
	}


  //按条件执行员工的查找并将结果保存到employeelist向量数组中
	public boolean execute(HttpServletRequest res) throws Exception {  //用于执行按条件查询
		request = res;
		String PAGE = request.getParameter("page");   //页码
		String searchZiduan = request.getParameter("searchZiduan");  //查询的字段
		String keyword = request.getParameter("keyword");	//查询关键词	
		if (keyword==null) keyword = "";
		if (searchZiduan == null) searchZiduan = "";
		keyword = getGbk(keyword);
		searchZiduan = getGbk(searchZiduan);
		try
		{
			page = Integer.parseInt(PAGE);
		}
		catch (NumberFormatException e)
		{
			page = 1;
		}
		 
		//取出记录数
		if (searchZiduan.equals("") && !keyword.equals("") ) {
			sqlStr = "select count(*) from employee where employeeId like '%" + keyword + "%' or name like '%" + keyword + "%' or department like '%" + keyword + "%'";
		} else if (!searchZiduan.equals("")) {
			if (searchZiduan.equals("employeeId")) {
				sqlStr = "select count(*) from employee where employeeId like '%" +keyword+ "%'";
			} else if(searchZiduan.equals("name")) {
				sqlStr = "select count(*) from employee where name like '%" + keyword + "%'";
			} else if(searchZiduan.equals("department")){
				sqlStr = "select count(*) from employee where department like '%" + keyword + "%'";
			}
		} else if(searchZiduan.equals("") && keyword.equals("")) {
			sqlStr = "select count(*) from employee";
		}

		int rscount = pageSize;
		try
		{
			ResultSet rs1 = stmt.executeQuery(sqlStr);
			if (rs1.next()) recordCount = rs1.getInt(1);				
			rs1.close();
		}
		catch (SQLException e)
		{
			errorMessage = "查询记录总数错误:" + searchZiduan + sqlStr + e.getMessage();
			return false;
		}
		//计算查询结果总页数
		if (recordCount < 1)
      pageCount = 0;
    else
      pageCount = (int)(recordCount - 1) / pageSize + 1;
		//检查查看的页面数是否在范围内
		if (page < 1)  
       page = 1;
    else if (page > pageCount)
       page = pageCount;
		rscount = (int) recordCount % pageSize;	 // 最后一页记录数
		
		sqlStr = "select * from employee ";  //根据不同条件构造不同的sql查询字符串
		if (searchZiduan.equals("") && !keyword.equals("") ) {
			sqlStr = sqlStr + "where employeeId like '%" + keyword + "%' or name like '%" + keyword + "%' or department like '%" + keyword + "%' order by employeeId desc";
		} else if(!searchZiduan.equals("")) {
			sqlStr = sqlStr + "where " + searchZiduan + " like '%" + keyword + "%' order by employeeId desc";
		} else if(searchZiduan.equals("") && keyword.equals("")) {
				sqlStr = sqlStr + "order by employeeId desc";
		}
		
		try
		{
			rs = stmt.executeQuery(sqlStr);
			employeelist = new Vector(rscount);
			for(int i=0;i<pageSize*(page-1);i++)rs.next();//跳过前面页的记录
			while (rs.next())
			{
				employee anemployee = new employee();
				anemployee.setEmployeeId(rs.getString("employeeId"));
				anemployee.setName(rs.getString("name"));
				anemployee.setCardNumber(rs.getString("cardNumber"));
				anemployee.setNation(rs.getString("nation"));
				anemployee.setSex(rs.getString("sex"));
				anemployee.setBirthday(rs.getString("birthday"));
				anemployee.setGraduateSchool(rs.getString("graduateSchool"));
				anemployee.setSchoolRecord(rs.getString("schoolRecord"));
				anemployee.setDepartment(rs.getString("department"));