JDBC， what is.pdf

《JDBC， what is.pdf》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、WhatisJDBC?JDBCisJavaapplicationprogramminginterfacethatallowstheJavaprogrammerstoaccessdatabasemanagementsystemfromJavacode.ItwasdevelopedbyJavaSoft,asubsidiaryofSunMicrosystems.DefinitionJavaDatabaseConnectivityinshortcalledasJDBC.ItisajavaAPIwhichenabl

2、esthejavaprogramstoexecuteSQLstatements.ItisanapplicationprogramminginterfacethatdefineshowajavaprogrammercanaccessthedatabaseintabularformatfromJavacodeusingasetofstandardinterfacesandclasseswrittenintheJavaprogramminglanguage.JDBChasbeendevelopedunderth

3、eJavaCommunityProcessthatallowsmultipleimplementationstoexistandbeusedbythesameapplication.JDBCprovidesmethodsforqueryingandupdatingthedatainRelationalDatabaseManagementsystemsuchasSQL,Oracleetc.TheJavaapplicationprogramminginterfaceprovidesamechanismford

4、ynamicallyloadingthecorrectJavapackagesanddriversandregisteringthemwiththeJDBCDriverManagerthatisusedasaconnectionfactoryforcreatingJDBCconnectionswhichsupportscreatingandexecutingstatementssuchasSQLINSERT,UPDATEandDELETE.DriverManageristhebackboneofthejd

5、bcarchitecture.GenerallyallRelationalDatabaseManagementSystemsupportsSQLandweallknowthatJavaisplatformindependent,soJDBCmakesitpossibletowriteasingledatabaseapplicationthatcanrunondifferentplatformsandinteractwithdifferentDatabaseManagementSystems.JavaDat

6、abaseConnectivityissimilartoOpenDatabaseConnectivity(ODBC)whichisusedforaccessingandmanagingdatabase,butthedifferenceisthatJDBCisdesignedspecificallyforJavaprograms,whereasODBCisnotdependeduponanylanguage.InshortJDBChelpstheprogrammerstowritejavaapplicati

7、onsthatmanagethesethreeprogrammingactivities:1.Ithelpsustoconnecttoadatasource,likeadatabase.2.Ithelpsusinsendingqueriesandupdatingstatementstothedatabaseand3.Retrievingandprocessingtheresultsreceivedfromthedatabaseintermsofansweringtoyourquery.ProductCom

8、ponentsofJDBCJDBChasfourComponents:1.TheJDBCAPI.2.TheJDBCDriverManager.3.TheJDBCTestSuite.4.TheJDBC-ODBCBridge.1.TheJDBCAPI.TheJDBCapplicationprogramminginterfaceprovidesthefacilityforaccessingtherelationaldatabasef