eu.slipo.athenarc.triplegeo.db

Class SpatiaLiteDbConnector

java.lang.Object

eu.slipo.athenarc.triplegeo.db.SpatiaLiteDbConnector

All Implemented Interfaces:

DbConnector

public class SpatiaLiteDbConnector
extends java.lang.Object
implements DbConnector

SpatiaLite implementation of DbConnector class. Used in establishing a connection to a SpatiaLite database. IMPORTANT! Native libraries for SpatiaLite (https://www.gaia-gis.it/fossil/libspatialite/index) must be located in the directory at which the Java application is called in order to run smoothly this 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

Constructor Summary

Constructors

Constructor and Description
SpatiaLiteDbConnector(java.lang.String dbName, java.lang.String encoding) Constructor of DbConnector implementation class for establishing connection to a SpatiaLite database.

Method Summary

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

Methods inherited from class java.lang.Object

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

Field Detail

dbName

private java.lang.String dbName

connection

private java.sql.Connection connection

encoding

private java.lang.String encoding

Constructor Detail

SpatiaLiteDbConnector

public SpatiaLiteDbConnector(java.lang.String dbName,
                             java.lang.String encoding)

Constructor of DbConnector implementation class for establishing connection to a SpatiaLite database.

Parameters:

dbName - The name of 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 database.

executeQuery

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

Returns the result of the SQL query executed against the SpatiaLite 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 database.

Specified by:

closeConnection in interface DbConnector

openConnection

private java.sql.Connection openConnection()

Establishes a connection to the Database.

Returns:

Connection to the database.