From 86397b404b0f18da000b2eb9ad64a5cbedb4cc93 Mon Sep 17 00:00:00 2001
From: 81041 <81041@DESKTOP-025NVD9>
Date: 星期一, 18 十一月 2019 10:04:15 +0800
Subject: [PATCH] 后台提交
---
platforms/android/app/src/main/java/com/fgkj/impl/BatttestdataDAOImpl.java | 212 +++++++++++++++++++++++++++-------------------------
1 files changed, 110 insertions(+), 102 deletions(-)
diff --git a/platforms/android/app/src/main/java/com/fgkj/impl/BatttestdataDAOImpl.java b/platforms/android/app/src/main/java/com/fgkj/impl/BatttestdataDAOImpl.java
index ccaa4d0..4342289 100644
--- a/platforms/android/app/src/main/java/com/fgkj/impl/BatttestdataDAOImpl.java
+++ b/platforms/android/app/src/main/java/com/fgkj/impl/BatttestdataDAOImpl.java
@@ -1,17 +1,19 @@
package com.fgkj.impl;
+import android.database.Cursor;
+import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.ResultSet;
-import java.sql.SQLException;
import java.text.ParseException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
+import com.fgkj.dao.ActionUtil;
import com.fgkj.dao.BaseDAO;
import com.fgkj.dao.BattTestData;
import com.fgkj.dto.Batttestdata;
@@ -21,19 +23,26 @@
import com.sqlite_DaoHelper.DBUtil;
public class BatttestdataDAOImpl implements BaseDAO{
-
+ //鎵归噺鎻掑叆鏀剧數璁板綍
public boolean add(SQLiteDatabase db,Object obj) {
List<Batttestdata> list=(List<Batttestdata>) obj;
- ArrayList<String> sql_str=new ArrayList();
- if(list!=null&&list.size()>0){
- for (int i = 0; i < list.size(); i++) {
- Batttestdata b=list.get(i);
- String sql="insert into db_batt_testdata.tb_batttestdata_"+b.getBattGroupId()+"(BattGroupId,test_record_count,test_type,data_new,data_available,record_num,test_starttime,record_time,test_timelong,online_vol,group_vol,test_curr,test_cap,mon_num,mon_vol,mon_tmp) " +
- " values("+b.getBattGroupId()+","+b.getTest_record_count()+","+b.getTest_type()+","+b.getData_new()+","+b.getData_available()+","+b.getRecord_num()+",'"+DAOHelper.sdf.format(b.getTest_starttime())+"','"+DAOHelper.sdf.format(b.getRecord_time())+"',"+b.getTest_timelong()+","+b.getOnline_vol()+","+b.getGroup_vol()+","+b.getTest_curr()+","+b.getTest_cap()+","+b.getMon_num()+","+b.getMon_vol()+","+b.getMon_tmp()+")";
- sql_str.add(sql);
+ boolean bl=true;
+ try {
+ db.beginTransaction();
+ if(list!=null&&list.size()>0){
+ for (int i = 0; i < list.size(); i++) {
+ Batttestdata b=list.get(i);
+ String sql="insert into db_batt_testdata.tb_batttestdata_"+b.getBattGroupId()+"(BattGroupId,test_record_count,test_type,data_new,data_available,record_num,test_starttime,record_time,test_timelong,online_vol,group_vol,test_curr,test_cap,mon_num,mon_vol,mon_tmp) " +
+ " values("+b.getBattGroupId()+","+b.getTest_record_count()+","+b.getTest_type()+","+b.getData_new()+","+b.getData_available()+","+b.getRecord_num()+",'"+ ActionUtil.sdf.format(b.getTest_starttime())+"','"+ActionUtil.sdf.format(b.getRecord_time())+"',"+b.getTest_timelong()+","+b.getOnline_vol()+","+b.getGroup_vol()+","+b.getTest_curr()+","+b.getTest_cap()+","+b.getMon_num()+","+b.getMon_vol()+","+b.getMon_tmp()+")";
+ db.execSQL(sql);
+ }
}
+ db.setTransactionSuccessful();
+ db.endTransaction();
+ } catch (SQLException e) {
+ bl=false;
+ e.printStackTrace();
}
- boolean bl= DAOHelper.makeManualCommit(DBUtil.getConn(), sql_str);
return bl;
}
@@ -42,48 +51,74 @@
return bl;
}
-
+ //鎵归噺淇敼鏁版嵁
public boolean updatePro(SQLiteDatabase db,Object obj) {
List<Batttestdata> list= (List<Batttestdata>) obj;
- ArrayList<String> sql_str=new ArrayList();
- if(list!=null&&list.size()>0){
- for (int i = 0; i < list.size(); i++) {
- Batttestdata b=list.get(i);
- float mon_tmp=(float) (Math.random()+20);
- BigDecimal bd = new BigDecimal((double)mon_tmp);
- bd = bd.setScale(1,4);
- mon_tmp = bd.floatValue();
- String sql="update db_batt_testdata.tb_batttestdata_"+b.getBattGroupId()+" set mon_tmp="+mon_tmp+" where num="+b.getNum();
- sql_str.add(sql);
- System.out.println(mon_tmp+" "+i);
+ boolean bl=true;
+ try {
+ db.beginTransaction();
+ if(list!=null&&list.size()>0){
+ for (int i = 0; i < list.size(); i++) {
+ Batttestdata b=list.get(i);
+ float mon_tmp=(float) (Math.random()+20);
+ BigDecimal bd = new BigDecimal((double)mon_tmp);
+ bd = bd.setScale(1,4);
+ mon_tmp = bd.floatValue();
+ String sql="update db_batt_testdata.tb_batttestdata_"+b.getBattGroupId()+" set mon_tmp="+mon_tmp+" where num="+b.getNum();
+ db.execSQL(sql);
+ }
}
+ db.setTransactionSuccessful();
+ db.endTransaction();
+ } catch (SQLException e) {
+ bl=false;
+ e.printStackTrace();
}
- boolean bl=DAOHelper.makeManualCommit(DBUtil.getConn(), sql_str);
return bl;
}
- //6.1鐢垫睜鍏呮斁鐢电鐞嗗垹闄ゆ搷浣�
+ //鍒犻櫎鏀剧數璁板綍锛坆attgroupid锛宼est_record_count锛�
public boolean del(SQLiteDatabase db,Object obj) {
- Batttestdata test = (Batttestdata) obj;
- String sql = "delete from db_batt_testdata.tb_batttestdata_" + test.getBattGroupId()
- + " where battgroupid=? and test_record_count=? ";
- Boolean bl = DAOHelper.executeUpdate(
- DBUtil.getConn(), sql,
- new Object[] { test.getBattGroupId(),test.getTest_record_count() });
+ Batttestdata bdata = (Batttestdata) obj;
+ boolean bl=true;
+ try {
+ String sql = "delete from db_batt_testdata.tb_batttestdata_" + bdata.getBattGroupId()
+ + " where battgroupid=? and test_record_count=? ";
+ db.execSQL(sql,new Object[]{bdata.getBattGroupId(),bdata.getTest_record_count()});
+ } catch (SQLException e) {
+ bl=false;
+ e.printStackTrace();
+ }
return bl;
}
- //鐢垫睜鍏�/鏀剧數鏁版嵁绠＄悊鍒犻櫎
- public String delPro(SQLiteDatabase db,Object obj) {
- Batttestdata bd=(Batttestdata) obj;
- String sql="delete from db_batt_testdata.tb_batttestdata_"+bd.getBattGroupId()+" where test_record_count="+bd.getTest_record_count();
- return sql;
+ //鎵归噺鍒犻櫎鏁版嵁
+ public boolean delPro(SQLiteDatabase db,Object obj) {
+ List<Batttestdata> list= (List<Batttestdata>) obj;
+ boolean bl=true;
+ try {
+ db.beginTransaction();
+ if(list!=null&&list.size()>0){
+ for (int i = 0; i < list.size(); i++) {
+ Batttestdata b=list.get(i);
+ String sql = "delete from db_batt_testdata.tb_batttestdata_" + b.getBattGroupId()
+ + " where battgroupid="+b.getBattGroupId()+" and test_record_count="+b.getTest_record_count();
+ db.execSQL(sql);
+ }
+ }
+ db.setTransactionSuccessful();
+ db.endTransaction();
+ } catch (SQLException e) {
+ bl=false;
+ e.printStackTrace();
+ }
+ return bl;
}
public List searchAll(SQLiteDatabase db) {
return null;
}
- //鍘嗗彶鐩戞祴
+ //鍘嗗彶鐩戞祴鏍规嵁battgroupid鏌ヨ
public List serchByCondition(SQLiteDatabase db,Object obj) {
Batttestdata btd=(Batttestdata)obj;
int number=btd.getRecord_num();//鎬绘暟
@@ -102,38 +137,35 @@
" from db_batt_testdata.tb_batttestdata_"+btd.getBattGroupId()+"" +
" where test_record_count=? and (record_num%"+roteN+"=0 or test_timelong>=? or test_timelong<= ? or record_num>=("+number+"-100)) " +
" and db_batt_testdata.tb_batttestdata_"+btd.getBattGroupId()+".data_available=1 ";
- //System.out.println(sql);
- List list=DAOHelper.executeQuery(sql, DBUtil.getConn(),new Object[]{btd.getTest_record_count(),btd.getNum(),btd.getTest_type()}, new CallBack() {
- public List getResults(ResultSet rs) {
- List list=new ArrayList();
- try {
- while(rs.next()){
- Batttestdata b=new Batttestdata();
- b.setNum(rs.getInt("num"));
- b.setBattGroupId(rs.getInt("BattGroupId"));
- b.setTest_record_count(rs.getInt("test_record_count"));
- b.setTest_type(rs.getInt("test_type"));
- b.setData_new(rs.getInt("data_new"));
- b.setData_available(rs.getInt("data_available"));
- b.setRecord_num(rs.getInt("record_num"));
- b.setTest_starttime(rs.getTimestamp("test_starttime"));
- b.setRecord_time(rs.getTimestamp("record_time"));
- b.setTest_timelong(rs.getInt("test_timelong"));
- b.setOnline_vol(rs.getFloat("online_vol"));
- b.setGroup_vol(rs.getFloat("group_vol"));
- b.setTest_curr(rs.getFloat("test_curr"));
- b.setTest_cap(rs.getFloat("test_cap"));
- b.setMon_num(rs.getInt("mon_num"));
- b.setMon_vol(rs.getFloat("mon_vol"));
- b.setMon_tmp(rs.getFloat("mon_tmp"));
- list.add(b);
- }
- }catch (SQLException e) {
- e.printStackTrace();
- }
- return list;
+
+ List list=new ArrayList();
+ Cursor rs=db.rawQuery(sql,new String[]{String.valueOf(btd.getTest_record_count()),String.valueOf(btd.getNum()),String.valueOf(btd.getTest_type())});
+ try {
+ while (rs.moveToNext()){
+ Batttestdata b=new Batttestdata();
+ b.setNum(rs.getInt(rs.getColumnIndex("num")));
+ b.setBattGroupId(rs.getInt(rs.getColumnIndex("BattGroupId")));
+ b.setTest_record_count(rs.getInt(rs.getColumnIndex("test_record_count")));
+ b.setTest_type(rs.getInt(rs.getColumnIndex("test_type")));
+ b.setData_new(rs.getInt(rs.getColumnIndex("data_new")));
+ b.setData_available(rs.getInt(rs.getColumnIndex("data_available")));
+ b.setRecord_num(rs.getInt(rs.getColumnIndex("record_num")));
+ b.setTest_starttime(ActionUtil.sdf.parse(rs.getString(rs.getColumnIndex("test_starttime"))));
+ b.setRecord_time(ActionUtil.sdf.parse(rs.getString(rs.getColumnIndex("record_time"))));
+ b.setTest_timelong(rs.getInt(rs.getColumnIndex("test_timelong")));
+ b.setOnline_vol(rs.getFloat(rs.getColumnIndex("online_vol")));
+ b.setGroup_vol(rs.getFloat(rs.getColumnIndex("group_vol")));
+ b.setTest_curr(rs.getFloat(rs.getColumnIndex("test_curr")));
+ b.setTest_cap(rs.getFloat(rs.getColumnIndex("test_cap")));
+ b.setMon_num(rs.getInt(rs.getColumnIndex("mon_num")));
+ b.setMon_vol(rs.getFloat(rs.getColumnIndex("mon_vol")));
+ b.setMon_tmp(rs.getFloat(rs.getColumnIndex("mon_tmp")));
+ list.add(b);
}
- });
+ } catch (ParseException e) {
+ e.printStackTrace();
+ }
+ rs.close();
return list;
}
@@ -143,50 +175,26 @@
}
//鏌ヨ鏌愪竴娆℃祴璇曚腑鐨勬渶澶т竴娆＄殑娴嬭瘯鏃堕暱鍜屾渶鐭椂闀�<鍘嗗彶鐩戞祴>
- public List serchMaxAndMintime(Object obj){
+ public List serchMaxAndMintime(SQLiteDatabase db,Object obj){
Batttestdata btb=(Batttestdata) obj;
String sql=" SELECT MAX(record_num) number,MAX(test_timelong) as maxtime,MIN(test_timelong) as mintime FROM db_batt_testdata.tb_batttestdata_"+btb.getBattGroupId()+
" WHERE test_record_count=? and db_batt_testdata.tb_batttestdata_"+btb.getBattGroupId()+".data_available=1 LIMIT 1";
- List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{btb.getTest_record_count()}, new CallBack() {
-
- public List getResults(ResultSet rs) {
- List list=new ArrayList();
- try {
- while(rs.next()){
- Batttestdata btb=new Batttestdata();
- btb.setNum(rs.getInt("maxtime"));
- btb.setTest_type(rs.getInt("mintime"));
- btb.setRecord_num(rs.getInt("number"));
- list.add(btb);
- }
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- return list;
- }
- });
+ List list=new ArrayList();
+ Cursor rs=db.rawQuery(sql,new String[]{String.valueOf(btb.getTest_record_count())});
+ while(rs.moveToNext()){
+ Batttestdata b=new Batttestdata();
+ b.setNum(rs.getInt(rs.getColumnIndex("maxtime")));
+ b.setTest_type(rs.getInt(rs.getColumnIndex("mintime")));
+ b.setRecord_num(rs.getInt(rs.getColumnIndex("number")));
+ list.add(b);
+ }
+ rs.close();
return list;
}
public static void main(String[] args) {
- BatttestdataDAOImpl bimpl=new BatttestdataDAOImpl();
- Batttestdata_inf btd=new Batttestdata_inf();
- btd.setBattGroupId(1002410);
- btd.setNote("1,2,8,10,11,13,14,15,16,17,18,20,22,24,25,26,27,30,31,33,44,45,48,50,51,52,53,54,55");
- btd.setTest_record_count(47);
- List list=new ArrayList();
- list.add(btd);
- /*List list_all=bimpl.serchByInfo(list);
- for (int i = 0; i < list_all.size(); i++) {
- List<Batttestdata> list1=(List<Batttestdata>) list_all.get(i);
- for (Batttestdata b : list1) {
- System.out.println(b);
- }
- }
- System.out.println(list_all.size());*/
}
}
--
Gitblit v1.9.1