<% page import="java.util.*;" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML ">

JSP+JavaScript实现类似MSDN CSDN导航树效果

80酷酷网    80kuku.com

  javascript|js|导航

<!-- Tree.jsp -->
<% page contentType ="text/html;charset=gb2312" %>
<% page import="java.util.*;" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<BODY>
<iframe width="100%" height="100" id="hiddenframe"></iframe>
<script>
function ExpandNode(ParentNode,ParentId){
var NodeX = eval(ParentNode.id + '_0');
if (NodeX.style.display == 'none')
 {
  NodeX.style.display="block";
  if (NodeX.loaded == 'no')
     {
      document.frames['hiddenframe'].location.replace("subtree.jsp?PID=" + ParentId + "&PNode=" + ParentNode.id);
      NodeX.loaded = 'yes';
    }
 }
else
 {
  NodeX.style.display='none';
 }
}
</script>
<CENTER>
<TABLE border="1" width="20%" height="60%">
<TR>
<TD>
<DIV auto;WIDTH: 100%;HEIGHT: 100%">
<TABLE width="300%">
<TR>
<TD>
<%
 java.lang.Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//  java.sql.Connection ConnectionX = java.sql.DriverManager.getConnection("jdbc:ODBC:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\Resin\\doc\\examples\\Tree\\tree.mdb","admin", "");
//  java.sql.Statement StatementX = ConnectionX.createStatement();
 java.sql.ResultSet ResultSetX = java.sql.DriverManager.getConnection("jdbc:ODBC:driver={Microsoft Access Driver (*.mdb)};DBQ=e:\\resin-2.1.6\\doc\\examples\\Tree\\tree.mdb","admin", "").createStatement().executeQuery("select *,(select count(*) from tree where parentid = T.id) as children from tree T where parentid = 0");
 int i=0;
 int children;
 int ID;
 while (ResultSetX.next())
       {
children=ResultSetX.getInt("children");
ID=ResultSetX.getInt("id");
%>
<div id='Node_<%= i %>'><a CONTENT="">
</HEAD>
<%
String ParentNode = request.getParameter("PNode");
int i;
int j;
String nSpace="";
j= ParentNode.length()- ParentNode.replaceAll("_","").length();
for (i=0;i<j;i++)
   nSpace = nSpace + "  ";
String sHTML ="";
i=0;

 java.lang.Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//  java.sql.Connection ConnectionX = java.sql.DriverManager.getConnection("jdbc:ODBC:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\Resin\\doc\\examples\\Tree\\tree.mdb","admin", "");
//  java.sql.Statement StatementX = ConnectionX.createStatement();
 java.sql.ResultSet ResultSetX = java.sql.DriverManager.getConnection("jdbc:ODBC:driver={Microsoft Access Driver (*.mdb)};DBQ=e:\\resin-2.1.6\\doc\\examples\\Tree\\tree.mdb","admin", "").createStatement().executeQuery("select *,(select count(*) from tree where parentid =T.id ) as Children from tree T where parentid = " + request.getParameter("PID"));
 int children;
 int ID;
 while (ResultSetX.next())
 {    children=ResultSetX.getInt("children");
      ID=ResultSetX.getInt("id");
      sHTML = sHTML + "<div id='" + ParentNode + "_" + (i + 1) + "'>" + nSpace + "<a var x = eval('parent.' + '<%= ParentNode + "_0"%>' ) ;
   x.innerHTML="<%= sHTML %>";
</script>
</BODY>
</HTML>



分享到
  • 微信分享
  • 新浪微博
  • QQ好友
  • QQ空间
点击: