- Apache Commons DBUtils Tutorial
- DBUtils - Home
- DBUtils - Overview
- DBUtils - Environment Setup
- DBUtils - First Application
- Basic CRUD Examples
- DBUtils - Create Query
- DBUtils - Read Query
- DBUtils - Update Query
- DBUtils - Delete Query
- Apache Commons DBUtils Examples
- DBUtils - QueryRunner interface
- DBUtils - AsyncQueryRunner interface
- DBUtils - ResultSetHandler interface
- DBUtils - BeanHandler Class
- DBUtils - BeanListHandler Class
- DBUtils - ArrayListHandler Class
- DBUtils - MapListHandler Class
- Advanced DBUtils Examples
- DBUtils - Custom Handler
- DBUtils - Custom Row Processor
- DBUtils - Using DataSource
- DBUtils Useful Resources
- DBUtils - Quick Guide
- DBUtils - Useful Resources
- DBUtils - Discussion
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 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 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.