org.kuali.ole.select.gokb.service.impl

Class GokbRdbmsServiceImpl

java.lang.Object

org.kuali.ole.select.gokb.service.impl.GokbRdbmsServiceImpl

All Implemented Interfaces:

GokbRdbmsService

public class GokbRdbmsServiceImpl
extends Object
implements GokbRdbmsService

Created by premkumarv on 12/9/14.

Field Summary

Fields inherited from interface org.kuali.ole.select.gokb.service.GokbRdbmsService

INSERT_ORG_PREPARED_STMT, INSERT_ORG_ROLE_PREPARED_STMT, INSERT_PACKAGE_PREPARED_STMT, INSERT_PLATFORM_PREPARED_STMT, INSERT_TIPP_PREPARED_STMT, INSERT_TITLE_PREPARED_STMT, UPDATE_ORG_PREPARED_STMT, UPDATE_ORG_ROLE_PREPARED_STMT, UPDATE_PACKAGE_PREPARED_STMT, UPDATE_PLATFORM_PREPARED_STMT, UPDATE_TIPP_PREPARED_STMT, UPDATE_TITLE_PREPARED_STMT

Constructor Summary

Constructors

Constructor and Description
GokbRdbmsServiceImpl()

Method Summary

Methods

Modifier and Type	Method and Description
void	closeConnections() Close the SQL connections
Timestamp	getUpdatedDate() Get updated date
void	insertLogEndTime(int updatedId)
void	insertOrganizationRoles(List<OleGokbOrganizationRole> oleGokbOrganizationRoles) Insert list of OrganizationRoles
void	insertOrganizations(List<OleGokbOrganization> oleGokbOrganizations) Insert list of Organizations
void	insertOrUpdateOrganizationRoles(List<OleGokbOrganizationRole> oleGokbOrganizationRoles) Insert or Update list of OrganizationRoles
void	insertOrUpdateOrganizations(List<OleGokbOrganization> oleGokbOrganizations) Insert or Update list of Organizations
void	insertOrUpdatePackages(List<OleGokbPackage> oleGokbPackages) Insert or Update list of Packages
void	insertOrUpdatePlatforms(List<OleGokbPlatform> oleGokbPlatforms) Insert or Update list of Platforms
void	insertOrUpdateTipps(List<OleGokbTipp> oleGokbTipps)
void	insertOrUpdateTitles(List<OleGokbTitle> oleGokbTitles) Insert or Update list of Titles
void	insertPackages(List<OleGokbPackage> oleGokbPackages) Insert list of Packages
void	insertPlatforms(List<OleGokbPlatform> oleGokbPlatforms) Insert list of Platforms
int	insertStatus() Get recently inserted row id
void	insertTipps(List<OleGokbTipp> oleGokbTipps)
void	insertTitles(List<OleGokbTitle> oleGokbTitles) Insert list of Titles
void	truncateTables() Deleting all rows from the tables
void	updateOrganization(OleGokbOrganization oleGokbOrganization) Update Organization, if it exist already
void	updateOrganizationRole(OleGokbOrganizationRole oleGokbOrganizationRole) Update OrganizationRole, if it exist already
void	updatePackage(OleGokbPackage oleGokbPack) Update package, if it exist already
void	updatePlatform(OleGokbPlatform oleGokbPlatform) Update Platform, if it exist already
void	updateStatus(int id, String columnValue) Update the status
void	updateTipp(OleGokbTipp oleGokbTipp) Update Tipp, if it exist already
void	updateTitle(OleGokbTitle oleGokbTitle) Update Title, if it exist already

Methods inherited from class java.lang.Object

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

Constructor Detail

GokbRdbmsServiceImpl

public GokbRdbmsServiceImpl()

Method Detail

insertOrUpdatePackages

public void insertOrUpdatePackages(List<OleGokbPackage> oleGokbPackages)

Insert or Update list of Packages

Specified by:

insertOrUpdatePackages in interface GokbRdbmsService

Parameters:

oleGokbPackages -

insertOrUpdateTipps

public void insertOrUpdateTipps(List<OleGokbTipp> oleGokbTipps)

Specified by:

insertOrUpdateTipps in interface GokbRdbmsService

Parameters:

oleGokbTipps - Insert or Update list of Tipps

insertOrUpdateTitles

public void insertOrUpdateTitles(List<OleGokbTitle> oleGokbTitles)

Insert or Update list of Titles

Specified by:

insertOrUpdateTitles in interface GokbRdbmsService

Parameters:

oleGokbTitles -

insertOrUpdatePlatforms

public void insertOrUpdatePlatforms(List<OleGokbPlatform> oleGokbPlatforms)

Insert or Update list of Platforms

Specified by:

insertOrUpdatePlatforms in interface GokbRdbmsService

Parameters:

oleGokbPlatforms -

insertOrUpdateOrganizations

public void insertOrUpdateOrganizations(List<OleGokbOrganization> oleGokbOrganizations)

Insert or Update list of Organizations

Specified by:

insertOrUpdateOrganizations in interface GokbRdbmsService

Parameters:

oleGokbOrganizations -

insertOrUpdateOrganizationRoles

public void insertOrUpdateOrganizationRoles(List<OleGokbOrganizationRole> oleGokbOrganizationRoles)

Insert or Update list of OrganizationRoles

Specified by:

insertOrUpdateOrganizationRoles in interface GokbRdbmsService

Parameters:

oleGokbOrganizationRoles -

updatePackage

public void updatePackage(OleGokbPackage oleGokbPack)

Update package, if it exist already

Parameters:

oleGokbPack -

updateTipp

public void updateTipp(OleGokbTipp oleGokbTipp)

Update Tipp, if it exist already

Parameters:

oleGokbTipp -

updateTitle

public void updateTitle(OleGokbTitle oleGokbTitle)

Update Title, if it exist already

Parameters:

oleGokbTitle -

updatePlatform

public void updatePlatform(OleGokbPlatform oleGokbPlatform)

Update Platform, if it exist already

Parameters:

oleGokbPlatform -

updateOrganization

public void updateOrganization(OleGokbOrganization oleGokbOrganization)

Update Organization, if it exist already

Parameters:

oleGokbOrganization -

updateOrganizationRole

public void updateOrganizationRole(OleGokbOrganizationRole oleGokbOrganizationRole)

Update OrganizationRole, if it exist already

Parameters:

oleGokbOrganizationRole -

truncateTables

public void truncateTables()

Deleting all rows from the tables

Specified by:

truncateTables in interface GokbRdbmsService

getUpdatedDate

public Timestamp getUpdatedDate()

Get updated date

Specified by:

getUpdatedDate in interface GokbRdbmsService

Returns:

insertStatus

public int insertStatus()

Get recently inserted row id

Specified by:

insertStatus in interface GokbRdbmsService

Returns:

insertLogEndTime

public void insertLogEndTime(int updatedId)

Specified by:

insertLogEndTime in interface GokbRdbmsService

updateStatus

public void updateStatus(int id,
                String columnValue)

Update the status

Specified by:

updateStatus in interface GokbRdbmsService

Parameters:

id -

columnValue -

insertPackages

public void insertPackages(List<OleGokbPackage> oleGokbPackages)

Insert list of Packages

Specified by:

insertPackages in interface GokbRdbmsService

Parameters:

oleGokbPackages -

insertTipps

public void insertTipps(List<OleGokbTipp> oleGokbTipps)

Specified by:

insertTipps in interface GokbRdbmsService

Parameters:

oleGokbTipps - Insert list of Tipps

insertTitles

public void insertTitles(List<OleGokbTitle> oleGokbTitles)

Insert list of Titles

Specified by:

insertTitles in interface GokbRdbmsService

Parameters:

oleGokbTitles -

insertPlatforms

public void insertPlatforms(List<OleGokbPlatform> oleGokbPlatforms)

Insert list of Platforms

Specified by:

insertPlatforms in interface GokbRdbmsService

Parameters:

oleGokbPlatforms -

insertOrganizations

public void insertOrganizations(List<OleGokbOrganization> oleGokbOrganizations)

Insert list of Organizations

Specified by:

insertOrganizations in interface GokbRdbmsService

Parameters:

oleGokbOrganizations -

insertOrganizationRoles

public void insertOrganizationRoles(List<OleGokbOrganizationRole> oleGokbOrganizationRoles)

Insert list of OrganizationRoles

Specified by:

insertOrganizationRoles in interface GokbRdbmsService

Parameters:

oleGokbOrganizationRoles -

closeConnections

public void closeConnections()
                      throws SQLException

Close the SQL connections

Throws:

SQLException