Usually data is more often read than it is written, and performing data queries is the most important task done by database-driven applications. The standard JDBC API is rather verbose and adds a lot of boilerplate code around actual queries. Groovy provides more elegance to the querying code by simplifying access and mapping logic.
This recipe contains a highlight of some of the methods you can use to query a database using Groovy.
As for the previous recipes from this chapter, we will use the
DBUtil class defined in the Creating a database table recipe as well as the same database structure.
Considering that this recipe is about querying data, we need to populate our database first. The database population ...