sql database for testing code example

Example: database testing

JDBC
It is a Java-based data access technology used for Java database connectivity.
It provides classes and interfaces to connect or communicate Java 
application with database. 
JDBC API is a Java API that can access any kind of data stored in 
a Relational Database. It enables Java programs to execute SQL statements.

How did you do DB testing in your framework?

In my automation framework I have DB Utilities class which handles 
everything related to setting up connections, closing connections, 
getting data from database and storing results from database into 
different collections, arrays, etc. So that I can easily work with it.