Apache Commons DBUtils - Overview

Apache Commons DbUtils pbrary is a quite small set of classes, which are designed to make easier JDBC call processing without resource leak and to have cleaner code. As JDBC resource cleanup is quite tedious and error prone, DBUtils classes helps to abstract out the boiler plate code, so that the developers can focus on database related operations only.

Advantages of DBUtils

The advantages of using Apache Commons DBUtils are explained below −

No Resource Leakage − DBUtils classes ensures that no resource leakage happen.

Clean & Clear code − DBUtils classes provides clean and clear code to do the database operations without any need to write a cleanup or resource leak prevention code.

Bean Mapping − DBUtils class supports to automatically populate javabeans from a result set.

DBUtils Design Principles

The design principles of Apache Commons DBUtils are as follows −

Small − DBUtils pbrary is very small in size with fewer classes, so that it is easy to understand and use.

Transparent − DBUtils pbrary is not doing much work behind the scenes. It simply takes query and executes.

Fast − DBUtils pbrary classes do not create many background objects and is quite fast in database operation executions.