eu.slipo.athenarc.triplegeo.db

Class PostgisDbConnector

java.lang.Object

eu.slipo.athenarc.triplegeo.db.PostgisDbConnector

All Implemented Interfaces:

DbConnector

public class PostgisDbConnector
extends java.lang.Object
implements DbConnector

PostgreSQL/PostGIS implementation of DbConnector class.

Version:

2.0

Author:

Kostas Patroumpas

Field Summary

Fields

Modifier and Type	Field and Description
private java.sql.Connection	connection
private java.lang.String	dbName
private java.lang.String	encoding
private java.lang.String	host
private java.lang.String	password
private int	port
private java.lang.String	username

Constructor Summary

Constructors

Constructor and Description
PostgisDbConnector(java.lang.String host, int port, java.lang.String dbName, java.lang.String username, java.lang.String password, java.lang.String encoding) Constructor of DbConnector implementation class for establishing a connection to a PostgreSQL database with the PostGIS spatial extension.

Method Summary

Modifier and Type	Method and Description
void	closeConnection() Closes the connection to the PostgreSQL/PostGIS database.
java.sql.ResultSet	executeQuery(java.lang.String query) Returns the result of the SQL query executed against the PostgreSQL/PostGIS database.
java.lang.String	getDatabaseUrl() Returns the Database URL.
private java.sql.Connection	openConnection() Establishes a connection to the PostgreSQL/PostGIS database.

Methods inherited from class java.lang.Object

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

Field Detail

host

private java.lang.String host

port

private int port

dbName

private java.lang.String dbName

username

private java.lang.String username

password

private java.lang.String password

encoding

private java.lang.String encoding

connection

private java.sql.Connection connection

Constructor Detail

PostgisDbConnector

public PostgisDbConnector(java.lang.String host,
                          int port,
                          java.lang.String dbName,
                          java.lang.String username,
                          java.lang.String password,
                          java.lang.String encoding)

Constructor of DbConnector implementation class for establishing a connection to a PostgreSQL database with the PostGIS spatial extension.

Parameters:

host - The IP of the machine where the database is hosted.

port - The port where the database is listening.

dbName - The name of the database to connect to.

username - The user name credential to access the database.

password - The password credential to access the database.

encoding - The character encoding used in the database.

Method Detail

getDatabaseUrl

public java.lang.String getDatabaseUrl()

Returns the Database URL.

Specified by:

getDatabaseUrl in interface DbConnector

Returns:

databaseUrl with the URL of the PostgreSQL/PostGIS database.

executeQuery

public java.sql.ResultSet executeQuery(java.lang.String query)

Returns the result of the SQL query executed against the PostgreSQL/PostGIS database.

Specified by:

executeQuery in interface DbConnector

Parameters:

query - A SQL command for the SELECT query.

Returns:

Resultset with all results of the query.

closeConnection

public void closeConnection()

Closes the connection to the PostgreSQL/PostGIS database.

Specified by:

closeConnection in interface DbConnector

openConnection

private java.sql.Connection openConnection()

Establishes a connection to the PostgreSQL/PostGIS database.

Returns:

Connection to the database.