protected ClearHRHolidaies(HROfficePersistenceImpl persistenceImpl) {
_sqlUpdate =
SqlUpdateFactoryUtil.getSqlUpdate(
getDataSource(),
"DELETE FROM HRHolidays_HROffices WHERE hrOfficeId = ?",
new int[] {java.sql.Types.BIGINT});
}
protected RemoveHRHoliday(HROfficePersistenceImpl persistenceImpl) {
_sqlUpdate =
SqlUpdateFactoryUtil.getSqlUpdate(
getDataSource(),
"DELETE FROM HRHolidays_HROffices WHERE hrOfficeId = ? AND hrHolidayId = ?",
new int[] {java.sql.Types.BIGINT, java.sql.Types.BIGINT});
_persistenceImpl = persistenceImpl;
}
protected AddHRHoliday(HROfficePersistenceImpl persistenceImpl) {
_sqlUpdate =
SqlUpdateFactoryUtil.getSqlUpdate(
getDataSource(),
"INSERT INTO HRHolidays_HROffices (hrOfficeId, hrHolidayId) VALUES (?, ?)",
new int[] {java.sql.Types.BIGINT, java.sql.Types.BIGINT});
_persistenceImpl = persistenceImpl;
}
/**
* Performs an SQL query.
*
* @param sql the sql query to perform
*/
protected void runSQL(String sql) throws SystemException {
try {
DataSource dataSource = entryPersistence.getDataSource();
SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql, new int[0]);
sqlUpdate.update();
} catch (Exception e) {
throw new SystemException(e);
}
}
/**
* Performs a SQL query.
*
* @param sql the sql query
*/
protected void runSQL(String sql) {
try {
DataSource dataSource = ratingsStatsPersistence.getDataSource();
DB db = DBFactoryUtil.getDB();
sql = db.buildSQL(sql);
sql = PortalUtil.transformSQL(sql);
SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql, new int[0]);
sqlUpdate.update();
} catch (Exception e) {
throw new SystemException(e);
}
}
/**
* Performs a SQL query.
*
* @param sql the sql query
*/
protected void runSQL(String sql) {
try {
DataSource dataSource = resourcePermissionPersistence.getDataSource();
DB db = DBManagerUtil.getDB();
sql = db.buildSQL(sql);
sql = PortalUtil.transformSQL(sql);
SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql);
sqlUpdate.update();
} catch (Exception e) {
throw new SystemException(e);
}
}
/**
* Performs a SQL query.
*
* @param sql the sql query
*/
protected void runSQL(String sql) {
try {
DataSource dataSource = InfrastructureUtil.getDataSource();
DB db = DBManagerUtil.getDB();
sql = db.buildSQL(sql);
sql = PortalUtil.transformSQL(sql);
SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql, new int[0]);
sqlUpdate.update();
} catch (Exception e) {
throw new SystemException(e);
}
}
