salarymanage.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.salary;

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

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

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

	public Vector getSalarylist() {
		return salarylist;
	}

	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 salaryId = request.getParameter("salaryId");
			if(!salaryId.equals(""))
			  oneSalaryRecord.setSalaryId(Long.parseLong(salaryId));
			  **/
			String employeeId = request.getParameter("employeeId");
			if(null == employeeId || employeeId.equals("")) {
				employeeId = "";
				sqlflag = false;
			}
			oneSalaryRecord.setEmployeeId(getGbk(employeeId));				//员工编号
			
			String employeeName = request.getParameter("employeeName");
			if(null == employeeName || employeeName.equals("")) {
				employeeName = "";
				sqlflag = false;
			}
			oneSalaryRecord.setEmployeeName(getGbk(employeeName));				//员工姓名
			
			Integer year = Integer.parseInt(request.getParameter("year"));
			if(null == year || !(1900 < year && 2030 > year)) {
				year = 2000;
				sqlflag = false; 
			}
			oneSalaryRecord.setYear(year);														//工资年份
			
			Integer month = Integer.parseInt(request.getParameter("month"));
			if(null == month || !(0 < month && 13 > month)) {
				month = 1;
				sqlflag = false;
			}
			oneSalaryRecord.setMonth(month);													//工资月份
			
			Float basicWage;
			try {
			  basicWage = Float.parseFloat(request.getParameter("basicWage"));
			} catch(Exception ex) {
				basicWage = 0.0f;
				sqlflag = false;
			}
			oneSalaryRecord.setBasicWage(basicWage);								//基本工资
			
			Float overtimeWage;
			try {
				overtimeWage = Float.parseFloat(request.getParameter("overtimeWage"));
			} catch (Exception ex) {
				overtimeWage = 0.0f;
			}
			oneSalaryRecord.setOvertimeWage(overtimeWage);					//加班工资
			
			Float trafficWage;
			try {
				trafficWage = Float.parseFloat(request.getParameter("trafficWage"));
			} catch (Exception ex) {
				trafficWage = 0.0f;
			}
			oneSalaryRecord.setTrafficWage(trafficWage);						//交通补助工资
			
			Float kaoqinReduce;
		  try {
			  kaoqinReduce = Float.parseFloat(request.getParameter("kaoqinReduce"));
			} catch (Exception ex) {
				kaoqinReduce = 0.0f;
			}
			oneSalaryRecord.setKaoqinReduce(kaoqinReduce);					//考勤扣除
			
			Float secureReduce;
			try {
				secureReduce = Float.parseFloat(request.getParameter("secureReduce"));
			} catch(Exception ex) {
				secureReduce = 0.0f;
			}
			oneSalaryRecord.setSecureReduce(secureReduce);					//保险扣除
			
			Float taxReduce;
			try {
				taxReduce = Float.parseFloat(request.getParameter("taxReduce"));
			} catch(Exception ex) {
				taxReduce = 0.0f;
			}
			oneSalaryRecord.setTaxReduce(taxReduce);								//税收扣除
		
		  String memo = request.getParameter("memo");
		  if(null == memo || memo.equals("")) {
		  	memo = "";
		  }
		  oneSalaryRecord.setMemo(getGbk(memo));										//备注
		  
			if (sqlflag){
				flag = true;
			}
			return flag;					
		}
		catch (Exception e)
		{
			errorMessage = e.getMessage();
			return flag;
		}
	}


  //按条件执行工资信息的查找并将结果保存到salarylist向量数组中
	public boolean execute(HttpServletRequest res) throws Exception {  //用于执行按条件查询
		request = res;
		String PAGE = request.getParameter("page");   //页码
		try {
			page = Integer.parseInt(PAGE);
		}
		catch (NumberFormatException e)
		{
			page = 1;
		}
		String searchYear = request.getParameter("searchYear");  //查询某年的工资
		String searchMonth = request.getParameter("searchMonth"); //查询某月的工资
		String searchZiduan = request.getParameter("searchZiduan"); //查询的字段
		String keyword = request.getParameter("keyword");	      //查询关键词	
		if(searchYear == null) searchYear = "";
		if(null == searchMonth) searchMonth = "";
		if(keyword==null) keyword = "";
		if(searchZiduan == null) searchZiduan = "";
		keyword = getGbk(keyword);
		searchZiduan = getGbk(searchZiduan);
		
		boolean sqlCondition = false;
		//取出记录数
		sqlStr = "select count(*) from salary";
		if(!searchYear.equals("")) {
			sqlStr = sqlStr + " where year = " + searchYear;
			sqlCondition = true;
		}
		if(!searchMonth.equals("")) {
			if(sqlCondition) {
				sqlStr = sqlStr + " and month = " + searchMonth;
				sqlCondition = true;
			} else {
				sqlStr = sqlStr + " where month = " + searchMonth;
			}
		}
		if(!(searchZiduan.equals(""))) {
			if(sqlCondition) {
				sqlStr = sqlStr + " and "+ searchZiduan + " like '%" + keyword + "%'";
			} else {
				sqlStr = sqlStr + " where " + searchZiduan + " like '%" + keyword + "%'";
			}
		}
		
		int rscount = pageSize;
		try
		{
			ResultSet rs1 = stmt.executeQuery(sqlStr);
			if (rs1.next()) recordCount = rs1.getInt(1);				
			rs1.close();
		}
		catch (SQLException e)
		{
			errorMessage = "查询记录总数错误:" + 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;
		  }