eu.slipo.athenarc.triplegeo.db

Class MySqlDbConnector

java.lang.Object

eu.slipo.athenarc.triplegeo.db.MySqlDbConnector

All Implemented Interfaces:

DbConnector

public class MySqlDbConnector
extends java.lang.Object
implements DbConnector

MySQL implementation of DbConnector class. NOTE: JDBC driver automatically uses the encoding specified by the host; no need to specify such parameter in the connection.

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
MySqlDbConnector(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 MySQL database.

Method Summary

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

MySqlDbConnector

public MySqlDbConnector(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 MySQL 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 MySQL database.

executeQuery

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

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

Specified by:

closeConnection in interface DbConnector

openConnection

private java.sql.Connection openConnection()

Establishes a connection to the MySQL database.

Returns:

Connection to the database.