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

在基于JDBC的数据库应用开发中,对应用性能影响的一个重要方面往往是数据库连接的管理。由于传统的访问数据库模式在这方面存在明显的缺陷,这就需要在实际的应用开发中重新设计一个更加合理、高效的解决方案。本文在透彻分析传统模式缺陷的基础上提出并实现一个合理、有效的策略：数据库连接池技术。运用这一技术能极大地改善数据库连接的管理效率,使得开发高性能的数据库应用成为可能。同时,本文还深入地剖析连接池管理中的几个关键技术：连接池大小的确定、事务处理、封装和连接多个数据库服务器等。最后给出一个数据库连接池的通用实现框架及其使用方法。

Research and Realization of Database Connection Pool Technology Based on 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.