officemenu.java

企业网上办公自动化系统 jsp tomcat sql200

package com.office.officemenu;

import java.io.IOException;
import java.util.ArrayList;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.jsp.tagext.TagSupport;

import com.office.actionform.LogonForm;
import com.office.dao.Content;
import com.office.dao.DB;

public class OfficeMenu extends TagSupport {
	public int doStartTag() throws JspException {
		HttpServletRequest request=(HttpServletRequest)pageContext.getRequest();
		HttpSession session=request.getSession();
		ArrayList menulist1=new ArrayList();		
        menulist1=(ArrayList)session.getAttribute("menulist");
        LoadMenu(menulist1);
	    return SKIP_BODY;
	}
    private void LoadMenu(ArrayList menulist1){
    	HttpServletRequest request=(HttpServletRequest)pageContext.getRequest();
		String contextPath=request.getContextPath();
    	HttpSession session=request.getSession();
    	JspWriter jspwriter=pageContext.getOut();
		String selectmenu1=(String)session.getAttribute("selectmenu1");
		if(selectmenu1==null)selectmenu1="";
		try{
		    if(menulist1==null||menulist1.size()==0){
    		    jspwriter.write("<tr><td height=300 align='center' valign='top'>没有菜单可显示！</td></tr>");
    	    }
		    else{
		        jspwriter.write("<tr><td heigth='200' align='center'background='"+contextPath+"/image/left_back.jpg'><table width='100%' border='1' cellspacing='0' cellpadding='1' bordercolor=black bordercolorlight=black bordercolordark=lightgrey>");
 		    	for(int i=0;i<menulist1.size();i++){
        		    MenuSigle menu1sigle=(MenuSigle)menulist1.get(i);
        		    if(selectmenu1.equals(menu1sigle.getMenuid())){
        		    	jspwriter.write("<tr><td height='25' align='left' background='"+contextPath+"/image/menu1_1_1.jpg'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>"+menu1sigle.getMenuname()+"</b></td></tr>");
        		    	LoadMenu2(menu1sigle.getMenuid());
    	    	    }
        		    else{jspwriter.write("<tr><td height='25' align='left' background='"+contextPath+"/image/menu1_1.jpg' onMouseOver='javascript:this.background=\""+contextPath+"/image/menu1_1_1.jpg\"' onMouseOut='javascript:this.background=\""+contextPath+"/image/menu1_1.jpg\"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href='"+contextPath+menu1sigle.getMenuaction()+"'>"+menu1sigle.getMenuname()+"</a></td></tr>");}
 		    	}
		        jspwriter.write("</table></td></tr>");
		    }
		}
		catch(IOException e){e.printStackTrace();}
	}    
    private void LoadMenu2(String menuparentid){
    	HttpServletRequest request=(HttpServletRequest)pageContext.getRequest();
		HttpSession session=request.getSession();
		String contextPath=request.getContextPath();
		int userable=((LogonForm)session.getAttribute("logonuser")).getUserable();
		JspWriter jspwriter=pageContext.getOut();
		String selectmenu2=(String)session.getAttribute("selectmenu2");
         if(selectmenu2==null)selectmenu2="";
		ArrayList menulist2=new ArrayList();
        String sql="select * from "+Content.TB_MENU+" where "+Content.MENUPARENTID+"='"+menuparentid+"' and "+Content.MENUJIBIE+"='2' and "+Content.USERABLE+" <= "+userable+" order by "+Content.MENUORDER;
        DB db=new DB();
        menulist2=db.getmenulist(sql);
        try{
		    if(menulist2!=null&&menulist2.size()!=0){
		        jspwriter.write("<tr><td align='center'height=10><table border='0' cellpadding='0' cellspacing='-2' bordercolor=black bordercolorlight=black bordercolordark=white>");
 		    	for(int i=0;i<menulist2.size();i++){
        		    MenuSigle menu2sigle=(MenuSigle)menulist2.get(i);
        		    if(selectmenu2.equals((menu2sigle).getMenuid())){
        		    	jspwriter.write("<tr><td width=184 height='25' valign='bottom' nowrap bgcolor='lightgrey' background='"+contextPath+"/image/menu2_1.jpg'><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href='"+contextPath+menu2sigle.getMenuaction()+"'>"+menu2sigle.getMenuname()+"</b></td></tr>");
        		    	session.setAttribute("pagepath",menu2sigle.getMenuaction());
        		    	LoadMenu3(menu2sigle.getMenuid());
    	    	    }
        		    else{
        		    	jspwriter.write("<tr><td width=184 height='25' valign='bottom' nowrap bgcolor='lightgrey' background='"+contextPath+"/image/menu2_1.jpg'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href='"+contextPath+menu2sigle.getMenuaction()+"'>"+menu2sigle.getMenuname()+"</a></td></tr>");
        		    }
 		    	}
		        jspwriter.write("</table></td></tr>");
		    }
		}
		catch(IOException e){e.printStackTrace();}
    }    
    private void LoadMenu3(String menuparentid){
    	HttpServletRequest request=(HttpServletRequest)pageContext.getRequest();
		HttpSession session=request.getSession();
    	String contextPath=request.getContextPath();
		int userable=((LogonForm)session.getAttribute("logonuser")).getUserable();
		JspWriter jspwriter=pageContext.getOut();
		String selectmenu3=(String)session.getAttribute("selectmenu3");
         if(selectmenu3==null)selectmenu3="";
		ArrayList menulist3=new ArrayList();
        String sql="select * from "+Content.TB_MENU+" where "+Content.MENUPARENTID+"='"+menuparentid+"' and "+Content.MENUJIBIE+"='3' and "+Content.USERABLE+"<="+userable+" order by "+Content.MENUORDER;
        DB db=new DB();
        menulist3=db.getmenulist(sql);
        try{
		    if(menulist3==null||menulist3.size()==0){
    		  
    	    }
		    else{
		        jspwriter.write("<tr><td height='25' valign='bottom' nowrap bgcolor='lightgrey'><table width='98%'   border='0' align='center' cellpadding='0' cellspacing='-2' bordercolor=black bordercolorlight=black bordercolordark=white>");
 		    	for(int i=0;i<menulist3.size();i++){
        		    MenuSigle menu3sigle=(MenuSigle)menulist3.get(i);
        		    if(selectmenu3.equals((menu3sigle).getMenuid())){
        		    	jspwriter.write("<tr><td width='184' height='25' valign='bottom' nowrap bgcolor='#999999'  background='"+contextPath+"/image/menu3_1.jpg'><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href='"+contextPath+menu3sigle.getMenuaction()+"'>"+menu3sigle.getMenuname()+"</b></td></tr>");
        		    	session.setAttribute("pagepath",menu3sigle.getMenuaction());
        		    }
        		    else{
        		    	jspwriter.write("<tr><td width='184' height='25' valign='bottom' nowrap bgcolor='#999999'  background='"+contextPath+"/image/menu3_1.jpg'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href='"+contextPath+menu3sigle.getMenuaction()+"'>"+menu3sigle.getMenuname()+"</a></td></tr>");
        		    }
 		    	}
		        jspwriter.write("</table></td></tr>");
		    }
		}
		catch(IOException e){e.printStackTrace();}
    }
}