Using JDBC & the Template Method Pattern for Database Access

摘要

JDBC is a simple and flexible way to access a relational database. The knock on JDBC is that it forces a developer to familiarize himself with its API, whose use can often result in reams of duplicate or similar code: get a connection, execute a statement, parse a result set, etc. All of which needs to be wrapped in a try-catch block and synchronized. However, in this article, I'll describe how to use the template method pattern to centralize an application's JDBC code into a single class that can be extended using a minimum of JDBC knowledge.