tempList 根据传入的pmId不同创建的list对应的model不同,但是又要获得这个tempList 的属性像pointname,changethis等等,object不能用get+属性名来获取,只能用反射获得字段数组,进而获取字段名,字段值。
public String getExportProjMethodIssueExcelPath(String currPId,String writeStartDate,String writeEndDate, List<RptDailyRecordData> exportRecordsList) throws ClassNotFoundException, IllegalArgumentException, IllegalAccessException {
String result = "";
ExcelExportor exportor = new ExcelExportor();
// 根据工程ID查询工程信息
TProjProjectDAO tProjProjectDAO = new TProjProjectDAO();
TProjProject currProj = tProjProjectDAO.findById(currPId);
List<RptDailyData> exportDataList = new ArrayList<RptDailyData>();
for(RptDailyRecordData exportRecord:exportRecordsList){
List tempList = createInstance(exportRecord.getPmId()).getIssueDataList(exportRecord.getPmId(), exportRecord.getIssue());
for(int i=0;i<tempList.size();i++){
TProjProjectMethod proMethod = methodDao.findById(exportRecord.getPmId());
TDicMonitorMethod mtd = mMethodDao.findById(proMethod.getMmId());
Class clazz = Class.forName("model."+ mtd.getMmClassName());
Field[] fieldList=clazz. getDeclaredFields();//获得对应model的所有属性数组
String pointName="";
Double thisvalue=0d,changeThis=0d,changeTotal=0d,changeRate=0d;
for(Field f:fieldList){
if(f.getName().equals("pointName")){
f.setAccessible(true);//因为model的属性全部是private类型,要获取之前必须先设置其可被获取
Object o=f.get( tempList.get(i));//pointName是String类型
pointName = o.toString();
}
if(f.getName().equals("thisvalue")){
f.setAccessible(true);
thisvalue =(Double)(f.get(tempList.get(i)));//如果model的接收参数用的是double就用getDouble(tempList.get(i))来获得
}
if(f.getName().equals("changeThis")){
f.setAccessible(true);
changeThis = (Double)(f.get(tempList.get(i)));
}
if(f.getName().equals("changeTotal")){
f.setAccessible(true);
changeTotal = (Double)(f.get(tempList.get(i)));
}
if(f.getName().equals("changeRate")){
f.setAccessible(true);
changeRate = (Double)(f.get(tempList.get(i)));
}
}
RptDailyData exportData=new RptDailyData();
exportData.setWriteDate(exportRecord.getWriteDate());
exportData.setpStatusReport(exportRecord.getpStatusReport());
exportData.setPName(currProj.getPName());
exportData.setMonitorDate(exportRecord.getMonitorDate());
exportData.setWeather(mImpl.ShowWeatherInfoByPidMdateTwo(currPId,exportRecord.getMonitorDate().toString().substring(0,9)));
exportData.setWritePerson(exportRecord.getWritePerson());
exportData.setMmName(exportRecord.getMmName());
exportData.setIssue(exportRecord.getIssue());
exportData.setPointName(pointName);
exportData.setThisvalue(thisvalue);
exportData.setChangeThis(changeThis);
exportData.setChangeTotal(changeTotal);
exportData.setChangeRate(changeRate);
//for(tempList)
exportDataList.add(exportData);
}
}
exportor.SortByWriteDate(exportDataList);
// 调用导出Excel方法
result = exportor.exportRptDailyExcel(currProj,writeStartDate,writeEndDate, exportDataList);
//System.out.println(result);
return result;
}
注意:clazz 是类,f.get()要放入的是一个Object变量,即这个类的对象,在这里就是按条件查出来的tempList的每个对象实例