很久以前的一棵树

系统功能表: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,user,pass);Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,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,0,0,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>

秒客网

很久以前的一棵树

相关文章