Example #1
0
 public List<Map<String, Object>> page(String sql, String page, String rp, String total) {
   String pagesql = Page.mysqlPageSql(sql, total, rp, page);
   List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
   try {
     list = sqldao.query(pagesql);
   } catch (Exception e) {
     logger.error("PageDaoImpl--page", e);
   }
   return list;
 }
Example #2
0
 public String getCount(String sql) {
   String total = "0";
   List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
   try {
     list = sqldao.query(sql);
   } catch (Exception e) {
     logger.error("PageDaoImpl--getCount", e);
   }
   if ((list != null) && (list.size() > 0)) {
     total = Long.toString((Long) list.get(0).get("count"));
   }
   return total;
 }