org.transitime.db

Class GenericQuery

java.lang.Object

org.transitime.db.GenericQuery

Direct Known Subclasses:

ChartGenericJsonQuery, GenericCsvQuery, GenericJsonQuery

public abstract class GenericQuery
extends java.lang.Object

For doing a query without using Hibernate. By using regular JDBC and avoiding Hibernate can connect to multiple databases of different types.

Author:

SkiBu Smith

Constructor Summary

Constructors

Constructor and Description
GenericQuery(java.lang.String agencyId) Constructor
GenericQuery(java.lang.String dbType, java.lang.String dbHost, java.lang.String dbName, java.lang.String dbUserName, java.lang.String dbPassword) Constructor

Method Summary

Modifier and Type	Method and Description
static java.sql.Connection	getConnection(java.lang.String dbType, java.lang.String dbHost, java.lang.String dbName, java.lang.String dbUserName, java.lang.String dbPassword) Gets a database connection to be used for the query

Methods inherited from class java.lang.Object

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

Constructor Detail

GenericQuery

public GenericQuery(java.lang.String dbType,
                    java.lang.String dbHost,
                    java.lang.String dbName,
                    java.lang.String dbUserName,
                    java.lang.String dbPassword)
             throws java.sql.SQLException

Constructor

Parameters:

dbType -

dbHost -

dbName -

dbUserName -

dbPassword -

Throws:

java.sql.SQLException

GenericQuery

public GenericQuery(java.lang.String agencyId)
             throws java.sql.SQLException

Constructor

Parameters:

agencyId -

Throws:

java.sql.SQLException

Method Detail

getConnection

public static java.sql.Connection getConnection(java.lang.String dbType,
                                                java.lang.String dbHost,
                                                java.lang.String dbName,
                                                java.lang.String dbUserName,
                                                java.lang.String dbPassword)
                                         throws java.sql.SQLException

Gets a database connection to be used for the query

Parameters:

dbType -

dbHost -

dbName -

dbUserName -

dbPassword -

Returns:

Throws:

java.sql.SQLException