com.raritantechnologies.prefs
Class JdbcManager

java.lang.Object
  com.raritantechnologies.prefs.JdbcManager

public class JdbcManager

extends java.lang.Object

Contains JDBC-specific logic for the RTI prefs package. Gets user preferences from a database table and can save preferences from PreferencesBean objects. The PreferencesBean contains mapping of preferences value to the specific table in which the value is stored.

Developed by Raritan Technologies .

Author:

Glenn Robitaille

Constructor Summary

JdbcManager()

Method Summary

void	connect(java.lang.String databaseConnectionManagerName)
void	disconnect()
void	finalize()
java.util.Set	getMultiRowSet(java.lang.String databaseConnectionManagerName, java.lang.String tblName, java.lang.String tblUserColumn, java.lang.String userId, java.lang.String selectColumn) get preferences for a preferences table, which are stored as a single row using some sort of userid key.
java.util.HashMap	getSingleRowPrefs(java.lang.String databaseConnectionManagerName, java.lang.String table, java.lang.String userColumn, java.lang.String userId) get preferences for a preferences table, which are stored as a single row using some sort of userid key.
void	saveMultiRowSet(java.lang.String databaseConnectionManagerName, java.lang.String table, java.lang.String userColumn, java.lang.String userId, PreferencesBean prefBean)
void	saveSingleRowPrefs(java.lang.String databaseConnectionManagerName, java.lang.String table, java.lang.String userColumn, java.lang.String userId, PreferencesBean prefBean)

Methods inherited from class java.lang.Object

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

Constructor Detail

JdbcManager

public JdbcManager()

Method Detail

connect

public void connect(java.lang.String databaseConnectionManagerName)
             throws ConfigurationException,
                    java.sql.SQLException

Throws:

ConfigurationException

java.sql.SQLException

disconnect

public void disconnect()
                throws ConfigurationException,
                       java.sql.SQLException

Throws:

ConfigurationException

java.sql.SQLException

getSingleRowPrefs

public java.util.HashMap getSingleRowPrefs(java.lang.String databaseConnectionManagerName,
                                           java.lang.String table,
                                           java.lang.String userColumn,
                                           java.lang.String userId)
                                    throws ConfigurationException,
                                           java.sql.SQLException

get preferences for a preferences table, which are stored as a single row using some sort of userid key.

Throws:

ConfigurationException

java.sql.SQLException

saveSingleRowPrefs

public void saveSingleRowPrefs(java.lang.String databaseConnectionManagerName,
                               java.lang.String table,
                               java.lang.String userColumn,
                               java.lang.String userId,
                               PreferencesBean prefBean)
                        throws ConfigurationException,
                               java.sql.SQLException

Throws:

ConfigurationException

java.sql.SQLException

getMultiRowSet

public java.util.Set getMultiRowSet(java.lang.String databaseConnectionManagerName,
                                    java.lang.String tblName,
                                    java.lang.String tblUserColumn,
                                    java.lang.String userId,
                                    java.lang.String selectColumn)
                             throws ConfigurationException,
                                    java.sql.SQLException

get preferences for a preferences table, which are stored as a single row using some sort of userid key.

Throws:

ConfigurationException

java.sql.SQLException

saveMultiRowSet

public void saveMultiRowSet(java.lang.String databaseConnectionManagerName,
                            java.lang.String table,
                            java.lang.String userColumn,
                            java.lang.String userId,
                            PreferencesBean prefBean)
                     throws ConfigurationException,
                            java.sql.SQLException

Throws:

ConfigurationException

java.sql.SQLException

finalize

public void finalize()