org.kuali.kfs.module.bc.document.dataaccess.impl

Class BudgetConstructionDaoJdbcBase

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.kfs.module.bc.document.dataaccess.impl.BudgetConstructionDaoJdbcBase

All Implemented Interfaces:

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

Direct Known Subclasses:

BenefitsCalculationDaoJdbc, BudgetConstructionAccountFundingDetailReportDaoJdbc, BudgetConstructionAccountObjectDetailReportDaoJdbc, BudgetConstructionAccountSummaryReportDaoJdbc, BudgetConstructionDocumentAccountObjectDetailReportDaoJdbc, BudgetConstructionHumanResourcesPayrollInterfaceDaoJdbc, BudgetConstructionLevelSummaryReportDaoJdbc, BudgetConstructionList2PLGReportDaoJdbc, BudgetConstructionMonthlyBudgetsCreateDeleteDaoJdbc, BudgetConstructionMonthSummaryReportDaoJdbc, BudgetConstructionObjectSummaryReportDaoJdbc, BudgetConstructionPositionFundingDetailReportDaoJdbc, BudgetConstructionReasonStatisticsReportDaoJdbc, BudgetConstructionSalaryStatisticsReportDaoJdbc, BudgetConstructionSalarySummaryReportDaoJdbc, BudgetConstructionSynchronizationProblemsReportDaoJdbc, BudgetOrganizationPushPullDaoJdbc, BudgetPullupDaoJdbc, BudgetReportsControlListDaoJdbc, HumanResourcesPayrollDaoJdbc, OrganizationBCDocumentSearchDaoJdbc, OrganizationSalarySettingSearchDaoJdbc, ReportDumpDaoJdbc

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

create methods for building SQL useful to all extenders

Field Summary

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

logger

Constructor Summary

Constructors

Constructor and Description
BudgetConstructionDaoJdbcBase()

Method Summary

Methods

Modifier and Type	Method and Description
protected void	clearTempTableBySesId(String tableName, String SesIdColumn, String sessionId)
protected void	clearTempTableByUnvlId(String tableName, String personUnvlIdColumn, String principalName)
protected Date	getFiscalYearStartDate(Integer universityFiscalYear) given a fiscal year, get the first day of that fiscal year
protected StringBuilder	getSqlSubStringFunction(String fieldName, Integer startLocation, Integer substringLength) return a substring function that is Oracle-specific if the DB Platform is Oracle, and an ANSI-92 compliant function otherwise Oracle's syntax is not ANSI-92 compliant
void	setOjbOraclePlatform(String ojbOraclePlatform)
void	setOjbPlatform(String ojbPlatform)

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

BudgetConstructionDaoJdbcBase

public BudgetConstructionDaoJdbcBase()

Method Detail

clearTempTableByUnvlId

protected void clearTempTableByUnvlId(String tableName,
                          String personUnvlIdColumn,
                          String principalName)

clearTempTableBySesId

protected void clearTempTableBySesId(String tableName,
                         String SesIdColumn,
                         String sessionId)

getFiscalYearStartDate

protected Date getFiscalYearStartDate(Integer universityFiscalYear)

given a fiscal year, get the first day of that fiscal year

Parameters:

universityFiscalYear - = fiscal year (must be in the table)

Returns:

the date on which the fiscal year passed as a parameter starts

getSqlSubStringFunction

protected StringBuilder getSqlSubStringFunction(String fieldName,
                                    Integer startLocation,
                                    Integer substringLength)

return a substring function that is Oracle-specific if the DB Platform is Oracle, and an ANSI-92 compliant function otherwise Oracle's syntax is not ANSI-92 compliant

Parameters:

fieldName - = string representing the name of the DB field (possibly qualified)

startLocation - = starting location of the substring

substringLength - = length of the substring

Returns:

the substring function

setOjbPlatform

public void setOjbPlatform(String ojbPlatform)

setOjbOraclePlatform

public void setOjbOraclePlatform(String ojbOraclePlatform)