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.Cabin_board;
|
|
public class Cabin_boardImpl 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) {
|
Cabin_board cb=(Cabin_board) obj;
|
String sql=" select * from db_partinsystem.cabin_board where dev_id=? ";
|
List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{cb.getDev_id()}, new CallBack() {
|
|
@Override
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
while(rs.next()){
|
Cabin_board c=new Cabin_board();
|
c.setDev_id(rs.getInt("dev_id"));
|
c.setRecord_time(rs.getTimestamp("record_time"));
|
c.setThreeAB_vol(rs.getFloat("threeAB_vol"));
|
c.setThreeBC_vol(rs.getFloat("threeBC_vol"));
|
c.setThreeCA_vol(rs.getFloat("threeCA_vol"));
|
c.setQ1F(rs.getFloat("q1f"));
|
c.setQ1currA(rs.getFloat("q1currA"));
|
c.setQ1currB(rs.getFloat("q1currB"));
|
c.setQ1currC(rs.getFloat("q1currC"));
|
c.setQ1power_active(rs.getFloat("q1power_active"));
|
c.setQ1power_apparent(rs.getFloat("q1power_apparent"));
|
c.setQ1power_factor(rs.getFloat("q1power_factor"));
|
c.setQ1circuit_state(rs.getInt("q1circuit_state"));
|
c.setQ1ele_state(rs.getInt("q1ele_state"));
|
c.setQ1event_state(rs.getInt("q1event_state"));
|
|
c.setQ1F(rs.getFloat("q2f"));
|
c.setQ2currA(rs.getFloat("q2currA"));
|
c.setQ2currB(rs.getFloat("q2currB"));
|
c.setQ2currC(rs.getFloat("q2currC"));
|
c.setQ2power_active(rs.getFloat("q2power_active"));
|
c.setQ2power_apparent(rs.getFloat("q2power_apparent"));
|
c.setQ2power_factor(rs.getFloat("q2power_factor"));
|
c.setQ2circuit_state(rs.getInt("q2circuit_state"));
|
c.setQ2ele_state(rs.getInt("q2ele_state"));
|
c.setQ2event_state(rs.getInt("q2event_state"));
|
|
c.setQ3F(rs.getFloat("q3f"));
|
c.setQ3currA(rs.getFloat("q3currA"));
|
c.setQ3currB(rs.getFloat("q3currB"));
|
c.setQ3currC(rs.getFloat("q3currC"));
|
c.setQ3power_active(rs.getFloat("q3power_active"));
|
c.setQ3power_apparent(rs.getFloat("q3power_apparent"));
|
c.setQ3power_factor(rs.getFloat("q3power_factor"));
|
c.setQ3circuit_state(rs.getInt("q3circuit_state"));
|
c.setQ3ele_state(rs.getInt("q3ele_state"));
|
c.setQ3event_state(rs.getInt("q3event_state"));
|
|
c.setQ4F(rs.getFloat("q4f"));
|
c.setQ4currA(rs.getFloat("q4currA"));
|
c.setQ4currB(rs.getFloat("q4currB"));
|
c.setQ4currC(rs.getFloat("q4currC"));
|
c.setQ4power_active(rs.getFloat("q4power_active"));
|
c.setQ4power_apparent(rs.getFloat("q4power_apparent"));
|
c.setQ4power_factor(rs.getFloat("q4power_factor"));
|
c.setQ4circuit_state(rs.getInt("q4circuit_state"));
|
c.setQ4ele_state(rs.getInt("q4ele_state"));
|
c.setQ4event_state(rs.getInt("q4event_state"));
|
|
c.setQ5F(rs.getFloat("q5f"));
|
c.setQ5currA(rs.getFloat("q5currA"));
|
c.setQ5currB(rs.getFloat("q5currB"));
|
c.setQ5currC(rs.getFloat("q5currC"));
|
c.setQ5power_active(rs.getFloat("q5power_active"));
|
c.setQ5power_apparent(rs.getFloat("q5power_apparent"));
|
c.setQ5power_factor(rs.getFloat("q5power_factor"));
|
c.setQ5circuit_state(rs.getInt("q5circuit_state"));
|
c.setQ5ele_state(rs.getInt("q5ele_state"));
|
c.setQ5event_state(rs.getInt("q5event_state"));
|
|
c.setQ6F(rs.getFloat("q6f"));
|
c.setQ6currA(rs.getFloat("q6currA"));
|
c.setQ6currB(rs.getFloat("q6currB"));
|
c.setQ6currC(rs.getFloat("q6currC"));
|
c.setQ6power_active(rs.getFloat("q6power_active"));
|
c.setQ6power_apparent(rs.getFloat("q6power_apparent"));
|
c.setQ6power_factor(rs.getFloat("q6power_factor"));
|
c.setQ6circuit_state(rs.getInt("q6circuit_state"));
|
c.setQ6ele_state(rs.getInt("q6ele_state"));
|
c.setQ6event_state(rs.getInt("q6event_state"));
|
|
c.setQ7F(rs.getFloat("q7f"));
|
c.setQ7currA(rs.getFloat("q7currA"));
|
c.setQ7currB(rs.getFloat("q7currB"));
|
c.setQ7currC(rs.getFloat("q7currC"));
|
c.setQ7power_active(rs.getFloat("q7power_active"));
|
c.setQ7power_apparent(rs.getFloat("q7power_apparent"));
|
c.setQ7power_factor(rs.getFloat("q7power_factor"));
|
c.setQ7circuit_state(rs.getInt("q7circuit_state"));
|
c.setQ7ele_state(rs.getInt("q7ele_state"));
|
c.setQ7event_state(rs.getInt("q7event_state"));
|
|
c.setQ8F(rs.getFloat("q8f"));
|
c.setQ8currA(rs.getFloat("q8currA"));
|
c.setQ8currB(rs.getFloat("q8currB"));
|
c.setQ8currC(rs.getFloat("q8currC"));
|
c.setQ8power_active(rs.getFloat("q8power_active"));
|
c.setQ8power_apparent(rs.getFloat("q8power_apparent"));
|
c.setQ8power_factor(rs.getFloat("q8power_factor"));
|
c.setQ8circuit_state(rs.getInt("q8circuit_state"));
|
c.setQ8ele_state(rs.getInt("q8ele_state"));
|
c.setQ8event_state(rs.getInt("q8event_state"));
|
|
c.setQ9F(rs.getFloat("q9f"));
|
c.setQ9currA(rs.getFloat("q9currA"));
|
c.setQ9currB(rs.getFloat("q9currB"));
|
c.setQ9currC(rs.getFloat("q9currC"));
|
c.setQ9power_active(rs.getFloat("q9power_active"));
|
c.setQ9power_apparent(rs.getFloat("q9power_apparent"));
|
c.setQ9power_factor(rs.getFloat("q9power_factor"));
|
c.setQ9circuit_state(rs.getInt("q9circuit_state"));
|
c.setQ9ele_state(rs.getInt("q9ele_state"));
|
c.setQ9event_state(rs.getInt("q9event_state"));
|
|
c.setQ10F(rs.getFloat("q10f"));
|
c.setQ10currA(rs.getFloat("q10currA"));
|
c.setQ10currB(rs.getFloat("q10currB"));
|
c.setQ10currC(rs.getFloat("q10currC"));
|
c.setQ10power_active(rs.getFloat("q10power_active"));
|
c.setQ10power_apparent(rs.getFloat("q10power_apparent"));
|
c.setQ10power_factor(rs.getFloat("q10power_factor"));
|
c.setQ10circuit_state(rs.getInt("q10circuit_state"));
|
c.setQ10ele_state(rs.getInt("q10ele_state"));
|
c.setQ10event_state(rs.getInt("q10event_state"));
|
|
c.setQ11F(rs.getFloat("q11f"));
|
c.setQ11currA(rs.getFloat("q11currA"));
|
c.setQ11currB(rs.getFloat("q11currB"));
|
c.setQ11currC(rs.getFloat("q11currC"));
|
c.setQ11power_active(rs.getFloat("q11power_active"));
|
c.setQ11power_apparent(rs.getFloat("q11power_apparent"));
|
c.setQ11power_factor(rs.getFloat("q11power_factor"));
|
c.setQ11circuit_state(rs.getInt("q11circuit_state"));
|
c.setQ11ele_state(rs.getInt("q11ele_state"));
|
c.setQ11event_state(rs.getInt("q11event_state"));
|
|
c.setQ12F(rs.getFloat("q12f"));
|
c.setQ12currA(rs.getFloat("q12currA"));
|
c.setQ12currB(rs.getFloat("q12currB"));
|
c.setQ12currC(rs.getFloat("q12currC"));
|
c.setQ12power_active(rs.getFloat("q12power_active"));
|
c.setQ12power_apparent(rs.getFloat("q12power_apparent"));
|
c.setQ12power_factor(rs.getFloat("q12power_factor"));
|
c.setQ12circuit_state(rs.getInt("q12circuit_state"));
|
c.setQ12ele_state(rs.getInt("q12ele_state"));
|
c.setQ12event_state(rs.getInt("q12event_state"));
|
|
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;
|
}
|
|
}
|
