[postgis-users] How do I handle a ResultSet from a java request?
drsockmonkee at gmail.com
Tue Oct 6 15:44:29 PDT 2015
Thanks for the help everyone..
It works.. I have a little bit of polishing up but it is printing out the
The money portion ...
con = DriverManager.getConnection(
"jdbc:postgresql://myserver/mydb", "user", "password");
st = con.createStatement();
//This has to be in a single line to work.
String myQuery = "SELECT row_to_json(fc) FROM (SELECT 'FeatureCollection'
As type, array_to_json(array_agg(f)) As features FROM (SELECT 'Feature' As
type, ST_AsGeoJSON(lg.geog)::json As geometry, row_to_json((ani_id, name,
lat, lon, animalpref)) As properties FROM animals As lg ) As f ) As fc;";
rs = st.executeQuery(myQuery);
String returnValue = "";
String myResults = rs.getString(1);
returnValue = myResults;
On Tue, Oct 6, 2015 at 3:21 PM, Andrew Davis <drsockmonkee at gmail.com> wrote:
> Thanks... i will
> On Oct 6, 2015 3:21 PM, "Walter Nordmann" <walter.nordmann at web.de> wrote:
>> have a look at JDBC. thats's the right software library to use.
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users