eu.slipo.athenarc.triplegeo.db

Class SqlServerDbConnector

java.lang.Object

eu.slipo.athenarc.triplegeo.db.SqlServerDbConnector

All Implemented Interfaces:

DbConnector

public class SqlServerDbConnector
extends java.lang.Object
implements DbConnector

Microsoft SQL Server implementation of DbConnector class. LIMITATION: SQL Server does NOT inherently support transformation between coordinate reference systems (CRS).

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

Constructor Summary

Constructors

Constructor and Description
SqlServerDbConnector(java.lang.String host, int port, java.lang.String dbName, java.lang.String username, java.lang.String password) Constructor of DbConnector implementation class for establishing a connection to a SQLServer 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 SQLServer 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

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

connection

private java.sql.Connection connection

Constructor Detail

SqlServerDbConnector

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

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

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.

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 SQLServer 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.