yuangong.java

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

			int Page = 1;
			if (page == null || page.equals("")) {
				Page = 1;
			} else {
				Page = Integer.parseInt(page);
			}
			if (Page <= 0) {
				Page = 1;
			}
			if (Page > totalPage) {
				Page = totalPage;
			}
		
		
			request.setAttribute("Page",Page+"");
			String queryPageSQL = "SELECT * FROM (SELECT row_.*,rownum rownum_  FROM "
					+ "(SELECT * FROM empsys WHERE states_id="+id+" AND dep_name='"+dep_name+"' AND emp_name LIKE '%"+mohuname+"%' ORDER BY emp_id) row_ WHERE rownum<=?) WHERE rownum_>?";
	
			int start = (Page - 1) * pageSize;
			int end = Page * pageSize;
			
			if (end > totalRecord)
				end = totalRecord;
	
			
			ResultSet rs1 = null;
			
			PreparedStatement pstmt = conn.prepareStatement(queryPageSQL);
			pstmt.setInt(1, end);
			pstmt.setInt(2, start);
			rs1 = pstmt.executeQuery();
			while (rs1.next())
			{
				AdForm ad = new AdForm();
				ad.setAa(rs1.getString("emp_name"));
				ad.setBb(rs1.getString("emp_sex"));
				ad.setCc(rs1.getString("emp_birth").substring(0, 10));
				ad.setDd(rs1.getString("emp_jianli"));
				ad.setEe(rs1.getString("emp_shenfen"));
				ad.setFf(rs1.getString("emp_baozhang"));
				ad.setGg(rs1.getString("emp_tuizi"));
				ad.setHh(rs1.getString("emp_tuishi").substring(0, 10));
				ad.setIi(rs1.getString("xue_name"));
				ad.setJj(rs1.getString("dep_name"));
				ad.setKk(rs1.getString("nation_name"));
				ad.setLl(rs1.getString("zhicheng_name"));
				ad.setMm(rs1.getString("zhiwu_name"));
				ad.setNn(rs1.getInt("emp_id")+"");
				request.setAttribute("name", rs1.getString("states_name"));
				
				jlist.add(ad);				
			}
		conn.close();	
		} catch (Exception e) {
			e.printStackTrace();
		} 
			
	    request.setAttribute("jlist",jlist);
	}
	
	//公用的方法：执行修改或删除后，查询全部信息（某一状态下）
	public void quanD (HttpServletRequest request) {
		
		HttpSession session = request.getSession();
		ArrayList jlist = new ArrayList();
		int id = Integer.parseInt((String)session.getAttribute("sid"));
		
		String dep_name = (String)session.getAttribute("sname");
		try {
			//String dep_name = new String(dep_name1.getBytes("iso-8859-1"),"gbk");
			
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
			Connection conn = ds.getConnection();
			Statement stmt = conn.createStatement();
			
			String sql = "select count(*) as rowcounts from empsys WHERE states_id="+id+" AND dep_name='"+dep_name+"'";
			ResultSet rs = stmt.executeQuery(sql);
			rs.next();
			int totalRecord = rs.getInt(1);			
			
			//request.setAttribute("totalRecord",totalRecord);
			
			int pageSize = 3;
			int totalPage = 1;
			int tmpPage = 0;
			
			tmpPage = totalRecord % pageSize;
			if (tmpPage == 0) {
				totalPage = totalRecord / pageSize;
			} else {
				totalPage = (int) (Math.floor(totalRecord / pageSize) + 1);
			}
			if (totalPage == 0) {
				totalPage = 1;
			}
			
			request.setAttribute("totalPage",totalPage+"");
			
			
			String page = request.getParameter("Page");
			
			int Page = 1;
			if (page == null || page.equals("")) {
				Page = 1;
			} else {
				Page = Integer.parseInt(page);
			}
			if (Page <= 0) {
				Page = 1;
			}
			if (Page > totalPage) {
				Page = totalPage;
			}
		
		
			request.setAttribute("Page",Page+"");
			String queryPageSQL = "SELECT * FROM (SELECT row_.*,rownum rownum_  FROM "
					+ "(SELECT * FROM empsys WHERE states_id="+id+" AND dep_name='"+dep_name+"' ORDER BY emp_id) row_ WHERE rownum<=?) WHERE rownum_>?";
	
			int start = (Page - 1) * pageSize;
			int end = Page * pageSize;
			
			if (end > totalRecord)
				end = totalRecord;
	
			
			ResultSet rs1 = null;
			
			PreparedStatement pstmt = conn.prepareStatement(queryPageSQL);
			pstmt.setInt(1, end);
			pstmt.setInt(2, start);
			rs1 = pstmt.executeQuery();
			while (rs1.next())
			{
				AdForm ad = new AdForm();
				ad.setAa(rs1.getString("emp_name"));
				ad.setBb(rs1.getString("emp_sex"));
				ad.setCc(rs1.getString("emp_birth").substring(0, 10));
				ad.setDd(rs1.getString("emp_jianli"));
				ad.setEe(rs1.getString("emp_shenfen"));
				ad.setFf(rs1.getString("emp_baozhang"));
				ad.setGg(rs1.getString("emp_tuizi"));
				ad.setHh(rs1.getString("emp_tuishi").substring(0, 10));
				ad.setIi(rs1.getString("xue_name"));
				ad.setJj(rs1.getString("dep_name"));
				ad.setKk(rs1.getString("nation_name"));
				ad.setLl(rs1.getString("zhicheng_name"));
				ad.setMm(rs1.getString("zhiwu_name"));
				ad.setNn(rs1.getInt("emp_id")+"");
				request.setAttribute("name", rs1.getString("states_name"));
				
				jlist.add(ad);				
			}
		conn.close();	
		} catch (Exception e) {
			e.printStackTrace();
		} 
			
	    request.setAttribute("jlist",jlist);
				
	}	
	
	//公用的方法：执行修改或删除后，查询模糊信息（某一状态下）
	public void yuanD (HttpServletRequest request) {
		HttpSession session = request.getSession();
		ArrayList jlist = new ArrayList();
		int id = Integer.parseInt((String)session.getAttribute("sid"));
		String mohuname = (String)session.getAttribute("mname");
		
		String dep_name = (String)session.getAttribute("sname");
		try {
			//String dep_name = new String(dep_name1.getBytes("iso-8859-1"),"gbk");
			//String mohuname = new String(mohunames.getBytes("iso-8859-1"),"gbk");
			
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
			Connection conn = ds.getConnection();
			Statement stmt = conn.createStatement();
			
			String sql = "select count(*) as rowcounts from empsys WHERE states_id="+id+" AND dep_name='"+dep_name+"' AND emp_name LIKE '%"+mohuname+"%'";
			ResultSet rs = stmt.executeQuery(sql);
			rs.next();
			int totalRecord = rs.getInt(1);			
			
			//request.setAttribute("totalRecord",totalRecord);
			
			int pageSize = 3;
			int totalPage = 1;
			int tmpPage = 0;
			
			tmpPage = totalRecord % pageSize;
			if (tmpPage == 0) {
				totalPage = totalRecord / pageSize;
			} else {
				totalPage = (int) (Math.floor(totalRecord / pageSize) + 1);
			}
			if (totalPage == 0) {
				totalPage = 1;
			}
			
			request.setAttribute("totalPage",totalPage+"");
			
			
			String page = request.getParameter("Page");
			
			int Page = 1;
			if (page == null || page.equals("")) {
				Page = 1;
			} else {
				Page = Integer.parseInt(page);
			}
			if (Page <= 0) {
				Page = 1;
			}
			if (Page > totalPage) {
				Page = totalPage;
			}
		
		
			request.setAttribute("Page",Page+"");
			String queryPageSQL = "SELECT * FROM (SELECT row_.*,rownum rownum_  FROM "
					+ "(SELECT * FROM empsys WHERE states_id="+id+" AND dep_name='"+dep_name+"' AND emp_name LIKE '%"+mohuname+"%' ORDER BY emp_id) row_ WHERE rownum<=?) WHERE rownum_>?";
	
			int start = (Page - 1) * pageSize;
			int end = Page * pageSize;
			
			if (end > totalRecord)
				end = totalRecord;
	
			
			ResultSet rs1 = null;
			
			PreparedStatement pstmt = conn.prepareStatement(queryPageSQL);
			pstmt.setInt(1, end);
			pstmt.setInt(2, start);
			rs1 = pstmt.executeQuery();
			while (rs1.next())
			{
				AdForm ad = new AdForm();
				ad.setAa(rs1.getString("emp_name"));
				ad.setBb(rs1.getString("emp_sex"));
				ad.setCc(rs1.getString("emp_birth").substring(0, 10));
				ad.setDd(rs1.getString("emp_jianli"));
				ad.setEe(rs1.getString("emp_shenfen"));
				ad.setFf(rs1.getString("emp_baozhang"));
				ad.setGg(rs1.getString("emp_tuizi"));
				ad.setHh(rs1.getString("emp_tuishi").substring(0, 10));
				ad.setIi(rs1.getString("xue_name"));
				ad.setJj(rs1.getString("dep_name"));
				ad.setKk(rs1.getString("nation_name"));
				ad.setLl(rs1.getString("zhicheng_name"));
				ad.setMm(rs1.getString("zhiwu_name"));
				ad.setNn(rs1.getInt("emp_id")+"");
				request.setAttribute("name", rs1.getString("states_name"));
				
				jlist.add(ad);				
			}
		conn.close();	
		} catch (Exception e) {
			e.printStackTrace();
		} 
			
	    request.setAttribute("jlist",jlist);
	}	

//按部门执行操作	
	//公用方法：查询部门显示在网页/query/buchaxun.jsp上
	public void buC (HttpServletRequest request)
	{	
				ArrayList jlist = new ArrayList();
		try {
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
			Connection conn = ds.getConnection();
			Statement stmt = conn.createStatement();
			String sql = "select * from departments";
			ResultSet rs = stmt.executeQuery(sql);
					
		while (rs.next())
		{
			AdForm ad = new AdForm();
			ad.setAa(rs.getString("dep_name"));
			jlist.add(ad);				
		}
		
		System.out.print(jlist.size());
		conn.close();			
		}
		catch (Exception e) 
		{
			e.printStackTrace();
		}
		request.setAttribute("jlist", jlist);
	}
	//在职查看信息时
	public ActionForward buCha (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		buC(request);
		return mapping.findForward("buch");
	}
	//在职修改信息时
	public ActionForward buXiu (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		buC(request);
		return mapping.findForward("buxiu");
	}
	//在职删除信息时
	public ActionForward buShan (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		buC(request);
		return mapping.findForward("bushan");
	}
	
	//离退查看信息时
	public ActionForward buCha1 (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		buC(request);
		return mapping.findForward("buch1");
	}
	//离退删除信息时
	public ActionForward buShan1 (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		buC(request);
		return mapping.findForward("bushan1");
	}
	
	//停薪查看信息时
	public ActionForward buCha2 (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		buC(request);
		return mapping.findForward("buch2");
	}
	//停薪删除信息时
	public ActionForward buShan2 (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		buC(request);
		return mapping.findForward("bushan2");
	}
	
	//挂靠查看信息时
	public ActionForward buCha3 (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		buC(request);
		return mapping.findForward("buch3");
	}
	//挂靠删除信息时
	public ActionForward buShan3 (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		buC(request);
		return mapping.findForward("bushan3");
	}
	
	
//以下为实现员工信息查看
	//员工信息模糊查询并显示在网页（/query/chakanxx.jsp）上
	public ActionForward moHu (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{								
		
		moHuCha(request);
		return mapping.findForward("xinxi");
		
	}
	//在职员工信息全部查看并显示在（/query/chakanxx.jsp）上
	public ActionForward xinXiCha (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		yuangCha(request);
	
		return mapping.findForward("xinxi");
		
	}	
	
//以下为实现修改
	//公用的方法：修改前显示单条详细记录
	public void xiuGaiF (HttpServletRequest request)
	{	
		int emp_id = Integer.parseInt(request.getParameter("emp_ids"));
		HttpSession session = request.getSession();
		session.setAttribute("emp_ida", emp_id+"");
		
				ArrayList jlist = new ArrayList();
				ArrayList jlist0 = new ArrayList();
				ArrayList jlist1 = new ArrayList();
				ArrayList jlist2 = new ArrayList();
				ArrayList jlist3 = new ArrayList();
				ArrayList jlist4 = new ArrayList();
				ArrayList jlist5 = new ArrayList();
					
		try {			
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");