日期:2012-08-29 浏览次数:20901 次
ASP+ACCESS 在数据量达100万条记录下,载入速度仍然惊人....
// 网上转载. 忘了作者... : )
//********************** index.asp ************************//
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%Option Explicit%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>tree</title>
<link href="css/style.css" rel="stylesheet" type="text/css">
<script language="JavaScript">
<!--
var d1,d2;
function expand(id)
{
var d=new Date();
d1=d.valueOf();
var s_id = eval("s" + id);
var dir_id = eval("dir" + id);
if(s_id.href != '')
{
//window.open(s_id.href);
//or
//top.frames['FrameName'].location.href = s_id.href;
}
switch(dir_id.open)
{
//改变"+","-"
case "true":
{
with(dir_id)
{
innerText = "+";
open = "false";
className = 'dirclose';
}
if(document.getElementById("t" + id))
{
eval("t"+id).style.display = 'none';
document.getElementById("load_" + id).style.display = 'none';
return;
}
else
{
document.getElementById("load_" + id).style.display = 'none';
}
break;
}
case "false":
{
with(dir_id)
{
innerText = "-";
open = "true";
className = 'diropen';
}
document.getElementById("load_" + id).style.display = '';
if(document.getElementById("t" + id))
{
eval("t" + id).style.display = '';
eval("load_" + id).style.display = 'none';
return;
}
else
{
document.frames['hifm'].location.replace("subtree.asp?id=" + id);
}
break;
}
default:dir_id.innerText = "."; dir_id.className = 'dirNode'; return;
}
}
function ArrToHtml(ArrNode,nodeid)
{
//输出到页面
var node_html = '<table id="t' + nodeid + '" width="100%" border="0" style="position: relative; left: 18px;" cellspacing="0" cellpadding="0">';
var str,opened,cls
for (var i = 0; i < ArrNode.length; i++)
{
if (ArrNode[i].iChildren == 0)
{
str = '.';
opened = 'no';
cls = 'dirNode';
}
else
{
str = '+';
opened = 'false';
cls = 'dirclose';
}
node_html += '<tr><td id="node' + ArrNode[i].id + '" class="td_node" valign="top"><span class="' + cls + '" id="dir' + ArrNode[i].id + '" open="' + opened + '">' + str + '</span><span class="node" id="s' + ArrNode[i].id + '" title="' + ArrNode[i].Content + '" href="' + ArrNode[i].strLink + '">' + ArrNode[i].Content + '</span></td></tr>';
if (ArrNode[i].iChildren > 0)
{
node_html += '<tr id="load_' + ArrNode[i].id