package com.fgkj.impl;
|
|
import android.content.ContentValues;
|
import android.database.Cursor;
|
import android.database.sqlite.SQLiteDatabase;
|
|
import java.text.ParseException;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
import com.fgkj.dao.ActionUtil;
|
import com.fgkj.dao.BaseDAO;
|
import com.fgkj.dto.Batttestdata_inf;
|
|
|
public class Batttestdata_infDAOImpl implements BaseDAO {
|
//向batttestdata_inf表中添加数据
|
public boolean add(SQLiteDatabase db,Object obj) {
|
/*Batttestdata_inf b=(Batttestdata_inf)obj;
|
String sql="insert into tb_batttestdata_inf(BattGroupId,test_record_count,test_record_count_ex,test_type,record_time_interval,data_new,data_available,record_num,test_starttime,test_starttime_ex,test_starttype,record_time,test_timelong,test_stoptype,group_vol,test_curr,test_cap,max_monnum,max_monvol,min_monnum,min_monvol,mon_num,mon_vol,upload_usr_id) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
|
boolean bl=true;
|
try {
|
db.execSQL(sql,new Object[]{
|
b.getBattGroupId(),
|
b.getTest_record_count(),
|
b.getTest_record_count_ex(),
|
b.getTest_type(),
|
b.getRecord_time_interval(),
|
b.getData_new(),
|
b.getData_available(),
|
b.getRecord_num(),
|
b.getTest_starttime(),
|
b.getTest_starttime_ex(),
|
b.getTest_starttype(),
|
b.getRecord_time(),
|
b.getTest_timelong(),
|
b.getTest_stoptype(),
|
b.getGroup_vol(),
|
b.getTest_curr(),
|
b.getTest_cap(),
|
b.getMax_monnum(),
|
b.getMax_monvol(),
|
b.getMin_monnum(),
|
b.getMin_monvol(),
|
b.getMon_num(),
|
b.getMon_vol(),
|
b.getUpload_usr_id()
|
});
|
} catch (android.database.SQLException e) {
|
bl=false;
|
e.printStackTrace();
|
}*/
|
boolean bl=true;
|
ContentValues cv =Batttestdata_infDAOImpl.getContentValues(obj);
|
long row = db.insert("tb_batttestdata_inf", null, cv);
|
if(row>0){
|
bl=true;
|
}else{
|
bl=false;
|
}
|
return bl;
|
}
|
|
public boolean update(SQLiteDatabase db,Object obj) {
|
Batttestdata_inf b=(Batttestdata_inf)obj;
|
ContentValues cv=Batttestdata_infDAOImpl.getContentValues(obj);
|
String sql="num=?";
|
long row=db.update("tb_batttestdata_inf",cv,sql,new String[]{String.valueOf(b.getNum())});
|
return false;
|
}
|
|
//电池充放电删除记录
|
public boolean del(SQLiteDatabase db,Object obj) {
|
Batttestdata_inf tdata=(Batttestdata_inf)obj;
|
boolean bl=true;
|
/*String sql="delete from tb_batttestdata_inf where num=?";
|
try {
|
db.execSQL(sql, new Object[]{tdata.getNum()});
|
} catch (android.database.SQLException e) {
|
bl=false;
|
e.printStackTrace();
|
}*/
|
String sql="num=?";
|
long row = db.delete ("tb_batttestdata_",sql,new String[]{String.valueOf(tdata.getNum())});
|
if(row>0){
|
bl=true;
|
}else{
|
bl=false;
|
}
|
return bl;
|
}
|
//查询所有的充放电信息
|
public List searchAll(SQLiteDatabase db) {
|
String sql="select num,BattGroupId,test_record_count,test_type,record_time_interval,record_num,test_starttime,record_time,test_timelong,group_vol,test_curr,test_cap,max_monnum,max_monvol,min_monnum,min_monvol,mon_num,mon_vol " +
|
" from tb_batttestdata_inf " ;
|
Cursor rs=db.rawQuery(sql,new String[]{});
|
List list=new ArrayList();
|
try {
|
while(rs.moveToNext()){
|
Batttestdata_inf b=new Batttestdata_inf();
|
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.setRecord_time_interval(rs.getInt(rs.getColumnIndex("record_time_interval")));
|
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.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.setMax_monnum(rs.getInt(rs.getColumnIndex("max_monnum")));
|
b.setMax_monvol(rs.getFloat(rs.getColumnIndex("max_monvol")));
|
b.setMin_monnum(rs.getInt(rs.getColumnIndex("min_monnum")));
|
b.setMin_monvol(rs.getFloat(rs.getColumnIndex("min_monvol")));
|
b.setMon_num(rs.getInt(rs.getColumnIndex("mon_num")));
|
b.setMon_vol(rs.getFloat(rs.getColumnIndex("mon_vol")));
|
list.add(b);
|
}
|
} catch (ParseException e) {
|
e.printStackTrace();
|
}finally {
|
rs.close();
|
}
|
return list;
|
}
|
|
//根据battfroupid查询历史数据查询
|
public List serchByCondition(SQLiteDatabase db,Object obj) {
|
Batttestdata_inf bti=(Batttestdata_inf)obj;
|
String sql="select num,BattGroupId,test_record_count,test_type,record_time_interval,record_num,test_starttime,record_time,test_timelong" +
|
",group_vol,test_curr,test_cap,max_monnum,max_monvol,min_monnum,min_monvol,mon_num,mon_vol"
|
+" from tb_batttestdata_inf where "
|
+" BattGroupId=? " +
|
" order by test_type asc,test_starttime desc ";
|
List list=new ArrayList();
|
Cursor rs=db.rawQuery(sql,new String[]{String.valueOf(bti.getBattGroupId())});
|
try {
|
while(rs.moveToNext()){
|
Batttestdata_inf b=new Batttestdata_inf();
|
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.setRecord_time_interval(rs.getInt(rs.getColumnIndex("record_time_interval")));
|
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.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.setMax_monnum(rs.getInt(rs.getColumnIndex("max_monnum")));
|
b.setMax_monvol(rs.getFloat(rs.getColumnIndex("max_monvol")));
|
b.setMin_monnum(rs.getInt(rs.getColumnIndex("min_monnum")));
|
b.setMin_monvol(rs.getFloat(rs.getColumnIndex("min_monvol")));
|
b.setMon_num(rs.getInt(rs.getColumnIndex("mon_num")));
|
b.setMon_vol(rs.getFloat(rs.getColumnIndex("mon_vol")));
|
list.add(b);
|
}
|
} catch (ParseException e) {
|
e.printStackTrace();
|
}finally {
|
rs.close();
|
}
|
return list;
|
}
|
|
public List serchByInfo(SQLiteDatabase db,Object obj) {
|
return null;
|
}
|
|
//获取ContentValues
|
public static ContentValues getContentValues(Object obj){
|
Batttestdata_inf bti=(Batttestdata_inf)obj;
|
ContentValues cv=new ContentValues();
|
cv.put("num",bti.getNum());
|
cv.put("BattGroupId",bti.getBattGroupId());
|
cv.put("test_record_count",bti.getTest_record_count());
|
cv.put("test_type",bti.getTest_type());
|
cv.put("record_time_interval",bti.getRecord_time_interval());
|
cv.put("record_num",bti.getRecord_num());
|
|
cv.put("test_starttime",ActionUtil.sdf.format(bti.getTest_starttime()));
|
cv.put("record_time",ActionUtil.sdf.format(bti.getRecord_time()));
|
|
cv.put("test_timelong",bti.getTest_timelong());
|
cv.put("group_vol",bti.getGroup_vol());
|
cv.put("test_curr",bti.getTest_curr());
|
cv.put("test_cap",bti.getTest_cap());
|
cv.put("max_monnum",bti.getMax_monnum());
|
cv.put("max_monvol",bti.getMax_monvol());
|
cv.put("min_monnum",bti.getMin_monnum());
|
cv.put("mon_num",bti.getMon_num());
|
cv.put("mon_vol",bti.getMon_vol());
|
return cv;
|
}
|
|
|
public static void main(String[] args) {
|
Batttestdata_infDAOImpl bimpl=new Batttestdata_infDAOImpl();
|
}
|
}
|
