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.kns.dao.jdbc.PlatformAwareDaoBaseJdbc
                  org.kuali.kfs.module.bc.document.dataaccess.impl.BudgetConstructionDaoJdbcBase

All Implemented Interfaces:

org.kuali.rice.kns.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.kns.dao.jdbc.PlatformAwareDaoBaseJdbc

create methods for building SQL useful to all extenders

Field Summary

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

logger

Constructor Summary

BudgetConstructionDaoJdbcBase()

Method Summary

protected void	clearTempTableBySesId(String tableName, String SesIdColumn, String sessionId)
protected void	clearTempTableByUnvlId(String tableName, String personUnvlIdColumn, String principalName)
protected String	getExpenditureINList() return a SQL IN list containing the budget construction expenditure object types
protected Date	getFiscalYearStartDate(Integer universityFiscalYear) given a fiscal year, get the first day of that fiscal year
protected String	getRevenueINList() return a SQL IN list containing the budget construction revenue object types
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
protected String	inString(Integer parameterCount) build a string of placeholders for a parameterized java.sql IN clause
protected String	inString(List<String> inListValues) build a SQL IN clause from the array of parameters passed in
void	setOjbOraclePlatform(String ojbOraclePlatform)
void	setOjbPlatform(String ojbPlatform)
void	setParameterService(org.kuali.rice.kns.service.ParameterService parameterService)

Methods inherited from class org.kuali.rice.kns.dao.jdbc.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)

inString

protected String inString(Integer parameterCount)

build a string of placeholders for a parameterized java.sql IN clause

Parameters:

parameterCount - the number of parameters in the IN clause

Returns:

the String (?,?,?) with the correct nubmer of parameters

inString

protected String inString(List<String> inListValues)

build a SQL IN clause from the array of parameters passed in

Parameters:

inListValues: - components of the IN list

Returns:

an empty string if the IN list will be empty

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

getExpenditureINList

protected String getExpenditureINList()

return a SQL IN list containing the budget construction expenditure object types

Returns:

a null string if the system parameter does not exist or is empty

getRevenueINList

protected String getRevenueINList()

return a SQL IN list containing the budget construction revenue object types

Returns:

a null string if the system parameter does not exist or is empty

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)

setParameterService

public void setParameterService(org.kuali.rice.kns.service.ParameterService parameterService)