<%@ Language=VBScript %>
<%
Response.CharSet="gb2312"
Response.ContentType="text/html"
'''''''''''''''''''''''''''''''Server code start'''''''''''''''''''''''''''''''
dim parId,nodeLayer
parid=Request.QueryString("parId")
nodeLayer=cint(Request.QueryString("nodeLayer"))
if(parid="") then
Response.Write("root id can't is null")
Response.End()
end if
if parid="root" then parid=int(0)
if(nodeLayer<0) then
nodeLayer=0
end if
%>
<%
strconn="DBQ="+server.mappath("xTree.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
''SQL 语句书写要求:在记录集的前面三个字段必须依次为:row_id(惟一的主键)、name(菜单条显示的内容)、par_id(父节点row_id),其它根据需要输出与显示
set conn=server.createobject("ADODB.connection")
conn.open strconn
strsql="select * from tree where par_id="& parid & ""
'Response.Write strsql
set rs=server.createobject("ADODB.Recordset")
rs.open strsql,conn,1,1
i=0
dim row_id
row_id=""
while not rs.EOF
row_id=rs.Fields("row_id").Value
name=rs.Fields("name").Value
j=0