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); } }