From 21500d7529fe258fd35316ddf294a406781d9f4d Mon Sep 17 00:00:00 2001
From: xuxiuxi <xuxiuxi@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期二, 01 八月 2017 18:00:39 +0800
Subject: [PATCH]
---
VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DataSynchronDao.java | 181 ++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 177 insertions(+), 4 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 f863c7a..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
@@ -1,5 +1,11 @@
package cn.com.basic.face.service.sqlite;
+import android.content.ContentValues;
+import android.database.Cursor;
+import android.database.sqlite.SQLiteDatabase;
+
+import cn.com.basic.face.base.MainActivity;
+
/**
* 鏁版嵁鍚屾dao灞�
*
@@ -7,6 +13,145 @@
public class DataSynchronDao {
public static DataSynchronDao instance = new DataSynchronDao();
+
+//##################澧炲垹鏀规煡妗堜緥##########################
+
+
+ /***
+ * 鍒涘缓涓�涓〃
+ * @param db
+ */
+ private void createTable(SQLiteDatabase db){
+ //鍒涘缓琛⊿QL璇彞
+ String stu_table="create table usertable(_id integer primary key autoincrement,sname text,snumber text)";
+ //鎵цSQL璇彞
+ db.execSQL(stu_table);
+ }
+
+
+
+
+
+ /***
+ * 娣诲姞妗堜緥
+ * @param db
+ *
+ * 鍙傛暟1 琛ㄥ悕绉帮紝
+ 鍙傛暟2 绌哄垪鐨勯粯璁ゅ��
+ 鍙傛暟3 ContentValues绫诲瀷鐨勪竴涓皝瑁呬簡鍒楀悕绉板拰鍒楀�肩殑Map锛�
+ 锛堬級
+ */
+ private void insert(SQLiteDatabase db){
+ //瀹炰緥鍖栧父閲忓��
+ ContentValues cValue = new ContentValues();
+ //娣诲姞鐢ㄦ埛鍚�
+ cValue.put("sname","xiaoming");
+ //娣诲姞瀵嗙爜
+ cValue.put("snumber","01005");
+ //璋冪敤insert()鏂规硶鎻掑叆鏁版嵁
+ db.insert("stu_table",null,cValue);
+}
+
+
+ /***
+ * 鍒犻櫎鏁版嵁
+ * @param db
+ * 鍙傛暟1 琛ㄥ悕绉�
+ 鍙傛暟2 鍒犻櫎鏉′欢
+ 鍙傛暟3 鍒犻櫎鏉′欢鍊兼暟缁�
+ */
+ private void delete(SQLiteDatabase db) {
+ //鍒犻櫎鏉′欢
+ String whereClause = "id=?";
+ //鍒犻櫎鏉′欢鍙傛暟
+ String[] whereArgs = {String.valueOf(2)};
+ //鎵ц鍒犻櫎
+ db.delete("stu_table",whereClause,whereArgs);
+ }
+
+
+ /***
+ * 淇敼鏁版嵁
+ * @param db
+ *
+ * 鍙傛暟1 琛ㄥ悕绉�
+ 鍙傛暟2 璺熻鍒桟ontentValues绫诲瀷鐨勯敭鍊煎Key-Value
+ 鍙傛暟3 鏇存柊鏉′欢锛坵here瀛楀彞锛�
+ 鍙傛暟4 鏇存柊鏉′欢鏁扮粍
+ */
+ private void update(SQLiteDatabase db) {
+ //瀹炰緥鍖栧唴瀹瑰��
+ ContentValues values = new ContentValues();
+ //鍦╲alues涓坊鍔犲唴瀹�
+ values.put("snumber","101003");
+ //淇敼鏉′欢
+ String whereClause = "id=?";
+ //淇敼娣诲姞鍙傛暟
+ String[] whereArgs={"2"};
+ //淇敼
+ db.update("usertable",values,whereClause,whereArgs);
+ }
+
+
+ /***
+ * 鏌ヨ鏁版嵁
+ * @param db
+ *
+ 鍦ˋndroid涓煡璇㈡暟鎹槸閫氳繃Cursor绫绘潵瀹炵幇鐨勶紝褰撴垜浠娇鐢⊿QLiteDatabase.query()鏂规硶鏃讹紝浼氬緱鍒颁竴涓狢ursor瀵硅薄锛孋ursor鎸囧悜鐨勫氨鏄瘡涓�鏉℃暟鎹��
+ 瀹冩彁渚涗簡寰堝鏈夊叧鏌ヨ鐨勬柟娉曪紝鍏蜂綋鏂规硶濡備笅锛�
+ public Cursor query(String table,String[] columns,String selection,String[] selectionArgs,String groupBy,String having,String orderBy,String limit);
+ 鍚勪釜鍙傛暟鐨勬剰涔夎鏄庯細
+ 鍙傛暟table:琛ㄥ悕绉�
+ 鍙傛暟columns:鍒楀悕绉版暟缁�
+ 鍙傛暟selection:鏉′欢瀛楀彞锛岀浉褰撲簬where
+ 鍙傛暟selectionArgs:鏉′欢瀛楀彞锛屽弬鏁版暟缁�
+ 鍙傛暟groupBy:鍒嗙粍鍒�
+ 鍙傛暟having:鍒嗙粍鏉′欢
+ 鍙傛暟orderBy:鎺掑簭鍒�
+ 鍙傛暟limit:鍒嗛〉鏌ヨ闄愬埗
+ 鍙傛暟Cursor:杩斿洖鍊硷紝鐩稿綋浜庣粨鏋滈泦ResultSet
+ Cursor鏄竴涓父鏍囨帴鍙ｏ紝鎻愪緵浜嗛亶鍘嗘煡璇㈢粨鏋滅殑鏂规硶锛屽绉诲姩鎸囬拡鏂规硶move()锛岃幏寰楀垪鍊兼柟娉昰etString()绛�.
+
+
+ 鏂规硶鎻忚堪
+ getCount() :鑾峰緱鎬荤殑鏁版嵁椤规暟
+ isFirst() :鍒ゆ柇鏄惁绗竴鏉¤褰�
+ isLast() :鍒ゆ柇鏄惁鏈�鍚庝竴鏉¤褰�
+ moveToFirst() :绉诲姩鍒扮涓�鏉¤褰�
+ moveToLast() :绉诲姩鍒版渶鍚庝竴鏉¤褰�
+ move(int offset) :绉诲姩鍒版寚瀹氳褰�
+ moveToNext() :绉诲姩鍒颁笅涓�鏉¤褰�
+ moveToPrevious() :绉诲姩鍒颁笂涓�鏉¤褰�
+ getColumnIndexOrThrow(String columnName) :鏍规嵁鍒楀悕绉拌幏寰楀垪绱㈠紩
+ getInt(int columnIndex) :鑾峰緱鎸囧畾鍒楃储寮曠殑int绫诲瀷鍊�
+ getString(int columnIndex) :鑾峰緱鎸囧畾鍒楃缉褰辩殑String绫诲瀷鍊�
+ */
+ private void query(SQLiteDatabase db) {
+ //鏌ヨ鑾峰緱娓告爣
+ Cursor cursor = db.query("usertable",null,null,null,null,null,null);
+
+ //鍒ゆ柇娓告爣鏄惁涓虹┖
+ if(cursor.moveToFirst()){
+ //閬嶅巻娓告爣
+ for(int i=0;i<cursor.getCount();i++){
+ cursor.move(i);
+ //鑾峰緱ID
+ int id = cursor.getInt(0);
+ //鑾峰緱鐢ㄦ埛鍚�
+ String username=cursor.getString(1);
+ //鑾峰緱瀵嗙爜
+ String password=cursor.getString(2);
+ //杈撳嚭鐢ㄦ埛淇℃伅
+ System.out.println(id+":"+username+":"+password);
+ }
+ }
+ }
+
+
+//#######################浠ヤ笂涓哄鍒犳敼鏌EMO#################################
+
+
+
/**
* 鑾峰彇dao瀵硅薄
@@ -19,19 +164,47 @@
/**
* 鍗曞悜鍚屾锛屼粠瀹㈡埛绔悓姝ュ埌鏈嶅姟鍣ㄧ
* @param clientTable
- * @param serviceTable
*/
- public static void client2service(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;
+
+ 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
* @param serviceTable
*/
- public static void service2client(String clientTable,String serviceTable){
+ public static void serviceToClient(String clientTable,String serviceTable){
//1.鏍规嵁涓婃鍚屾鏃堕棿鑾峰彇闇�瑕佸悓姝ョ殑鏁版嵁
//2.淇濆瓨鏁版嵁鍒板鎴风
--
Gitblit v1.8.0