dealjob.java

个人办公平台,用JAVA开发的TOMCAT的服务器

					e.printStackTrace();
					} catch (IOException e) {
						
					e.printStackTrace();
					}
					
					

					//Djmethod dmt=new Djmethod();
					//dmt.getEmplyee();
					
				}
				else {
					try {
								res.sendRedirect("error.html");
								} catch (IOException e) {
									
									
						        e.printStackTrace();
								}
					
				}
	   	    }else if(method.equals("saveself")){
	   	    	 String mat=(String)session.getAttribute("mat");
	   	    	 System.out.println(session.getAttribute("id"));
	   	    	 String time=(String)req.getParameter("starttime");
	   	    	 String savepro=req.getParameter("saveproject");
	   	    	 Djmethod dmt=new Djmethod();
	   	    	 int m=dmt.addAgentList("update o_project set protime=to_date('"+time+"','yyyy-mm-dd'),promatter='"+savepro+"' where promatter='"+mat+"'");
	   	    	 if(m>0){
	   	    	 	try {
						req.getRequestDispatcher("/success1.jsp").forward(req,res);
					} catch (ServletException e) {
						
						e.printStackTrace();
					} catch (IOException e) {
					
						e.printStackTrace();
					}
	   	    	 }else{
	   	    	 	   try {
						res.sendRedirect("/error.html");
					} catch (IOException e) {
						
						e.printStackTrace();
					}
	   	    	 }
	   	    	 
	   	    } 
	   	    //系统管理模块
	   	    if(method.equals("depart")){
	   	    	
				System.out.println("admin depart");
				
				String jdepid=req.getParameter("jdepid");
	   	    	String depid=req.getParameter("depid");
	   	    	String depname=req.getParameter("depname");
	   	    	System.out.println("部门编号："+depid);
	   	    	System.out.println("部门名称:"+depname);
	   	    	Djmethod dmt=new Djmethod();
	   	    	String strSQL="select depid,depname from o_department where depid='"+depid+"' or depname='"+depname+"'";
	   	    	System.out.println(strSQL);

	   	    	boolean m=dmt.getDepid(strSQL);
	   	    	System.out.println("是否有此部门"+m);
	   	    	if(m){
	   	    	
				String strInsert="insert into O_DEPARTMENT values('"+depid+"','"+jdepid+"','"+depname+"')";
				int n=dmt.addAgentList(strInsert);
	   	    	if(n>0){
	   	    		System.out.println("添加部门成功");
	   	    		try {
						req.getRequestDispatcher("/depsuccess.jsp").forward(req,res);
					} catch (ServletException e) {
						
						e.printStackTrace();
					} catch (IOException e) {
						
						e.printStackTrace();
					}
	   	    	}else{
					System.out.println("添加部门失败");
	   	    		try {
						res.sendRedirect("/skyhawk/admin/error.jsp");
					} catch (IOException e) {
						
						e.printStackTrace();
					}
	   	    	}
	   	    	}else{
	   	    		try {
						res.sendRedirect("/skyhawk/admin/error.jsp");
					} catch (IOException e) {
					
						e.printStackTrace();
					}
	   	    	}
	   	   
	   	    }else if(method.equals("updep")){
	   	    	
	   	    	System.out.println("in the updep");
	   	    	List list1=new ArrayList();
	   	    	String seldep=req.getParameter("seldep");
	            String strSQL="select * from o_department where depid='"+seldep+"'";
	            Djmethod djm=new Djmethod();
	            list1=djm.getDepart(strSQL);
	   	    	session.setAttribute("list1",list1);
	   	    	try {
					res.sendRedirect("/skyhawk/admin/alertdep.jsp");
				} catch (IOException e) {
					
					e.printStackTrace();
				}
	   	    	
	   	    	
	   	    }else if(method.equals("addemp")){
	   	    	
	   	    	//添加角色
				Djmethod dmt1=new Djmethod();
	   	    	String empid=req.getParameter("empid");
	   	    	int empid1=Integer.parseInt(empid);
	   	    		   	    	
				String empname=req.getParameter("empname");
				String pasw=req.getParameter("pasw");
				String sex=req.getParameter("sex");
				int nsex;
				if(sex.equals("男")){
					nsex=0;
				}else{
					nsex=1;
				}
				System.out.println("性别："+nsex);
				String position=req.getParameter("position");
				String blo=req.getParameter("blood");
				int nblo=0;
				if(blo.equals("A")){
					nblo=1;
				}else if(blo.equals("B")){
					nblo=2;
				}else if(blo.equals("O")){
					nblo=3;
				}else if(blo.equals("AB")){
					nblo=4;
				}
				System.out.println("血形："+nblo);
				String top=req.getParameter("top");
				int top1=Integer.parseInt(top);
				String weight=req.getParameter("weight");
				int weight1=Integer.parseInt(weight);
				String dep=req.getParameter("depart");
				System.out.println("部门："+dep);
				String tel=req.getParameter("tel");
				int tel1=Integer.parseInt(tel);
				String self=req.getParameter("self");
				String love=req.getParameter("love");
				System.out.println("血形：");
				String pur=req.getParameter("purview");
				int npur;
				if(pur.equals("管理员")){
					npur=1;
				}else if(pur.equals("部门经理")){
					npur=2;
				}else{
					npur=0;
				}
				int dir = 1;
				for(int i=1;i<1000;i++){
					dir=i;
				}
				System.out.println("权限："+npur);
				String share=req.getParameter("share");
				int nshare;
				if(share.equals("是")){
					nshare=0;
				}else{
					nshare=1;
				}
				String strSQL1="select empid from o_myinfo1 where empid='"+empid1+"'";
				boolean m=dmt1.getDepid(strSQL1);
				if(m){
				String strInsert="insert into o_myinfo1 values('"+empid1+"','"+pasw+"','"+nsex+"','"+position+"','"+nblo+"','"+top1+"','"+weight1+"','"+empname+"','"+dep+"','"+tel1+"','"+self+"','"+love+"','"+nshare+"')";
				String strInsert1="insert into o_employee values('"+empid1+"','"+dep+"','"+dir+"','"+empname+"','0','"+npur+"')";
				
				int np=dmt1.addAgentList(strInsert);
				int np1=dmt1.addAgentList(strInsert1);
				if(np==1 && np1==1){
					try {
						req.getRequestDispatcher("/successemp.jsp").forward(req,res);
					} catch (ServletException e) {
						
						e.printStackTrace();
					} catch (IOException e) {
						
						e.printStackTrace();
					}
				}
	   	    }else{
	   	    		try {
						res.sendRedirect("/skyhawk/admin/error.jsp");
					} catch (IOException e) {
						
					e.printStackTrace();
					}
	   	    	}
	   	  
	


	   }else if(method.equals("modydep")){
	   	
	   	           String jid=req.getParameter("seldep");
	   	           String id=req.getParameter("depid");
	   	           String depname=req.getParameter( "depname");
	   	           String depid=(String)session.getAttribute("depid");
				   Djmethod dmt=new Djmethod();
				   int m=dmt.addAgentList("update o_department set depid='"+id+"',JUNIORID='"+jid+"',depname='"+depname+"' where depid='"+depid+"'");
				   if(m>0){
							   try {
								   req.getRequestDispatcher("/successmody.jsp").forward(req,res);
							   } catch (ServletException e) {
						
								   e.printStackTrace();
							   } catch (IOException e) {
					
								   e.printStackTrace();
							   }
							}else{
								  try {
								   res.sendRedirect("/error.html");
							   } catch (IOException e) {
						
								   e.printStackTrace();
							   }
							}
	   	          
	   	
	   	    		
			 }
	   }

	public static void main(String[] args) {
	
	}
}