package com.fgkj.impl;
|
|
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.sql.ResultSet;
|
import java.sql.SQLException;
|
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(Object obj) {
|
Battinf binf=(Battinf) obj;
|
String sql=" insert into tb_battinf(BattGroupId,BattGroupName,BattGroupName1,BattFloatCurrent,MonCount,MonCapStd,MonVolStd,MonResStd,MonSerStd,MonTmpStd,BattProducer,BattInUseDate,station_install) " +
|
" values(?,?,?,?,?,?,?,?,?,?,?,?,?)";
|
boolean bl= DAOHelper.executeUpdate(DBUtil.getConn(),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(),binf.getBattInUseDate(),binf.getStation_install()});
|
return bl;
|
}
|
//根据battgroupid修改表的数据
|
@Override
|
public boolean update(Object obj) {
|
Battinf binf=(Battinf) obj;
|
String sql=" update tb_battinf set BattGroupName=?,BattGroupName1=?,BattFloatCurrent=?,MonCount=?,MonCapStd=?,MonVolStd=?,MonResStd=?,MonSerStd=?,MonTmpStd=?,BattProducer=?,BattInUseDate=?,station_install=? where BattGroupId=? ) ";
|
boolean bl= DAOHelper.executeUpdate(DBUtil.getConn(),sql,new Object[]{binf.getBattGroupName(),binf.getBattGroupName1(),binf.getBattFloatCurrent(),binf.getMonCount(),binf.getMonCapStd(),binf.getMonVolStd()
|
,binf.getMonResStd(),binf.getMonSerStd(),binf.getMonTmpStd(),binf.getBattProducer(),binf.getBattInUseDate(),binf.getStation_install(),binf.getBattGroupId()});
|
return bl;
|
}
|
|
@Override
|
public boolean del(Object obj) {
|
return false;
|
}
|
//查询库中存在的所有电池组信息
|
@Override
|
public List searchAll() {
|
String sql=" select * from tb_battinf where station_install=1 order by battgroupid asc ";
|
List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new CallBack() {
|
@Override
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
while (rs.next()){
|
Battinf binf=new Battinf();
|
binf.setNum(rs.getInt("num"));
|
binf.setBattGroupId(rs.getInt("battgroupid"));
|
binf.setBattGroupName(rs.getString("battgroupname"));
|
binf.setBattGroupName1(rs.getString("battgroupname1"));
|
binf.setBattFloatCurrent(rs.getDouble("BattFloatCurrent"));
|
binf.setMonCapStd(rs.getDouble("MonCapStd"));
|
binf.setMonVolStd(rs.getDouble("MonVolStd"));
|
binf.setMonCount(rs.getInt("MonCount"));
|
binf.setMonResStd(rs.getDouble("MonResStd"));
|
binf.setMonSerStd(rs.getDouble("MonSerStd"));
|
binf.setMonTmpStd(rs.getDouble("MonTmpStd"));
|
binf.setBattProducer(rs.getString("BattProducer"));
|
binf.setBattInUseDate(rs.getDate("BattInUseDate"));
|
binf.setStation_install(rs.getInt("Station_install"));
|
list.add(binf);
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
return list;
|
}
|
|
@Override
|
public List serchByCondition(Object obj) {
|
return null;
|
}
|
|
@Override
|
public List serchByInfo(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(DAOHelper.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);*/
|
List<Battinf> list=bimpl.searchAll();
|
for (Battinf b:list
|
) {
|
System.out.println(b);
|
}
|
}
|
}
|
