eu.slipo.athenarc.triplegeo.db

Class MsAccessDbConnector

java.lang.Object

eu.slipo.athenarc.triplegeo.db.MsAccessDbConnector

All Implemented Interfaces:

DbConnector

public class MsAccessDbConnector
extends java.lang.Object
implements DbConnector

Microsoft Access implementation of DbConnector class. CAUTION: In the execution, include -Dfile.encoding=UTF-8 when applying against geodatabases with UTF-8 encoding; similarly for other encodings.

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	password
private java.lang.String	username

Constructor Summary

Constructors

Constructor and Description
MsAccessDbConnector(java.lang.String dbName, java.lang.String username, java.lang.String password) Constructor of DbConnector implementation class for establishing a connection to a MSAccess database.

Method Summary

Modifier and Type	Method and Description
void	closeConnection() Closes the connection to the MSAccess database.
java.sql.ResultSet	executeQuery(java.lang.String query) Returns the result of the SQL query executed against the MSAccess database.
java.lang.String	getDatabaseUrl() Returns the Database URL.
private java.sql.Connection	openConnection() Establishes a connection to the MSAccess 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

username

private java.lang.String username

password

private java.lang.String password

connection

private java.sql.Connection connection

Constructor Detail

MsAccessDbConnector

public MsAccessDbConnector(java.lang.String dbName,
                           java.lang.String username,
                           java.lang.String password)

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

Parameters:

dbName - Full path to the MSAccess database.

username - The user name to access the database (if applicable).

password - The password to access the database (if applicable).

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 MSAccess database.

executeQuery

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

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

Specified by:

closeConnection in interface DbConnector

openConnection

private java.sql.Connection openConnection()

Establishes a connection to the MSAccess database.

Returns:

Connection to the database.