public ERegisterBackgroundThemeDTO getThemeById(long themeId) { ERegisterBackgroundThemeDTO theme = null; try { StringBuffer sql = new StringBuffer(); sql.append("SELECT ").append(selectFields()); sql.append(" FROM eregister_background_themes WHERE ThemeId=?"); makeConnection(getDbLookup()); statement = conn.prepareStatement(sql.toString()); statement.setLong(1, themeId); rs = statement.executeQuery(); int col = 0; while (rs.next()) { theme = new ERegisterBackgroundThemeDTO(); theme.setThemeId(rs.getLong(++col)); theme.setThemeDesc(rs.getString(++col)); } } catch (SQLException e) { logger.error("SQLException in ERegisterBackgroundThemeDAO:getThemeById() : ", e); } catch (Exception e) { logger.error("Exception in ERegisterBackgroundThemeDAO:getThemeById() : ", e); } finally { closeConnection(); } return theme; }
public List<ERegisterBackgroundThemeDTO> getAllBackgroundThemes() { List<ERegisterBackgroundThemeDTO> themes = null; try { StringBuffer sql = new StringBuffer(); sql.append("SELECT ").append(selectFields()); sql.append(" FROM eregister_background_themes"); makeConnection(getDbLookup()); statement = conn.prepareStatement(sql.toString()); rs = statement.executeQuery(); int col = 0; ERegisterBackgroundThemeDTO themeDto = null; while (rs.next()) { themeDto = new ERegisterBackgroundThemeDTO(); themeDto.setThemeId(rs.getLong(++col)); themeDto.setThemeDesc(rs.getString(++col)); if (themes == null) { themes = new ArrayList<ERegisterBackgroundThemeDTO>(); } col = 0; themes.add(themeDto); } } catch (SQLException e) { logger.error("SQLException in ERegisterBackgroundThemeDAO:getAllBackgroundThemes() : ", e); } catch (Exception e) { logger.error("Exception in ERegisterBackgroundThemeDAO:getAllBackgroundThemes() : ", e); } finally { closeConnection(); } return themes; }