很久以前的一棵树

概述系统功能表:inside_tree id int 4   parentid int 4   message varchar 50   说明 varchar 50 Null     <%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><%@page i

系统功能表:insIDe_tree

ID	int	4
parentID	int	4
message	varchar	50
说明	varchar	50	Null

 

 

<%@page ContentType="text/HTML; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><%@page import="java.util.*"%><%!//方便起见这里就不写成javabean了class cn {//连接数据库，这里以MS-sql为例String jdbcDriver="com.microsoft.jdbc.sqlserver.sqlServerDriver";//jdbc驱动String connectionString="jdbc:microsoft:sqlserver://localhost:1433;Databasename=sunmoon";//数据库连接字符串String user="sa";//数据库用户名String pass="sa";//数据库密码Connection conn=null;ResultSet rs=null;public cn() {try { Class.forname(jdbcDriver);} catch(ClassNotFoundException e) { System.err.println(e.toString());}}public ResultSet executequery(String sql) {rs=null;try {conn=DriverManager.getConnection(connectionString,user,pass);Statement stmt=conn.createStatement(ResultSet.TYPE_SCRolL_SENSITIVE,ResultSet.CONCUR_UPDAtable);rs=stmt.executequery(sql);}catch(sqlException e) {System.err.println(e.toString());}return rs;}public voID executeUpdate(String sql) {try {conn=DriverManager.getConnection(connectionString,ResultSet.CONCUR_UPDAtable);stmt.executeUpdate(sql);}catch(sqlException e) {System.err.println(e.toString());}}}class tree {cn conn=new cn();public voID init(javax.servlet.Jsp.JspWriter out,javax.servlet.http.httpServletRequest request,String username) throws Exception { out.println("<Title>系统管理员功能</Title>"); buildTree(out,username);//初始调用}public voID buildTree(javax.servlet.Jsp.JspWriter out,int parentID,int level,String username) throws Exception { leveL++; ResultSet rs=conn.executequery("select * from admin_tree where parentID="+parentID+" order by ID");// ResultSet rs2=conn.executequery("select * from parentRights where username='sensory' order by parentID"); //select * from tree where parentID in (select parentID from parentRights )order by ID while(rs.next()) { int ID; ID=rs.getInt("ID"); String IDStr = String.valueOf(ID); //int转化为String //String username="a"; //替换为session名 ResultSet rs2=conn.executequery("select * from admin_function where username='"+username+"' and parentID='"+IDStr+"' order by parentID"); if (!rs2.next()) //if((rs.getInt("ID")!=6) && (rs.getInt("ID")!=10)) //权限管理 { out.println("<div>"); for(int i=0;i<level-1;i++) out.print("<img src="/" mce_src="/""white.gif/"> "); if(has_child(rs.getInt("ID"))) { out.print("<img alt=/"展开/" mce_"cursor:hand;/" onclick=/"myClick('"+rs.getInt("ID")+"');/" ID=/"img"+rs.getInt("ID")+"/" src="/" mce_src="/""plus.gif/"> <img ID=/"im"+rs.getInt("ID")+"/" src="/" mce_src="/""closedfold.gif/"> "); out.print("<span onclick=/"myClick1('"+rs.getInt("ID")+"');/" mce_"cursor:default;/" ID=/"span"+rs.getInt("ID")+"/">"+rs.getString("message")+" </span>"); out.println("<div mce_"display:none;/" ID=/"div"+rs.getInt("ID")+"/">"); buildTree(out,rs.getInt("ID"),level,username);//递归调用 out.println("</div>"); } else out.print("<img src="/" mce_src="/""dot.gif/"><span onclick=/"myClick1('"+rs.getInt("ID")+"');/" mce_"cursor:default;/" ID=/"span"+rs.getInt("ID")+"/">"+rs.getString("message")+" </span>"); out.println("</div>"); } } rs.close(); rs=null; }private boolean has_child(int parentID) throws Exception { ResultSet rs=conn.executequery("select * from admin_tree where parentID="+parentID+" order by ID"); return rs.next();}}%><!--以上代码可以写成javabean--><mce:script language="JavaScript"><!--这段Js为了实现树的展开和关闭的效果--><!--function myClick(ID) { eval("var div=div"+ID); eval("var img=img"+ID); eval("var im=im"+ID); div.style.display=div.style.display!="none"?"none":"block"; img.src=div.style.display!="none"?"minus.gif":"plus.gif"; im.src=div.style.display!="none"?"openfold.gif":"closedfold.gif"; img.alt=div.style.display!="none"?"关闭":"展开"; }function myClick1(ID) { //document.form1.parentID.value=ID; admin/sysManage.Jsp if (ID==101) { window.open('../admin/userManage/userRun.Jsp','message','scrollbars=auto,status=yes,toolbar=yes,menubar=yes,location'); } if (ID==102) { window.open('../admin/userManage/userFunction.Jsp',location'); } if (ID==1001) { window.open('../admin/Vote/Votemain.Jsp',location'); } if (ID==2001) { window.open('../admin/notebook/adminnotedetail.Jsp',location'); } if (ID==5001) { window.open('../message/adminmsgcenter.Jsp',location'); } if (ID==8001) { window.open('../admin/database/backup.Jsp',location'); } if (ID==8002) { window.open('../admin/database/restore.Jsp',location'); } else { } }// --></mce:script><HTML><table> <tr> <td height="300" valign="top"> <%String username = (String) session.getValue("userID");tree myTree=new tree();myTree.init(out,request,username);%> </td> </tr> <tr><strong><Font size="1"><%=username%></Font></strong> </tr></table></HTML>

总结

以上是内存溢出为你收集整理的很久以前的一棵树全部内容，希望文章能够帮你解决很久以前的一棵树所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。