jsp 实现简单的左边菜单.docVIP

jsp 实现简单的左边菜单 %@ page contentType=text/html; charset=gb2312 language=java import=java.sql.* errorPage= % %@ include file=../golbal/connection.jsp% html head meta content=MSHTML 5.00.2614.3500 name=GENERATOR jsp:useBean id=con scope=page class=net.xcsoa.pub.ConfigUtils / link href=../css/menucss.css rel=stylesheet type=text/css script type=text/javascript src=../js/menujs.js/script title用户菜单/title /head % String userid=(String)session.getAttribute(userid); String tempWhere=; String remoteAddr = request.getRemoteAddr(); String No_of_happy=(String)session.getAttribute(No_of_happy); if(remoteAddr==null) remoteAddr=; if(!remoteAddr.equals(127.0.0.1)){ if(!remoteAddr.equals()){ if(Integer.parseInt(remoteAddr.substring(0,remoteAddr.indexOf(.)))10) tempWhere= and menuinfo.menuid not in (1402,1401); }else{ tempWhere= and menuinfo.menuid not in (1402,1401);} } if(No_of_happy.trim().equals(1)) tempWhere=tempWhere+ and menuinfo.menuid 98 ; int str=con.getConMenu(userid,tempWhere); % body bgColor=#ffffff onload=init(22,%=str%) onResize=return window_onresize() leftmargin=0 topmargin=0 % String Item=; String ManName=; String ItemName=; int i=0; String f_id; sql=SELECT menuinfo.MenuID, menuinfo.Pesciption FROM menu_public INNER JOIN menuinfo ON menu_public.menuid = menuinfo.MenuID WHERE (LEN(menuinfo.MenuID) = 2) AND (menuinfo.MenuID 00) AND (menu_public.flag = 1) +tempWhere+ UNION SELECT popedom.menuid, menuinfo.Pesciption AS Pesciption FROM popedom INNER JOIN menuinfo ON popedom.menuid = menuinfo.MenuID WHERE (LEN(menuinfo.MenuID) = 2) AND (menuinfo.MenuID 00) and popedom.flag=1 and popedom.userid=+userid+ +tempWhere+ ORDER BY menuinfo.MenuID ; ResultSet f_rs=stmt.executeQuery(sql); while (f_rs.next()){ Item=(f_rs.getString(MenuID)).substring(0,2); ManName=f_rs.getString(Pesciption); % div id=menulayer%=i%Div div id=iconlayer%=i%Div table align=left border=0 cellPadding=1 cellSpacing=0 width=120 TBODY %