@EipkRequest("/s/article/man")
public String articleMan(Model m) {
String search_where = "";
if (SysUtil.StrToInt(m.getPar("clear")) == 0) {
search_where =
m.getSessionPar("search_where") != null ? (String) m.getSessionPar("search_where") : "";
} else {
int search_section = SysUtil.StrToInt(m.getPar("search_section"));
String search_article_title = m.getPar("search_article_title");
if (search_section != 0) {
search_where += " and sectionId=" + search_section;
}
if (!search_article_title.equals("")) {
search_where += " and title like '%" + search_article_title + "%'";
}
}
m.setSessionPar("search_where", search_where);
String sql = "";
DB db = new DB();
sql = "select id,sectionName from t_section order by id";
List<Map<String, Object>> section_list = db.query(sql);
sql =
"select count(*) as num from t_article a,t_section s where a.sectionId=s.id "
+ search_where;
int total = SysUtil.StrToInt("" + db.querySingle(sql).get("num"));
int pagth = SysUtil.StrToInt(m.getPar("pagth"));
int start = SysUtil.getSplitPageStartId(total, SysUtil.PAGE_SIZE, pagth);
sql =
"select a.id,a.pubDate,s.sectionName,a.title,a.hits from t_article a,t_section s where a.sectionId=s.id "
+ search_where
+ " order by pubDate desc limit ?,?";
List<Map<String, Object>> article_list = db.query(sql, start, SysUtil.PAGE_SIZE);
db.close();
m.setAttr(
"split_page_str", SysUtil.getSplitPageStr(m.getRequest(), total, SysUtil.PAGE_SIZE, pagth));
m.setAttr("section_list", section_list);
m.setAttr("article_list", article_list);
return "";
}
