package com.fgkj.dao.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.dto.BattInf;
|
import com.fgkj.dto.Battinf_ex;
|
|
public class Battinf_exImpl implements BaseDAO,CallBack{
|
|
public List getResults(ResultSet rs) {
|
// TODO Auto-generated method stub
|
return null;
|
}
|
|
public boolean add(Object obj) {
|
// TODO Auto-generated method stub
|
return false;
|
}
|
|
public boolean update(Object obj) {
|
// TODO Auto-generated method stub
|
return false;
|
}
|
|
public boolean del(Object obj) {
|
// TODO Auto-generated method stub
|
return false;
|
}
|
|
public List searchAll() {
|
// TODO Auto-generated method stub
|
return null;
|
}
|
//根据电池组的信息stationid查询
|
public List serchByCondition(Object obj) {
|
BattInf binf=(BattInf) obj;
|
String sql=" select * from db_battinf.tb_battinf_ex where stationId=? ";
|
List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getStationId()}, new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
while(rs.next()){
|
Battinf_ex binf_ex=new Battinf_ex();
|
binf_ex.setNum(rs.getInt("num"));
|
binf_ex.setStationId(rs.getString("stationId"));
|
binf_ex.setFBSDeviceId(rs.getInt("fBSDeviceId"));
|
binf_ex.setStationName(rs.getString("stationName"));
|
binf_ex.setStationCode(rs.getString("stationCode"));
|
binf_ex.setStationRegion(rs.getString("stationRegion"));
|
binf_ex.setKeyWords(rs.getString("keyWords"));
|
binf_ex.setAffiliation(rs.getString("affiliation"));
|
binf_ex.setDataSources(rs.getString("dataSources"));
|
binf_ex.setStationType(rs.getString("stationType"));
|
binf_ex.setLongitude(rs.getDouble("longitude"));
|
binf_ex.setLatitude(rs.getInt("latitude"));
|
binf_ex.setStationAddr(rs.getString("stationAddr"));
|
binf_ex.setStationLevel(rs.getString("stationLevel"));
|
binf_ex.setMaintenanceState(rs.getString("maintenanceState"));
|
binf_ex.setBlockedState(rs.getString("blockedState"));
|
binf_ex.setMaintenanceCompany(rs.getString("maintenanceCompany"));
|
binf_ex.setBusinessScenario(rs.getString("businessScenario"));
|
binf_ex.setCoverScenario(rs.getString("coverScenario"));
|
binf_ex.setSiteTerrain(rs.getString("siteTerrain"));
|
binf_ex.setPropertyRights(rs.getString("propertyRights"));
|
binf_ex.setPropertyUnit(rs.getString("propertyUnit"));
|
binf_ex.setIsShare(rs.getString("isShare"));
|
binf_ex.setUseUnit(rs.getString("useUnit"));
|
binf_ex.setSiteCode(rs.getString("siteCode"));
|
binf_ex.setHistorySiteCode(rs.getString("historySiteCode"));
|
binf_ex.setSiteInternalNumber(rs.getString("siteInternalNumber"));
|
binf_ex.setSitePinyinReferred(rs.getString("sitePinyinReferred"));
|
binf_ex.setSiteChineseReferred(rs.getString("siteChineseReferred"));
|
binf_ex.setSiteMergeRecord(rs.getString("siteMergeRecord"));
|
binf_ex.setIsOpenBusiness(rs.getString("isOpenBusiness"));
|
binf_ex.setSchoolPersonnel(rs.getString("schoolPersonnel"));
|
binf_ex.setEntryTime(rs.getString("entryTime"));
|
binf_ex.setModifyPeople(rs.getString("modifyPeople"));
|
binf_ex.setModifyTime(rs.getString("modifyTime"));
|
binf_ex.setNote(rs.getString("note"));
|
binf_ex.setSiteReceivesMark(rs.getString("siteReceivesMark"));
|
binf_ex.setSiteValidity(rs.getString("siteValidity"));
|
binf_ex.setSiteNameCMCC(rs.getString("siteNameCMCC"));
|
binf_ex.setSiteNameCUCC(rs.getString("siteNameCUCC"));
|
binf_ex.setSiteNameCTC(rs.getString("siteNameCTC"));
|
binf_ex.setProducer(rs.getString("producer"));
|
binf_ex.setLastTimeLong(rs.getDouble("lastTimeLong"));
|
binf_ex.setLastTimeType(rs.getString("lastTimeType"));
|
binf_ex.setLastTimeDate(rs.getTimestamp("lastTimeDate"));
|
binf_ex.setShareInfo(rs.getString("shareInfo"));
|
binf_ex.setElectPowerCMCC(rs.getInt("electPowerCMCC"));
|
binf_ex.setElectPowerCUCC(rs.getInt("electPowerCUCC"));
|
binf_ex.setElectPowerCTC(rs.getInt("electPowerCTC"));
|
binf_ex.setIsCanElectPower(rs.getInt("isCanElectPower"));
|
binf_ex.setUpperStationRoute(rs.getDouble("upperStationRoute"));
|
binf_ex.setUpperStationDifficult(rs.getString("upperStationDifficult"));
|
binf_ex.setClienteleErrorService(rs.getString("clienteleErrorService"));
|
list.add(binf_ex);
|
}
|
} catch (SQLException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
return list;
|
}
|
|
public List serchByInfo(Object obj) {
|
// TODO Auto-generated method stub
|
return null;
|
}
|
public static void main(String[] args) {
|
Battinf_exImpl bimpl=new Battinf_exImpl();
|
BattInf binf=new BattInf();
|
binf.setStationId("42000001");
|
List list=bimpl.serchByCondition(binf);
|
System.out.println(list.size());
|
}
|
}
|
