org.deegree.sqldialect.postgis
Class PostGISGeometryConverter

java.lang.Object
  org.deegree.sqldialect.postgis.PostGISGeometryConverter

All Implemented Interfaces:

ParticleConverter<Geometry>, GeometryParticleConverter

public class PostGISGeometryConverter
extends Object
implements GeometryParticleConverter

GeometryParticleConverter for PostGIS databases.

Version:

$Revision: 31055 $, $Date: 2011-06-14 17:19:48 +0200 (Di, 14. Jun 2011) $

Author:

Markus Schneider, last edited by: $Author: mschneider $

Constructor Summary

PostGISGeometryConverter(String column, ICRS crs, String srid, boolean useLegacyPredicates)
Creates a new PostGISGeometryConverter instance.

Method Summary

ICRS	getCrs()
String	getSelectSnippet(String tableAlias) Returns an SQL fragment for SELECTing the particle value from the associated database table.
String	getSetSnippet(Geometry particle) Returns a PreparedStatement fragment for setting the given particle value in an SQL statement.
String	getSrid()
void	setParticle(PreparedStatement stmt, Geometry particle, int paramIndex) Converts the given particle and sets the designated SQL parameter in the given PreparedStatement.
Geometry	toParticle(ResultSet rs, int colIndex) Builds a particle from the specified column of the current row of the given ResultSet.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

PostGISGeometryConverter

public PostGISGeometryConverter(String column,
                                ICRS crs,
                                String srid,
                                boolean useLegacyPredicates)

Creates a new PostGISGeometryConverter instance.

Parameters:

column - (unqualified) column that stores the geometry, must not be null

crs - CRS of the stored geometries, can be null

srid - PostGIS spatial reference identifier, must not be null

useLegacyPredicates - if true, legacy-style PostGIS spatial predicates are used (e.g. Intersects instead of ST_Intersects)

Method Detail

getSelectSnippet

public String getSelectSnippet(String tableAlias)

Description copied from interface: ParticleConverter

Returns an SQL fragment for SELECTing the particle value from the associated database table.

Specified by:

getSelectSnippet in interface ParticleConverter<Geometry>

Parameters:

tableAlias - alias that's used for disambiguating the table, may be null

Returns:

SQL fragment (e.g. X1.columname), may be null

toParticle

public Geometry toParticle(ResultSet rs,
                           int colIndex)
                    throws SQLException

Description copied from interface: ParticleConverter

Builds a particle from the specified column of the current row of the given ResultSet.

Specified by:

toParticle in interface ParticleConverter<Geometry>

Parameters:

rs - result set, never null

colIndex - index of the column in the result set

Returns:

particle, may be null

Throws:

SQLException

getSetSnippet

public String getSetSnippet(Geometry particle)

Description copied from interface: ParticleConverter

Returns a PreparedStatement fragment for setting the given particle value in an SQL statement.

The value may be set in a literal SQL fashion (e.g. '2007-08-09') or as a PreparedStatement placeholder ('?').

Specified by:

getSetSnippet in interface ParticleConverter<Geometry>

Parameters:

particle - particle value, can be null

Returns:

SQL fragment (e.g. ?), may be null

setParticle

public void setParticle(PreparedStatement stmt,
                        Geometry particle,
                        int paramIndex)
                 throws SQLException

Description copied from interface: ParticleConverter

Converts the given particle and sets the designated SQL parameter in the given PreparedStatement.

Specified by:

setParticle in interface ParticleConverter<Geometry>

Parameters:

stmt - prepared statement, never null

particle - particle value, can be null

paramIndex - index of the SQL parameter in the statement

Throws:

SQLException

getSrid

public String getSrid()

Specified by:

getSrid in interface GeometryParticleConverter

getCrs

public ICRS getCrs()

Specified by:

getCrs in interface GeometryParticleConverter