com.ibm.tivoli.nm.collectors.impl.ciscolms

Class CiscoLMSDatabaseAccessObject

java.lang.Object

com.ibm.tivoli.nm.collectors.impl.ciscolms.CiscoLMSDatabaseAccessObject

public class CiscoLMSDatabaseAccessObject
extends java.lang.Object

Constructor Summary

Constructors

Constructor and Description
CiscoLMSDatabaseAccessObject(java.lang.String host, java.lang.String port, java.lang.String dbName, java.lang.String userName, java.lang.String password, java.lang.String databaseType, java.lang.String connString) Constructor for the DB access object

Method Summary

Modifier and Type	Method and Description
java.util.ArrayList<java.util.HashMap<java.lang.String,java.lang.String>>	executeStatement(java.util.List<java.lang.String> columnName, java.util.List<java.lang.String> tableName, java.lang.String whereClause) Method to construct SQL query based on the column names, table names and where clause, and generates the output of the SQL query into a List
java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.String>>	executeStatement(java.util.List<java.lang.String> columnName, java.util.List<java.lang.String> tableName, java.lang.String whereClause, java.lang.String mapKey) Method to construct SQL query based on the column names, table names, where clause, and generates the output of the sql query into a Map with the mapKey as the key

Methods inherited from class java.lang.Object

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

Constructor Detail

CiscoLMSDatabaseAccessObject

public CiscoLMSDatabaseAccessObject(java.lang.String host,
                                    java.lang.String port,
                                    java.lang.String dbName,
                                    java.lang.String userName,
                                    java.lang.String password,
                                    java.lang.String databaseType,
                                    java.lang.String connString)

Constructor for the DB access object

Parameters:

host - The hostname/ip of the db to connect to the db

port - The port of the db to connect to the db

dbName - The db schema name

userName - The userName to connect to the db

password - The password to connect to the db

databaseType - The databaseType string used to register the db

connString - The connection string used to make connection via the jdbc driver

Method Detail

executeStatement

public java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.String>> executeStatement(java.util.List<java.lang.String> columnName,
                                                                                                                 java.util.List<java.lang.String> tableName,
                                                                                                                 java.lang.String whereClause,
                                                                                                                 java.lang.String mapKey)

Method to construct SQL query based on the column names, table names, where clause, and generates the output of the sql query into a Map with the mapKey as the key

Parameters:

columnName - The list of column names to be used in the SQL query

tableName - The list of table names to be used in the SQL query

whereClause - The where clause to be used in the SQL query

mapKey - The column to be used as key to the map

Returns:

Map containing the result of the SQL query

executeStatement

public java.util.ArrayList<java.util.HashMap<java.lang.String,java.lang.String>> executeStatement(java.util.List<java.lang.String> columnName,
                                                                                                  java.util.List<java.lang.String> tableName,
                                                                                                  java.lang.String whereClause)

Method to construct SQL query based on the column names, table names and where clause, and generates the output of the SQL query into a List

Parameters:

columnName - The list of column names to be used in the SQL query

tableName - The list of table names to be used in the SQL query

whereClause - The where clause to be used in the SQL query

Returns:

List containing the result of the SQL query