From c2911fa6d4f5d00bfee156ab07a241497305f878 Mon Sep 17 00:00:00 2001
From: sujinwen <sujinwen@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期二, 25 七月 2017 10:45:46 +0800
Subject: [PATCH]
---
VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/SynchronRecordDao.java | 53 +++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 53 insertions(+), 0 deletions(-)
diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/SynchronRecordDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/SynchronRecordDao.java
new file mode 100644
index 0000000..5e8e37d
--- /dev/null
+++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/SynchronRecordDao.java
@@ -0,0 +1,53 @@
+package cn.com.basic.face.service.sqlite;
+
+import android.database.Cursor;
+
+import java.text.SimpleDateFormat;
+import java.util.Date;
+
+import cn.com.basic.face.base.MainActivity;
+import cn.com.basic.face.discern.entity.VisitTableSynchronRecord;
+
+/**
+ * 鍚屾璁板綍琛╠ao
+ * Created by SJW on 2017/7/25 0025.
+ */
+
+public class SynchronRecordDao {
+
+ public static SynchronRecordDao instance=new SynchronRecordDao();
+ public static SynchronRecordDao getInstance(){
+ return instance;
+ }
+
+ /***
+ * 鍔犺浇鍚屾璁板綍琛�
+ * @param tableName 琛ㄥ悕
+ * @return
+ */
+ public VisitTableSynchronRecord getSynRecord(String tableName){
+ String sql="select * from visit_table_synchron_record where table_name='" + tableName + "'";
+ VisitTableSynchronRecord record=null;
+ Cursor c = MainActivity.getInstance().db.rawQuery(sql,new String[]{});
+ if(c.moveToFirst()){
+ record=new VisitTableSynchronRecord();
+ record.setId(c.getString(c.getColumnIndex("id")));
+ record.setSynchronTime(c.getString(c.getColumnIndex("synchron_time")));
+ record.setTableName(tableName);
+ return record;
+ }
+ return null;
+ }
+
+ /**
+ * 鏇存柊璁板綍
+ * @param tableName 琛ㄥ悕
+ * @param synDate 鏈�杩戜竴娆″悓姝ユ椂闂�
+ */
+ public void updateSynRecord(String tableName, Date synDate){
+ SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+ String sql="update visit_table_synchron_record set synchron_time="+"'"+sdf.format(synDate)+"'"+" where table_name='" + tableName + "'";
+ MainActivity.getInstance().db.execSQL(sql);
+ }
+
+}
--
Gitblit v1.8.0