基于JDBC与设计模式的数据库连接池实现方法

摘要

At present,in the Java database applications exists a solution that the Connection object is frequently created and closed when the database is visited through JDBC. This solution will bring a large performance overhead for the applications which have large concurrent access volume. In view of the issue, has proposed and realized a database Connection pool method based on the combination of JDBC and design pattern. The method has achieved the management of the Connection object through the Connection pool object and the Connection pool manager.the Connection object is not closing but putting back the Connection pool after using up to achieve the purpose of reuse, thus improving the efficiency of Java database applications.%目前Jave数据库应用程序中存在着通过JDBC访问数据库时频繁创建、关闭Connection对象的做法.这种做法对并发访问量大的应用会带来较大的性能开销.针对这一问题,提出并实现了一个基于JDBC与设计模式相结合的数据库连接池实现方法,该方法从连接池对象和连接池管理者两个方面实现对Connection对象的管理,Connection对象使用完后不去关闭而是放回到连接池中以达到复用的目的,从而提高了Java数据库应用的效率.