CODEWITHSUNDEEP
javapostgresqljdbcpostgispostgresql-9.1
Adnan Ali
Adnan Ali

Reputation: 103

Insert Point (Geometry) value in PostgreSQL with JDBC

Please give me code example to insert records containing SQL statement:

insert into TABLE 
(id, value1, value2, point, value3) 
values
(1,'A', 'M', POINT (13.45646, 56.61782),5);

in JDBC/Postgresql code.

If anyone has solution of PreparedStatement or anyother useful solution it is highly welcomed!

Upvotes: 10

Views: 10797

Answers (1)

Mike T
Mike T

Reputation: 43642

At the simplest level, you can build a prepared statement using geometry constructors to pass parameters.

insert into "TABLE"(id, value1, value2, point, value3)
values(1, $1, $2, ST_SetSRID(ST_MakePoint($3, $4), 4326)), $5);

Where $3 and $4 are the longitude and latitude.

See also the PostGIS documentation for the JDBC interface which may be useful with other geometry types (LineString, Polygon, MultiPoint, MultiLineString, MultiPolygon).

Upvotes: 7

Related Questions