lundi 20 avril 2015

Postgis - geography data type via JDBC

I am working on a web project, using postgresql 9.3 postgis 2.1.

I have a column of type geography in the table, it just store a point.

Now I need to insert / select the type via JDBC with Java object.

I have read postgis manual, but it provides little information.

My questions is:

  1. In java pojo model class, what Java type I should use for the column?
  2. How do I write the insert sql?
  3. How do I write the select sql to retrieve the value and put into Java object?
  4. If I am using mybatis, does it effect answers to above questions?

Aucun commentaire:

Enregistrer un commentaire