tj_state.java

1.员工添加 2.人事调动 3.在职人员管理 4.部门（分厂）管理

package pmsys.wyj;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.DynaActionForm;
import org.apache.struts.actions.DispatchAction;

import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import java.io.*;
import jxl.*; 
import jxl.write.*; 

import pmsys.*;
import pmsys.wyj.*;

public class TJ_State extends DispatchAction {
	/**
	 * 在职----生成部门列表
	 */
	public ActionForward zaizhilist(ActionMapping mapping,
									ActionForm form,
									HttpServletRequest request,
									HttpServletResponse response) {
		String state = "1";
		request.setAttribute("state",state);
		try{
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
			TJ_List tl = new TJ_List();
			ArrayList dlist = tl.list(ds);
			request.setAttribute("deptlist",dlist);
		} catch(Exception e1) {
			e1.printStackTrace();
		}	
		return mapping.findForward("tj_zaizhi");	
	}
	/**
	 * 按在职统计查询
	 */
	public ActionForward zaizhi(ActionMapping mapping,
									ActionForm form,
									HttpServletRequest request,
									HttpServletResponse response) {
		ArrayList dlist1 = new ArrayList();
		DynaActionForm dyform = (DynaActionForm) form;
		String state = request.getParameter("state");
		String tjdept = (String) dyform.get("tjdept");
		try{
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
			TJ_State_query sq = new TJ_State_query();
			dlist1 = sq.state_query(ds,request,tjdept,state);
			
			request.setAttribute("dept0",dlist1);
		} catch(Exception e1) {
			e1.printStackTrace();
		}
		return mapping.findForward("tj_zaizhi_list");	
	}
	/**
	 * 导出数据--在职
	 */
	public ActionForward report_date_zaizhi(ActionMapping mapping,
										ActionForm form,
										HttpServletRequest request,
										HttpServletResponse response) {
		String tjdepts = request.getParameter("dept");
		String states = "1";
		DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
		
		String sql = "SELECT * FROM employees WHERE states_id=? AND dep_dep_id=?";
		Report_data_state rds = new Report_data_state();
		String succ = rds.data_state(ds,request, sql,tjdepts,states);
		
		request.setAttribute("zaizhi_ok",succ);//导出成功设置属性
        return mapping.findForward("tj_zaizhi_list");
	}
	/**
	 * 离退休----生成部门列表
	 */
	public ActionForward lituilist(ActionMapping mapping,
									ActionForm form,
									HttpServletRequest request,
									HttpServletResponse response) {
		String state = "2";
		request.setAttribute("state",state);
		try{
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
			TJ_List tl = new TJ_List();
			ArrayList dlist = tl.list(ds);
			request.setAttribute("deptlist",dlist);
		} catch(Exception e1) {
			e1.printStackTrace();
		}	
		return mapping.findForward("tj_litui");	
	}
	/**
	 * 按离退休统计查询
	 */
	public ActionForward litui(ActionMapping mapping,
									ActionForm form,
									HttpServletRequest request,
									HttpServletResponse response) {
		ArrayList dlist1 = new ArrayList();
		DynaActionForm dyform = (DynaActionForm) form;
		String state = request.getParameter("state");
		String tjdept = (String) dyform.get("tjdept");
		try{
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
			TJ_State_query sq = new TJ_State_query();
			dlist1 = sq.state_query(ds,request,tjdept,state);
			
			request.setAttribute("dept0",dlist1);
		} catch(Exception e1) {
			e1.printStackTrace();
		}
		return mapping.findForward("tj_litui_list");	
	}
	/**
	 * 导出数据--离退休
	 */
	public ActionForward report_date_litui(ActionMapping mapping,
										ActionForm form,
										HttpServletRequest request,
										HttpServletResponse response) {
		String tjdepts = request.getParameter("dept");
		String states = "2";
		DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
		
		String sql = "SELECT * FROM employees WHERE states_id=? AND dep_dep_id=?";
		Report_data_state rds = new Report_data_state();
		String succ = rds.data_state(ds,request, sql,tjdepts,states);
		
		request.setAttribute("litui_ok",succ);//导出成功设置属性
        return mapping.findForward("tj_litui_list");
	}
	/**
	 * 停薪留职----生成部门列表
	 */
	public ActionForward tingxinglist(ActionMapping mapping,
									ActionForm form,
									HttpServletRequest request,
									HttpServletResponse response) {
		String state = "3";
		request.setAttribute("state",state);
		try{
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
			TJ_List tl = new TJ_List();
			ArrayList dlist = tl.list(ds);
			request.setAttribute("deptlist",dlist);
		} catch(Exception e1) {
			e1.printStackTrace();
		}	
		return mapping.findForward("tj_tingxing");	
	}
	/**
	 * 按停薪留职统计查询
	 */
	public ActionForward tingxing(ActionMapping mapping,
									ActionForm form,
									HttpServletRequest request,
									HttpServletResponse response) {
		ArrayList dlist1 = new ArrayList();
		DynaActionForm dyform = (DynaActionForm) form;
		String state = request.getParameter("state");
		String tjdept = (String) dyform.get("tjdept");
		try{
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
			TJ_State_query sq = new TJ_State_query();
			dlist1 = sq.state_query(ds,request,tjdept,state);
			
			request.setAttribute("dept0",dlist1);
		} catch(Exception e1) {
			e1.printStackTrace();
		}
		return mapping.findForward("tj_tingxing_list");	
	}
	/**
	 * 导出数据--停薪留职
	 */
	public ActionForward report_date_tingxing(ActionMapping mapping,
										ActionForm form,
										HttpServletRequest request,
										HttpServletResponse response) {
		String tjdepts = request.getParameter("dept");
		String states = "3";
		DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
		
		String sql = "SELECT * FROM employees WHERE states_id=? AND dep_dep_id=?";
		Report_data_state rds = new Report_data_state();
		String succ = rds.data_state(ds,request, sql,tjdepts,states);
		
		request.setAttribute("tingxing_ok",succ);//导出成功设置属性
        return mapping.findForward("tj_tingxing_list");
	}
	/**
	 * 挂靠----生成部门列表
	 */
	public ActionForward guakaolist(ActionMapping mapping,
									ActionForm form,
									HttpServletRequest request,
									HttpServletResponse response) {
		String state = "4";
		request.setAttribute("state",state);
		try{
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
			TJ_List tl = new TJ_List();
			ArrayList dlist = tl.list(ds);
			request.setAttribute("deptlist",dlist);
		} catch(Exception e1) {
			e1.printStackTrace();
		}	
		return mapping.findForward("tj_guakao");	
	}
	/**
	 * 按挂靠统计查询
	 */
	public ActionForward guakao(ActionMapping mapping,
									ActionForm form,
									HttpServletRequest request,
									HttpServletResponse response) {
		ArrayList dlist1 = new ArrayList();
		DynaActionForm dyform = (DynaActionForm) form;
		String state = request.getParameter("state");
		String tjdept = (String) dyform.get("tjdept");
		try{
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
			TJ_State_query sq = new TJ_State_query();
			dlist1 = sq.state_query(ds,request,tjdept,state);
			
			request.setAttribute("dept0",dlist1);
		} catch(Exception e1) {
			e1.printStackTrace();
		}
		return mapping.findForward("tj_guakao_list");	
	}
	/**
	 * 导出数据--挂靠
	 */
	public ActionForward report_date_guakao(ActionMapping mapping,
										ActionForm form,
										HttpServletRequest request,
										HttpServletResponse response) {
		String tjdepts = request.getParameter("dept");
		String states = "4";
		DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
		
		String sql = "SELECT * FROM employees WHERE states_id=? AND dep_dep_id=?";
		Report_data_state rds = new Report_data_state();
		String succ = rds.data_state(ds,request, sql,tjdepts,states);
		
		request.setAttribute("guakao_ok",succ);//导出成功设置属性
        return mapping.findForward("tj_guakao_list");
	}
}