package com.fgkj.partinsystem.impl;
|
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
import com.fgkj.dao.BaseDAO;
|
import com.fgkj.dao.CallBack;
|
import com.fgkj.dao.DAOHelper;
|
import com.fgkj.db.DBUtil;
|
import com.fgkj.partinsystem.dto.Centra_frequency;
|
|
public class Centra_frequencyImpl implements BaseDAO,CallBack{
|
|
@Override
|
public List getResults(ResultSet rs) {
|
// TODO Auto-generated method stub
|
return null;
|
}
|
|
@Override
|
public boolean add(Object obj) {
|
// TODO Auto-generated method stub
|
return false;
|
}
|
|
@Override
|
public boolean update(Object obj) {
|
// TODO Auto-generated method stub
|
return false;
|
}
|
|
@Override
|
public boolean del(Object obj) {
|
// TODO Auto-generated method stub
|
return false;
|
}
|
|
@Override
|
public List searchAll() {
|
// TODO Auto-generated method stub
|
return null;
|
}
|
//根据设备id查询设备实时数据
|
@Override
|
public List serchByCondition(Object obj) {
|
Centra_frequency cf=(Centra_frequency) obj;
|
String sql=" select * from db_partinsystem.centra_frequency where dev_id=? ";
|
List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{cf.getDev_id()}, new CallBack() {
|
|
@Override
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
while(rs.next()){
|
Centra_frequency c=new Centra_frequency();
|
c.setDev_id(rs.getInt("dev_id"));
|
c.setRecord_time(rs.getTimestamp("record_time"));
|
c.setUin1_vol(rs.getFloat("uin1_vol"));
|
c.setUin2_vol(rs.getFloat("uin2_vol"));
|
c.setIin1_curr(rs.getFloat("iin1_curr"));
|
c.setIin2_curr(rs.getFloat("iin2_curr"));
|
c.setProtigbt1_tmp(rs.getFloat("protigbt1_tmp"));
|
c.setProtigbt2_tmp(rs.getFloat("protigbt2_tmp"));
|
c.setProtigbt8_tmp(rs.getFloat("protigbt8_tmp"));
|
c.setTl1_tmp(rs.getFloat("tl1_tmp"));
|
c.setTl2_tmp(rs.getFloat("tl2_tmp"));
|
c.setTcab_tmp(rs.getFloat("tcab_tmp"));
|
c.setFlag(rs.getInt("flag"));
|
|
c.setVdc_up1_vol(rs.getFloat("vdc_up1_vol"));
|
c.setVdc_down1_vol(rs.getFloat("vdc_down1_vol"));
|
c.setUm1_in_vol(rs.getFloat("um1_in_vol"));
|
c.setIla1_curr(rs.getFloat("ila1_curr"));
|
c.setIlb1_curr(rs.getFloat("ilb1_curr"));
|
c.setIlc1_curr(rs.getFloat("ilc1_curr"));
|
c.setIoa1_curr(rs.getFloat("ioa1_curr"));
|
c.setIob1_curr(rs.getFloat("iob1_curr"));
|
c.setIoc1_curr(rs.getFloat("ioc1_curr"));
|
c.setUoab1_vol(rs.getFloat("uoab1_vol"));
|
c.setUobc1_vol(rs.getFloat("uobc1_vol"));
|
c.setUoca1_vol(rs.getFloat("uoca1_vol"));
|
c.setTigbt1_tmp(rs.getFloat("tigbt1_tmp"));
|
c.setTdiode1_tmp(rs.getFloat("tdiode1_tmp"));
|
c.setTlac1_tmp(rs.getFloat("tlac1_tmp"));
|
c.setTcac1_tmp(rs.getFloat("tcac1_tmp"));
|
c.setTcdc1_tmp(rs.getFloat("tcdc1_tmp"));
|
c.setM1_flag_state(rs.getInt("m1_flag_state"));
|
c.setPower1(rs.getFloat("power1"));
|
c.setF1(rs.getFloat("f1"));
|
c.setErrcode1(rs.getInt("errcode1"));
|
|
c.setVdc_up8_vol(rs.getFloat("vdc_up8_vol"));
|
c.setVdc_down8_vol(rs.getFloat("vdc_down8_vol"));
|
c.setUm_in8_vol(rs.getFloat("um_in8_vol"));
|
c.setIla8_curr(rs.getFloat("ila8_curr"));
|
c.setIlb8_curr(rs.getFloat("ilb8_curr"));
|
c.setIlc8_curr(rs.getFloat("ilc8_curr"));
|
c.setIoa8_curr(rs.getFloat("ioa8_curr"));
|
c.setIob8_curr(rs.getFloat("iob8_curr"));
|
c.setIoc8_curr(rs.getFloat("ioc8_curr"));
|
c.setUoab8_vol(rs.getFloat("uoab8_vol"));
|
c.setUobc8_vol(rs.getFloat("uobc8_vol"));
|
c.setUoca8_vol(rs.getFloat("uoca8_vol"));
|
c.setTigbt8_tmp(rs.getFloat("tigbt8_tmp"));
|
c.setTdiode8_tmp(rs.getFloat("tdiode8_tmp"));
|
c.setTlac8_tmp(rs.getFloat("tlac8_tmp"));
|
c.setTcac8_tmp(rs.getFloat("tcac8_tmp"));
|
c.setTcdc8_tmp(rs.getFloat("tcdc8_tmp"));
|
c.setM8_flag_state(rs.getInt("m8_flag_state"));
|
c.setPower8(rs.getFloat("power8"));
|
c.setF8(rs.getFloat("f8"));
|
c.setErrcode8(rs.getInt("errcode8"));
|
|
|
list.add(c);
|
}
|
} catch (SQLException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
return list;
|
}
|
|
@Override
|
public List serchByInfo(Object obj) {
|
// TODO Auto-generated method stub
|
return null;
|
}
|
|
}
|
