package com.fgkj.impl;
|
|
import android.database.Cursor;
|
import android.database.SQLException;
|
import android.database.sqlite.SQLiteDatabase;
|
import android.util.Log;
|
|
import com.fgkj.dao.ActionUtil;
|
import com.fgkj.dao.BaseDAO;
|
import com.fgkj.dto.Battinf;
|
import com.sqlite_DaoHelper.CallBack;
|
import com.sqlite_DaoHelper.DAOHelper;
|
import com.sqlite_DaoHelper.DBUtil;
|
|
import java.io.File;
|
import java.sql.ResultSet;
|
import java.text.ParseException;
|
import java.text.SimpleDateFormat;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
|
public class BattinfImpl implements BaseDAO, CallBack {
|
//插入电池组信息
|
@Override
|
public boolean add(SQLiteDatabase db,Object obj) {
|
Battinf binf=(Battinf) obj;
|
boolean bl=true;
|
String sql=" insert into tb_battinf(BattGroupId,BattGroupName,BattGroupName1,BattFloatCurrent,MonCount,MonCapStd,MonVolStd,MonResStd,MonSerStd,MonTmpStd,BattProducer,BattInUseDate,station_install) " +
|
" values(?,?,?,?,?,?,?,?,?,?,?,?,?)";
|
db.execSQL(sql,new Object[]{binf.getBattGroupId(),binf.getBattGroupName(),binf.getBattGroupName1(),binf.getBattFloatCurrent(),binf.getMonCount(),binf.getMonCapStd(),binf.getMonVolStd()
|
,binf.getMonResStd(),binf.getMonSerStd(),binf.getMonTmpStd(),binf.getBattProducer(),ActionUtil.getSimpDate(binf.getBattInUseDate()),binf.getStation_install()});
|
try {
|
return bl;
|
} catch (Exception e) {
|
bl=false;
|
e.printStackTrace();
|
}
|
return bl;
|
}
|
//根据battgroupid修改表的数据
|
@Override
|
public boolean update(SQLiteDatabase db,Object obj) {
|
Battinf binf=(Battinf) obj;
|
boolean bl=true;
|
String sql=" update tb_battinf set BattGroupName=?,BattGroupName1=?,BattFloatCurrent=?,MonCount=?,MonCapStd=?,MonVolStd=?,MonResStd=?,MonSerStd=?,MonTmpStd=?,BattProducer=?,BattInUseDate=?,station_install=? where BattGroupId=? ";
|
try {
|
db.execSQL(sql,new Object[]{binf.getBattGroupName(),binf.getBattGroupName1(),binf.getBattFloatCurrent(),binf.getMonCount(),binf.getMonCapStd(),binf.getMonVolStd()
|
,binf.getMonResStd(),binf.getMonSerStd(),binf.getMonTmpStd(),binf.getBattProducer(),ActionUtil.getSimpDate(binf.getBattInUseDate()),binf.getStation_install(),binf.getBattGroupId()});
|
} catch (SQLException e) {
|
bl=false;
|
e.printStackTrace();
|
}
|
return bl;
|
}
|
//根据id删除
|
@Override
|
public boolean del(SQLiteDatabase db,Object obj) {
|
Battinf binf=(Battinf)obj;
|
boolean bl=true;
|
String sql=" delete from tb_battinf where BattGroupId=? ";
|
try {
|
db.execSQL(sql,new Object[]{binf.getBattGroupId()});
|
} catch (SQLException e) {
|
bl=false;
|
e.printStackTrace();
|
}
|
|
return bl;
|
}
|
//查询库中存在的所有电池组信息
|
@Override
|
public List searchAll(SQLiteDatabase db) {
|
String sql=" select * from tb_battinf where station_install=1 order by battgroupid asc ";
|
List list=new ArrayList();
|
Cursor rs = db.rawQuery(sql,new String[]{});
|
while(rs.moveToNext()){
|
Battinf binf=new Battinf();
|
binf.setNum(rs.getInt(rs.getColumnIndex("num")));
|
binf.setBattGroupId(rs.getInt(rs.getColumnIndex("BattGroupId")));
|
binf.setBattGroupName(rs.getString(rs.getColumnIndex("BattGroupName")));
|
binf.setBattGroupName1(rs.getString(rs.getColumnIndex("BattGroupName1")));
|
binf.setBattFloatCurrent(rs.getDouble(rs.getColumnIndex("BattFloatCurrent")));
|
binf.setMonCapStd(rs.getDouble(rs.getColumnIndex("MonCapStd")));
|
binf.setMonVolStd(rs.getDouble(rs.getColumnIndex("MonVolStd")));
|
binf.setMonCount(rs.getInt(rs.getColumnIndex("MonCount")));
|
binf.setMonResStd(rs.getDouble(rs.getColumnIndex("MonResStd")));
|
binf.setMonSerStd(rs.getDouble(rs.getColumnIndex("MonSerStd")));
|
binf.setMonTmpStd(rs.getDouble(rs.getColumnIndex("MonTmpStd")));
|
binf.setBattProducer(rs.getString(rs.getColumnIndex("BattProducer")));
|
try {
|
Date date= ActionUtil.sdfwithOut.parse( rs.getString(rs.getColumnIndex("BattInUseDate")));
|
binf.setBattInUseDate(date);
|
} catch (ParseException e) {
|
e.printStackTrace();
|
}
|
binf.setStation_install(rs.getInt(rs.getColumnIndex("station_install")));
|
list.add(binf);
|
}
|
rs.close();
|
return list;
|
}
|
//根据电池组id查询电池组信息
|
@Override
|
public List serchByCondition(SQLiteDatabase db,Object obj) {
|
Battinf b=(Battinf)obj;
|
String sql=" select * from tb_battinf where BattGroupId=? order by battgroupid asc ";
|
List list=new ArrayList();
|
Cursor rs = db.rawQuery(sql,new String[]{String.valueOf(b.getBattGroupId())});
|
while(rs.moveToNext()){
|
Battinf binf=new Battinf();
|
binf.setNum(rs.getInt(rs.getColumnIndex("num")));
|
binf.setBattGroupId(rs.getInt(rs.getColumnIndex("BattGroupId")));
|
binf.setBattGroupName(rs.getString(rs.getColumnIndex("BattGroupName")));
|
binf.setBattGroupName1(rs.getString(rs.getColumnIndex("BattGroupName1")));
|
binf.setBattFloatCurrent(rs.getDouble(rs.getColumnIndex("BattFloatCurrent")));
|
binf.setMonCapStd(rs.getDouble(rs.getColumnIndex("MonCapStd")));
|
binf.setMonVolStd(rs.getDouble(rs.getColumnIndex("MonVolStd")));
|
binf.setMonCount(rs.getInt(rs.getColumnIndex("MonCount")));
|
binf.setMonResStd(rs.getDouble(rs.getColumnIndex("MonResStd")));
|
binf.setMonSerStd(rs.getDouble(rs.getColumnIndex("MonSerStd")));
|
binf.setMonTmpStd(rs.getDouble(rs.getColumnIndex("MonTmpStd")));
|
binf.setBattProducer(rs.getString(rs.getColumnIndex("BattProducer")));
|
try {
|
Date date= ActionUtil.sdfwithOut.parse( rs.getString(rs.getColumnIndex("BattInUseDate")));
|
binf.setBattInUseDate(date);
|
} catch (ParseException e) {
|
e.printStackTrace();
|
}
|
binf.setStation_install(rs.getInt(rs.getColumnIndex("station_install")));
|
list.add(binf);
|
}
|
rs.close();
|
return list;
|
}
|
|
@Override
|
public List serchByInfo(SQLiteDatabase db,Object obj) {
|
return null;
|
}
|
|
@Override
|
public List getResults(ResultSet rs) {
|
return null;
|
}
|
|
public static void main (String[] args) throws ParseException {
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
Date date1 = sdf.parse("2000-01-01");
|
|
Battinf binf=new Battinf();
|
binf.setBattGroupId(1000002);
|
binf.setBattGroupName("电池组2");
|
binf.setBattGroupName1("电池组");
|
binf.setBattFloatCurrent(51.5);
|
binf.setMonCapStd(150);
|
binf.setMonVolStd(12);
|
binf.setMonCount(4);
|
binf.setMonResStd(5000);
|
binf.setMonSerStd(0.002);
|
binf.setMonTmpStd(50.2);
|
binf.setBattProducer("理士");
|
binf.setBattInUseDate(ActionUtil.getSimpDate(date1));
|
//System.out.println(DAOHelper.getSimpDate(date1));
|
// System.out.println(binf.getBattInUseDate());
|
binf.setStation_install(1);
|
BattinfImpl bimpl=new BattinfImpl();
|
/*boolean bl=bimpl.add(binf);
|
System.out.println(bl);*/
|
String path=System.getProperty("user.dir");
|
String db_path= "/app/assets/sqlites/fbs9600.db";
|
String filePath = path+db_path;
|
System.out.println(filePath);
|
File jhPath=new File(filePath);
|
SQLiteDatabase db = SQLiteDatabase.openOrCreateDatabase(jhPath, null);
|
List<Battinf> list=bimpl.searchAll(db);
|
for (Battinf b:list
|
) {
|
System.out.println(b);
|
}
|
}
|
}
|
