The drop wizard example application was developed to, as its name implies, provide examples of some of the features present in drop wizard.
Included with this application is an example of the optional db API module. The examples provided illustrate a few of the features available in JDBI, along with demonstrating how these are used from within dropwizard.
This database example is comprised of the following classes.
-
The
PersonDAO
illustrates using the SQL Object Queries and string template features in JDBI. -
All the SQL statements for use in the
PersonDAO
are located in thePerson
class. -
migrations.xml
illustrates the usage ofdropwizard-migrations
which can create your database prior to running your application for the first time. -
The
PersonResource
andPeopleResource
are the REST resource which use the PersonDAO to retrieve data from the database, note the injection of the PersonDAO in their constructors.
As with all the modules the db example is wired up in the initialize
function of the HelloWorldApplication
.
To test the example application run the following commands.
-
To package the example run.
mvn package
-
To setup the h2 database run.
java -jar target/dropwizard-example-0.8.0-SNAPSHOT.jar db migrate example.yml
-
To run the server run.
java -jar target/dropwizard-example-0.8.0-SNAPSHOT.jar server example.yml
-
To hit the Hello World example (hit refresh a few times).
-
To post data into the application.
curl -H "Content-Type: application/json" -X POST -d '{"fullName":"Other Person","jobTitle":"Other Title"}' http://localhost:8080/people