entry层:Set<Integer> powerStatusList;//对应数据库的电源状态;
Dao层使用;
sql = "select (select a form table1 where b=t.b) as a,b system from table2 t where"
//显示结果为:查询表1中a的数据别名为a并查询表2中b的数据,显示a,b数据;
//sql.append("String")增加String sql语句;
Marker marker = new Marker();
if(null != result.get("POWERStATUS")){
Integer powerState = ((BigDecimal) result.get("POWERStATUS")).intValue();
//BigDecimal的使用和intValue(),valueOf()的区别应用
if(null == marker.getPowerStatusList()){
//避免空指针异常;
marker.setPowerStatusList(new TreeSet<Integer>);//TreeSet集合的应用
}
marker.getPowerStatusList().add(powerState);
}
List<Marker> markerList = new ArrayList<Marker>(markerMap.values());//将markerMap的值赋予markerList
loop:for(Marker tempMarker : markerList){
//断电
StringBuffer iconType = new StringBuffer();
Set<Integer> powerStatusList = tempMarker.getPowerStatusList();
if(tempMarker.getPowerStatusList() != null || tempMarker.getEquList().contains(1)){
powerStatusList.iterator();
for(Iterator<Integer> it = powerStatusList.iterator();it.hasNext();)
if(it.next() != 1){
iconType.append("-").append("POWERDOWN");
tempMarker .setIconType((iconType.toString());
continue loop;//指定跳转
}
}
}
return markerList;