很久以前的一棵树

发布时间：2020-12-12 15:15:22 所属栏目：MsSql教程来源：网络整理

导读：系统功能表 :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.*"%%!//方便起见这里

int

parentid

int

message

varchar

说明

varchar

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=/"展开/" style="/" mce_style="/""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")+"');/" style="/" mce_style="/""cursor:default;/" id=/"span"+rs.getInt("id")+"/">"+rs.getString("message")+" </span>"); out.println("<div style="/" mce_style="/""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")+"');/" style="/" mce_style="/""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(); } } %>  <mce:script language="JavaScript"> </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>

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

系统功能表:inside_tree