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 pmsys.*;
import pmsys.wyj.*;

public class State extends DispatchAction {
	/**
	 * ----生成状态列表
	 */
	public ActionForward statelist(ActionMapping mapping,
									ActionForm form,
									HttpServletRequest request,
									HttpServletResponse response) {
		ArrayList dlist = new ArrayList();
		Connection conn = null;
		try{

			//链接池连接数据库
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
			conn = ds.getConnection();
			
			//查处所有交费类型
			Statement stmt = conn.createStatement();
			String sql = "SELECT * FROM states";
			ResultSet rs = stmt.executeQuery(sql);
			//将数据库表字段值存入UserForm的相应属性中
			while(rs.next()) {
				if(rs.getInt("states_id") == 2){
					continue;
				}
				UserForm account = new UserForm();
				account.setDeptno(rs.getInt("states_id") + "");
				account.setDname(rs.getString("states_name"));
				dlist.add(account);
			}
			request.setAttribute("statelist",dlist);
		} catch(Exception e) {
			e.printStackTrace();
		} finally {
			if (conn != null) {
				try {
					conn.close();
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		}	
		return mapping.findForward("rytz_state");
	}
	/**
	 * 查找要调整的姓名
	 */
	public ActionForward ry_chazhao_state(ActionMapping mapping,
									ActionForm form,
									HttpServletRequest request,
									HttpServletResponse response) {
		ArrayList dlist1 = new ArrayList();

		DynaActionForm dyform = (DynaActionForm) form;
		String emp_names = (String) dyform.get("emp_name");  //员工姓名
		String state = (String) dyform.get("state");  //状态id号

		Connection conn = null; 
		Statement stmt = null;
		String sql = null;
		try{
			//处理乱码
			String emp_name = new String(emp_names.getBytes("iso-8859-1"),"gbk");
			//选择符合条件的sql语句
			if(emp_name.trim().equals("") || emp_name.trim().equals(null)){
				int states_id = Integer.parseInt(state);
				sql = "SELECT * FROM employees e,states s WHERE e.states_id=s.states_id AND e.states_id=" + states_id;
			}else{
				int states_id = Integer.parseInt(state);
				sql = "SELECT * FROM employees e,states s WHERE e.emp_name LIKE '%" + emp_name + "%' AND e.states_id=" + states_id + " AND e.states_id=s.states_id";
			}	
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");	
			conn = ds.getConnection();
			
			stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery(sql);
			
			while(rs.next()){
				UserForm dept1 = new UserForm();
				dept1.setDeptno(rs.getInt("emp_id")+"");
				dept1.setDname(rs.getString("emp_name"));
				dept1.setDept(rs.getString("states_name"));
				dlist1.add(dept1);
			}
			request.setAttribute("emp_list",dlist1);
		} catch(Exception e1) {
			e1.printStackTrace();
		} finally {
			if (conn != null) {
				try {
					conn.close();
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		}
		return mapping.findForward("rytz_state_update");	
	}
	/**
	 * 查找当前调整姓名的信息
	 */
	public ActionForward ry_state_chazhao(ActionMapping mapping,
									ActionForm form,
									HttpServletRequest request,
									HttpServletResponse response) {
		ArrayList dlist1 = new ArrayList();
		ArrayList dlist2 = new ArrayList();
		DynaActionForm dyform = (DynaActionForm) form;
		String emp_ids = (String) dyform.get("emp_id");  //员工姓名
		int emp_id = Integer.parseInt(emp_ids);
		Connection conn = null; 
		Statement stmt = null;
		String sql = sql = "SELECT * FROM employees e,states s WHERE e.states_id=s.states_id AND emp_id=" + emp_id;
		try{	
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");	
			conn = ds.getConnection();
			
			stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery(sql);
			while(rs.next()){
				UserForm dept1 = new UserForm();
				dept1.setDeptno(rs.getInt("emp_id")+"");
				dept1.setDname(rs.getString("emp_name"));
				dept1.setDept(rs.getString("states_name"));
				String state = rs.getString("states_id") + "";
				if(state.equals("1")){
					UserForm dept2 = new UserForm();
					dept2.setDeptno("2");
					dept2.setDname("离退");
					dlist2.add(dept2);
					UserForm dept3 = new UserForm();
					dept3.setDeptno("3");
					dept3.setDname("停薪留职");
					dlist2.add(dept3);
				}else if(state.equals("3")){
					UserForm dept2 = new UserForm();
					dept2.setDeptno("1");
					dept2.setDname("在职");
					dlist2.add(dept2);
					UserForm dept3 = new UserForm();
					dept3.setDeptno("2");
					dept3.setDname("离退");
					dlist2.add(dept3);
					UserForm dept4 = new UserForm();
					dept4.setDeptno("4");
					dept4.setDname("挂靠");
					dlist2.add(dept4);
				}else if(state.equals("4")){
					UserForm dept2 = new UserForm();
					dept2.setDeptno("1");
					dept2.setDname("在职");
					dlist2.add(dept2);
					UserForm dept3 = new UserForm();
					dept3.setDeptno("2");
					dept3.setDname("离退");
					dlist2.add(dept3);
					UserForm dept4 = new UserForm();
					dept4.setDeptno("3");
					dept4.setDname("停薪留职");
					dlist2.add(dept4);
				}
				request.setAttribute("state_list",dlist2);
				dlist1.add(dept1);
			}
			request.setAttribute("emp_list",dlist1);
		} catch(Exception e1) {
			e1.printStackTrace();
		} finally {
			if (conn != null) {
				try {
					conn.close();
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		}
		return mapping.findForward("rytz_state_xg");	
	}
	/**
	 * 人员调整----调整状态
	 */
		public ActionForward ry_state(ActionMapping mapping,
									ActionForm form,
									HttpServletRequest request,
									HttpServletResponse response) {
		ArrayList dlist1 = new ArrayList();
		DynaActionForm dyform = (DynaActionForm) form;
		String emp_id = (String) dyform.get("emp_id");  //员工姓名
		String states_id = (String) dyform.get("state");  //部门id号
		
		Connection conn = null; 
		try{
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");	
			conn = ds.getConnection();
			String sql = "UPDATE employees SET states_id=? WHERE emp_id=?";
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.setString(1,states_id);
			pstmt.setString(2,emp_id);
			ResultSet rs = pstmt.executeQuery();
			if(rs.next()){
				request.setAttribute("state_ok","调整成功！");
			}else{
				request.setAttribute("state_ok","调整失败！");
			}
		} catch(Exception e1) {
			e1.printStackTrace();
		}	
		return mapping.findForward("rytz_state_tz");	
	}
}