拿来

	if (null != caseList && 0 != caseList.size()) {
				for (Iterator it = caseList.iterator(); it.hasNext();) {
					int beginRow = ++r;
					Object[] row = (Object[]) it.next();
					requisitionTime=(Date) row[0];
					businessTitle= (String) row[1];
					problem=(String) row[2];
					solution=(String) row[3];
					
					addCellbyMerge(0,beginRow,0,r,ToDateString(requisitionTime),false,sheet);
					addCellbyMerge(1,beginRow,1,r,businessTitle,false,sheet);
					addCellbyMerge(2,beginRow,2,r,problem,false,sheet);
					addCellbyMerge(3,beginRow,3,r,solution,false,sheet);
					addCellbyMerge(4,beginRow,4,r,"",false,sheet);
					
				}
			}

Map map = null;
			String  businessTitle=null;
			Timestamp requisitionTime=null;
			String  problem=null;
			String  solution=null;
			
			if (null != caseList && 0 != caseList.size()) {
				for (Iterator it = caseList.iterator(); it.hasNext();) {
					int beginRow = ++r;
					map = (Map) it.next();
					businessTitle=(String)map.get("businessTitle");
					requisitionTime=(Timestamp)map.get("requisitionTime");
					problem=(String)map.get("problem");
					solution=(String)map.get("solution");
					
					addCellbyMerge(0,beginRow,0,r,ToDateString(requisitionTime),false,sheet);
					addCellbyMerge(1,beginRow,1,r,businessTitle,false,sheet);
					addCellbyMerge(2,beginRow,2,r,problem,false,sheet);
					addCellbyMerge(3,beginRow,3,r,solution,false,sheet);
					addCellbyMerge(4,beginRow,4,r,"",false,sheet);
					
				}
			}

StringBuffer hql = new StringBuffer("Select new Map(t.requisitionTime as requisitionTime," +
				"t.businessTitle as businessTitle,t.problem as problem, r.solution as solution  ) from BusinessInfo t ,MyProjectInfo p ,BusinessProcess r " +
				"where t.id=r.businessId and r.processType='2' and p.projectId=t.projectId and p.clientId=" + clientId);