基于JDBC数据库连接池技术的研究与实现  

Research and Realization of Database Connection Pool Technology Based on JDBC

作　　者：刘冰[1] 

机构地区：[1]达州职业技术学院信息工程系,四川达州635001

出　　处：《计算机与现代化》2010年第7期32-34,共3页Computer and Modernization

摘　　要：在基于JDBC的数据库应用开发中,对应用性能影响的一个重要方面往往是数据库连接的管理。由于传统的访问数据库模式在这方面存在明显的缺陷,这就需要在实际的应用开发中重新设计一个更加合理、高效的解决方案。本文在透彻分析传统模式缺陷的基础上提出并实现一个合理、有效的策略:数据库连接池技术。运用这一技术能极大地改善数据库连接的管理效率,使得开发高性能的数据库应用成为可能。同时,本文还深入地剖析连接池管理中的几个关键技术:连接池大小的确定、事务处理、封装和连接多个数据库服务器等。最后给出一个数据库连接池的通用实现框架及其使用方法。During the development of database application based on JDBC,the management of database connection is often an important aspect which will affect the application capability.As the traditional modes of visiting database have obvious defects,a much more reasonable and high-efficient method must be redesigned in actual situation.First,on the basis of a thorough analysis of the defects in traditional modes,a reasonable and efficient strategy-database connection pool is put forward,which greatly improves the management efficiency of database connection with this technology and makes it possible to develop high-capability database application.Second,several key technologies in connection pool management are also deeply analyzed,such as the determination of the size of the connection pool,transaction processing,encapsulation,and the connection of multiple database servers.Last,a general framework of database connection pool and its usage are given.

关 键 词：访问模式 JDBC 连接 数据库连接池 封装 事务 

分 类 号：TP393[自动化与计算机技术—计算机应用技术]