<%
db="pic/Database/DataShop.mdb" '数据库文件位置
connstr="DBQ="+server.mappath(""&db&"")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
sqlBigClass="select * from BigClass order by BigClassID"
Set rsBigClass= Server.CreateObject("ADODB.Recordset")
rsBigClass.open sqlBigClass,conn,1,1
rsBigClass.movefirst
do while not rsBigClass.eof
%>
<%
sqlClass="select * from SmallClass where BigClassName='" & rsBigClass("BigClassName") & "' Order by SmallClassID"
Set rsClass= Server.CreateObject("ADODB.Recordset")
rsClass.open sqlClass,conn,1,1
do while not rsClass.eof
%>
All rights reserved:Jinxiang Golden Profit Food Co.,Ltd.
Address: In The East of National Road 105, 6Kilometers North of Jinxiang County, Shandong Province
Postcode: 272000 Tel.: 0086-537-8751668 faxes: 0537-8755363
