tiaozheng.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 TiaoZheng extends DispatchAction {
	/**
	 * ----生成部门列表
	 */
	public ActionForward deptlist(ActionMapping mapping,
									ActionForm form,
									HttpServletRequest request,
									HttpServletResponse response) {
		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("rytz_dept");	
	}
	/**
	 * 查找要调整的姓名
	 */
	public ActionForward ry_chazhao(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 dept = (String) dyform.get("dept");  //部门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)){
				if(dept.equals("#")){
					sql = "SELECT * FROM employees,departments WHERE dep_dep_id=dep_id";
				}else{
					int dep_id = Integer.parseInt(dept);
					sql = "SELECT * FROM employees,departments WHERE dep_dep_id=dep_id AND dep_dep_id=" + dep_id;
				}
			}else{
				if(dept.equals("#")){
					sql = "SELECT * FROM employees,departments WHERE dep_dep_id=dep_id AND emp_name LIKE '%" + emp_name + "%'";
				}else{
					int dep_id = Integer.parseInt(dept);
					sql = "SELECT * FROM employees,departments WHERE emp_name LIKE '%" + emp_name + "%' AND dep_dep_id=" + dep_id + " AND dep_dep_id=dep_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("dep_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_dept_update");	
	}
	/**
	 * 查找当前调整姓名的信息
	 */
	public ActionForward ry_tiaozheng_chazhao(ActionMapping mapping,
									ActionForm form,
									HttpServletRequest request,
									HttpServletResponse response) {
		ArrayList dlist1 = 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,departments WHERE dep_dep_id=dep_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("dep_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_dept_list");	
	}
	/**
	 * ----生成调整部门列表
	 */
	public ActionForward tzdeptlist(ActionMapping mapping,
									ActionForm form,
									HttpServletRequest request,
									HttpServletResponse response) {
		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("rytz_dept_xg");	
	}
	
	/**
	 * 人员调整----调整部门
	 */
	public ActionForward ry_tiaozheng(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 dept_id = (String) dyform.get("dept");  //部门id号
		Connection conn = null; 
		try{
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");	
			conn = ds.getConnection();
			String sql = "UPDATE employees SET dep_dep_id=? WHERE emp_id=?";
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.setString(1,dept_id);
			pstmt.setString(2,emp_id);
			ResultSet rs = pstmt.executeQuery();
			if(rs.next()){
				request.setAttribute("dept_tiaozheng_ok","调整成功！");
			}else{
				request.setAttribute("dept_tiaozheng_ok","调整失败！");
			}
		} catch(Exception e1) {
			e1.printStackTrace();
		}	
		return mapping.findForward("rytz_dept_tz");	
	}
}