@Override
public void read(Object arg) {
// TODO Auto-generated method stub
UrlClassList ucl = UrlClassList.getInstance();
setRoot("classify_action_url", ucl.read("classify_action"));
int offset = 0;
if (page != 0) {
offset = (page - 1) * Limit;
}
String format =
"select id,pid,name,ctime,displays,(select name from "
+ DB_HOR_PRE
+ "classify h where h.id=c.pid ) as pname from "
+ DB_HOR_PRE
+ "classify c where "
+ UserPermi()
+ " order by id desc limit %d offset %d";
String sql = String.format(format, Limit, offset);
List<Map<String, Object>> res;
try {
res = FetchAll(sql);
setRoot("classify_list", res);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
SetPage();
}
private void SetPage() {
Page p = new Page();
UrlClassList ucl = UrlClassList.getInstance();
int t = Tol();
String page_html = p.s_page(ucl.read(SliceName(stdClass)), t, page, Limit, "");
setRoot("Page", page_html);
setRoot("edit_url", ucl.read("classify_action"));
setRoot("add_url", ucl.create("classify_action"));
// setRoot("remove_url", ucl.remove("mongo_db_edit_action"));
setRoot("classify_action_url", ucl.read("classify_action"));
}