jsp 实现简单的左边菜单

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../golbal/connection.jsp"%>








<%
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);
%>
) 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 erid='"+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>

Div>


<%
sql="SELECT menuinfo.MenuID, menuinfo.Pesciption, menuinfo.Web_Url, menuinfo.ImageAddr FROM menu_public INNER JOIN menuinfo ON menu_public.menuid = menuinfo.MenuID WHERE (LEN(menuinfo.MenuID) = 4) AND (LEFT(menuinfo.MenuID, 2) = '"+Item+"') AND (LTRIM(RTRIM(menuinfo.Web_Url)) <> '') AND (menu_public.flag = '1') UNION SELECT menuinfo.MenuID, menuinfo.Pesciption AS Pesciption, menuinfo.Web_Url AS Web_Url, menuinfo.ImageAddr FROM popedom INNER JOIN menuinfo ON popedom.menuid = menuinfo.MenuID WHERE (LEN(menuinfo.MenuID) = 4) AND (LEFT(menuinfo.MenuID, 2) = '"+Item+"') AND (LTRIM(RTRIM(menuinfo.Web_Url)) <> '') AND (popedom.flag = '1') AND (erid = '"+userid+"') ORDER BY menuinfo.MenuID";

rs=stmt1.executeQuery(sql);
while (rs.next()){
ItemName=rs.getString("Pesciption");
%>

<%
}%>

borderColorLight=#ffffff cellPadding=0 cellSpacing=0 onmousedown="this.borderColorLight='#000000';this.borderColorDark='#cccccc'" onmouseout="this.borderColorLight='#ffffff';this.borderColorDark='#ffffff'" onmouseover="this.borderColorLight='#cccccc';this.borderColorDark='#000000'" onmouseup="this.borderColorLight='#ffffff';this.borderColorDark='#ffffff'"> borderColorLight=#ffffff>&menuid=<%=rs.getString("menuid")%>" target=main> border=0 height=32 src="<%=rs.getString("ImageAddr")%>" style="FILTER: alpha(opacity=100)" width=32>

&menuid=<%=rs.getString("menuid")%>" target=main><%=ItemName%>

Div>onmousedown="javascript:this.src='../images/gif/scrollup2.gif';menuscrollup()"
onmouseout="javascript:this.src='../images/gif/scrollup.gif';menuscrollstop()"
onmouseup="javascript:this.src='../images/gif/scrollup.gif';menuscrollstop()"
src="../images/gif/scrollup.gif" title=更多 width=16>

Div>onmousedown="javascript:this.src='../images/gif/scrolldown2.gif';menuscrolldown()"
onmouseout="javascript:this.src='../images/gif/scrolldown.gif';menuscrollstop()"
onmouseup="javascript:this.src='../images/gif/scrolldown.gif';menuscrollstop()"
src="../images/gif/scrolldown.gif" title=更多 width=16>

Div>
cellPadding=0 cellSpacing=0 height=28 onclick=javascript:menubarpush(<%if(str-1==i) out.print(str-1); else out.print(i);%>)
onmousedown="javascript:this.borderColorDark='White';this.borderColorLight='#505050'"
onmouseout="javascript:this.borderColorDark='#505050';this.borderColorLight='White'"
onmouseup="javascript:this.borderColorDark='#505050';this.borderColorLight='White'"
style="CURSOR: hand" width="120">

borderColorLight=#cccccc colSpan=0 noWrap rowSpan=0><%=ManName%>

<% i=i+1;
}

f_rs.close();

stmt.close();
stmt1.close();
conn.close();
%>