org.transitime.db

Class GenericCsvQuery

java.lang.Object

org.transitime.db.GenericQuery

org.transitime.db.GenericCsvQuery

public class GenericCsvQuery
extends GenericQuery

For doing an SQL query and returning the results in CVS format.

Author:

SkiBu Smith

Method Summary

Modifier and Type	Method and Description
static java.lang.String	getCsvString(java.lang.String agencyId, java.lang.String sql) Runs a query and returns result as a CSV string.
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

Method Detail

getCsvString

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

Runs a query and returns result as a CSV string.

Parameters:

agencyId - For determining which database to access

sql - The SQL to execute

Returns:

CVS string of results from query

Throws:

java.sql.SQLException

main

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

For debugging.

Parameters:

args -