Interacting with the database
Now we have a database and data in place. However, in order to be able to connect to the database, we need to include the
mysql jdbc connector in the project. Also, we will need the
dropwizard-jdbi module that will allow us to create a database connection and Data Access Objects (DAO) through which we will query the database, making use of the API provided by the JDBI project (http://jdbi.org/).
Let's see what is needed in order to achieve this. First, add the following dependencies in
pom.xml within the