public static List<NewsPoll> selectAll() throws FtdException {
List<NewsPoll> newsPolls = new ArrayList<NewsPoll>();
DBClient dbClient = SysMgr.getInstance().getDbClient();
String sql = "select * from news_poll";
CachedRowSet rs = null;
try {
rs = dbClient.executeQuery(sql);
if (rs != null) {
while (rs.next()) {
NewsPoll np = new NewsPoll();
np.setNewsId(rs.getInt("news_id"));
np.setNewsTitle(rs.getString("news_title"));
np.setPollImgUrl(rs.getString("poll_img_url"));
np.setArticleId(rs.getInt("article_id"));
np.setActive(rs.getInt("is_active"));
newsPolls.add(np);
}
}
} catch (SQLException e) {
throw new FtdException(e, "db.sql.error");
} finally {
if (rs != null)
try {
rs.close();
} catch (SQLException e) {
// do nothing
}
}
return newsPolls;
}
