From 54b23ebcea16ba422afd595bcaf04d0b7cb6407c Mon Sep 17 00:00:00 2001
From: xuxiuxi <xuxiuxi@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期三, 26 七月 2017 14:39:00 +0800
Subject: [PATCH]
---
VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DataSynchronDao.java | 38 +++++++++++++++++++++++++++++---------
1 files changed, 29 insertions(+), 9 deletions(-)
diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DataSynchronDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DataSynchronDao.java
index c1b4159..fa03d4f 100644
--- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DataSynchronDao.java
+++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DataSynchronDao.java
@@ -4,7 +4,7 @@
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
-import cn.com.basic.face.base.Config;
+import cn.com.basic.face.base.MainActivity;
/**
* 鏁版嵁鍚屾dao灞�
@@ -148,9 +148,6 @@
}
-
-
-
//#######################浠ヤ笂涓哄鍒犳敼鏌EMO#################################
@@ -167,18 +164,41 @@
/**
* 鍗曞悜鍚屾锛屼粠瀹㈡埛绔悓姝ュ埌鏈嶅姟鍣ㄧ
* @param clientTable
- * @param serviceTable
*/
- public static void clientToService(String clientTable,String serviceTable){
+ public static void clientToService(String clientTable){
+ //public Cursor query(String table,String[] columns,String selection,String[] selectionArgs,String groupBy,String having,String orderBy,String limit);
+ SQLiteDatabase db = MainActivity.getInstance().db;
- SQLiteDatabase db = Config.sqlMap.getDb();
- db.beginTransaction();
db.execSQL("");
db.endTransaction();
//1.鏍规嵁涓婃鍚屾鏃堕棿鎵惧嚭闇�瑕佷笂浼犵殑鏁版嵁
- //2.鍙戦�佹暟鎹粰鏈嶅姟鍣ㄧ
+ db.execSQL("");
+ //1.鏍规嵁涓婃鍚屾鏃堕棿鎵惧嚭闇�瑕佷笂浼犵殑鏁版嵁
+
+
+ String selection="is_synchron=?";
+ String[] selectionArgs=new String[]{"N"};
+ String orderBy="update_time desc";
+ Cursor cursor = db.query(clientTable,null,selection,selectionArgs,null,null,orderBy,null);
+
+ while (cursor.moveToNext())
+ {
+ int useid = cursor.getInt(cursor.getColumnIndex("useid"));
+ String date = cursor.getString(cursor.getColumnIndex("date"));
+ String content = cursor.getString(cursor.getColumnIndex("content"));
+ int fangxiang =cursor.getShort(cursor.getColumnIndex("dirr"));
+ boolean dirr;
+ }
+
+ cursor.close();
+ db.close();
+
}
+
+
+
+
/**
* 鍗曞悜鍚屾锛屼粠鏈嶅姟绔悓姝ュ埌瀹㈡埛绔�
* @param clientTable
--
Gitblit v1.8.0