Ӧо
APPLICATION RESERCH OF COMPUTERS
2000  Vol.17No.1P.84-86




һֻWebݿϵͳ
ʵ½ۡл
ժ Ҫ һֻWebݿϵͳƣϸϵͳṹݿϵͳƣƺݿеȼ档
ؼ ݿ Web ODBC ASP/ADC
ڵУҵҵͷҵΪInternetݿӦõļ߸٣۹гΪʵֵȶʹһWebΪͻˡWebУϢıͼļʽд洢WebѯٶȺƺǻݺͻڽṹļSybaseOracleInformixרݿϵͳܶԴݽġйֻ֯ҪѯܺܿõѯWebн͹㷺УͨInternetԽԶ̲ѯάĹܣЩݿϵͳ޷ġˣInternetWebĳıӹܲѯݿΪǵԸܰWebݿ⼼лؽһ𣬱ܴչWebܣҲɳԭЩݿϵͳбϢԴߵŵ㼯һ壬ʹInternetͬʱгıܺݿ⹦ܣʹϢϵͳܵõܴߡ绯ϢǸݽĽĻݿ绯ϢĻˣWebݿϵͳΪϢĻߡ
1 ϵͳṹ
WebݿϵͳһWebΪû桢һݿϢ洢һߵWebɣͼ1ʾWebݳ򻯲ұ׼DBMS(ݿϵͳ)֯ͱ׼ݵĽպʹ洢⼴ǿݿʵ;ҲǹWebڵĸĽûΨһҪڻϰװĳWebΨһҪѧʹõҲWebûͨWebҳʾıݿн͵ĽȡҳӡбнѡԼѯ򡣴ݿȡϢıͼ󡢱ͼλ߶ýʽWebҳʾ

ͼ1WebݿϵͳĻṹ
WebݿּԼŵ㡣WebûĶǳ򵥣ڶݵ˵Էǳ޴ĴЭǳ׳ŵ㡣ݿϵͳŵģͣ洢ͻȡݵĽ׳ķչûӦó߼ߣǿȨͰȫƣԼάԵЧ;ȡƻWebݿϵͳҪּŵ㡣
ƵĻWebݿϵͳһܹӦͨõĲѯݿάϵͳǣھ忪ʱѡһоĿĵʵõϵͳпʹƵϵͳһʼ;ʵԡĿǰƵϵͳΪһWWWվʵֱȫĵӲWebѯԶά߶ȹܡӸԶĽǶȽǵӦеһΣڴ˻ϣչԽΪһҵϵǿ󽻻ʽվṩģ͡ؼǲѯٶȺݸµٶȡӰѯٶȵ棺һٶȣһݿѯЧʡݵĸٶڹԱĹֻн⣬鷢Ͷϵͳʵ塣
2 ݿ
ĿǰȡݿĽҪУ
(1)CGIͨؽӿCGIǵǰΪõһּCGI׼ѡʹöֲͬд̬WebĵЩ԰FORTRANCȱԺPerlTCLUNIX ShellȽԡͳCGIкܶȱ㣺粻׿޸ĳɱߡޡ׾Ͳ߱(Transaction)Ĺܡọ̈ÿһҪһ½ȥûʸ߷ڣĽ̻ĵϵͳԴʹվֳӦʱӳ
(2)ISAPI(Internet Server API)MicrosoftΪһַ̽ӿڱ׼DLLȳķʽɼһЩCGIеƣǶ̵⣬ΪչCGIṩһЩô
(3)NSAPI(Networks Server API)NetscapeISAPIƣNetscape
(4)ScriptԣĿǰȡݿĽڷм򵥵ScriptűԡṹѯSQL׼HTML룬ͨODBCӵݿ⣬SQLɴȡݿ⡣νēűԴ따ͨı׼HTMLģ塢HTMLģ壬ԼʹһScriptHTMLģSQL
(5)JavaSun Microsystems˾ǵǰԡJavaһǿġṹȫ򵥡󡢷ֲʽ̺߳Ͷ̬翪ԡͨJavaЧݿAPIʹJDBCûܿڶݿƷƥӦóApplet
ѡASP/ADOݿϵͳĿ
ASP/ADOMicrosoft¼ݿ߱ص㣺
(1)̼򵥡ASPʹýűԣֱǶ뵽HTMLУҪӼֱСűԵǼѧұ༭͵ǳ㡣
(2)㡣ScriptԶǶ뵽ҳHTMLУʹScriptHTMLĿһɣǳ㡣ļHTMLǷģHTMLıдȫͬĹ̡
(3)ֹ֧㷺ASPͨActiveX Data ObjectʵݿȡܡͨODBCӶݿ⣬FoxProdBaseMSSQL ServerOracleInformixDB2Ҫݿ⡣
(4)ԡASP֧VBScriptJavaScript⣬Բʽֵ֧ԣPERLTCLȡ⣬ASPͨActiveX Server Components (ActiveXԪ)书ܡVisual BasicVisual C++COBOLȳЩActiveX Server Components
(5)
(6)޹ءе֧ASPΪűǷ϶ڿͻУ͵ϵWebҳWebɵģԲصܷűWebѾнűĴ׼HTML䵽ֻнűĽصԷ˽ű׸ơûҳĽűǿֻǱ׼HTML
ASPͨ׺Ϊ.aspļʵ֣Web.aspļʱASPűʼСȻWebASPASPȫȡļִнű̬Webҳ͸
ASPлMicrosoftIIS(Internet Information Server/Windows NT)PWS(Personal Web Server/Windows 95/98)Web ServerװActive Server PagesȻҲASPһޣNTƽ̨гռʵѸASPص㣬ASP
Windows NT ServerIISIIS3.0ṩַWWWGopherFTPWWWΪͻύWebҳͻ.aspļֱӰװʹµIIS4.0汾ΪиǿߵWebܺͰȫԡ
ݿⷽ棬ϵݿ(DBMS)ȡ֮ǰĲͺ״ݿ⣬Ϊݿṹʽѯ(SQL)ǹϵݿѯ㷺һԣһܺܺõزݺͷݵԡSQL仹ԱǶ뵽һУӶʹݿȡܡSQLһֽʽѯԣûֱӲѯ洢ݣһԣûں̵ܶʱڻش൱ӵ⡣ǲñ׼SQL-92Ϊݿѯԡ
ͬʱǲMicrosoft SQL Server 6.5ΪݿһģܵĹϵݿϵͳרΪͻ/ơĿʽϵͳϵṹǿĹߺݸƹΪϢṩһ׿Խƽ̨
ʹõһϵпߺͻ¡
ϵͳWindows NT 4.0
WebIIS 4.0
ݿMicrosoft SQL Server 6.5
ߣVisual InterDevFrontPage 98Visual J++6.0
3 ϵͳ
ϵͳʹ߷ΪࣺԱ˾עûһûԱվݿάְȨʹߵʹȨ޺ԼԸݿȽά͹˾ͨԶ±˾Ϣݲѯ˾Ķעûӵжġѯʵͻÿ֪ͨȨһûֻͲѯ۵Ȩ
ͻݲɼϵͳһҪܣϵͳͨעɼͻݣһûͨдעΪעûԱעݽк˶ԣӶûͬʱעûȨޡ
ݿ
Corbtab洢˾ϵͳԱϢȨޡCorp-idǹ˾ţCorp-cityCorp-nameCorp-addressCorp-connectֱڳС˾ַϵCorp-passwordǹԱ͹˾룬remarkǱעidentifyʹȨޣվԱΪ9ռȨޣɹ޸еı˾Ȩ޵ڡ9ɹ˾ݿ⡣ؼCorp-id
Hardware洢ӲϢhardware.Corp-id=corptab-Corp-idhardwarecorptabĹϵHard-categoryHard-brandHard-specofferֱΪӲࡢƷơͺźͼ۸ڵӲ۸仯Ѹ٣DateΪӲ۸ڡTimestampǱؼ֣ӲĲƷкš
Software洢Ϣsoftware.Corp-id=corptab-Corp-idsoftwarecorptabĹϵSoft-categorySoft-brandSoft-madeofferֱΪࡢơ˾ͼ۸۸ȶdate־ͬTimestampǱؼʣĲƷкš
Customer洢עûϢCust-idCust-nameCust-profCust-cardCust-addressCust-phoneCust-emailCust-passwordֱΪûIDְҵ֤롢סַ绰E-mail룬timestampûעʱ䡣ؼCust-id
Ordertab洢Ϣͨordertab.cust-id=customer.cust-idordertab.productID=hardware. timestaordertab.productID=hardware.timestampcustomerhardwaresoftwareϵProductIDǶƷıţOrder-numberDateǶͶڡ
4 
(1)ݿӣԡ
ʹASPServer.CreateObjectADODB.ConnectionADODB.RecordsetʵţʹýűԵıָΪʵConnRSֵעǣʹҪʹConn.closeرݿ⡣
(2)׼Sqlѯ䣬ȷѯ
ûĲѯȷSQL䣬ȻʹSourceԼ¼SQL˵ʹOpenַͣԵõŻܡѭ˳ƹݡʹRS.EOFǷΪжϹǷ񵽵סøɲѯѡûѡȷѯ
(3)޸ݿ⡣
ûӡ޸ġɾҪȷӦSQL䡣ȻʹִݿĲ
(4)顣
еҳҪܽ롣checkûûݿȡ룬ûбȽϡȷʾҳ档ȷûSessionСҪҳ棬SessionݿȡûУ飬תʼҳ档Աҳֱҳ档⣬˳ʱҪʹע˳SessionCookeеݣⱻá
(5)
ûʹCheckBoxѡѡ񶨹ƷͨƷкΨһȷͱʶƷSession("ProductLink")УʹñSUM㶨Ʒܼۡû޸Ķ˻ضordertabУڶʷвѯ
(6)ѯҳʾ
ݿзϲѯļ¼һԵĶrecordsetУڴУȻͨADORecordsetṩļרַ֧ҳԣPageSize(ҳС)PageCount(ҳĿ)ԼAbsolutePage(ҳ)ҳÿҳΪʾʮС
5 ݿ
ݿеķΪ
(1)ͽĿ¼IISеȡĿ¼µġ_privateĿ¼Ա༭Ŀ¼·Ŀ¼ͨ_private·ΪC:\Inetpub\wwwrootĿ¼ϵͳĬϵWWWĿ¼Ȼ󣬽.aspļƵ:\Inetpub\wwwrootĿ¼¡Ҫע⽫Ŀ¼ķȨѡΪִСűΪ˰ȫòҪΪȡ
(2)ԴƣѡODBCݿļASPDatabaseAccessͨADOӲWebݿķDSNDSN-less֣
DSN(Data Source NameԴ)һϵͳԴƣODBC¼УݿļΪSystem DSNASP<%connstr="DSN"%>ָDSN
DSN-lessһͨASPļֱָݿļλã轨DSNķ๫˾ûԼWEBǵվǴԶ˵ϣҪ޸DSNñȽ鷳ʹDSN-lessֱָԶݿλǡǡһ⣬£
<%connstr="DBQ="+server.mappath("database/source.mdb")+";
DefaultDir=;DRIVE R={Microsoft Access Driver (*.mdb)};DriverId=25;
FIL=MS Access;ImplicitCommit Sync=Yes;MaxBufferSize=512;
MaxScanRows=8;PageTimeout=5;Safe Transactions=0;
Th reads=3;UserCommitSync=Yes;" %>
ָҪӵݿ󣬾Ϳͨ·Ӳݿ⣺
<% Set Conn=Server.CreateObject("ADODB.Connection")Conn. Open constr
%>
6 ܽ
WebݿϵͳǵչĻASP/ADOһ²ѸٷչļѸȡͳCGIĵλΪݿͶ̬ʽվмASPѾNTƽ̨ˡҪڷNTƽ̨ϿASPӦóǿһΪInstantASPĵHalcyon˾ʹظԭASPӦó򼴿Խκβƽ̨ϡʹASPΪһֿƽ̨InternetIntranetExtranetӦóInstantASPṩASPActiveXEnterprise Java BeansCORBA-compliant objectsӶʹASP˸Ϊ㷺ӦáͬṩͨADOӿڷӸݿ⣬ɶ̬ҳǿܡڿ߶ԿʹñԻ򹤾磺Visual BasicJavaScriptVBScriptC++JavaHTMLDelphiVisual InterDevп
ʵѧӹϵ 人 430074
ѧӹϵ 人 430074
½ۣѧӹϵ 人 430074
л貣ѧӹϵ 人 430074
ο
1. NTݿٳɗʵй, 1998
2, , ¬ͮ. JavaԼӦ. 廪ѧ, 1996
3Curt Lang Jeff Chow. ֮Ӣ, . WEBINTRANETϵϢ漼. ӹҵ, 1998
ոڣ199983
