by.belsoft.report.tools.reportdb
Class QueryUtilities

java.lang.Object
  |
  +--by.belsoft.report.tools.reportdb.QueryUtilities

public class QueryUtilities

extends java.lang.Object

The class to work with datasources

Author:

Ilya Kirillov

Constructor Summary

QueryUtilities()

Method Summary

java.sql.Connection	getConnection(java.lang.String url, java.lang.String login, java.lang.String password) getConnection gets connection by given data
java.util.ArrayList	getDrivers() getDrivers gets drivers avalible
java.util.ArrayList	getTableColumns(java.sql.Connection con, java.lang.String table, java.lang.String pre, java.lang.String url) getTableColumns gets database table columns
java.util.ArrayList	getTables(java.sql.Connection con, java.lang.String url) getTables gets database tables
void	loadDrivers(java.net.URL[] urlList) loadDrivers loads drivers
boolean	testDriver(java.lang.String driver) testDriver tests driver

Methods inherited from class java.lang.Object

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

Constructor Detail

QueryUtilities

public QueryUtilities()

Method Detail

getConnection

public java.sql.Connection getConnection(java.lang.String url,
                                         java.lang.String login,
                                         java.lang.String password)

getConnection gets connection by given data

Parameters:

url - String the url

login - String the login

password - String the parrword

Returns:

Connection the result connection

loadDrivers

public void loadDrivers(java.net.URL[] urlList)

loadDrivers loads drivers

Parameters:

urlList - URL[] the drivers urls

getDrivers

public java.util.ArrayList getDrivers()

getDrivers gets drivers avalible

Returns:

ArrayList with drivers

testDriver

public boolean testDriver(java.lang.String driver)

testDriver tests driver

Parameters:

driver - String the driver to test

Returns:

boolean test state

getTables

public java.util.ArrayList getTables(java.sql.Connection con,
                                     java.lang.String url)

getTables gets database tables

Parameters:

con - Connection the connection

url - String the url

Returns:

ArrayList with tables

getTableColumns

public java.util.ArrayList getTableColumns(java.sql.Connection con,
                                           java.lang.String table,
                                           java.lang.String pre,
                                           java.lang.String url)

getTableColumns gets database table columns

Parameters:

con - Connection the connection

table - String the table

pre - String the prefix

url - String the url

Returns:

ArrayList the list with tables