From 9e5babf9db52e64bdae60137be7696e56241fca6 Mon Sep 17 00:00:00 2001 From: xingzilong <xingzilong@454eff88-639b-444f-9e54-f578c98de674> Date: 星期五, 18 八月 2017 18:12:17 +0800 Subject: [PATCH] H264 NALU解析 并在RTSPServer判断 --- VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/PhoneCallDao.java | 18 ++++-------------- 1 files changed, 4 insertions(+), 14 deletions(-) diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/PhoneCallDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/PhoneCallDao.java index c2344e5..4bb4f19 100644 --- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/PhoneCallDao.java +++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/PhoneCallDao.java @@ -10,7 +10,7 @@ import java.util.List; import cn.com.basic.face.base.BaseApplication; -import cn.com.basic.face.base.Config; +import cn.com.basic.face.base.MainActivity; import cn.com.basic.face.discern.common.CommonVariables; import cn.com.basic.face.discern.common.ResultBean; import cn.com.basic.face.discern.query.item.CheckInQueryItem; @@ -31,8 +31,7 @@ */ public ResultBean findPhoneCallLeftList(String searchText, final int pageNum) { ResultBean resultBean = new ResultBean(); - SQLiteDatabase db = Config.sqlMap.getDb(); - db.beginTransaction(); + SQLiteDatabase db = MainActivity.getInstance().db; try { StringBuilder sb = new StringBuilder(40); sb.append("SELECT b.username caller,c.username callee,d.dept_name caller_dept,e.dept_name callee_dept,") @@ -70,18 +69,13 @@ } 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); resultBean.setData(list); - c.close(); - c_count.close(); - db.setTransactionSuccessful(); } catch (Exception e) { e.printStackTrace(); - } finally { - db.endTransaction(); } return resultBean; } @@ -92,8 +86,7 @@ * @param interviewee */ public void addPhoneCall(CheckInQueryItem visitor, CheckInQueryItem interviewee) { - SQLiteDatabase db = Config.sqlMap.getDb(); - db.beginTransaction(); + SQLiteDatabase db = MainActivity.getInstance().db; try { StringBuilder sb = new StringBuilder(40); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); @@ -103,11 +96,8 @@ cv.put("callee_id",interviewee.getRegisterId()); cv.put("device_id",BaseApplication.getInstance().getAndroidDevice().getDeviceId()); db.insert("phone_call",null,cv); - db.setTransactionSuccessful(); } catch (Exception e) { e.printStackTrace(); - } finally { - db.endTransaction(); } } -- Gitblit v1.8.0