΢ͻӦ
WEIXINGJI YU YINGYONG
19993 18 3 vol.18 No.3



JavaWeb·ֲʽݿ⻥Եʵ
Īٻ
ժҪӦJDBCWebʵֶݿ͸ʼRMIJavaAppletİȫƣʵWeb·ֲʽݿĻһJavaʵֵWebNClient/ServerṹֲʽݿӦϵͳģ͡
ؼʣԶ̷(RMI)JDBCӿڡWWWֲʽݿ⻥
Javaǽķչеģܹڶ̶̼ѸٳΪȵ㣬õǷֲġݿ⴦棬JavaṩJDBC APIΪݿ⿪Ӧṩ˱׼Ӧó̽ӿڡ˵RMIԶ̷õĸRMIʺJavaִԣʹ÷ֲʽ²ͬJava֮ͨŸӼȻ壬JavaѾΪݿӦõ빤֮һ
1JDBCԭ
JDBC(Java Database Connectivity)1Sun˾ע˵ִ̱꣬SQLJavaӦó̽ӿAPIһϵJavaԱдͽӿڣΪݿ⿪߿ݿӦṩ˱׼Ӧó̽ӿڡ
1.1JDBC
JDBCԺSQLκݿ⣬Ҳ˵ͨJDBC APIݿӦÿ߾ͲҪд1Sybaseݿ⣬д1Oracleݿ⣬ٱд3Informixݿ⣬ֻд1ʹJDBC APIĳ򣬾ͿԽSQLѯʵݿ⡣ͬʱJavaԱдӦó򣬾ƽ̨޹ԣҪΪͬƽ̨дͬӦóˣJavaJDBCдݿӦóĿ߿дһΣ洦á
JDBCչJavaԵĹܡ磬ʹJavaJDBC1ܹԶݿϻȡϢľJavaӦС(Applet)Webҳ߿1ܹʹҵԱͨҵڲ(Intranet)1ڲݿӦá
JavaJDBCʹϢռͷͷǳ׺;ã˾ҵԼǰݿϵͳЩݿϵͳǻͬģȻɵطϢҿ1µݿӦõʱҲ̡
1.2JDBCϵṹ
JDBCϵṹ4
1.JDBCӦóJDBCӦóûûӿ֮ĽԼJDBCĶ󷽷ԸSQL䲢ȡ
2.JDBCJDBCΪӦóغ͵
3.JDBCJDBCִJDBC󷽷ĵãSQLָԴظӦóҲκηԴıҪн
4.ԴԴݼĻɣҪָݿ⳧̵ݿϵͳ
ODBCһJDBCṩԱı̽ӿ2ɣӦóı̽ӿJDBC API͹ײ㿪ӿJDBC Driver APIJDBC APIΪӦóԱṩģJDBC Driver APIΪҵݿ⳧ṩġҵݿ⳧̵JDBCJDBCԶͳһġ
2RMIԭ
1ֲʽϵͳУͬϵĳ֮ͨţֱͨӶSockeṭǱȽϵײķҲʹòθһЩRPC(Remote Procedure Call)ʵ֡ǶJavaִ˵ЩͻƶɱƻJavaԡJavaRMIҪʵֲַʽ󻷾µĲͬϵĶ֮໥á
2.1RMI
RMIԶ̷(Remote Method Invocation)Javaϵ˵һżJavaһִԣÿһʵ嶼ԶʽύġΪʹֲʽµJava̱һԣSum˾˷ֲʽĸΪֲʽ(Զ̶)֮以ṩʺ϶ĻڳĶεĻƣRMIʹ÷ֲʽµJava̻˵Java֮ͨŲ漰ײЭݵı룬ӶӼ򵥺Ȼ
2.2RMIϵṹ
ͼ1ʾRMIϵͳ3ɣ/ܹ(stub/skeleton)㣬Զòʹ㡣ÿһı߽ضĽЭ綨ģˣÿһڲǶģҲ˵ĳһʵϵĸı䣬ǲӰ쵽ġ


ͼ1  RMIϵṹ
stub/skeletonJavaRMIϵͳֵĽӿڡRMIϵͳУһʵǰŴĽɫstubskeletonֱǿͻͷĴˡڿͻˣͻstubԶ̷stubЩ󴫵ݸҰѵýظͻ򡣶ڷˣԿͻ˵ĵΪskeletonգskeletonӦĶ󷽷Ϊ֮񣬵ýҲskeletonظͻˡ
ԶòǾĴʵԶ̶õĲ֣еİĸƵȶԶ̶ĲԶò
ĵΪǽӣҸͼЩӣͬʱΪдڸõַռԶ̶ά1Զ̶Ա㶨λԶ̵õĿꡣ
2.3л
RMIϵͳлõл(object serialization)лʵǶJavaı룬Զ̷ùУѷͷҪ͵JavaȱֽȻٽ紫ͣڽշѽյֽԭJava󣬴Ӷʵ˲ַͬռϵĶ͸͡
2.4RMIĿ
RMIJavaԵģĿʵֶԴڲͬϵĶ޷Զ̵ãѷֲʽģȻؼɵJavaܵشϱJavaԣҲJava runtimeṩİȫԡ
RMIϵеԶ̷õʵϸڶJava˵͸ģԶ̶֮ã͸ñصJavaһļȻ塣
RMIԶ̷ĵǺҪģ﷨ϣԱطĵһµġ 
3JAVAWeb·ֲʽݿ⻥Եʵ
3.1JDBCݿ⻥Եʵ
JDBCҪʵֶԸݿķʣһּ򵥶ֿݵķODBCODBCĿǰϳݿӦüṩ˶ԸݿͳһķʽӿڡˣֻҪͨJDBC-ODBC򣬾ͿʵֶԸֹϵݿ͸ʣӶʹJDBCӦóԼ򶼻˶ݿĶԡ
3.2RMIJavaAppletİȫ
JDBCӦó˵RMIŵԳԽJava Appletܵ簲ȫơAppletΪRMIϵͳĿͻ˲֣ǴRMIڵڵصģԷRMIϵԴݿͽշصݣΪJava ApplicationRMIûAppletƣԷϵԴݿ⡣տͻAppletݿ󣬸ͨJDBCȥݿԴҰѷʽݷظͻAppletʵRMI˿ͻAppletݿ1JavaAppletİȫơ
3.3RMIJDBCʵ1Client/Serverṹģ
ԴͳĶṹһĽ취ǲClient/Serverṹڿͻݿ֮1м㡱ͻеݿʶмִУʵĽмݿգתͻˡмʵ1á
RMIΪͻݿ֮м㣬֮ͨšͻApple tݿͨRMIݿύʽҲݿͨ RMIͻAppletݡRMIʵҲ1JDBCӦóͨRMIϵͳ AppletͨŲΪͨJDBCݿӣӶʵ˿ͻApplet ݿ֮ӡ
ʹRMIJDBCϵķʵWebµԶݷʣ1Եŵ㣬Ϊ Java򣬲ҪеͲJDBC APIãɷṩӦĸ߲API ΪRMIȫԶԿͻAppletһԼϵͳԺ ȫԡ
3.4ʵ1nClient/Serverṹ
ģͣǿWeb·ֲʽݿӦõĻRMIֵ֧Եͨ (1ڵϵRMIȿΪֿΪͻ)ص㣬ȫʵ 1ͼ2ʾnͻ/ģʽӦá

ͼ2  Nͻ/ģʽڷֲʽݿеӦ
ӦϵͳֲڲͬڵϵķԼǵֱӿͻ ɣÿ1 ֱӿͻ1ṹϵͳHTTPRMIϵͳ(Server/Cl ient)JDBCODBCSQLݿɣÿ1ͨRMIϵͳ Լֱӿͻͨšϵͳ棬Ϊֱӿͻ ṩݷͻݷ
ʵӦʱÿһ϶1ű¼ĵַ ÿһֱӿͻݿ룬ȵԼڵ ݿȥѯӦϢظͻ򣬾Ͱյַ ͲѯӦϢҲǷظͻ򣬸֪ ͻѯʧܡԵأеĿͻܹ͸зϵݿ⡣ ʵ1WebµķֲʽݿӦá
4ܡ
JDBCRMIʵWebµķֲʽݿ⻥ԣӦJavaһԣͬʱ ҲǶԴͳC/SϵṹһָĽм򵥡Чŵ㣬Javaĸ ԣر˵RMIΪҵֵ֧JDBCű׼ķչ һõӹ㷺Ӧá
ߵλɳƼѧֲصʵ(410073)
ο
1Rasmussen B.WDB-A Web Interface to SQL Databases.European Southern Observatory,http://arch-http.hq.eso.org/bfrasmus/wdb/wdb.html,1997
2Naguyen T,Srinivasan V.Accessing Relational Database From the World Wide Web. ACM SIGMOD 96 Montreal,Canada,1996
3Yaylor A.JDBC Developer's Resource.Prentice Hall PTR,http://www.preh all.com,1997
(ոڣ1998-09-01)
