使用DW用ASP+ACCESS编写目录树

　　下面这段程序代码是用来显示目录树用的，保存成文件：inc.asp

<%
response.write("" & chr(13))
response.write("" & chr(13)&"" & chr(13))
response.write("" & chr(13) & "" & chr(13) & "" & chr(13) & "
" & chr(13) & "")
response.write("" & chr(13) & "" & chr(13) & "" & chr(13))
response.write("" & chr(13))
response.write("" & chr(13))
response.write("
不可修改根节点添加
" & chr(13))
'此处调用显示目录树的递归函数
listChild(0)
response.write("
" & chr(13))

'下面代码为显示目录树最关键的函数，使用了递归方法（很多象这样类型的都是用递归来做的。）
function listChild(id)
dim sRec,sSql,sNum,sTmp
set sRec=server.createobject("adodb.recordset")
sSql="select listId,listName,listInfo,parentId from listTable where parentId=" & id
sRec.open sSql,sConn,3,1
if not sRec.eof then
sNum=1
response.write("" & chr(13))
while not sRec.eof
sTmp=sConn.execute("select count(listId) as countSub from listTable where parentId=" & sRec("listId"))
if sTmp("countSub")>0 then
response.write("" & chr(13))
if sNum=sRec.recordcount then
response.write("" & chr(13))
else
response.write("" & chr(13))
end if
response.write("" & chr(13) & "" & chr(13))
response.write("")
if sNum=sRec.recordcount then
response.write("" & chr(13))
else
response.write("" & chr(13))
end if
response.write("" & chr(13) & "" & chr(13))
else
response.write("" & chr(13))
if sNum=sRec.recordcount then
response.write("" & chr(13))
else
response.write("" & chr(13))
end if
response.write("" & chr(13) & "" & chr(13))
end if
sRec.movenext
sNum=sNum+1
wend
response.write("
" & chr(13) & "" & chr(13))
response.write("" & chr(13) & "" & chr(13) & "" & chr(13))
response.write("" & chr(13) & "" & chr(13) & "" & chr(13) & "
" & server.HTMLEncode(sRec("listName")) & "
添加
编辑
删除

" & chr(13) & "
response.write("")
response.write(" ")
response.write(" " & chr(13))
listChild(sRec("listid"))
response.write("
" & chr(13) & "" & chr(13))
response.write("" & chr(13) & "" & chr(13) & "" & chr(13))
response.write("" & chr(13) & "" & chr(13) & "" & chr(13) & "
" & sRec("listInfo") & " " & server.HTMLEncode(sRec("listName")) & "
添加
编辑
删除

" & chr(13) & "
" & chr(13))
end if
sRec.close '关闭记录集
set sRec=nothing '关闭记录集
end function
sConn.close '关闭数据库链接
set sConn=nothing '关闭数据库链接
%>

<%
function checkstr(str)
str=replace(str,"'","''",1,-1,1)
checkstr=str
end function

dim disp,parentId,listName,listInfo
disp=request.QueryString("disp")
parentId=request.QueryString("parentId")
select case disp
case "add"
listName=checkstr(left(request.QueryString("listName"),10))
listInfo=checkstr(left(request.QueryString("listInfo"),50))
if listName="" then listName="空白节点"
if listInfo="" then ListInfo="此节点在添加入未填写内容"
sSql="insert into listTable (listName,listInfo,parentId) values('" & listName & "','" & listInfo & "'," & parentId & ")"
case "edit"
listName=checkstr(left(request.QueryString("listName"),10))
listInfo=checkstr(left(request.QueryString("listInfo"),50))
if listName="" then listName="空白节点"
if listInfo="" then listInfo="此节点在添加入未填写内容"
sSql="update listTable set listName='" & listName & "',listInfo='" & listInfo & "' where listId=" & parentId
case "del"
sSql="delete from listTable where listId=" & parentId & " or parentId=" & parentId
end select
sConn.execute sSql,,1
response.redirect("index.asp")
%>

　　以上代码保存成的文件放在同一目录下面（在这里我们称为根目录）。
　　在根目录下新建一个CSS目录.
　　下面为CSS定义，保存成css.css文件，放在CSS目录下。注：有一两个样式是不要的，我没删
.menuPro {
    border-top: 1px dotted #A5BBE0;
    border-right: 1px dotted #31548E;
    border-bottom: 1px dotted #31548E;
    border-left: 1px dotted #A5BBE0;
    overflow: visible;
    font-family: "Verdana", "Arial", "Helvetica", "sans-serif";
    font-size: 12px;

}
.menuGro {
    border-top: 2px outset #31548E;
    border-right: 2px outset #A5BBE0;
    border-bottom: 2px outset #A5BBE0;
    border-left: 2px outset #31548E;
    overflow: visible;
    font-family: "Verdana", "Arial", "Helvetica", "sans-serif";
    font-size: 12px;

}
.menuFont {
    font-family: "Verdana", "Arial", "Helvetica", "sans-serif";
    font-size: 12px;
}
.showDiv {
    display:'';
}
.hiddenDiv {
    display:none;
}
.treeDiv {
    background-color: #A8D5EA;
    height: 100%;
    width: 100%;
    border-top-width: 2px;
    border-right-width: 2px;
    border-bottom-width: 2px;
    border-left-width: 2px;
    border-top-style: inset;
    border-right-style: inset;
    border-bottom-style: inset;
    border-left-style: inset;
    border-top-color: #3680C9;
    border-right-color: #BCD5ED;
    border-bottom-color: #BCD5ED;
    border-left-color: #3680C9;
    overflow: auto;
    padding: 20px;

}
body {
    overflow: hidden;
}
.formDiv {
    font-family: "Verdana", "Arial", "Helvetica", "sans-serif";
    font-size: 12px;
    font-weight: normal;
    background-color: #7ABDDE;
    height: 200px;
    width: 300px;
    border-top: 1px outset #B9DCFF;
    border-right: 1px outset #004488;
    border-bottom: 1px outset #004488;
    border-left: 1px outset #B9DCFF;
    overflow: hidden;

}
.text1 {
    width: 160px;
}
.DivBut {
    font-family: "Verdana", "Arial", "Helvetica", "sans-serif";
    font-size: 12px;
    font-weight: normal;
    background-color: #3399CC;
    height: 20px;
    width: 40px;
    border: 1px outset;

}

　　另在根目录下建一个IMAGES目录。用来放那些文件夹样子的小图。

最新热点		最新推荐		相关文章
				用手机挂QQ 你也能快速升级为… 制作一个百毒不侵的系统修改Win XP开机画面最简单办… 将WindowsXP加速到极限用脚本恢复Windows XP的用户… 如何创建自己的网站 Windows操作系统中必须禁止的… Windows目录下几大需清理的地… 经典常见计算机密码破解实用… 网络攻击的几种攻击与防御手…