Ӧ
COMPUTER APPLICATIONS
1999 19 6 Vol.19 No.6 1999



WebݿӼ

ժҪϸĿǰҪֽӿڼWebģ֣ǵĽӿԭͿ̽˷Աȣһӿڼķչ˿
ؼʡӿ,Web,CGI,API,JDBC
INTERCONNECTION BETWEEN WEB SERVER AND DBMS SERVER
Ding Mingji
Information Centre of Liaohe Oilfield, Liaoning.Panjin 124010
AbstractThis paper expounding three present major interface technology in detailbeginning with Web model analyzing and comparing their interface principle and their developing process. Finallyput forward my view in the development of this interface technology.
KeywordsInterfaceWeb serverCGIAPIJDBC
1Webݿӷ
ӦõռWebݿԵԽԽҪ೧̲ƳµĽӿڼʹӸӼࡢ͸ЧWebݿĽӿڼѳΪWebϢϵͳĺġWebݿӷͨɷΪJavaģJDBCͨؽӿ(CGI)Ӧñ̽ӿ(API)
2Javaݿ⻥ӿ(JDBC)
JavaƳʹWebҳ˻ͶУûԴWebJavaС򵽱УЩصСԾ򱾵سһɶطʱغԴϸJDBCԭʵַ
2.1JDBCԭ
JDBCһִֿSQLݿAPIһЩJavaдࡢɡڹODBCͬԱṩһͳһġ׼ݿʽӿڡJDBCݿԭ:Internet/IntranetûʹӵػصWebϣغJavaСHTMLĵJavaСʹJDBCеСֱݿ⽨(ͼ1ʾ)

ͼ1ͨJDBCݿ
JDBCһݿϵͳAPI,Ľṹ: JDBC APIJDBC Drive APIJDBC APIṩӦóJDBC Driver ManagerͨŽӿڣJDBC Driver APIṩJDBC Driver ManagerݿͨŽӿڡ
JDBC Driver ManagerODBC Driver Managerɸݿ⳧̿JDBCJavaSoftṩһͨõJDBC Driver Managerÿݿ⳧̽ṩһODBCƵJDBC,ԱͿJavaзʸݿ⡣,JavaSoftṩһJDBC-ODBCţ֧JDBCͨеODBCݿ⡣
ĿǰJDBCѵõ೧̵֧֣BorlandIBMOracleSybaseȡĿǰеĴݿϵͳƳԼJDBC
2.2JDBCʵ
JDBC APIͨJavaӿʵֵģҪĽӿ:
 java.sql.DriverManager: JDBCݿļغжءDrivermanagerΪJDBCĹ㣬ҵװURLָݿJDBC򡣸Զݿһjava.sql.connection
 java.sql.Connection: ݿӡ
java.sql.ResultSet: ʾݿصĽͨʵֶݵķʡ
Ҫݿ⣬ȱ뽨һjava.sql.Connection󣬿ͨDriverManager.get.Connectionõ˶󡣸÷һURLΪURLΨһָҪʵݿκһSQL䶼ܸıݿڵ,,AutoCommitʧЧԵʹCommit޷ʵݿĸ¡java.sql.Statementָ״ִ̬еSQL䣬: java.sql.PreparedStatement  java.sql.CallableStatement; ǰִһԤSQL Statementִĳһ״̬ݿڵĴ洢̡JDBC APIjava.sql.ResultSetƾStatementõĶݣα(Cursor)ָʾǰ,ʹNextƶCursorһСResultSetGETõǰеֵ
JavaνһODBCԴִһSQL,صĽڽRSС
String url="jdbc:odbc:Factory";
Connection on=DriverManager.GetConnection
(url,"UserName","PassWord")
Statement stmt=con.CreateStatement();
ResultSet RS=stmt.ExecuteQuery
("SELECT EnoEnameEsex FROM Clerk");
JDBCݿURLָJDBC URLṹΪ:Jdbc:<SubPro-tocol>: <SubName>,SubProtocolʾһضݿ,SubNameSubProtocol,jdbc:odbc:FactoryָһODBCԴFactory
3ͨؽӿڼ(CGI)
CGIWebⲿĹ淶CGIдⲿչԴͻ(ͨWeb)ЭͬݣɿͻĽչĹܣɷɵĹⲿִʱHTMLĵĵWeb
CGIӦóܹнãͨݿAPIݿⲿԴͨšһCGIԴݿлȡݣȻʽΪHTMLĵ͸ҲԽõݷŵݿСͻûͿԺWebݴеķ֧CGI߿ʹһWebԱдCGI䣬аΪеPerlԡCC++VBDelphiȡ
4WebӦñ̽ӿ(API)
ЩWebCGIЧʵ¡ѵȱ,˸ԵķAPI(Application Programming Interface)ͼ˷CGIܷȱݡ
APIһΪһDLLṩ,פWebеĳ룬CGIչWebĹܡAPIʹWebʵκCGIʵֵĹ,Ҹû,Ӧó󡣳APIMicrosoft˾ISAPINetscapeNSAPIInformix˾IUWCAPI
ڿAPIӦóǱڵ,MicrosoftNetscapeԵķṩ˻APIı̽ӿڡMicrosoftṩIDC(Internet Database Connector)NetscapeṩLiveWire/LiveWire Pro
5ֽӿڼıȽ
ȻJDBC CGIWeb Server APIʵWebݿ,ǵĹԭǲͬġ
CGIAPIǽWebĳһ̻APIý̻APIõĽʽΪHTMLĵظWebȻWebõHTMLĵ˵ݿĽWebɵġJDBCУǶHTMLĵеJavaӦóصܹJavaıмУ˵ݿĽֱɵġ1ǴӲͬ˱Ƚϡ
1ֽӿڼȽ

ԡ
֡ࡡCGIAPIJDBC
ʵֵԺúú
̵ĸӶȸӸе
ԳԱҪ߸е
ʱ䳤е
ֲԽϺò
CPUؽϵ
ƽ̨ййй޹

Ƚ϶ԣCGIӿӦ߷ḻܷΧ,Գ졣CGIһҶֵ֧Ĺ淶CGI̫,һ򵥵SelectѯCGIʵ־Ҫϰ; CGIЧҲ,ҪԱϤHTMLټƽ̨йصȱ,CGIᱻµĹ淶ȡ
WebAPIдĳЧʸߣǣAPI̱CGIѣԳԱҪߡAPIǣAPIûлͨԣһAPIдĳܵһWebУʹ÷Χܸ˾(Oracle)Ƴ˻APIĿ,һ̶ϽAPIѵ,ԴAPIһ㣬Web̫ȱͨԡ
Java̹淶ӿЧʸߡJavaڿֲԡȫԺͿɿԵȷҲƣJavaĶ߳̿ƼԴִ߳ЧʡJavaڿͻУԱܴѸٵJava AppletCGIAPI޷ʵֵġ
ȻJavaȱṹ,ƽ̨GUIֲܴܺ,,ҲдչJDBCǰ;ĽӿڼJDBCODBC˼룬ֳɵODBCʸݿ,ԭеͶʡҪ,ݿⷽ,еݿ⳧̶֧JDBC׼Ƴ׼ƳԵJDBC;Web,MicrosoftԼActiveX⣬̶֧JDBC׼ʱƣJDBCȡCGIΪµͨõĽӿڹ淶
6ǰ
WebݿĽӿڼInternet/IntranetӦ򲻶չƳ³¡ŷֲʽWebеӦ,ʹInternet/Intranetʵֿƽ̨ԸпܱΪʵ,ڷֲʽWebݿӦϵͳΪҵзֲʽʱCGIAPIJDBCпܳΪʷµĽӿڼ㡢ʵáȫǵ˼뽫Ϊһ½ӿڼĻ
߼飺˶ʿҪݿӦϵͳҳĿо
ߵλɺϢġ.̽124010)
ο
1ݡT.Berners-lee. Hypertext Transfer protocol. Internet Engineering Task Foece Working Draft. 1993,11
2ݡ,ԣ,Ǯȫ. WWW. ΢, 1997;(2):100-103
3ݡַ֣,Ź. JDBCӿڼ.й,1997;28(7):82
ո:1999-02-01(޸ĸ)
