Ӧо
APPLICATION RESEARCH OF COMPUTERS
2000Vol.17No.5P.67-69



C/SģʽOPACƺʵ
ʡŸסΰ졡ɷ
ժ  Ҫ  ϸ˿ͻ/Ķģʽ˻ͻ/ģʽOracle Application Server Ľṹʵֻƺʵѯ(OPAC)ķʵ
ؼ  ͻ    Web  ݿ
1  
缼ѸͷչռڸıŴͳͼݵķģʽͬʱҲͼԶϵͳ˸ߵҪͼݵϢŵӻֻԶ̻Դķչ֧InternetѾΪһͼԶϵͳҪ־
ʡίĻϢϵͳǽױϵͳ(JALIS)һҪɲ֣ǻڶƽ̨(Windows NTUNIX)ʹݿ(Oracle)ÿͻ/ϵṹһͼݹϵͳϵͳȫΧʮҸУͼݰװʹãƶͼҵı׼ӻȡ˾޴Ч档ӹ,ϵͳɷáĿءͨڿͳơZ39.50OPACȶϵͳ
OPAC(Online Public Access Catalog)ϵͳУǲOracle Application ServerC/SϵṹṩInternetĸЧĽʽĲѯ,ʵĿѯϢͨ鿯ѯ鿯ԤԼȷ
2  ͻ/ϵ
ͻ/ϵͨΪģʽȡӦ߼ڿͻ˺ͷηֲСĿͻ/ϵֻпͻ˺ͷˡӦ߼ɢڿͻ˺ͷˡͼ1ʾ

ͼ1ͨC/Sģʽ
C/SģʽݴϵͳĿ,ԴӦ֮ʵ˽ϺõĶӦõķ롣ڵӦϵͳУC/SģʽǱȽϳļڴ󲿷ֵӦҲԽܡģʽ಻֮ͻͬʱʾ߼ͲӦ߼,һַʿͻʽӦõĸ,Էֲڿͻ˵Ӧϵͳά൱ͬʱӦ߼ɢڿͻͷˣϵͳƺʵ˸ӶȺάѶȡ
C/SģʽĲ㣬ṹչΪṹѿͻ˺ͷеӦ߼פм㣬Ӧ߼㣬ʹ÷ֻݷ񣬿ͻֻʾ߼Ӧó档Կͻ˵ƺͿҲ˱ü򵥣ͬʱҲ˿ͻӦõĸģʽµĿͻ˳ΪݿͻˡʵʵӦУΪӦ߼һֵĴ洢̺ʹȻפݿУԻݿȫֺ֧ŻܡϵͳOPACϵͳC/Sṹĳɹ
3  OASṹ
Oracleģʽ(NCA)һģʽOracle Application Server(OAS)Ϊģʽм㣬Ӧ߼㣬ṹͼ2

ͼ2OASC/Sģʽ
ݿͻ˵3ṹУͻģ԰أҪڱʾӦõûӿڡӦ߼мʵֻPL/SQL洢̺JAVA̵ʽ洢ݿС
Ϊ3ṹм㣬OASṩͻ˺ݿ֮ŻӿڡOAS֧¶Ӧ:
ͨؽӿ(CGI)Ӧ

JCORBAӦ
ҵJAVABeansӦ
OPACʵ,ֻ֧HTTPķ,Ϊ˶̬شȡOracleݿеϢ,ѡOASĲ(Cartridge);̬HTMLĵϸOPACϵͳʹõOASؼͼ

OASṩԼWebҲּ֧ܹʹǹͬͷܼһ𣬻Żܡ

һһڵϵĲʵÿһʵ(ͼ2)ÿڵֻһڷάһ¼ŵǰõĲ һĳķʵʱ,ݸʵ͵ĲڻûпõĲ,OASִĲһ²ִĲѾٴĲOASһµĲµĲһµĲȻµĲĻ壬ѽķɺµĲԼΪµʹá
Ͳ
OASṩһֹܸǿ󡢸ЧķӦãΪһһ⣬ʵ˳߼ṩ˶Դ洢طݿеĳ߼ʡһ̣һʵʵڲִвCORBA
CGI򣬲ΪÿһOASͷݵǰķöԽ䲢вĲڽշʵͬһУڶ̨Ϸ䡣ԲչܹԶӦ߸
OASֲֶ֧,PL/SQLJWEBCLiveHTMLPerlݲͬĲԹͬӦá
ӦúͲӦ÷йӦõҪĶһִӦ߼ĴͶλӦ߼ݡPL/SQLʹ֮OracleݿִPL/SQL洢̵ִд롣˵ӵĸOracleݿ⼰õû롣ͬʱҲӦ÷ͨšӦڡһӦðһЩͬһֲ͡ÿӦúͲһڡÿֻһӦá
һӦʱʹý̵Ĳʼһʼ󣬾ɲԿͻ˵磬ͼ3ʾӦУAӦ1һӦ2ڲ1Ӧ1һʵУŲC1ʵͲC2ʵеĲʼC1C2

ͼ3Ͳ
OPACʵʹPL/SQL޶ȵݿܡPL/SQLûʹOracleݿеĴ洢ӦáÿPL/SQLһDAD¼ݿݡDADָݿDSNûȷһԴԸԴķȨޡһPL/SQLҲһ·ͨ·صPL/SQL԰һPL/SQLǵһӦáӦõĸʹһΪһΪеĲͬһС
OASյһʱ
1)յͻ˵һ󣬾˭ӦôOPACϵͳУ󴫵ݸWRB(Web Request Broker)Ϊǹڲġ
2)·WRBPL/SQLӦôȻ󴫵ݸӦõĲ̡
3)ڲڣPL/SQLDADȷҪӵݿ⡢PL/SQLͻ
4)PL/SQLݿ⣬׼òȻݿеĴ洢̡
5)洢HTMLҳ棬пܰݿж̬õݺ;̬ݡ
6)洢̵صPL/SQLͿͻˡ
õĴ洢̱뷵HTMLʽݵͻˡΪ򻯲PL/SQLṩһWeb߼(the PL/SQL Web Toolkit)ڴ洢ʹãԻϢHTMLǡͷϢȵȡ
ʹPL/SQLŵ㣺
Ӧ߼Դ洢̵ʽ洢ݿ
޶ȵеĴ洢
İȫ
зʹö̬HTMLҳĹ߼
4  OPACʵ
ͼݵOPAC(Online Public Access Catalog)ҪߣṩۺϢѯṹͼ4

ͼ4OPACṹ
ĿѯΪ˵PL/SQLʵݿͻ˵ӣӦͻ˵󣬻ȡݿݣ̬HTMLҳ淵ظͻ˵Ĺ̡ͨOPACеĿѯ棬URLΪhttp://libsys2000.nju.edu.cn/ opac/opac.complex_searchOASӦ󣬸URLе·'opac'ѡPL/SQLPL/SQLӺ̨Oracleݿ⣬ݿopacеĴ洢complex_search洢УͨOASWeb߼ṩHTP̬HTMLҳ棬ֱӷͱȡΪɵHTMLҳĿһ
洢complex_searchʾ
create or replace procedure complex_search
is
cursor c is select doc_type_code,doc_type_name from
doc_type_code
where code_use_flag = '1';
begin
htp.formOpen('opac.adv_search_chk');
htp.p('<table border="0" width="100%" cellpadding="3">');
htp.p('<caption align="center"><h1>鿯Ŀ¼ѯ</h1> 
</caption>');
htp.p('<tr><td width="50%" height="24"><p align="right">
  </td>');
htp.p(' <td><input TYPE="text" NAME="title" SIZE="20" MAXLENGTH="80"></td></tr> ');
htp.p('<tr><td width="50%" height="24"><p align="right">
ȡţ</td>');
htp.p(' <td><input TYPE="text" NAME="call_no" SIZE="20" MAXLENGTH="40"></td></tr> ');
htp.p('<tr><td width="50%" height="24"><p align="right">
ͣ</td>');
htp.p(' <td><select name="doctype" size="1"> <option selected value="*"></option> ');
for r in c loop
htp.p('<option value="'||r.doc_type_code||'">'||r.doc_type_name||'</option> ');
end loop;
htp.p('</select></td></tr> ');
htp.p('<tr><td width="100%" height="24" colspan="2" align="center"><input TYPE="submit" VALUE="ʼѯ">');
htp.p('<input TYPE="reset" VALUE=""> 
</td></tr></table>');
htp.formClose;
end complex_search;
洢complex_search̬ȡݿݣHTMLǼϢɵHTMLĵIEʾͼ5

ͼ5鿯Ŀ¼ѯ
OPACʵУеHTMLĵPL/SQL洢̶̬ɡڲҪݿֱʹ˾̬HTMLҳ档󵽴OAS ʱ·Ĳ̬ͬHTMLĵֱӴOASзأӦٶȵЧʡ
5  
C/SģʽOracle Application ServerOracleݿܽϣOracleݿǿܣṩ˿ٸЧWebOPACϵͳȫʮҸУͼݵʹУܻûһº
(Ͼѧϵ  Ͼ 210093)
Ÿ(Ͼѧϵ  Ͼ 210093)
ΰ(Ͼѧϵ  Ͼ 210093)
ɷ(Ͼѧϵ  Ͼ 210093)
ο
1Oracle Application Server Document
2Scott Urman. Oracle8 PL/SQL. : еҵ
ոڣ1999-12-27
