数据库连接策略优化方法  

Optimizing method of database connection strategy

作　　者：孔哲[1] 孟丽荣[1] 孙筱雯 

机构地区：[1]山东大学计算机科学与技术学院,山东济南250061 [2]山东第二轻工业设计院,山东济南250014

出　　处：《山东大学学报（工学版）》2003年第6期652-657,共6页Journal of Shandong University（Engineering Science）

摘　　要：目的是结合邮政物流信息系统的开发 ,实现高效、安全的数据库连接管理 ,方法为在对数据库连接进行详细分析的基础上 ,利用资源池设计模式 ,实现数据库连接池 ,实现连接的高效、安全的复用 ,提出并实现了一个高效的数据库连接管理策略 ,使得开发高性能的数据库应用变得相对容易 .对于事务和多线程下的数据库连接这两个难点问题进行了深入的剖析 ,并给出了一个基于设计模式的解决方案 ,由此 ,本文结合邮政物流信息系统的开发 ,给出了一个具有一定普遍意义的基本的连接管理框架 ,使得高效。The objective of the paper is that based on th e research of Post Logis tic Information System, an effective strategy of database-connection management is researched and realized in the paper. The methods is that based on the analys ing of database-connection, using the design pattern of resource pool, the data bas e-connection pool is realized. And then,we realize a safe and high-powered reu se of connection, research and realize an effective strategy of database-connectio n management. This will make the development of high-powered database applicatio n comparatively easy. After anatomizing the problem of affair and multithreading in depth, a solve scheme based on design pattern is presented. The conclusion is that based on the research of Post Logistic Information System, a popular and ba sic management frame of connection is presented and this will make the effective and safe reuse of database conncetion available.

关 键 词：物流信息系统 JDBC 连接池 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]