offlogbean.java

本程序利用java和jsp实现电子政务中涉及到的办公日志系统。利用javabean和jsp的使用技巧和中间软件weblogic8.1.

	public boolean workDel(HttpServletRequest req, HttpServletResponse resp)
	{
		HttpSession httpsession = req.getSession();
		String username=(String)httpsession.getAttribute("username");
		        
		boolean islogin=isLogin(req,resp);
		if(!islogin)
		     return islogin;
		
		String jobid=req.getParameter("jobid");
		String sql="delete from job where jobid="+jobid;
        System.out.println("update sql is: "+sql);
        
        DbADO dbAdo=new DbADO();
        dbAdo.connect();
        dbAdo.update_insert(sql);
        dbAdo.close();
        String result="删除工作日志成功!";
        req.setAttribute("result",result);
               
		return islogin;
	}
	
	public boolean deptList(HttpServletRequest req, HttpServletResponse resp)
	{
		boolean isadmin=isAdmin(req,resp);
		if(!isadmin)
		     return isadmin;
		
		String partid="";
		String sql1="select * from part";   
		String sql2="";  
		ResultSet rs2=null; 
		
		Vector deptList=new Vector();   
		Vector userList=new Vector();
		
	    DbADO dbAdo=new DbADO();
        dbAdo.connect();
    
        ResultSet rs1=dbAdo.select(sql1);
       
       try{
           
            while(rs1.next())
           {
           	     userList=null;
           	     userList=new Vector();
           	     partid=rs1.getString("partid");
           	     System.out.println("partid="+partid);
           	     userList.addElement(partid);
           	     userList.addElement(rs1.getString("partname"));
           	     
           	     sql2="select * from users where partid="+partid;
           	     rs2=dbAdo.select(sql2);
           	     
           	     while(rs2.next())
           	     {
           	     	userList.addElement(rs2.getString("id"));
           	     	userList.addElement(rs2.getString("username"));
           	     	userList.addElement(rs2.getString("truename"));
           	     	System.out.println("truename="+rs2.getString("truename"));
           	     }
           	     deptList.addElement(userList);
    	      
    	   }
           
       }
       catch(Exception e){
             e.printStackTrace();
       }
       finally{
           dbAdo.close();
       }   
	
	   if(deptList!=null)
             req.setAttribute("deptList",deptList);
             
       return isadmin;
	}
	
	public boolean deptSave(HttpServletRequest req, HttpServletResponse resp,String partname)
	{
		boolean isadmin=isAdmin(req,resp);
		if(!isadmin)
		     return isadmin;
		     
		System.out.println("partname is: "+partname);
						
		String sql="insert into part (partname) values ('"+partname+"')";
       
        DbADO dbAdo=new DbADO();
        dbAdo.connect();
        dbAdo.update_insert(sql);
        dbAdo.close();
        String result="添加部门成功!";
        req.setAttribute("result",result);
       	return isadmin;
	}
	
	public boolean deptDel(HttpServletRequest req, HttpServletResponse resp)
	{
		boolean isadmin=isAdmin(req,resp);
		if(!isadmin)
		     return isadmin;
		
		String partid=req.getParameter("partid");
		String sql="delete from part where partid="+partid;
        System.out.println("update sql is: "+sql);
        
        DbADO dbAdo=new DbADO();
        dbAdo.connect();
        dbAdo.update_insert(sql);
        dbAdo.close();
        String result="删除部门成功!";
        req.setAttribute("result",result);
       
		return isadmin;
	}
	
	public boolean deptEdit(HttpServletRequest req, HttpServletResponse resp)
	{
		   boolean isadmin=isAdmin(req,resp);
		   if(!isadmin)
		     return isadmin;
		   
		   String partid=req.getParameter("partid");
		   Vector viewContent=new Vector();
		   
		   String  sql="select * from part where partid="+partid;
		   		   
           DbADO dbAdo=new DbADO();
           dbAdo.connect(); 
           ResultSet rs=dbAdo.select(sql);
           try
           {
           
              while(rs.next())
              {
           	     viewContent.addElement(rs.getString("partid"));
           	     viewContent.addElement(rs.getString("partname"));
    	      }
          
            }
            catch(Exception e)
            {
                 e.printStackTrace();
             }
             finally
            {
        	dbAdo.close();
            }   
			
			if(viewContent!=null)
              req.setAttribute("viewContent",viewContent);
              
		   	  
		return isadmin;
           
	}
	
	public boolean deptUpdate(HttpServletRequest req, HttpServletResponse resp,String partname)
	{
		boolean isadmin=isAdmin(req,resp);
		if(!isadmin)
		     return isadmin;
		
		String partid=req.getParameter("partid");
				
		String sql="update part set partname='"+partname+"' where partid="+partid;
        System.out.println("update sql is: "+sql);
        
        DbADO dbAdo=new DbADO();
        dbAdo.connect();
        dbAdo.update_insert(sql);
        dbAdo.close();
        String result="编辑部门成功!";
        req.setAttribute("result",result);
     
		return isadmin;
	}
	
	public boolean userNew(HttpServletRequest req, HttpServletResponse resp)
	{
		   boolean isadmin=isAdmin(req,resp);
		   if(!isadmin)
		     return isadmin;
		    
		   String partid=req.getParameter("partid");
		   String partname="";
		   String  sql="select * from part where partid="+partid;
		   		   
           DbADO dbAdo=new DbADO();
           dbAdo.connect(); 
           ResultSet rs=dbAdo.select(sql);
           try
           {
           
              while(rs.next())
              {
           	     partname=rs.getString("partname");
    	      }
          
            }
            catch(Exception e)
            {
                 e.printStackTrace();
             }
             finally
            {
        	dbAdo.close();
            }   
			
			req.setAttribute("partid",partid);
			req.setAttribute("partname",partname);
              
		   		  
		return isadmin;
           
	}
	
	public boolean userSave(HttpServletRequest req, HttpServletResponse resp,String truename,String username)
	{
		boolean isadmin=isAdmin(req,resp);
		if(!isadmin)
		     return isadmin;
		     
		System.out.println("username is: "+username);
	    
	    String password=req.getParameter("password").trim();	
	    String userflag=req.getParameter("flag");
	    String partid=req.getParameter("partid");				
		String sql="insert into users (username,password,truename,flag,partid) values ('"+username+"',";
		sql=sql+"'"+password+"','"+truename+"',"+userflag+","+partid+")";
       
        DbADO dbAdo=new DbADO();
        dbAdo.connect();
        dbAdo.update_insert(sql);
        dbAdo.close();
        String result="添加用户成功!";
        req.setAttribute("result",result);
       
       	return isadmin;
	}
	
	public boolean userEdit(HttpServletRequest req, HttpServletResponse resp)
	{
		   boolean isadmin=isAdmin(req,resp);
		   if(!isadmin)
		     return isadmin;
		  
		   String id=req.getParameter("id");
		   Vector viewContent=new Vector();
		   
		   String  sql="select * from users where id="+id;
		   		   
           DbADO dbAdo=new DbADO();
           dbAdo.connect(); 
           ResultSet rs=dbAdo.select(sql);
           try
           {
           
              while(rs.next())
              {
           	     viewContent.addElement(rs.getString("id"));
           	     viewContent.addElement(rs.getString("username"));
           	     viewContent.addElement(rs.getString("password"));
           	     viewContent.addElement(rs.getString("truename"));
           	     viewContent.addElement(rs.getString("flag"));
    	      }
          
            }
            catch(Exception e)
            {
                 e.printStackTrace();
             }
             finally
            {
        	dbAdo.close();
            }   
			
			if(viewContent!=null)
              req.setAttribute("viewContent",viewContent);
      	   	  
		return isadmin;
           
	}
	
	public boolean userUpdate(HttpServletRequest req, HttpServletResponse resp,String truename,String username)
	{
		boolean isadmin=isAdmin(req,resp);
		if(!isadmin)
		     return isadmin;
				
		String id=req.getParameter("id");
		String password=req.getParameter("password").trim();
		String flag=req.getParameter("flag");
				
		String sql="update users set username='"+username+"',password='"+password+"',truename='"+truename+"'";
		sql=sql+",flag="+flag+" where id="+id;
        System.out.println("update sql is: "+sql);
        
        DbADO dbAdo=new DbADO();
        dbAdo.connect();
        dbAdo.update_insert(sql);
        dbAdo.close();
        String result="编辑用户信息成功!";
        req.setAttribute("result",result);
        
        return isadmin;
	}
	
	public boolean userDel(HttpServletRequest req, HttpServletResponse resp)
	{
		boolean isadmin=isAdmin(req,resp);
		if(!isadmin)
		     return isadmin;
				
		String id=req.getParameter("id");
		String sql="delete from users where id="+id;
        System.out.println("update sql is: "+sql);
        
        DbADO dbAdo=new DbADO();
        dbAdo.connect();
        dbAdo.update_insert(sql);
        dbAdo.close();
        String result="删除员工信息成功!";
        req.setAttribute("result",result);
               
		return isadmin;
	}
	
	public boolean passEdit(HttpServletRequest req, HttpServletResponse resp)
	{
		   HttpSession httpsession = req.getSession();
		   String username=(String)httpsession.getAttribute("username");
		        
		   boolean islogin=isLogin(req,resp); 
		   if(!islogin)
		     return islogin;
		  
		   Vector viewContent=new Vector();
		   
		   String  sql="select * from users where username='"+username+"'";
		   		   
           DbADO dbAdo=new DbADO();
           dbAdo.connect(); 
           ResultSet rs=dbAdo.select(sql);
           try
           {
           
              while(rs.next())
              {
           	     viewContent.addElement(rs.getString("id"));
           	     viewContent.addElement(rs.getString("username"));
           	     viewContent.addElement(rs.getString("password"));
           	  }
           }  
            catch(Exception e)
            {
                 e.printStackTrace();
             }
             finally
            {
        	dbAdo.close();
            }   
			
			if(viewContent!=null)
              req.setAttribute("viewContent",viewContent);
              
		   	  
		return islogin;
           
	}
	
	public boolean passUpdate(HttpServletRequest req, HttpServletResponse resp)
	{
		HttpSession httpsession = req.getSession();
		String username=(String)httpsession.getAttribute("username");
		
		boolean islogin=isLogin(req,resp); 
		if(!islogin)
		     return islogin;              
		
		String password=req.getParameter("newpin").trim();
		String sql="update users set password='"+password+"' where username='"+username+"'";
        System.out.println("update sql is: "+sql);
        
        DbADO dbAdo=new DbADO();
        dbAdo.connect();
        dbAdo.update_insert(sql);
        dbAdo.close();
        String result="修改密码成功!";
        req.setAttribute("result",result);
       
		return islogin;
	}
	
	public boolean logOut(HttpServletRequest req, HttpServletResponse resp)
	{
		HttpSession httpsession = req.getSession();
		httpsession.setAttribute("truename",null);
        httpsession.setAttribute("flag",null);
        httpsession.setAttribute("username",null);
		
		return true;
	}
		
	public boolean isAdmin(HttpServletRequest req, HttpServletResponse resp)
	{
	    boolean isadmin=true;
	    
	    HttpSession httpsession = req.getSession();
		String username=(String)httpsession.getAttribute("username");
		Integer Flag=null;
        Flag=(Integer)httpsession.getAttribute("flag");
        int flag=Flag.intValue();
               
		if(username==null||flag>2)
		        isadmin=false;
		        
		return isadmin;        
	}	
	
	public boolean isLogin(HttpServletRequest req, HttpServletResponse resp)
	{
	    boolean islogin=true;
	    
	    HttpSession httpsession = req.getSession();
		String username=(String)httpsession.getAttribute("username");
		               
		if(username==null)
		        islogin=false;
		        
		return islogin;        
	}			
}