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/DepartmentDao.java | 42 +++++++++++++++++++++++++++++++++++++++--- 1 files changed, 39 insertions(+), 3 deletions(-) diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DepartmentDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DepartmentDao.java index c588ed5..2e63525 100644 --- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DepartmentDao.java +++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DepartmentDao.java @@ -1,8 +1,44 @@ package cn.com.basic.face.service.sqlite; -/** - * Created by xiuxi on 2017/7/17. - */ +import android.database.Cursor; +import android.database.sqlite.SQLiteDatabase; + +import java.util.ArrayList; +import java.util.List; + +import cn.com.basic.face.base.Config; +import cn.com.basic.face.base.MainActivity; +import cn.com.basic.face.discern.entity.Dictionary; public class DepartmentDao { + + public static DepartmentDao instance = new DepartmentDao(); + public static DepartmentDao getInstance() { + return instance; + } + + /** + * 宸叉暟鎹瓧鍏稿皝瑁呯殑閮ㄩ棬List + * @return + */ + public List<Dictionary> loadDepartmentDictionary() { + List<Dictionary> list = new ArrayList<Dictionary>(); + try { + String sql = "select a.dept_id,a.dept_name from department a"; + Dictionary aqi = null; + + Cursor c = MainActivity.getInstance().db.rawQuery(sql, new String[]{}); + while (c.moveToNext()) { + aqi = new Dictionary(); + aqi.setDictId(c.getString(c.getColumnIndex("dept_id"))); + aqi.setName(c.getString((c.getColumnIndex("dept_name")))); + list.add(aqi); + } + }catch (Exception e) { + e.printStackTrace(); + } + return list; + + } + } -- Gitblit v1.8.0