BQ GIAO Dl)C vA DAo T~O TRUONG D~I HQC DAN L~P NGO~I NGU - TIN HQC TP.HCM KHOA CONG NGHt THONG TIN ~ A K A KHOA LUAN • TOT NGHIE• XAYDVNGHtTH6NGQuiNL~ CHUONG TRINH VA KRACH DU LlCH TIffiN WEB SERVER GIANG VIEN HUONG DAN: LE HOAI BAC SINH VIEN THl)'C HItN : HUYNH ANH THANH PHO HO CHi MINH - 2001 • Loi rnd dgu Chuang 1 : T6ng quan v~ IIS 1. lIS la gl ? 2 1. HO(;ltd,Qng cua lIS 2 1. Cai d~t lIS tren NT Server 3 Chuang 2 : T6ng quan v~ ASP Database 2.
Cac d6i t~<1ngActive Server 8 2. M6 hlnh d6i tu<1ngcua ADO 9 2. Ca i d~ t DSN 9 Chuang 3 : M6 hlnh d6i tu<1ng ADO 3. D6i tu<1ngCornrnand 19 Chuang 4 : Gidi thi~u v~ Visual InterDev 4.
Ctta s6 sO(;lnthao HTML 22 4. HQP c6ng Cl,l 22 4. Stt dl,lng che' dQ Design-View 23 4. Stt dl,lng che' dQ Quick-View 24 4.
Stt dl,lng che' dQ Source-View 25 4. Ctta s6 Project Explorer. Qucln 19 Web Project 26 4. T(;lo mQt Web Project dan ginn 31 4.
Cac khai ni~m v~ Web Project. Queln 19 cac Web Project. Tuang ta c vd i CS DL 44 Chuang 5 : Phan tich va thie't ke' 5. Phan ti~h hi~n tr(;lng.
Thie't ke' va xay dlfng CSDL. Xay dlfng til diSn dG' li~u. Xay dlfng m5i ke't h<;1pgiua cac thlfc th~ 51 5. Me hlnh thlfc th~ ke't h<;1p 61 5.
Me hlnh quan h~ 62 5. Me hlnh Logic 62 5. Phat tri~n cac rang bUQc toan v~n 63 5. Me hlnh xU'1y 64 5.
So d6 ngu ca nh 64 5. So d6 dong du 1i~u d~y du (DFD) 64 5. T6 chilc v~t 1y 65 Chuang 6 : Thie't k,e' ph~n m€m 6. Bang xac dinh t~m anh hUdng 76 6.
Thie't ke' giao di~n chinh 76 6. Thie't ke' cac giao di~n truy xuat va c~p nh~t du li~u. 79 Tai 1i~u tham khao Y' • 1 _ ••. ? LOICAMON Em xin gdi Wi cam on den giang vien huang dfrn d5 t~n tlnh giup do em co du di~u ki~n va hi€u biet d€ tIm hi€u va hoan thanh lu~n an.
Va em dIng chan thanh biet on Nha Truong va tfit ca cac thgy co d5 d~y d6 va huang dfrn em xac djnh du<;1chuang phan tich va xay dlfng phgn mSm.4 • 'w " ? ~ LOI M<1 DAD Xa HQi ngay cang phat tri~n thl vai tro Clla vi~c xU'1y thong tin ngay cang trCl nen quan trQng. LUQng thong tin 1a rnQt kho'i dfi' li~u IOn rna vi~c xU'ly l'.li doi hoi to'c dQ tinh toan nhanh voi tinh chinh xac cao. Vi the, nhu c~u tin hQc h6a cac cong vi~c xU'ly thong tin 1a thiet thljc va ca'p bach. Co sCidfi' 1i~u 1a rnQt trong nhfi'ng lTnh vljc dUQc quan ta m d~ ph~lc V~I cho vi~c 1uu trfi' va truy xua't thong tin.
Tuy nhien, khi vi~c trao d6i thong tin tren the gioi dang pha t tri~n voi to'c dQ ra't cao thl vi~c truy c~p thong tin qua Internet trCl nen ph6 bien. Trong nnh vljc Co SCIDfi' Li~u thl vi~c dua thong tin len trang Web va c~p nh~t chung 1a rnQt yeu to' khong th~ thieu. 8€ tai clla kh6a 1u~n nay se tdnh bay cach t'.lO cac trang Web cho phep nguoi sU'd~ng tuong tac d€ dang voi cac may Chll va co sCidfi' li~u sU' d~ng ASP (Active Server Pages). ASP 1a rnQt co che dUQc hang Microsoft J.
phat tri~n d~ lien ket rnQt so' cong ngh~ nh~rn t'.lO nen cac trang Web hi~n d'. Trong nhfi'ng cong ngh~ d6 c6 ADO (ActiveX Data Object) SU'd~ng ASP se t'.lo cac trang Web dQng ket no'i den t~p tin CSDL d~ 1a'y, hi~n thj thong tin, d~ khi khach hang truy c~p den trang Web, hQ se tha'y dUQc tr'.lng thai hi~n t'.li clla CSDL. Ba't Cll khi nao ta chinh slta dG' li~u, slj sU'a d6i d6 se dUQc tlj dQng phan anh ngay len trang Web. Vai ASP/ADO nhan vien c6 th~ c~p nh~t va thao tac, truy xua't til xa.
Khach hang c6 thci dang ~y cac yeu c~u (c~ th~ trong d€ tai nay 1a dang ky cac chuyen di ho~c dQc thong bao v€ chuyen di rnoi dUQc hO'.lch djnh s~p tai) ma khong c~n den cong ty. 'r- T6ng quan v~ lIS 2 • u ,,? ~ CHUONG 1. TONG QUAN VE lIS (INTERNET INFORMATION SERVER) 1. lIS Iii gi ? Microsoft Internet Information Server la mQt Web Server giup hi€n thi thong tin tren Internet ho~c Intranet.
IIS hi€n thj thong tin b~ng cach su d~ng giao thlic HTTP. Ngoai ra, IIS con ho tn1 cac giao thCfc truy~n file FrP (File Transfer Protocol - giup ngu'oi su dl:lOg chuy€n nhung t~ p tin til Web) va Gopher,Services (dung Menu Driven Protocol d€ xac dinh vi trf Clla tai li~u). Ho:;tt dQng ella lIS Web co ban la mQt h~ thong yeu c~u va tra loi. Cac Web Browser yeu c~u thong tin b~ng cach gdi cac URL de'n cho Web Server, Web Server dap ling b~ng cach tra l~i cac trang HTML.
Trang HTML la trang Web tInh da du'<;5C dinh d~ng va tich tru trong Web site, la trang rna Server t~o ra cho vi~c tra Wi cac thong tin du'<;5ccung ca'p til phia Client ho~c la trang ghi nhung t~p tin va Folder co gia tri tren , Web site. Moi trang tren Internet co mQt URL duy nha't d€ phan bi~t. Web Browser yeu c~u b~ng cach gdi URL de'n cho Web Server. Server dung thong tin trong URL d€ trlnh bay trang.
Web Server dap l~i nhung yeu c~u trang clla Browser b~ng cach tra l~i trang HTML. Trang HTML clla Web Server bao g6m: • Trang tInh : La nhung trang HTML du'<;5cchuffn bi tru'dc trong nhung yeu c~u clla Web Server d€ tra l~i nhung trang cho Client. User t~i Browser yeu c~u trang HTML tInh b~ng cach danh VaG URL ho~c nha'p vaG di€m ke't noi vdi URL, yeu c~u nay du'<;5CBrowser gdi Wi Web Server va Web Server gdi l~i trang HTML. • Trang dQng : d€ co kha nang tu'ong tac vdi ngu'oi su d",ng, c~n phai co nhung trang Web dQng.
Web Browser t~p h<;5p cac thong tin til ngu'oi dung (thong qua form nh~p li~L1)va chuy€n v~ Web Server. Web Server se ch~y cac ling d~ll1g • T6ng quan v€ lIS 3 'y c~n thie't d~ xU' 19' cac thong tin tren va ke't qua cuoi cung v~ Ii la trang HTML gdi tdi cho Browser. Citi d~t lIS treD NT Server ASP la mQt ph~n cua lIS trong NT Option Pack 4.0 Cai d~ t lIS va ASP 1. Cai d~t Windows NT Server 4.
£)~u dung t1t ca cac dich Vl}dang dung ODBC, co ca SQL Server. £)~ cai Option Pack, phai cai Service Pack 3 trudc. IE phai dU<;Jccai d thai di~m nay theo yeu c~ u cua NT 4. Option Pack chua ph~n m€m lIS cung ASP engine.m cach cai d~t di~n hlnh se cho phep cai t1t ca cac thanh ph~n c~n thie't d~ ch<;tyASP va ADO tren NT cung vdi mQt so thanh ph~n phl} khong c~n thie't cho ASP-ADO.
Con ne'u ta chQn cach cai d~t theo yeu c~u (custom installation) thl phai chQn du cac thanh ph~n sau : •. Internet Service Manager: day la ph~n plugin vao Microsoft r Management Console d~ quan tri lIS 4.0 • World Wide Web Server: thanh ph~n chlnh cua lIS • Data Source: day la cac driver va provider dung d~ truy xu1t cac ngu6n dG'lit%uthong dl}ng nhu SQL Server, Oracle va Access. • MDAC: thanh ph~n chlnh cua ADO cung vdi cac t~p tin OLE DB va ODBC.' • Microsoft Management Console: chuang trlnh giao tie'p d~ thtfc thi cac thao tac quan trio • NT Option Pack Common : t~p tin bao g6m cac thanh ph~n chinh cua Option Pack. • Transaction Server Core Components: chua cac thanh ph~n chinh cua Transaction Server c~n cho lIS 5.
Sau khi b<;tnda: chQn cac thanh ph~n va thu ml}c dkh, chQn local lam tai khmln quan tri cua Microsoft Transaction Server 6. Ch<;tyMDAC Service Pack mdi nh1t. T6ng quan v~ lIS 4 8. Tim cac t~p tin Adovbs.inc (VB Script) va AdoJavas.inc (JScript) tren c1Iachuang trlnh g6c va chep chung vao thu ml;}cg6c cua Web site hay mot thu ml;}c rna bC;lntruy xufft chung d~ Iffy cac h~ng s6 ADO.
Chung thuong dUQc d~ t trong thu ml;}cProgram files\Common files\system\ado 9. Md MMC va tIm de'n thu ml;}clIS. Md thu ml;}c d6, sau d6 rnd bi~u tUQng hlnh may tinh c6 dffu * ben cC;lnh,man hlnh sau se hi~n ra : ~ Console Root B.[1!) Internet Information Server ; B.~' working $@ Default FTPSite. Administration 'Web Site ! [iH!@ Default SMTP Site r ffi.~ Microsoft Transaction Server C:\I netpub\iissamples C:\'WINNT\S ystem32\inetsrv\iisadmin C:\'WINNT\Help C:\I netpub\scripts C:\ WI NNT\S ystem32\inetsrv\iisadmpwd C:\Program Files\Common Files\system\msadc 10.
Nhffp chuot phai len ml;}c Default Web Site va chQn Properties. Trong tab Documents them vao Default.asp hay ten bfft Cll trang nao phu ,. hQp voi yeu c~u cua bC;ln,thong thuong se belt d~u voi Default.asp T6ng quan v~ lIS 5 f 11. V~n a trong hQp thoC;liProperties, chuy~n sang tab Home Directory va ki~m tra xem Permissions dii du<jc thie't l~p la Script hay chua.
, • T6ng quan v@lIS 6 Default Web Site Pl'operties Documents HTTP Headers Web Site ] OQerators I ISAPI Filters When connecting to this resowce, the content should come from: • e;. located on a\'lother comJ:1uter n A redirection to a .tRL Local Pa!h: f C6ng vi~c cai d~t ASP tren NT voi lIS toi day coi nhtt ke't thuc. [1 , 32-34] I T6ng quan v~ ASP Database 7 CHUONG 2: TONG QUAN vI: ASP DATABASE Trong ali li~u nay chi d~ c~p den ASP du'Qc dung d€ thiet ke nhung trang Web tu'dng tac vdi CSDL. Gi6'i thi~u : ASP la mQt cong ngh~ mdi du'Qc du'a ra d€ lien ket vdi mQt so cong ngh~ nh~m t(;lOcae trang Web hi~n d(;li, cho phep ngu'oi sU'dl,lIlg tu'dng tac d~ dang vdi cac may chu va cd sd dG' li~u.
Cong ngh~ nay du'Qc ap dl,lng t(;li Web Server. MQt trong nhung thu~n IQi rna ASP mang l(;licho cac nha t(;lOling dl,lng tren Web la kha nang cho phep sU'dl,lng h6n hQp giUa cac ngon ngG' l~p trlnh va ngon ngG' HTML tren trang Web. Cac nha t(;lo ling dl,lng tren Web co th€ h/a chQn ba't ky lo(;li ngon ngu nao thkh hQP. ASP con h6 trQ cac giao tiep ngon ngG' cua ActiveX g6m: VBScript, Jscript va PerlScript.
D€ khai baa mQt ngon ngu muon sU'dl,lng ta dung the (tag) <script></script> vdi Cll pha p nhu' sau : <script language="VBScript"> '-. : <!script> ASP la mQt p.h~n md rQng cho Web Server. No cung ca'p mQt t~p hQp cac thanh ph~n (component) va doi tu'Qng (object) d€ quan ly sl! tu'dng tac vdi giG'a Web server va Browser. Cac doi tu'Qng nay co th€ du'Qc xU'ly bdi Scripting Language (VB Script, Jscript,.
) Server Response Object Object. Server Request Object Client Application Obect Object Context Object Server Object - I T6ng quan v~ ASP Database 8. Cac d6i tu'Q'ngActive Server: Co 6 d6i tu<jng Active Server dU<jc t~o san, m6i d6i tu<jng lien quan de'n m(H khia c~nh d~c trung clla s11tuong tac : • Request • Response • Server • Application • Session • ObjectContext D6i tu<jng Request xu 19 yeu c~u rna nguai dung dua ra cho mQt site hay mQt ling dl;mg.