yuangong.java

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

			Connection conn = ds.getConnection();
			Statement stmt = conn.createStatement();
			String sql = "select * from empsys WHERE emp_id="+emp_id;
			ResultSet rs = stmt.executeQuery(sql);
			
			Statement stmt0 = conn.createStatement();
			Statement stmt1 = conn.createStatement();
			Statement stmt2 = conn.createStatement();
			Statement stmt3 = conn.createStatement();
			Statement stmt4 = conn.createStatement();
			Statement stmt5 = conn.createStatement();
			
			ResultSet rs0 = stmt0.executeQuery("SELECT * FROM nations");
			ResultSet rs1 = stmt1.executeQuery("SELECT * FROM xuelis");
			ResultSet rs2 = stmt2.executeQuery("SELECT * FROM states");
			ResultSet rs3 = stmt3.executeQuery("SELECT * FROM departments");
			ResultSet rs4 = stmt4.executeQuery("SELECT * FROM zhichengs");
			ResultSet rs5 = stmt5.executeQuery("SELECT * FROM zhiwus");
			
			if (rs.next())
			{
				AdForm ad = new AdForm();
				ad.setAa(rs.getString("emp_name"));
				ad.setBb(rs.getString("emp_sex"));
				ad.setCc(rs.getString("emp_birth").substring(0, 10));
				ad.setDd(rs.getString("emp_jianli"));
				ad.setEe(rs.getString("emp_shenfen"));
				ad.setFf(rs.getString("emp_baozhang"));
				ad.setGg(rs.getString("emp_tuizi"));
				ad.setHh(rs.getString("emp_tuishi").substring(0, 10));
				ad.setKk(rs.getString("nation_name"));
				ad.setIi(rs.getString("states_name"));
				ad.setJj(rs.getString("xue_name"));
				ad.setLl(rs.getString("zhiwu_name"));
				ad.setMm(rs.getString("zhicheng_name"));
				ad.setNn(rs.getString("dep_name"));
				
				jlist.add(ad);	
			}
			
			while (rs0.next())
			{
				UserForm uf = new UserForm();
				uf.setDeptno(rs0.getString("nation_name"));
				jlist0.add(uf);
			}
			
			while (rs1.next())
			{
				UserForm uf = new UserForm();
				uf.setDname(rs1.getString("xue_name"));
				jlist1.add(uf);
			}
			System.out.println(jlist1.size());
			while (rs2.next())
			{
				UserForm uf = new UserForm();
				uf.setLoc(rs2.getString("states_name"));
				jlist2.add(uf);
			}
			
			while (rs3.next())
			{
				UserForm uf = new UserForm();
				uf.setDate(rs3.getString("dep_name"));
				jlist3.add(uf);
			}
			
			while (rs4.next())
			{
				AdForm ad = new AdForm();
				ad.setOo(rs4.getString("zhicheng_name"));
				jlist4.add(ad);
			}
			
			while (rs5.next())
			{
				AdForm ad = new AdForm();
				ad.setPp(rs5.getString("zhiwu_name"));
				jlist5.add(ad);
			}
			
			conn.close();			
		}
		catch (Exception e) 
		{
			e.printStackTrace();
		}
		
		request.setAttribute("jlist",jlist);
		request.setAttribute("jlist0",jlist0);
        request.setAttribute("jlist1",jlist1);
        request.setAttribute("jlist2",jlist2);
        request.setAttribute("jlist3",jlist3);
        request.setAttribute("jlist4",jlist4);
        request.setAttribute("jlist5",jlist5);
		
	}
	//公用方法：修改结果存入数据库
	public void xiuGaihF (ActionForm form,HttpServletRequest request)throws Exception
	{	
		UploadForm uploadForm = (UploadForm) form;

		// Process the FormFile
		FormFile myFile = uploadForm.getJianli();
		String contentType = myFile.getContentType();
		String fileName = myFile.getFileName();
		int fileSize = myFile.getFileSize();
		byte[] fileData = myFile.getFileData();
		
		System.out.println("contentType: " + contentType);
		System.out.println("File Name: " + fileName);
		System.out.println("File Size: " + fileSize);

		 //String u =
		 //request.getSession().getServletContext().getRealPath("/");//得到访问资源的硬盘绝对路径

		FileOutputStream out = new FileOutputStream(new File("c:\\" + fileName));
		out.write(fileData);
		out.close();
//-------------------------
		HttpSession session = request.getSession();
		session.setAttribute("contentType", contentType);
		session.setAttribute("fileName", fileName);
		session.setAttribute("fileSize", Integer.valueOf(fileSize));
	
		
		
		
		System.out.print("33333333333333qqqqqqqqq");
		//HttpSession session = request.getSession();
		System.out.print((String)(session.getAttribute("emp_ida")));
		int emp_id = Integer.parseInt((String)(session.getAttribute("emp_ida")));
		String name1 = request.getParameter("name");
		String sex1 =request.getParameter("sex");
		String date1 = request.getParameter("date");
		String nation1 = request.getParameter("nation");
		String xueli1 = request.getParameter("xueli");
		String dept1 = request.getParameter("dept");
		String zhiwu1 = request.getParameter("zhiwu");
		String zhicheng1 = request.getParameter("zhicheng");
		String state1 = request.getParameter("state");
		
		String shenfen1 = request.getParameter("shenfen");
		String shehui1 = request.getParameter("shehui");
		int tuizi = Integer.parseInt(request.getParameter("tuizi"));
		String tuishi1 = request.getParameter("tuishi");
		
		try {
			String name = new String(name1.getBytes("iso-8859-1"),"gbk");
			String sex = new String(sex1.getBytes("iso-8859-1"),"gbk");
			String date = new String(date1.getBytes("iso-8859-1"),"gbk");
			String nation = new String(nation1.getBytes("iso-8859-1"),"gbk");
			String xueli = new String(xueli1.getBytes("iso-8859-1"),"gbk");
			String dept = new String(dept1.getBytes("iso-8859-1"),"gbk");
			String zhiwu = new String(zhiwu1.getBytes("iso-8859-1"),"gbk");
			String zhicheng = new String(zhicheng1.getBytes("iso-8859-1"),"gbk");
			String state = new String(state1.getBytes("iso-8859-1"),"gbk");
			//String jianli = new String(jianli1.getBytes("iso-8859-1"),"gbk");
			String shenfen = new String(shenfen1.getBytes("iso-8859-1"),"gbk");
			String shehui = new String(shehui1.getBytes("iso-8859-1"),"gbk");
			String tuishi = new String(tuishi1.getBytes("iso-8859-1"),"gbk");
			
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
			Connection conn = ds.getConnection();
			Statement stmt = conn.createStatement();
			Statement stmt1 = conn.createStatement();
			Statement stmt2 = conn.createStatement();
			Statement stmt3 = conn.createStatement();
			Statement stmt4 = conn.createStatement();
			Statement stmt5 = conn.createStatement();
			
			String sql = "SELECT xue_id FROM xuelis WHERE xue_name='"+xueli+"'";
			String sql1 = "SELECT dep_id FROM departments WHERE dep_name='"+dept+"'";
			String sql2 = "SELECT states_id FROM states WHERE states_name='"+state+"'";
			String sql3 = "SELECT nation_id FROM nations WHERE nation_name='"+nation+"'";
			String sql4 = "SELECT zhicheng_id FROM zhichengs WHERE zhicheng_name='"+zhicheng+"'";
			String sql5 = "SELECT zhiwu_id FROM zhiwus WHERE zhiwu_name='"+zhiwu+"'";
			
			ResultSet rs = stmt.executeQuery(sql);
			ResultSet rs1 = stmt1.executeQuery(sql1);
			ResultSet rs2 = stmt2.executeQuery(sql2);
			ResultSet rs3 = stmt3.executeQuery(sql3);
			ResultSet rs4 = stmt4.executeQuery(sql4);
			ResultSet rs5= stmt5.executeQuery(sql5);
			
			rs.next();
			rs1.next();
			rs2.next();
			rs3.next();
			rs4.next();
			rs5.next();
		
			int xue_id = rs.getInt("xue_id");
			int dep_id = rs1.getInt("dep_id");
			int states_id = rs2.getInt("states_id");
			int nation_id = rs3.getInt("nation_id");
			int zhicheng_id = rs4.getInt("zhicheng_id");
			int zhiwu_id = rs5.getInt("zhiwu_id");
			
			Statement stmt6 = conn.createStatement();
			String sql6 = "UPDATE employees SET xue_xue_id="+xue_id+",dep_dep_id="+dep_id
				+",states_id="+states_id+",nat_nation_id="+nation_id+",emp_name='"+name
				+"',emp_sex='"+sex+"',emp_birth=to_date('"+date+"','yyyy-mm-dd'),emp_jianli='c:\\" + fileName
				+"',emp_shenfen='"+shenfen+"',emp_baozhang='"+shehui+"',emp_tuizi="+tuizi+",emp_tuishi=to_date('"+tuishi+"','yyyy-mm-dd')WHERE emp_id="+emp_id;
			int rs6= stmt6.executeUpdate(sql6);
			
			
			Statement stmt7 = conn.createStatement();
			String sql7 = "UPDATE emp_zhich SET zhicheng_id="+zhicheng_id+"WHERE emp_id="+emp_id;
			int rs7 = stmt7.executeUpdate(sql7);
			
			Statement stmt8 = conn.createStatement();
			String sql8 = "UPDATE emp_zhiwu SET zhiwu_id="+zhiwu_id+"WHERE emp_id="+emp_id;
			int rs8 = stmt8.executeUpdate(sql8);
			
			conn.close();
		}
		catch (Exception e) {
			
			e.printStackTrace();
		}
	}
	
	//模糊信息修改前显示多条模糊信息到/query/chakan.jsp上
	public ActionForward moHuXiuX (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{								
		moHuCha(request);
		return mapping.findForward("cha");
	}
	//模糊信息修改前将单条信息从数据库中查出 显示在/manage/xiugai.jsp上
	public ActionForward xiuGai (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		xiuGaiF(request);
		return mapping.findForward("xiu");
	}
	//将模糊信息修改结果存入数据库表中
	public ActionForward xiuGaih (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response) throws Exception
	{	
		xiuGaihF(form,request);
		return mapping.findForward("yx");
	}
	//模糊修改成功后执行的方法：显示修改前所有模糊信息记录，以便修改其他信息
	public ActionForward yuangChaS (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		yuanD(request);		
		return mapping.findForward("cha");
		
	}
	
	
	//全部信息修改前进行数据库查询显示多条记录
	public ActionForward chaKanX (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		yuangCha(request);
		return mapping.findForward("cha1");
	}	
	//全部信息修改前将单条记录从数据库查出  
	public ActionForward xiuGai1 (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		xiuGaiF(request);
		return mapping.findForward("xiu1");
	}	
	//将全部信息修改一条记录结果存入数据库
	public ActionForward xiuGaih1 (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response) throws Exception
	{	
		xiuGaihF(form,request);
		return mapping.findForward("quan");
	}	
	//全部信息中修改一条后执行：显示全部记录，以便修改其他信息
	public ActionForward yuangCha1 (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		quanD(request);		
		return mapping.findForward("cha1");
	}
	
//以下为实现删除
	//全部信息中执行删除前显示多条记录
	public ActionForward chaKan (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		yuangCha(request);		
		return mapping.findForward("shan");
	}	
	//公用的方法：执行删除
	public void shanF (HttpServletRequest request) {
		
		int emp_id = Integer.parseInt(request.getParameter("emp_idss"));
		try {
			
			DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
			Connection conn = ds.getConnection();
			Statement stmt = conn.createStatement();
			Statement stmt1 = conn.createStatement();
			Statement stmt2 = conn.createStatement();	
			
			String sql1 = "DELETE emp_zhich WHERE emp_id="+emp_id;
			String sql2 = "DELETE emp_zhiwu WHERE emp_id="+emp_id;
			String sql = "DELETE employees WHERE emp_id="+emp_id;
			
			ResultSet rs1 = stmt1.executeQuery(sql1);
			ResultSet rs2 = stmt2.executeQuery(sql2);
			ResultSet rs = stmt.executeQuery(sql);
			
			rs.next();
			rs1.next();
			rs2.next();

			conn.close();
		}
		catch (Exception e) {
			
			e.printStackTrace();
		}
	}
	//全部信息中删除一条记录
	public ActionForward shanChu (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		shanF(request);		
		return mapping.findForward("yg");
	}
	//全部信息中删除一条信息后执行，显示全部信息，以便继续删除别的记录
	public ActionForward yuangChaX (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		quanD(request);
		return mapping.findForward("shan");
	}	
	
	//模糊删除信息前显示多条模糊记录
	public ActionForward moHuXiu (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{								
		moHuCha(request);
		return mapping.findForward("shan1");
	}	
	//模糊删除一条记录
	public ActionForward shanChuS (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		shanF(request);
		return mapping.findForward("mo");
	}
	//模糊信息删除后执行，显示模糊信息，以便继续删除模糊信息
	public ActionForward moHuXiuS (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)
	{	
		yuanD(request);
		return mapping.findForward("shan1");
	}
	
//打开简历
	public ActionForward openJl (ActionMapping mapping, ActionForm form, 
			HttpServletRequest request, HttpServletResponse response)throws Exception
	{
		OpenFileAction ofa = new OpenFileAction();
		ofa.getStreamInfo(mapping, form, request, response);
		return mapping.findForward("add");
	}
	
	
}