org.kuali.ole.gl.dataaccess.impl

Class AccountBalanceDaoJdbcBase

java.lang.Object

org.springframework.dao.support.DaoSupport

org.springframework.jdbc.core.support.JdbcDaoSupport

org.springframework.jdbc.core.simple.SimpleJdbcDaoSupport

org.kuali.rice.core.framework.persistence.jdbc.dao.PlatformAwareDaoBaseJdbc

org.kuali.ole.gl.dataaccess.impl.AccountBalanceDaoJdbcBase

All Implemented Interfaces:

org.kuali.rice.core.framework.persistence.dao.PlatformAwareDao, org.springframework.beans.factory.InitializingBean

Direct Known Subclasses:

AccountBalanceConsolidationDaoJdbc, AccountBalanceLevelDaoJdbc, AccountBalanceObjectDaoJdbc

public class AccountBalanceDaoJdbcBase
extends org.kuali.rice.core.framework.persistence.jdbc.dao.PlatformAwareDaoBaseJdbc

A base class to support the JDBC operations done for AccountBalance inquiries

Field Summary

Fields inherited from class org.springframework.dao.support.DaoSupport

logger

Constructor Summary

Constructors

Constructor and Description
AccountBalanceDaoJdbcBase()

Method Summary

Methods

Modifier and Type	Method and Description
protected void	clearTempTable(String tableName, String sessionIdColumn, String sessionId) Deletes all entries in the temporary table for the given unique user
protected void	fixPendingEntryDisplay(Integer universityFiscalYear, String sessionId) Updates the fiscal year and account numbers of temporary pending entries for display
protected boolean	hasEntriesInPendingTable(String sessionId) Determines if the currently inquiring user has associated temporary pending entries in the temporary pending entry table
protected String	inString(int count) Creates a String bounded with parantheses with count number of question marks, like this: (?, ?, ?) if count is 3.
protected void	purgeCostShareEntries(String tableName, String sessionIdColumn, String sessionId) Removes all cost share entries from the temporary holding table for this unique inquiry

Methods inherited from class org.kuali.rice.core.framework.persistence.jdbc.dao.PlatformAwareDaoBaseJdbc

getDbPlatform, setDbPlatform

Methods inherited from class org.springframework.jdbc.core.simple.SimpleJdbcDaoSupport

getSimpleJdbcTemplate, initTemplateConfig

Methods inherited from class org.springframework.jdbc.core.support.JdbcDaoSupport

checkDaoConfig, createJdbcTemplate, getConnection, getDataSource, getExceptionTranslator, getJdbcTemplate, releaseConnection, setDataSource, setJdbcTemplate

Methods inherited from class org.springframework.dao.support.DaoSupport

afterPropertiesSet, initDao

Methods inherited from class java.lang.Object

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

Constructor Detail

AccountBalanceDaoJdbcBase

public AccountBalanceDaoJdbcBase()

Method Detail

inString

protected String inString(int count)

Creates a String bounded with parantheses with count number of question marks, like this: (?, ?, ?) if count is 3. Right, for creating the SQL queries

Parameters:

count - the count of question marks

Returns:

the resulting String

purgeCostShareEntries

protected void purgeCostShareEntries(String tableName,
                         String sessionIdColumn,
                         String sessionId)

Removes all cost share entries from the temporary holding table for this unique inquiry

Parameters:

tableName - the name of the temporary table to remove cost share entries from

sessionIdColumn - the name of the column in the temporary table that holds the unique id of the inquiry

sessionId - the unique id of the web session of the inquiring user

hasEntriesInPendingTable

protected boolean hasEntriesInPendingTable(String sessionId)

Determines if the currently inquiring user has associated temporary pending entries in the temporary pending entry table

Parameters:

sessionId - the unique web id of the inquiring user

Returns:

true if this inquiring user has temporary pending entries, false otherwise

fixPendingEntryDisplay

protected void fixPendingEntryDisplay(Integer universityFiscalYear,
                          String sessionId)

Updates the fiscal year and account numbers of temporary pending entries for display

Parameters:

universityFiscalYear - the fiscal year to update all the temporary pending entries of this inquiry to

sessionId - the unique web id of the inquiring user

clearTempTable

protected void clearTempTable(String tableName,
                  String sessionIdColumn,
                  String sessionId)

Deletes all entries in the temporary table for the given unique user

Parameters:

tableName - the table name to purge data from

sessionIdColumn - the name of the unique field on that table

sessionId - the unique value of the inquiry; basically, the unique web session id of the inquiring user