 | The topic of this article may not meet Misplaced Pages's general notability guideline. Please help to demonstrate the notability of the topic by citing reliable secondary sources that are independent of the topic and provide significant coverage of it beyond a mere trivial mention. If notability cannot be shown, the article is likely to be merged, redirected, or deleted. Find sources: "JDBCFacade" – news · newspapers · books · scholar · JSTOR (May 2022) (Learn how and when to remove this message) |
JDBCFacade is an open source library for making JDBC easier to use and less error prone while encouraging a clean separation between persistence and domain logic.
Technical Details
JDBCFacade supports J2SE 1.2 and later. This includes JDBC version 2.0 and later.
Unlike many similar tools, JDBCFacade does not interfere with the normal usage of JDBC in any way. JDBCFacade uses the command and abstract factory patterns to provide a simplified database api that hides many of the details of connection and error handling from the user.
JDBCFacade supports 4 types of commands:
- FetchCommand – executes a JDBC query (SELECT) statement that is expected to return zero or more rows and then uses the provided factory to create an object from each of those rows
- GetCommand – executes a JDBC query (SELECT) statement that is expected to return exactly one row and then uses the provided factory to create an object from that row
- UpdateCommand – Executes a JDBC statement that does not return a ResultSet, such as an update or DDL statement
- VisitCommand – Executes a JDBC query (SELECT) statement that is expected to return zero or more rows and then applies the provided visitor to each of those rows