国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁(yè) > 學(xué)院 > 開發(fā)設(shè)計(jì) > 正文

Java 數(shù)據(jù)庫(kù)連接驅(qū)動(dòng)程序類型

2019-11-18 10:47:59
字體:
來(lái)源:轉(zhuǎn)載
供稿:網(wǎng)友

一、示例分析

CreateTable,Insert,Update,Delete,Select,DropTable:

1〉java.sql中主要的類和接口:DriverManager,Connection,Statement,ResultSet;

2〉在Java中如何加載驅(qū)動(dòng)程序,如何建立數(shù)據(jù)庫(kù)連接,如何執(zhí)行SQL語(yǔ)句,如何處理峁?

二、基礎(chǔ)概念

1、JDBC框架

JDBC(Java DataBase Connectivity)是Java與數(shù)據(jù)庫(kù)的接口規(guī)范,由Java 語(yǔ)言編寫的類和接口組成,大致分為兩類:針對(duì)Java

程序員的JDBC API和針對(duì)數(shù)據(jù)庫(kù)開發(fā)商的低層的JDBC driver API。而JDBC驅(qū)動(dòng)程序由實(shí)施了這些接口的類組成。如下,

JDBC的總體結(jié)構(gòu)有四個(gè)組件:應(yīng)用程序、驅(qū)動(dòng)程序治理器、驅(qū)動(dòng)程序和數(shù)據(jù)源。


2、驅(qū)動(dòng)程序類型

JDBC驅(qū)動(dòng)器根據(jù)其實(shí)現(xiàn)方式分為4種類型


1、JDBC-ODBC bridge plus ODBC driver:        JDBC-ODBC橋驅(qū)動(dòng)程序,將JDBC調(diào)用轉(zhuǎn)換為ODBC的調(diào)用。( This combination PRovides JDBC access via ODBC drivers. ODBC binary code--and in many cases, database client code-- must be loaded on each client machine that uses a JDBC-ODBC Bridge. Sun provides a JDBC-ODBC Bridge driver, which is appropriate for eXPerimental use and for situations in which no other driver is available.)

2、Native-API partly-Java driver:  將JDBC調(diào)用轉(zhuǎn)換為對(duì)數(shù)據(jù)庫(kù)客戶端API的調(diào)用。(A native-API partly Java technology-enabled driver: This type of driver converts JDBC calls into calls on the client API for Oracle, Sybase, Informix, DB2, or other DBMS. Note that, like the bridge driver, this style of driver requires that some binary code be loaded on each client machine.)


3、 Pure Java Driver for Database Middleware: 先將JDBC調(diào)用轉(zhuǎn)換為DBMS-independent網(wǎng)絡(luò)協(xié)議,然后由服務(wù)器端的中間件轉(zhuǎn)換為具體數(shù)據(jù)庫(kù)服務(wù)器可以接收的網(wǎng)絡(luò)協(xié)議。(net-protocol fully Java technology-enabled driver #This style of driver translates JDBC calls into the middleware vendor's protocol, which is then translated to a DBMS protocol by a middleware server. The middleware provides connectivity to many different databases.)

4、Direct-to-Database Pure Java Driver:    將JDBC調(diào)用直接轉(zhuǎn)換為具體數(shù)據(jù)庫(kù)服務(wù)器可以接收的網(wǎng)絡(luò)協(xié)議。(native-protocol fully Java technology-enabled driver #This style of driver converts JDBC calls into the network protocol used directly by DBMSs, allowing a direct call from the client machine to the DBMS server and providing a practical solution for intranet access.)

發(fā)表評(píng)論 共有條評(píng)論
用戶名: 密碼:
驗(yàn)證碼: 匿名發(fā)表
主站蜘蛛池模板: 东莞市| 彭山县| 灌南县| 阜城县| 夏河县| 历史| 彭泽县| 抚顺市| 海伦市| 满城县| 奉节县| 阿拉善盟| 宽城| 莱芜市| 宁强县| 桦甸市| 嵊泗县| 安陆市| 剑河县| 甘德县| 藁城市| 榆树市| 南投县| 高雄市| 鄂尔多斯市| 福建省| 六安市| 宁国市| 道孚县| 宁陵县| 梨树县| 甘洛县| 玉溪市| 内黄县| 英超| 安平县| 道真| 博兴县| 新化县| 横峰县| 平乐县|