
COMPUTER ENGINEERING
1999  25 7 Vol.25 No.5 1999



JDBCʵֻInternetϴϵͳ
ӡԡ
ժҪһJDBCʵֵĻڡͻ-Web-ݿϵṹϴϵͳϵͳĹƷ㡢ЧʵѡJAVAݿӼJDBCʹϵͳڲͬӲƽ̨˳УʹҲǳ㡢ֻϵͨɣһƹֵ
ؼʡѧ  JDBC
An Internet-based Network Answering System Using JDBC
Yin Min Wang Xingyan Wang Lei
Computer and Information Management Center of Tsinghua University beijing 100084
AbstractThis paper introduces an Internet-based network answering system with a three layer architecture of Client-Web Server-Database Serverimplemented with JDBC and other network development technologies.The functions of our system are carefully designed and performed in order to get more convenience and wider usability,which is easy to achieve with the help of an innovative network language Jave and is database connection tools JDBC.These technologies enable the system to work under any kind of platform,with no more requirements other than an Internet browser to perform both routine and management working effcctively.
Key wordsNetwork educationNetwork answeringJDBC
1ͳģʽ
ǽѧһʮҪѧڣһԶĽڲͬǽʦѧһһĽͨɣѧŪ岻ٿȺδ漰ϸڲýʦԵָʦҲͨ˽ѧԿγ̵պӦЩϢýѧ
ͳĴһȡҽԺר￴ʽονʦڹ̶ص""Ӵǰɵѧǵ"֢"ַʽŲ⡢֡Чʵ͵ȱ㡣ΪˣһֱͼиĽ缼ĳͷչΪ⣬ṩһµ˼·
2ģʽƽ̨
ɣüʩʦѧгԽʱյϽɵĳӹ̶ĽתƵڵ磬ɵʱ޵Ĺ̶ʱα任ʱ̣Ӷʵָӷ㡢ЧĴɻУĽѧ罨󲽣ΧУ԰һɶȺ󽨳˾500λĴͼʵҡ5๦ܽҡ̨ѧCAIΪʵ縨ѧṩõӲǲƺͷչĿʵңĿǰ500̨΢Ǿͨרõ豸У԰йͬѧͨȡ֪ʶͬʱѧCAIȴܵĴͷ򱣴ŴḻĽѧԴʦĽ̰йزοϡϰϰ⡢ѽȵȡһ縨ѧϵͳӲƽ̨ͻܾѾɣǵϵͳΪ縨ѧϵͳһ֣йһƽ̨(ͼ1ʾ)

ͼ1У԰ѧ
ͳWWWӦãԵڷϵľ̬ϢΪߺͱ仯ھ̬ݵĻϼ붯̬ġĹܣѾΪĿǰӦõһչơΪӦһƣӦõϵṹҲѾԭе"ͻ-"ģʽת"ͻ--ݿ"ģʽ߸һ"ͻ-Web-Ӧ÷-ݿ"ļģʽṹϵͳͨʦѧѧʻǽʦ𣬶ҪĲԵĻǲϵͳϵṹʵֽʽϵͳͼ2ʾ

ͼ2 縨ѧϵͳӦýṹ
ͼ2ʾǿ縨ѧϵͳӦϵṹϵͳѧϵͳеһϵͳϵͳԿγΪĹλйصϢΧſγ̽֯ݿдŲͬγ̵ĴϢѧͽʦĽȵȣݿеĴϢϣѧʺͽʦĻشЩάݿеĴϢЩɴ洢ڷейسɵģʦѧֻҪһ̨ļͨõͿԷʵϴˡ
3ϵͳĹ
ϵͳչܿԻΪ֣һѧʹõʺͲ鿴⼰𲿷֣һǽʦʹõĻشά֡
3.1ѧʹù
ʣѧӵضַγ̱ʱϸʵCGI򽫽ѧ⣬ĿݣԼܵĸļЩϢĺ̨ݿⱣ
鿴FAQбϵͳУΪЧʣ"б"(FAQ--Frequently asked questions)FAQгһЩĹ⼰ѧµ֮ǰȲ鿴һFAQԼѾ˴𰸣Ͳˣ˴ϵͳʹЧʣ˽ʦظͶ
ѧʺʦĻش𶼿Ը͵ĸļγеԴļִļ˹ʽͼWORDļȣ鿴ʱֻʾĸļͿ԰ӷصرֱӴ򿪲鿴
3.2ʦɹ
ʦɹģгѧʦ鿴͹ʦѡһ֮µĲ
ɾʦɾظġʱĻû⣬ԱִࡢЧ
޸⣺ʦΪĳԱѧʵıǺȷУ޸ݣʹ֮ȷ
𰸺͸ļڿԱ⣬ʦӦĽ𣬱ҪʱԸһļһȷĴ𰸡
ΪFAQдԵ⣬ʦ԰FAQбϷ
4ϵͳʵ
ϵͳʱһЩǣͨ  Ҫѧͨúͻͨãڷ  Ҫѧʹ÷ͽʦά㡣Ϊ˴ﵽϵͳҪѡӲƽ̨޹صJAVAΪҪߣѡ˱ȽϳCGI̷JAVA˵CGIǵϵͳ漰˽϶ݿͱȻҪʹõJAVAݿJDBC
4.1JDBC
JAVAһαдеĿƽ̨ص㣬رʺ翪ӦáӦжֲΣ򵥵ĿԻΪͻ˺ͷˣͻ˵JAVAͨɽ뽻ܵС򣻶˵JAVAеŸΪؼҪݿķʡά1998걻ΪJAVAڷ˴Ӧõһ꣬JDBCĹ㷺ʹǷֲġ
JDBCJava DataBase ConnectionдͨJAVAݿļṹͼ3ʾ

ͼ3 JDBCṹ
ɼJDBCҪJDBC APIJDBC Driver API͸JDBCJAVAͨݿĽӿڡʹJDBCʵӦóݿķҪµĺô
(1)ƽ̨ͬһݿ⹦ܵӦóڲͬӲƽ̨ϣ
(2)ݿӣͬһӦó벻ͬƽ̨ϵĲͬݿӡ
ϵͳдҪͨݿĲΪϵͳͨԺͿƹԣѡJDBCʵϵͳĺĲ֡
4.2ϵͳʵ
ڵϣֻһЩ̬ͼϢżķչ̬ܱ뵽ҳ֮С
չҳܵķкܶ࣬綯̬HTMLScriptűԡJAVA AppletCGIרAPIȵȡЩɫеĸո𲽣еѽ죬ܵ˵δγһĬϵı׼͹ʶʵӦеײúַҪ
ǵϵͳУ˷JAVAԱдCGIͿͻJava ScriptдĽűϵģʽϵͳģṹͼ4ʾ

ͼ4 ϵͳʵֽṹʾͼ
ҪǳµĿǣ
(1)CGIһֱȽϳ͹㷺ʹõϱģʽϵͳҪݿ޸ġҺͽΪû̫ߵʵʱҪ󣬿ԲCGIģʽ
(2)JAVAǿƽ̨ıԣдCGIԹڲͬķϡ
(3)Java ScriptǶھ̬HTMLеĽűԣãʵ緵һҳȼ򵥲ʺڿͻʹãӦõԡԣʹѺá
5С
ĲһJDBCʵֵĻInternetϵͳơʵ֡ڴͳĽҴģʽϴɾµصԽԣ
(1)ϴŵԽʱյĽޣɻԽʦѧ˫ֻҪһ̨У԰װͨ΢ɻκʱУ
(2)ͨøЧڲϹFAQбķʽԼ˽ʦʱ䣬ѧҲͨ鿴˵ԼԿγ̵ȫʶϵͳرƣԲͬĿγ̺Ͳͬƽ̨ͨõġ
ȻϵͳһǷȱͲ㣬ҪһĸĽϵͳܣͨE-mailķʽڹFAQбͬʱӶԸͬѧĸڲ鿴бʱӸݼʵĲҵȵȡҪ˵ǣϵͳ縨ѧϵͳеһϵͳй֤ϵͳеģɣﲻ׸ĿǰϵͳѾͶʹãܵ˹ʦĻӭǽӦвƣʹܷӸá
߼飺ӡ Ů27꣬ʦҪоΪĳƺInternetϵݿ⿪Ӧ
ߵλ廪ѧϢı100084
ο
1Thomas M,Patel P,Hudson A,et al.ΰ.Java for Internet̼.ӹҵ, 1997-11
ոڣ1998-08-03
