RestAssured: example of using GPath for json response on July 13, 2017 API Java json JUnit REST RestAssured +
Move your sql query to resource file with @Autowired and factory method on July 01, 2017 DAO Java jdbc Spring SQL +