From d343b71cd89f59a87e85c46ce7a04d47c357462d Mon Sep 17 00:00:00 2001 From: xuxiuxi <xuxiuxi@454eff88-639b-444f-9e54-f578c98de674> Date: 星期二, 25 七月 2017 15:46:45 +0800 Subject: [PATCH] --- VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/AttendanceDao.java | 7 +++---- 1 files changed, 3 insertions(+), 4 deletions(-) diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/AttendanceDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/AttendanceDao.java index 63df3ec..cc508c8 100644 --- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/AttendanceDao.java +++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/AttendanceDao.java @@ -79,7 +79,7 @@ } Integer total = null; while (c_count.moveToNext()) { - total = c.getInt(c.getColumnIndex("count")); + total = c_count.getInt(0); } resultBean.setTotalPages(getTotalPageSize(total)); resultBean.setPageNum(pageNum); @@ -115,7 +115,7 @@ if(deviceCompanyId != null && !deviceCompanyId.trim().isEmpty()) { sb.append(" AND a.device_company_id = ").append(deviceCompanyId); } - sb.append("ORDER BY a.time DESC"); + sb.append(" ORDER BY a.time DESC"); StringBuilder count = new StringBuilder(sb.length()); count.append("select count(*) as count from (").append(sb).append(" ) _table"); sb.append(" LIMIT ").append("0").append(",").append(100); @@ -131,13 +131,12 @@ } Integer total = null; while (c_count.moveToNext()) { - total = c.getInt(c.getColumnIndex("count")); + total = c_count.getInt(0); } } catch (Exception e) { e.printStackTrace(); } return list; } - } -- Gitblit v1.8.0