ѧ
JOURNAL OF SOFTWARE
1999 1 No.1 1999



Intranetݿмԭ͵о빹* 
1ʢ2 
ժҪоͷIntranetϳõݿӿڷ,ڴ˻,һDB(database)мʽIntranetӦõ·.ͨݿӺͷʻƵĹ,϶ûݿ,Ż紫,֧ݿĽӿ.ϸظ˻ڸ÷DBм˼롢ʵַͲõĹؼ.
ؼʡIntranet,ݿӿ,м,Java,JDBC(Java database connectivity).
ͼšTP393
Research and Construction of a Database Middleware Prototype on Intranet 
MA Song1SHENG Hao-lin2 
AbstractIn this paper, the common database interface methods on Intranet are studied and analyzed. Based on that, a new method using DB middleware under the Intranet environment is posed. The key point is to provide an efficient and powerful mechanism to manage database connection and data access to meet the needs of application requirements. It will improve the network performance for multi-user accessing database and optimize network transmission. It can provide the interface with the various RDBMSs (relational database management systems). The design considerations, the implementing and the critical techniques used are given and explained in detail in this paper.
Key wordsIntranet, database interface, middleware, Java, JDBC (Java database connectivity).
ҵӵе󶼴칹֮,̨ʽϵͳΪĵĿͻͲͬ͵ķ.ϵͳ,ԺͻԲ,ϵͳ,ɴ˵ҵĿɿԺͰȫԵò֤,ʹò,ϵͳֺ֧άþӸ߲.Internet/IntranetӦһµҵϢĸ.׵ظıҵԭйģʽ͸ҵ֮估ҵ֮ϵʽ,ʹҵչзĹЧ.IntranetInternetչ,дͳҵڲܺͰȫ,־InternetĿԡ,ʹҵܵΪһ.ĳΪҵṩһʵе;.
IntranetҪΪ3ӦòΣϢ뷢ӦýϢȡԼҵҵ.߾ݿ֧еϵ.Ӧõڸ,ݿʱĹܺҪԽ,Ƕĵ3Ӧ.ǰ,WebӦõķѲܺܺõӦõҪ.Ϊ,һDB(database)мʽIntranetӦõ·,һDBмԭDBCM(database connection manager).ͨݿӺͷʻƵĹ,϶ûݿ,Ż紫,֧ݿ.ĵ23ڽDBCM˼롢ʵַͲõĹؼ.
Ŀǰ,ʵIntranet϶ݿʵĽӿڴ¿ԷΪ3֣1
(1) ͨؽӿCGI(common gateway interface)
ͨؽӿһڿͻWebWebCGIӦó֮䴫ϢĹ淶,HTTP(hyper text transfer protocol)С̸һַʽ.
CGIӿΪHTTPִгṩһּõķ,ʹֻ̬ĵԼΪHTTP֮ķ֮Ľӿ.CGIӿô,֮Ŀֲ,ԼĹ(ѳ)ΪƵĿ.ƾ,еWeb֧CGI.,CGIӿҲһЩ,Ҫľ,رҪݿӵĶûӦó.CGIܱͻ,һµ󵽴ʱ,ʹCGIһʵ,Ҳһµʵ.Խ,ϴĲҲԽ.Ϊÿ󴴽һӦý̻Ľ϶ʱҪڴ,ͬʱӦóõԴ,յܽ,ӵȴʱ.
(2) רAPI(application programming interface)
CGI֮,ΪWebݿ֮ͨЧʺ,Web̺ݿ⳧̷׷ƳԵרAPI.
Webݿӷ,NetscapeMicrosoftΪWeb̷ֱƳڸWebNSAPI(Netscape server application programming interface)ISAPI(Internet server application programming interface).CGIΪĽвͬ,NASPIISAPIԶ̬ӿʽڵ,NSAPIISAPIӦóЧʺ֮ܽCGIдȵ.Ȼ,͵APIҲһЩȱ,,NSAPIISAPI໥֮䲻ݣֻضķͲϵͳУڲ˶̬ӿʽ,һϲͱȽɷϵͳıҽгʱ.
ݿ⳧Oracle,SybaseInformixṩWebݿĽӿڷԵݿƷܼ,ЧʡܻǰȫԷ涼ﵽ˽Ϊˮƽ.Ҳֽܼ,ֻܾڸԵݿƷ֮,ԼԺͿֲԲ.
(3) Javaݿ⻥JDBC(Java database connectivity)
Ϊ˿˷CGIݿЧʵͺרAPIֲԲȱ,½ֵJDBCһֽΪĽӿڷ.JDBCִSQL(structured query language)JavaӦóӿ.һJavaдɵͽӿ,κιϵݿⷢSQL,ֶ֧Զݿķ.JDBC API,ֻдһܹJDBC APIӦݿ.JavaԵԽṹJDBCĿʹóԱֻдһγ.JDBCһͲεAPI,Ǹ߲APIĻ.ԱJDBCĻ,Ƴû⡢ʹõĸ߲εĽӿں͹.
1ݿм
ͨķʽ,ڷRDBMS(relational database management system)ʱҪȽû,ȻͨûӶݿв.,ӷʽܵݿû,ͨDBMSһû,ͨûͬʱӵDBû.DBӵûﵽʱ,µûͻʧ.IntranetӦ,ϻִûͬʱһݿ,ÿûһʱڻᱣַ,Ӷ˿õ.,ûڽпͻ˵Ĵʱ,DBͨǿе,ܹЩʱ,ʹЩܹΪûṩ,ô,ܴͬʱû.ûʹЩݿʱͶϿDB,ȻDBĶû,ǽDBͨ൱ʱĲ(ܰĳͨӡ̡Ȩ޼ȵ),ήݿķӦٶ,ʵʹʱЧʽϵ.ǵ˼ʹöDBӹṩӹķ,ͻֱDB,ͨDBӹ̽,DBҲͨDBӹɵ.ʵϾڿͻӦDB֮һм,Ҳνݿм.2
2ݿмԭDBCM˼
ƺʵֵݿмĻṹͼ1ʾ.ݿӹDBCM(database connection manager)һ,ǰ˵Ŀͻ˵ݿ֮ͨŵ.ͻDBCMĳݿSQLʱ,DBCMǰõݿ(DB Connection),ͨDB ConnectionSQLתӦݿ.ݿִSQL,ͨDB ConnectionظDBCM,ظͻ.ݿмϵṹõ(Three-tier)ͻ/ģ.мͻͨŲ׽(Stream Socket)ʵ,˶̵߳ŵ,ʹмͻ׽ܹͨؽ.мݿĽӿʹJDBC,ҸInternet/Intranetûݿʷʽ,öͻͬһDB ConnectionĻ,ݿʵЧ.ݿмݿ֮ͨʹSQLԶͨŵ.

ͼ1ݿмĻṹ
3ݿмԭDBCMʵ֡
ݿм˼,ʵֹҪĹؼ.
3.1JDBC
JDBCһDBMSĽӿ,һͨSQLݿʿܡ,ڲͬݿʹͳһĽӿ.ʹJDBC,Աֻдһݿӿ,±ܹκԴ.JDBCѾ𲽵õ˸̵Ͽ֧,ҲΪߺûṩһWebݿĽݾ,,JDBCһƹճΪWebݿʵ׼.3,о͹ݿмԭ;ǽJDBCĻ֮ϵ.
3.2׽
ЭTCP(transfer control protocol)ṩһֿɿĶ˶Զͨͨ,Internet/IntranetϵĿͻ/Ӧóͨ.׽е֮˫ͨ·һ˵.ӦTCP׽ֳΪ׽,ӵ.Ӧóض˿,ȴԿͻ.һ󵽴ʱ,ͻ֮佨һר,Ǿͨ.ӹ,ͻһض˿ں,һ׽ְ󶨵˿.ͻͨ׽дϢԼ׽жԷϢķʽͨ.,Ҳһµıض˿ں(ҪµĶ˿ںΪ,,ܹԭĶ˿ϼ).Ҳһ׽ְ󶨵ıض˿,ͨд׽ͻͨ.ͻͷʹͬЭ,Ҳ˵,ͨ׽شϢʱʹͬ.ͼ2ʾ׽ֵĹ.

ͼ2׽ֵĹ
3.3߳
߳һ֮е˳򻯿.ָ̳߳ڵʹö߳,Щ߳ͬһʱ䲢,ִвͬ.ڶ̳߳,߳ͨҪ.,һ߳ļд,ͬʱһ߳Ҫļж.̹߳ʱ,Ҫ߳ͬ,ԴﵽԤڵĽ.һм߳ھԴ,ͱʵ֤ͬƽ.ÿ̶߳޵Դܹ㹻ķʱ֤Ľ,ϵͳǹƽ.
ݿм,Ϊÿͻṩһ̵߳ķʽʵ.ݿм,Ҫ4̣߳(1) ߳,(2) ߳,(3) й߳,(4) ״̬߳.м̡߳й߳Լ״̬߳Ƿʼմڵ3߳,߳Ǹݿͻ,.ͼ3ʾ˷̵߳Ĺ.

ͼ3̵߳Ĺ
ڱʵݿмĹ,رע.ǲɿ,ͻͬɿ,Լ˳ֵĳ(Exception Handling).ڳ,Իָĳ״̬,ͷռõԴ.ʧܵĿͻӰ̶߳ͻӦ.ڶ̳߳,ڲʱӦ˯״̬,ͷŲҪռõԴ.,Ҫעٽͻ.Javaṩ˼(Monitors)notify()wait()ԼsynchronizeؼֵȻʵʩ̵߳ͬ.
3.4ͻͬһݿ
ӷʽʹͻһDB,ػ˿ͻܵDBûɵ.ݿмԻطʽDB,˽ͶϿDBʱĿ.RDBMSӿйصĲDBӹ,ʹ֧DBӷ.
DBӷмDBӵķʽõDB(߼),ÿָ(RDBMS,DB,USER,PASSWD).ͼ1пͻDBCM֮Ӿ߼.ʹЩʱ,ֻʹӵֶṩڲϸ.ַʽڼûԾ廷,RDBMSʱ,ͨ޸мĶԱⲻҪĳ޸.
ҪʹûԹһݿ,ҪЩûݿʱõĲ(RDBMS,DB,USER,PASSWD)һ,ֻӲȫһµݿ(߼)ܹһݿ.ͼ2DBCMݿ֮Ӿ.
ݿмṩ,Ļж,ӦDBʵ.ЩֳΪݿм߼ݿ.ݿмҪЩ߼ݿ.ݿм,߼ݿΨһ,ҶӦĳݿ.ÿ߼ݿһ鶨Ϣ,ݿDBûDBû,ʵ߼ݿķʿƹ,߼ݿķû,ڿͻʱʿ,Ƿ.
ݿмĿͻDBӶ߼,Щʵʲݿʱӳ䵽ݿмDBȥ,ͨЩʵʵزݿ.ֶͻݿӵԭǣ(1) ܹӵûDB߼ȫͬ,Ҳ˵,ͬDBûӵͬDBȥ,ֻȫͬӲ໥߼ϵ.ݿмṩ߼ݿ,ֻҪӵͬ߼ݿеû,DBӷʽȫͬ,ҲͿԹ.(2) .DBĻλ.һͻڵڱȫռһ,ʱû.ʱ,ûлSQL,ÿͻڸѾû״̬Դ.״̬µĿͻ໥֮Թ.
ص,DBӵĹĿʼֹ׶ν.ʼʱ,Ҫݿӣֹʱ,ͷݿ.
ݿмݿͨһع,Ҫʱӻзһ,ͷʱͷŵȥ.лݽṹ£
 ݿϢ
class ConnectionInfo {
InfodbInfo=null;
Connectioncon=null;
booleanisIdle = true;
java.util.Date idleStartTime=null;
public ConnectionInfo() 캯
}
 ݿӵĻ
class ConnectionTable {
static final int MAXSERVICE=100;
short serviceCounter=0;
Serviceۣ serviceArray;
Vector connectionInformation;
public ConnectionTable() 캯,ʼ
public Info findDBInfo(Info serviceInfo) ߼Ӧ
synchronized public ConnectionInfo findConnectionInfo(Info dbInfo) Ϊ߼ݿ
synchronized public void deleteIdleConnection() ͷѳʱݿ
}
ͻͨݿмṩ߼ݿ,ͻ߼ϷSQLʱ,DBCMΪ߼ӷӦĿõ(ǰڷӾ½һ),ͨݿͨ.й̶߳ں̨,ӵʹ״̬,ĳѳʱδ(ʱ),ϿͷԴ.
ھʵݿмʱ,ѡJava.Javaǽһ̵ĳ.,ѲJavaԵһֳ,Javaһ,γһµļģʽJava㻷.JavaԵĿ꼰صǣԡ󡢷ֲԡ׳ԡȫԡϵṹֲԡִСܡ̡̬߳.ȻJavaԵķC++ں̶ܴ϶,ǴӸ,JavaȥC++Щʹá⡢׳﷨Ԫ,ڴ͵֧֡תȸȴǿ,ԸӾ,ҲȽ.Javaвʹָ,ʹϵͳİȫԼǿ.4ΪJavaԾرʺ̵Լ֮C++ԵԽ,ѡJavaʵݿм.
,ʵݿмĹ,¹ؼͻ/ģ,Java,SQL,JDBC,׽,޶߳,߶ͻͬһݿ.
4С
ƺͿݿмԭûIntranetϽݿʵص,˶ͻͬһݿӵĻ,ݿƵӺͶϿĿ,ڳԴĻЧ.ϵͳJavaʵ,JDBCݿ,ʹϵͳĽ׳ԺͿֲԵõ˱,ڶƽ̨Ϸʸֹϵݿϵͳ,ǿϵͳӦ.
Ϊ˲Ըݿмԭ͵ʵЧ,JavaԱдһͻӦó.óûĸSQLһЩԶضʽݿϿָ,ЩύDBCMִ,ȻDBCMнʾ.ǲĻͬʱиÿͻ˳Լͬһ̨иóĶʵķʽDBCMĿͻ.ͻ˳Ĳϵͳƽ̨Windows 95,Windows NT Workstation,OS/2,˵DBMSWindows NT ServerϵMicrosoft SQL Server,Sybase SQL Server,SCO UNIXƽ̨ϵInformix,OS/2 Warp Serverƽ̨ϵDB2.ͨԿͻӦóSQLӦٶ,Ƿֵͻʱ,DBCMµӦٶ벻DBCMµӦٶ޼,ʱһЩ.ΪDBCM߼Ҫʱ,ͻ߼֮伸ûпԹ.ſͻ,DBCMϵʾ.ǵĲ,ͻﵽ20ʱ,DBCMSQLƽӦʱȲDBCMʱԼ7%,ͻﵽ50ʱ,ƽӦʱԼ16%.ɴ˿ɼ,ͻԽ,DBCM߾Խ.
,ݿмԭйܣ(1) ЧIntranet϶ûݿķܣ(2) ϢĴ䣻(3) Ż紫ܣ(4) ֹ֧ϵݿӣ(5) ֧Webе״̬һ,Ҳ֧Ӧ״̬ͳԵӣ(6) ΪIntranetӦݿṩһǿЧ;.
߽ܣ,1973,˶ʿ,ҪоΪݿ,Internet/Intranet.
ʢ,1960,,ҪоΪ,뻷,΢Ӧ.
ͨѶϵˣ,Ϻ 200233,ƽ·47110¥5ϺʿϢ޹˾
ߵλɡйϺзпƼϺ200021
ʢ֡ϺʿϢ޹˾Ϻ200233
E-mail: masong@hotmail.com
ο
1.Internetϵݿӿ.:Intranetֻļ.Ϻ,1997.2436(Ma Song. Database interface on Internet. In: Proceedings of the International Seminar on Intranet. Shanghai, 1997. 2436)
2.Internet/Intranetݿӿڼݿмԭ͵о빹˶ʿѧλģ.ѧ,1997(Ma Song. Internet/Intranet DB interface & the research and construction of DB middleware M.S. Dissertation. East China University of Science and Technology, 1997)
3Patel P, Moss K. Java Database Programming with JDBC. Scottsdale: Coriolis Group, 1996
4Cornell G, Horstmann C S. Core Java. Palo Alto, California: SunSoft Press, 1996
1997-09-29յԭ,1998-01-23յ޸ĸ 
