Re: [postgis-users] how to get point, polygon value in postgis JDBC?

[Maria Arias de Reyna]

El Viernes, 4 de Noviembre de 2011, LeeHyung Joo - Kevin escribió:
> Hi all.
> 
> I have a big problem on my work.
> 
> First of all, the version based on my work is PostgreSQL : 8.1.11, PostGIS
> : 1.5.2.
> 
> The problem is I can not get the value of Point and Polygon.
> 
> The code is below :
> 
> blah blah
> --
> -- public Test find(String Id) throws DAOException,
> ClassNotFoundException, SQLException {
> Class.forName("org.postgresql.Driver");
> String url = "jdbc:postgresql://localhost:8080/testdao";
> Connection conn = DriverManager.getConnection(url, admin, apple);
> PreparedStatement ps = conn.prepareStatement("select name, addr,
> ST_AsText(position) from listFriend where id=?"); ps.setString(1, Id);
> 
> ResultSet rs = ps.executeQuery();
> 
> //   
> ((org.postgresql.PGConnection)conn).addDataType("point",Class.forName("org
> .postgis.Point"));
> 
> while(rs.next()) {
> test = new Test();
> p = new Point();
> 
> test.setName(rs.getString(1));
> test.setAddr(rs.getString(2));
> test.setPosition(p);
> //System.out.println(rs.getString(3));
> ---
> ---
> 
> If I run the sentence, "System.out.println(rs.getString(3));, it works. It
> prints right output like "Point(13.123 11.123)".
> 
> But I don't know how to fix test.setPosition(p);
> 
> any helps will be thank.
> 
> 
> P.S. is it possible to be reason why the low or high version of PostgreSQL
> and PostGIS?
> 
> 
> Best Regards
> Kevin Lee.


Maybe you are looking for a WKT Parser? Like this one:

http://www.vividsolutions.com/jts/javadoc/com/vividsolutions/jts/io/WKTReader.html

If you are using the postGIS driver you should be able to use the geometry 
directly on your query, instead of using as_text.

-- 
María Arias de Reyna Domínguez
Área de Operaciones

Emergya Consultoría 
Tfno: +34 954 51 75 77 / +34 607 43 74 27
Fax: +34 954 51 64 73 
www.emergya.com
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[postgis-users] how to get point, polygon value in postgis JDBC?

[LeeHyung Joo - Kevin]

Hi all.

I have a big problem on my work.

First of all, the version based on my work is PostgreSQL : 8.1.11, PostGIS : 
1.5.2.

The problem is I can not get the value of Point and Polygon.

The code is below :

blah blah 

public Test find(String Id) throws DAOException, ClassNotFoundException, 
SQLException {
Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql://localhost:8080/testdao";
Connection conn = DriverManager.getConnection(url, admin, apple);
PreparedStatement ps = conn.prepareStatement("select name, addr, 
ST_AsText(position) from listFriend where id=?");
ps.setString(1, Id);

ResultSet rs = ps.executeQuery();

//
((org.postgresql.PGConnection)conn).addDataType("point",Class.forName("org.postgis.Point"));

while(rs.next()) {
test = new Test();
p = new Point();

test.setName(rs.getString(1));
test.setAddr(rs.getString(2));
test.setPosition(p);
//System.out.println(rs.getString(3));
--

If I run the sentence, "System.out.println(rs.getString(3));, it works. It 
prints right output like "Point(13.123 11.123)".

But I don't know how to fix test.setPosition(p);

any helps will be thank.


P.S. is it possible to be reason why the low or high version of PostgreSQL and 
PostGIS?


Best Regards
Kevin Lee.
  ___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users