使用Spring 架構存取資料庫之研究與實作

Reconfigurable Database Access using Spring Framework

王振祥(Jenh-Siang Wang)

指導教授 ： 留忠賢

中原大學/工學院/資訊工程研究所/碩士(2006年)

https://doi.org/10.6840/CYCU.2006.00378

摘要

在開發web-based應用系統時，必須對資料庫作存取。但在一大型 web-based應用系統中，這些存取資料庫的程式會有許多重複出現的狀況。如為了提可再使用性及系統的可維護性，因此有必要將系統的資料庫存取程式和商業邏輯程式作分離。
我們使用Data Access Object (DAO)這種模式，然後配合Spring Framework的IoC/DI的概念，動態注入物件間的關係，提升DAO程式的可再使用性。我們以一個實際軟體專案為範例，經重整後，當資料庫存取改變而需修改許多Web程式內的相同SQL語法時，我們只需修改一個地方，這樣系統日後易於維護。

關鍵字

DI ； Spring ； IoC

並列摘要

We must access the database when developing a web-based application system. But in a large-scale web-based application system, the programs for database access are usually duplicated. In order to enhance the reusability and maintainability of a system, it is necessary to separate the database access from business logic.
The data access object (DAO) pattern was used for this purpose. This pattern was then adapted to the Spring framework, which is an IoC/DI framework that dynamically injects the relationship among objects. This will enhance the reusability of DAO programs. A real software project was used as an example. After refactoring, we only need to change one SQL statement programs when same pattern of database access is changed. The system is thus easier to maintain.

並列關鍵字

DI ； IoC ； Spring

參考文獻

[3] Walter Hursch and Cristina Videira Lopes, “Separation of

[6] Martin Fowler, “ Inversion of Control Containers and the Dependency Injection pattern”, http://www.martinfowler.com/

參考文獻

[1] Rod Johnson and Juergen Hoeller, “Expert One-on-One J2EE Development without EJB”, Wiley, Inc., July 2004.

[2] Gregor Kiczales, John Lamping, Anurag Mendhekar, Chris Maeda, Cristina Videira Lopes, Jean-Marc Loingtier and John Irwin, “Aspect-Oriented Programming”, in Proceedings of the European Conference on Object-Oriented Programming (ECOOP),