public static final String[] rainType = new String[]{"250", "特大暴雨", "100", "大暴雨", "50", "暴雨", "25", "大雨", "10", "中雨或暴雪", "5", "小雨或大雪", "2.5", "小雨或中雪", "0.1", "小雨或小雪"}; private String getLevelName(String num){ String s = ""; for(int i=0; i<rainType.length; i=i+2){ BigDecimal b = new BigDecimal(rainType[i]); if((new BigDecimal(num)).compareTo(b) > -1){ s = rainType[i]+","+rainType[i+1]; return s; } } return s; }
public static final Map<Integer, String> familyTypeMap = new HashMap<Integer, String>(); static { familyTypeMap.put(1, "一般户"); familyTypeMap.put(2, "其他户"); familyTypeMap.put(3, "低保户"); familyTypeMap.put(4, "五保户");}
ledger.setFamilyType(getTypeInteger((HashMap<Integer, String>) familyTypeMap, getValue(xrow.getCell(5))));
Date d = null; Double da; //受灾时间、灾害种类 Cell cell = xrow.getCell(9); cell.setCellType(CellType.NUMERIC); if (DateUtil.isCellDateFormatted(cell)) { da = cell.getNumericCellValue(); d = DateUtil.getJavaDate(da); if(d != null) { ledger.setDisasterDate(d); } } ledger.setDisasterType(getTypeInteger((HashMap<Integer, String>) eventTypeMap, getValue(xrow.getCell(10))));
private Integer getTypeInteger(HashMap<Integer,String> hs, String s){ for(Map.Entry<Integer,String> m : hs.entrySet()){ if(s.equals(m.getValue()) || m.getValue().contains(s)){ return m.getKey(); } } return 0; }