Design Pattern-based Database Connection Pool Technology And Applications

The article is aimed at resolving problems in designing object-oriented software, to find a effective tool with good reusability and maintainability to assist software designers: Design Patterns; At the same time, in order to resolve problems caused by databases connection in database application system, it brings up with a effective technique: database connection pool technique.Main points in this article: elements of Design Patterns, classification of Design Pattern, the relationship between Design Patterns and object-oriented design principles, basic principle of database connection pool technique, work mechanism and basic management strategy; a reusable Database Connection Pool Technique with good maintainability through employing Design Patterns.Design Patterns is a guide for studying object-oriented design principles. Through learning and employing the idea of Design Patterns, designers can efficiently improve design style and professional level, increase communication, which assist designers to upgrade the system' s maintainability and reusability.Database Connection Pool Technique is considered as a effective way to resolve problems caused by database connections in application system. The principle of Database Connection Pool Technique is preparing certain connections beforehand for application system to reuse, which saves the time for application system and database engine creating or releasing connections, enhances the efficiency of application system. This article mainly focuses on studying work principle, mechanism, and management strategy of Database Connection Pool Technique, and tries to find the problems and improvement suggestion of access interface, expansibility, console mechanism and deployment in present product of Database Connection Pool Technique. By making use of Design Patterns, the article builds a database connection pool system to solve the problem. This system provides clients with the same interface as normative JDBC' s for client' s convenience; it can access several databases simultaneously with good expansibility; it offers normative console interface and console parameter, so different application systems can adjust their console strategy; Being a separate pack can easily be deployed and employed.