eu.slipo.athenarc.triplegeo.db

Class DB2DbConnector

java.lang.Object

eu.slipo.athenarc.triplegeo.db.DB2DbConnector

All Implemented Interfaces:

DbConnector

public class DB2DbConnector
extends java.lang.Object
implements DbConnector

IBM DB2 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
DB2DbConnector(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 an IBM DB2 database with the Spatial Extender.

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 IBM DB2 database.
java.lang.String	getDatabaseUrl() Returns the Database URL.
private java.sql.Connection	openConnection() Establishes a connection to the IBM DB2 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

DB2DbConnector

public DB2DbConnector(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 an IBM DB2 database with the Spatial Extender.

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 IBM DB2 database.

executeQuery

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

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

Returns:

Connection to the database.