From 4098b3f61bb7ffd9275d54612f68142fedefa0ea Mon Sep 17 00:00:00 2001
From: whyclj <1525436766@qq.com>
Date: 星期四, 28 十一月 2019 16:24:31 +0800
Subject: [PATCH] 修改线程中的数据库操作语句避免造成sqlite数据库bug
---
platforms/android/app/src/main/java/com/socket/BattResDataRecordThread.java | 25 ++++++++++++++-----------
1 files changed, 14 insertions(+), 11 deletions(-)
diff --git a/platforms/android/app/src/main/java/com/socket/BattResDataRecordThread.java b/platforms/android/app/src/main/java/com/socket/BattResDataRecordThread.java
index 546b368..96765c2 100644
--- a/platforms/android/app/src/main/java/com/socket/BattResDataRecordThread.java
+++ b/platforms/android/app/src/main/java/com/socket/BattResDataRecordThread.java
@@ -39,13 +39,13 @@
if(battData.state.monCount >0 && battData.state.mon_ress[battData.state.monCount-1] > 0){
//寮�濮嬭褰曞唴闃诲巻鍙叉暟鎹�
int max_test_record_count = queryMaxTestRecordCount(battData.battIndex,dbHelper); //鏌ヨ褰撳墠鐢垫睜缁勬渶澶х殑璁板綍绗旀暟
- Log.e(TAG, "run: MAXCOUNT:"+max_test_record_count );
+ //Log.e(TAG, "run: MAXCOUNT:"+max_test_record_count );
//鎻掑叆 tb_battresdata_inf 琛ㄤ腑
insertBattResDataInf(battData.battIndex, battData.state,dbHelper,max_test_record_count);
//鎻掑叆 tb_battresdata_id 琛ㄤ腑
insertBattResDataID(battData.battIndex,battData.state,dbHelper,max_test_record_count);
- Log.e(TAG, "run: battindex:"+battData.battIndex+"璁板綍鍘嗗彶鏁版嵁鎴愬姛 #############################");
+ //Log.e(TAG, "run: battindex:"+battData.battIndex+"璁板綍鍘嗗彶鏁版嵁鎴愬姛 #############################");
lastResTestCount = battData.state.getRestestcount();
}
}
@@ -70,11 +70,12 @@
SQLiteDatabase db = dbHelper.getWritableDatabase();
try {
db.execSQL(sql_str_start+sql_str_base);
- if(db != null){
- db.close();
- }
} catch (SQLException e) {
e.printStackTrace();
+ } finally{
+// if(db != null){
+// db.close();
+// }
}
}
@@ -101,11 +102,13 @@
try {
Log.d(TAG, "insertBattResDataInf: "+sql_str);
db.execSQL(sql_str);
- if(db != null){
- db.close();
- }
+
} catch (Exception e) {
e.printStackTrace();
+ } finally{
+// if(db != null){
+// db.close();
+// }
}
}
@@ -128,9 +131,9 @@
} catch (SQLException e) {
e.printStackTrace();
} finally{
- if(db != null){
- db.close();
- }
+// if(db != null){
+// db.close();
+// }
}
return max_test_record_count;
}
--
Gitblit v1.9.1