蛙蛙推薦:asp實現樹型結構選擇自onlytiancai的Blog
關鍵字蛙蛙推薦:asp實現樹型結構
出處
<!--
-----------[test]表生成腳本---------------
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[test]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[test]
GO
CREATETABLE[dbo].[test](
[id][int]IDENTITY(1,1)NOTNULL,
[str_note][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,
[father_id][int]NULL
)ON[PRIMARY]
GO
-->
<!--
***********************測試數據********************
[id][str_note][father_id]
[1][電腦書籍][0]
[2][軟件開發][1]
[3][硬件維修][1]
[4][asp][2]
[5][php][2]
[6][jsp][2]
[7][html][2]
[8][顯示器維修][3]
[9][主板維修][3]
[10][顯卡維修][3]
[11][vbs基礎][4]
[12][html基礎][4]
[13][ado基礎][4]
[14][do語句][11]
[15][for語句][11]
[16][select語句][11]
***************************************************
-->
<%
Dimstrconn,conn,rs,sql
strconn="Driver={sqlserver};server=localhost;database=wawavote;uid=sa;pwd=sa;"
Dimi
i=0
FunctionShowTree(parentID)
i=i+1
Dimrs
Setrs=Server.CreateObject("ADODB.RecordSet")
sql="SELECTid,str_note,father_id,(SELECTstr_noteFROMtestt2WHEREt2.id=t1.father_id)ASParentNameFROMtestt1WHEREt1.father_id="&Cint(parentID)
rs.opensql,strconn,1,1
DoWhileNotrs.Eof
forj=1toi
Response.Write("---")
next
Response.Write(rs(1)&"["&rs(3)&"]<br>")
ShowTreers(0)
i=i-1
rs.Movenext
Loop
rs.Close:Setrs=Nothing
EndFunction
SubShowTable(table)
Dimrs
Setrs=Server.CreateObject("ADODB.RecordSet")
sql="select*from"&trim(table)
rs.opensql,strconn,1,1
Fori=0Tors.Fields.Count-1
Response.Write("["&rs.fields(i).Name&"]")
next
Response.Write("<br>")
DoWhileNotrs.Eof
Fori=0Tors.Fields.Count-1
Response.Write("["&rs.fields(i).Value&"]")
next
Response.Write("<br>")
rs.MoveNext
Loop
rs.Close:Setrs=Nothing