org.transitime.reports

Class ChartGenericJsonQuery

java.lang.Object

org.transitime.db.GenericQuery

org.transitime.reports.ChartGenericJsonQuery

public class ChartGenericJsonQuery
extends GenericQuery

For providing data to a Google scatter chart when need to specify specific SQL for retrieving data from the database. Since any SQL statement can be used this feed can be used for generating a variety of scatter charts.

Author:

SkiBu Smith

Constructor Summary

Constructors

Constructor and Description
ChartGenericJsonQuery(java.lang.String agencyId)

Method Summary

Modifier and Type	Method and Description
static java.lang.String	getJsonString(java.lang.String agencyId, java.lang.String sql) Does SQL query and returns JSON formatted results.
static void	main(java.lang.String[] args) For debugging

Methods inherited from class org.transitime.db.GenericQuery

getConnection

Methods inherited from class java.lang.Object

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

Constructor Detail

ChartGenericJsonQuery

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

Parameters:

agencyId -

Throws:

java.sql.SQLException

Method Detail

getJsonString

public static java.lang.String getJsonString(java.lang.String agencyId,
                                             java.lang.String sql)
                                      throws java.sql.SQLException

Does SQL query and returns JSON formatted results.

Parameters:

agencyId -

sql -

Returns:

Throws:

java.sql.SQLException

main

public static void main(java.lang.String[] args)

For debugging

Parameters:

args -