Apache Commons DBUtils - Overview

Apache Commons DbUtils library 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 developers can focus on database related operations only.

Advantages of using DBUtils

• No Resource Leakage − DBUtils classes ensures that no resource leakage happen.
• Clean & Clear code − DBUtils classes provides clean and clear code to do database operations without needing to write any cleanup or resource leak prevention code.
• Bean Mapping − DBUtils class supports to automatically populate javabeans from a result set.

DBUtils Design principles

• Small − DBUtils library is very small in size with fewer classes so that it is easy to understand and use.
• Transparent − DBUtils library is not doing much work behind the scenes. It simply takes query and executes.
• Fast − DBUtils library classes do not create many background objects and is quite fast in database operation executions.