1. Silakan bangun nama basis data di SQLServer: House dan jalankan skrip berikut di rumah
IfExists (pilih*fromsysObjectswhereId = object_id (n´ [dbo]. [City] ´) andObjectProperty (id, n'isuserable ') = 1)
droptable [dbo]. [Kota]
PERGI
IfExists (pilih*fromsysObjectswhereId = object_id (n´ [dbo]. [Area] ´) andObjectProperty (id, n'isuserable ') = 1)
droptable [dbo]. [Area]
PERGI
Createtable [dbo]. [City] (
[id] [int] identitas (1,1) notnull,
[Nama] [nvarchar] (10) null
) Pada [primer]
PERGI
CreateTable [dbo]. [Area] (
[id] [int] identitas (1,1) notnull,
[CityId] [int] null,
[Nama] [nvarchar] (20) null
) Pada [primer]
PERGI
Nilai InsertIntocity (ID, Name) (1, "Guangzhou")
Nilai InsertIntocity (ID, Name) (2, "Shanghai")
Nilai InsertIntocity (ID, Name) (3, "Beijing")
Nilai InsertIntoarea (ID, CityID, Nama) (1,1, "Tianhe")
Nilai InsertIntoarea (ID, CityID, Name) (2,1, "White Cloud")
Nilai InsertIntoarea (ID, CityID, Nama) (3,2, "Hongkou")
Nilai InsertIntoarea (ID, CityID, Nama) (4,2, "Baoshan")
Nilai InsertIntoarea (ID, CityID, Nama) (5,2, "Jing'an")
Nilai InsertIntoarea (ID, CityID, Nama) (6,3, "Haidian")
Nilai InsertIntoarea (ID, CityID, Nama) (7,3, "Chaoyang")
2. Buat file
Buat File CityData.asp
<%@Bahasa = VBScript%>
<%Rsdispatch%>
<ScripTrunat = ServerLanguage = JavaScript>
<!-#includeVirtual = "/_ scriptLibrary/rs.asp"->
<!-#includeVirtual = "/jsconn.asp"->
functionDescription ()
{
this.getareAasArray = doGetData;
}
public_description = newDescription ();
FunctionDogetData (CityID)
{
VarSQL, RST, Strtext, Conn, I, J.
conn = newActivexObject ("adodb.connection");
conn.connectionstring = connstr;
Conn.ConnectionTimeout = 30;