數(shù)據(jù)庫連接池的研究與實(shí)現(xiàn)

論文字?jǐn)?shù):11106,頁數(shù):27

摘  要
在基于JDBC的數(shù)據(jù)庫實(shí)際應(yīng)用開發(fā)中，對數(shù)據(jù)庫連接的管理是一個(gè)重點(diǎn)也是一個(gè)難點(diǎn)，頻繁對數(shù)據(jù)庫的連接與關(guān)閉操作、多客戶對數(shù)據(jù)庫的并發(fā)訪問,一定程度上決定了WEB系統(tǒng)的響應(yīng)以及應(yīng)用性能。使用數(shù)據(jù)庫連接池方式能對數(shù)據(jù)庫的連接進(jìn)行管理和維護(hù),上層應(yīng)用程序通過數(shù)據(jù)庫連接池使用數(shù)據(jù)庫資源能提升系統(tǒng)性能，充分利用系統(tǒng)資源。文章通過介紹、分析數(shù)據(jù)庫連接池工作的基本原理，了解目前流行的WEB服務(wù)器在數(shù)據(jù)庫連接池方面的使用現(xiàn)狀后，總結(jié)一了些數(shù)據(jù)庫連接池開發(fā)程序中容易忽略的問題。并在學(xué)習(xí)掌握了實(shí)現(xiàn)連接池的關(guān)鍵技術(shù)后給出了一個(gè)較為高效的連接池管理策略，在這種策略思想的指導(dǎo)下實(shí)際開發(fā)出一個(gè)數(shù)據(jù)庫連接池模塊，使得上層應(yīng)用通過本連接池訪問數(shù)據(jù)庫資源變得相對高效和容易，從實(shí)際上論證了這種設(shè)計(jì)方案的可行性。

關(guān)鍵詞：連接池；數(shù)據(jù)庫；JDBC；并發(fā)訪問

Research and realization of the Database Connection Pool
Abstract
In the practically application development of database based on JDBC, the management of database connection is a key point and also a difficulty. The response and performance of the WEB system are depended on frequently connecting, closing and multi-user accessing in a certain extent. Using the Database Connection Pool can provide management and maintenance for connections of the database. The upper applications may access the database recourse via the Database Connection Pool, in order to upgrade system performance and fully utilize the system recourse. This article summarizes some issues which are easily ignored in the application development of the Database Connection Pool by the way of introducing and analyzing the basal working principles of the Database Connection Pool ,comprehending the using actuality of the Database Connection Pool on the popular WEB servers. Besides, I established a comparatively highly effective policy of the Connection Pool management after having learned and comprehended key technique of implementing the Connectivity Pool, and actually had developed a Database Connection Pool module under the guidance of that policy, causing the access of system resource by the upper applications via current Connectivity Pool becoming relatively highly effective and easy, demonstrated the feasibility of this design project in practice.

Key words: Database Connection Pool; Database; JDBC; Concurrence access

目  錄

1 引言 1
1.1 課題背景 1
1.2 連接池的主要作用 1
1.3 目前流行的web服務(wù)器數(shù)據(jù)庫連接池方面使用現(xiàn)狀 1
1.3.1 DHCP介紹 2
1.3.2 Poolman介紹 2
1.3.3 C3P0介紹 2
1.3.4 其他連接池（自寫連接池） 2
2 相關(guān)理論基礎(chǔ) 3
2.1 數(shù)據(jù)庫概述 3
2.2 數(shù)據(jù)庫連接池的基本原理 3
2.3 連接池中的關(guān)鍵技術(shù) 4
2.3.1 連接池的分配與釋放 4
2.3.2 連接池的維護(hù) 5
3 系統(tǒng)總體設(shè)計(jì)思想及方案 5
3.1 連接池中的關(guān)鍵類設(shè)計(jì) 6
3.2 連接池中的管理機(jī)制 7
3.3 實(shí)現(xiàn)一個(gè)連接池的其他問題 8
3.3.1 事務(wù)處理 8
3.3.2 封裝 9
3.3.3 并發(fā) 9
3.3.4 連接池的關(guān)閉 9
4 具體的設(shè)計(jì)流程和實(shí)現(xiàn) 10
4.1 連接池的建立 10
4.2 連接池的管理 12
4.3 連接池的關(guān)閉 14
4.4 連接池的測試 15
5 系統(tǒng)測試問題總結(jié) 15
5.1 連接池的泄露問題 15
5.1.1 產(chǎn)生現(xiàn)象 15
5.1.2 解決辦法 16
5.2 多數(shù)據(jù)庫服務(wù)器問題 17
結(jié)    論 19
參考文獻(xiàn) 20
致    謝 21
聲    明 22