HelloResource.java

package org.pwntester.jaxrs_jdbc;

import com.fasterxml.jackson.annotation.JsonProperty;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowCallbackHandler;

import javax.ws.rs.*;
import javax.ws.rs.core.MediaType;
import java.sql.ResultSet;
import java.sql.SQLException;

@Path("/hello-world")
public class HelloResource {

    @Autowired
    private JdbcTemplate template;

    @POST
    @Path("/xyz")
    @Consumes(MediaType.APPLICATION_JSON)
    @Produces(MediaType.APPLICATION_JSON)
    public String doQuery(SearchQuery sql) {
        template.query(sql.queryName, new RowCallbackHandler() {
            @Override
            public void processRow(ResultSet resultSet) throws SQLException {
                System.out.println("foo");
            }
        });
        return "Hello, World!";
    }

    public static class SearchQuery {
        @JsonProperty("queryName")
        public String queryName;
    }
}