asp無限分級(遞歸調用)

2024-05-04 10:58:49

字體：大中小

來源：轉載

供稿：網友

數據庫字段:id(自動編號),class_name(菜單名),parentID(父菜單id)
復制代碼代碼如下:

<%
dim m
m=0
call ShowTree(0)%>
<%
Sub ShowTree(parentID)
     dim s
     m=m+1
     Dim rs
     Set rs = Server.CreateObject("ADODB.RecordSet")
     sql="Select class_id,class_name FROM [WMS_Class] where class_father_id="&Cint(parentID)
     rs.open sql,Conn,1,1
     if rs.eof and m = 1 then
           response.Write("該頻道暫無欄目")
     end if
     Do While Not rs.Eof
               response.Write rs(0)
               for n=1 to m
                 if n = m and m = 1 then
                       Response.Write ("╋")
                 elseif n = 1 then
                       Response.Write ("　")
                 elseif n = m then
                       Response.Write ("├")
                 else
                       Response.Write ("│")
                 end if
           next
             response.Write rs(1)&"<br>"
           Call ShowTree(rs(0))
           m=m-1
           rs.Movenext
     Loop
End Sub
%>

上一篇：管理員登錄

下一篇：用ASP+FSO生成JS文件

發表評論

共有條評論