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