΢ͻӦ
WEIXINGJI YU YINGYONG
2000Vol.19No.5P.45-46




ASPADOڿʽԶ̸ѧеӦ
֣
ժ ҪASPADOڿʽԶ̸ѧORCAIеıʵ֡
ؼʣ̬ ̬ݶ ѧ
缼ķչΪϢĴṩΪ㷺ݵֶΣ缼ӦCAIѧCAIһչORCAIμ޵ơʱơ㷺봫ͳԶ̽Ƶص⣬Ϣ󡢽ǿܻص㡣ҹ㡢˿ڶࡢʵʩߵȽѧУԱȽ٣ҹչԶ̽شʵ塣
ORCAI˾дͳCAIĸֹܣַܳƣҪصǿûʵʱԡԣʵעᡢϿԡ۴ɣԼѧϢ¹ܡ
ʵʱҪʹASPADO
1 ASP
ASPActive Server PageΪ̬ҳMicrosoft˾ƳIIS30IIS401һĶ̬ҳԿ̬ܵWebӦãܽ׵ʵָӵWebչܡASPԵActiveXִӷȡASPʹWeb̬ҳ漰칦ƵWebݿӦñʮּ򵥡۶WebĿԱάԱ˵ASP1ǳɫĿ
ASPа5öASPͨ5öʵַͻĽǵƼܼ£
1Request󣺴ȡϢ
2Response󣺷Ϣ
3Server󣺶ԷActiveXṩʷԵĹܣ
4Session󣺴洢ûϢ
5Application󣺱û1Ϣ
ASPƵORCAIϵͳģͼ1ʾ

ͼ1 ORCAIϵͳģ
ASP𽫿ͻϵϢݸͬʱֽϢ͸ͻʵֿͻ֮ͨš潫ADOʵִӿͻͨݿԴĹܣҪκCGI
2 ADO
ADOActiveX Data ObjectsΪActiveXеݿASPͨʵֶݿķʡADOʹ˵ĽűͨODBCȡͲݿݡʹADOĶԽ͹ݿӣݿҪͻȡݣִи¡ɾݡȡODBCĴϢȡADOWebݿĽṹͼ2ʾ

ͼ2 ADOʵWebݿĻ
ADOṩ3Ҫ
1Connection󣺱ʾ1Դӣ
2Command󣺶Դв
3RecordSet󣺶ݿĽȫ¼
3 ϵͳʵ
д˵ASPʵֶԸϢĶ̬漰Webݿ̼ԱдASPҪӦݿ⣬ȻҳļԡϲԡģΪASPıдϲԡģҪܰشӷ˵ݿгȡһЩ⣨ж⡢ѡ⣩ϳԾעѧпԣԶѧԾжϣѷݿ⣻ѧԼĿԳɼʵֲ¡
1ݿ
ϵͳõAccessݿ⣬ļexammdbҪпԣ⣬ڼУǴ洢ݿеġΪܹмԶоǱ׼ģ⡢ѡ⡢жȡݿⴴ3ݱtiankongxuanzepanduanֱ洢⡢ѡ⡢ж⡣ͬԴѧɼݱchengji
2ҳļ
ڴݿԺ󣬾Ҫʼģÿ1ҳļΪ1Ӧó򣬳˿Խп⣬ѧѯԼοԳɼĹܡ
ҳkaoshiaspkaoshiaspģĺģȡ⣬о֣ѧĵ÷ּݿ⡣ÿӻҳFrontPageҳĴԪغ󣬾ͿԼASP롣
ȡ1ⲿֵĴ£
佨1RecordsetrecTimuSet recTimuServerCreateObjectADODBRecordset壩 
򿪼¼ѡеļ¼Ѽ¼Ŀڱ m
sqlselectfrom tiankong
recTimuOpen sqlexam壬adOpenKeyset
adLockOptimistic
mrecTimuRecordCount
ʼ
Randomize
ѡȡ1ڵ0Сmk
kIntRndm
recTimuMovefirst
recTimuMove k
Sessiontiankong壩recTimutkid壩
tiankongmainrecTimutkmain壩
tiankongnumrecTimutknum壩
Call InsertStrtiankongmain
رռ¼
recTimuClose
ģ¼עᣩҳregisterasp
ûעʱϵͳݿвѯûϢûѾעᣬû뿼ģ飬μӿԺԼĿԳɼ
ҳASP£
ݿ⣬ѡ񿼺źûƥ 
¼
Set recXueshengServerCreateObjectADODBRecordset壩
sqlselectfrom xuesheng where xshnum䣦
num and xshpasswd䣦passwd
recXueshengOpen sqlexam
¼Ϊգ˵ûעϢȷҳ 
ض򵽳ɼҳ
if Not recXueshengEOF then
Set Sessionuser壩recXuesheng
ResponseRedirecthttpzxlupgradeceshiframeasp
end if
֣װָӼѧԺ101416
ǣװָӼѧԺ101416
ο
1ǣ缼Ӧãɳƴ磬1999
2֣WebݿASPѧ 1999211
3ͮVBScriptʵʵ磬1999
ոڣ19991118
