com.fgm.javaUtils.dbObjects

Class InfoObjectManager

java.lang.Object

com.fgm.javaUtils.dbObjects.BaseObject

com.fgm.javaUtils.dbObjects.InfoObjectManager

public class InfoObjectManager
extends BaseObject

InfoObjectManager. Coordinates the other info objects and communicates with the client

Field Summary

Fields inherited from class com.fgm.javaUtils.dbObjects.BaseObject

_dbHelper, _dbName, _driverName, _hostName, _logger, _passwordString, _props, _userName

Constructor Summary

Constructors

Constructor and Description
InfoObjectManager() Instantiates a new info object manager.

Method Summary

Methods

Modifier and Type	Method and Description
java.lang.String	alterTable(CreateTableObject cto) Compare the table that is currently in the database and add/delete columns to match the map contained in the CreateTableObject.
protected java.lang.String	buildInsertSql(java.lang.String tableName, java.util.Map dataObject) Build a SQL string that will insert the contents of the dataObject map into the named table.
java.lang.String	createTable(CreateTableObject cto) Using the map of data contained in the CreateTableObject as a template, build a mySql table.
java.lang.String	createTableAndInsert(CreateTableObject cto) Check to see if the table already exists.
java.lang.String	describeObject(CreateTableObject cto) Returns a string containing a list of items in the data, the value used to create the table, and the java type of the data.
java.lang.String	dropTable(CreateTableObject cto) Drop the table specified in the tablename string within the CreateTableObject.
protected java.lang.String	genCreateTableSql(java.lang.String tableName, java.util.Map dataMap) Break down client object into a sql table.
java.lang.String	insertData(InsertObject io) Take the map wrapped in the passed-in InsertObject and store the values in the named table.
static void	main(java.lang.String[] args) The main method.
java.lang.String	precompiledInsert(InsertObject io) Take the map wrapped in the passed-in InsertObject and store the values in the named table using precompiled query syntax NOTE: THis code is unfinished and not working.
QueryResponseObject	retrieveData(QueryObject qo) Run a query using the query string contained in the QueryObject.
QueryResponseObject	runSql(QueryObject qo) Run the sql statement contained in the QueryObject.

Methods inherited from class com.fgm.javaUtils.dbObjects.BaseObject

createDatabase, getInfo, runSql

Methods inherited from class java.lang.Object

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

Constructor Detail

InfoObjectManager

public InfoObjectManager()

Instantiates a new info object manager.

Method Detail

genCreateTableSql

protected java.lang.String genCreateTableSql(java.lang.String tableName,
                                 java.util.Map dataMap)

Break down client object into a sql table.

Parameters:

tableName - the table name

dataMap - the data map

Returns:

the string

describeObject

public java.lang.String describeObject(CreateTableObject cto)

Returns a string containing a list of items in the data, the value used to create the table, and the java type of the data.

Parameters:

cto - the CreateTableObject

Returns:

the string

createTable

public java.lang.String createTable(CreateTableObject cto)

Using the map of data contained in the CreateTableObject as a template, build a mySql table.

Parameters:

cto - the cto

Returns:

- a string showing the status of the action

createTableAndInsert

public java.lang.String createTableAndInsert(CreateTableObject cto)

Check to see if the table already exists. If it does, then return. Otherwise create a table based on the map contained in the CreateTableObject and then insert that object as the first item in the table

Parameters:

cto - the cto

Returns:

- a string showing the status of the action

buildInsertSql

protected java.lang.String buildInsertSql(java.lang.String tableName,
                              java.util.Map dataObject)

Build a SQL string that will insert the contents of the dataObject map into the named table.

Parameters:

tableName - the table name

dataObject - the data object

Returns:

- the SQL string

insertData

public java.lang.String insertData(InsertObject io)

Take the map wrapped in the passed-in InsertObject and store the values in the named table.

Parameters:

io - - InsertObject containing table name and a Map of data

Returns:

- a string showing the status of the action

alterTable

public java.lang.String alterTable(CreateTableObject cto)

Compare the table that is currently in the database and add/delete columns to match the map contained in the CreateTableObject.

Parameters:

cto - the cto

Returns:

the string

dropTable

public java.lang.String dropTable(CreateTableObject cto)

Drop the table specified in the tablename string within the CreateTableObject.

Parameters:

cto - the cto

Returns:

- a string showing the status of the action

precompiledInsert

public java.lang.String precompiledInsert(InsertObject io)

Take the map wrapped in the passed-in InsertObject and store the values in the named table using precompiled query syntax NOTE: THis code is unfinished and not working.

Parameters:

io - - InsertObject containing table name and a Map of data

Returns:

- a string showing the status of the action

retrieveData

public QueryResponseObject retrieveData(QueryObject qo)

Run a query using the query string contained in the QueryObject. Typically, this string has been built in InfoObjectManager.as

Parameters:

qo - the qo

Returns:

a QueryResponseObject that contains an ArrayList of Maps with the results of the query

runSql

public QueryResponseObject runSql(QueryObject qo)

Run the sql statement contained in the QueryObject. Typically, this string has been built in InfoObjectManager.as

Parameters:

qo - the qo

Returns:

a QueryResponseObject that contains an ArrayList of Maps with the results of the query

main

public static void main(java.lang.String[] args)
                 throws org.dom4j.DocumentException,
                        java.io.IOException

The main method.

Parameters:

args - the arguments

Throws:

org.dom4j.DocumentException - the document exception

java.io.IOException - Signals that an I/O exception has occurred.