可重用Java数据库操作组件的设计和实现  

Design and Implementation of Module for Database in Java

作　　者：岳旭平[1] 王道顺[1] 

机构地区：[1]清华大学计算机系,北京100084

出　　处：《计算机应用研究》2006年第2期160-162,166,共4页Application Research of Computers

基　　金：国家自然科学基金资助项目(90304014)

摘　　要：基于Data AccessObject(DAO)设计模式,利用抽象、接口、类反射技术设计和实现了可重用Java数据库操作组件。它封装了注册和载入JDBC驱动程序、建立数据库连接、运行Structured Query Language(SQL)语句及处理查询结果集、查询结果集的分页显示操作,简化了Java DataBase Connectivity(JDBC)代码的编写,通过编写SQL语句,完成与数据库的交互。它设计的目标是简化中小型Java数据库应用的开发,提高开发的速度和测试的速度,降低数据库应用与数据来源的相关性,实现集中管理数据存取逻辑的功能。它与Struts框架有机结合,可进一步提高开发W eb应用的效率。为方便使用它,通过一个例子给予了详细描述。The module for the database in Java through abstract is designed and Implemented, interface and reflection technique. It encloses the common operations such as registering and loading JDBC driver, building database connection, running SQL and dealing with result sets, paging the record. It simplifies the coding of JDBC and completes the operations of accessing database through writing SQL. It will simplify the development of the database application in Java, make the procedure of the development more easy, decrease the relativity between the database and the application and centralize the management of the data access. It can integrate with Struts model perfectly. This paper will demonstrate how to use this module through a simple example.

关 键 词：DAO设计模式 数据库 JDBC 连接 抽象 STRUTS 类反射 JAVABEANS 

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