?//alarmLogExport.action
?/**
? * 日志导出
? *
? */
?@SuppressWarnings("unchecked")
?public String alarmLogExport() throws IOException {
??
?? ?
??? try {
? // AlarmLog 是model
//数据库查询数据放到List
List<AlarmLog>???list = alarmLogService.getAlarmLogList(beginTime,endTime,alarmMode,result);
?? } catch (Exception e1) {
?? }
?? response = (HttpServletResponse) ServletActionContext.getResponse();
?? OutputStream os = null;
?? try {
??? os = response.getOutputStream();
?? } catch (IOException e) {
?? }
?? response.reset();
?? response.setHeader("Content-disposition","attachment; filename="
????+ "alarmLog.xls");
?? response.setContentType("application/msexcel");
?? LogExport ?excelExport = new LogExport();
?? inputStream = excelExport.exportAlarmLog(list,os);
?? return SUCCESS;
?}
?
//工具类
//LogExport.java
import java.io.ByteArrayInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import com.model. AlarmLog;
public class LogExport {
?//警报日志AlarmLog
?public InputStream exportAlarmLog(List<AlarmLog> alarmLog,OutputStream os) throws IOException {
??
??//SimpleDateFormat df=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
??//创建excel
??HSSFWorkbook hwb = new HSSFWorkbook();
??int k = 1;
//创建sheet页
??HSSFSheet sheet = hwb.createSheet("警报日志" + k);
??k++;
//创建标题行
??HSSFRow row1 = sheet.createRow(0);
??row1.createCell(0).setCellValue(new HSSFRichTextString("通知的用户名"));
??row1.createCell(1).setCellValue(new HSSFRichTextString("通知的用户组织"));
??row1.createCell(2).setCellValue(new HSSFRichTextString("通知的用户邮箱"));
??row1.createCell(3).setCellValue(new HSSFRichTextString("通知的用户电话"));
??row1.createCell(4).setCellValue(new HSSFRichTextString("警报通知时间"));
??row1.createCell(5).setCellValue(new HSSFRichTextString("警报内容"));
??
??int row = 0;
??for (int i = 0; i < alarmLog.size(); i++) {
???if (i > 0 && i % 10000 == 0) {
????sheet = hwb.createSheet("警报日志" + k); // 建立新的BirthSheet对象
????k++;
????row1.createCell(0).setCellValue(new HSSFRichTextString("通知的用户名"));
????row1.createCell(1).setCellValue(new HSSFRichTextString("通知的用户组织"));
????row1.createCell(2).setCellValue(new HSSFRichTextString("通知的用户邮箱"));
????row1.createCell(3).setCellValue(new HSSFRichTextString("通知的用户电话"));
????row1.createCell(4).setCellValue(new HSSFRichTextString("警报通知时间"));
????row1.createCell(5).setCellValue(new HSSFRichTextString("警报内容"));
???}
???HSSFRow row2 = sheet.createRow((row % 10000) + 1);// 创建表格的行
???row2.createCell(0).setCellValue(new HSSFRichTextString(alarmLog.get(i).getUserName()));
???row2.createCell(1).setCellValue(new HSSFRichTextString(alarmLog.get(i).getUserDepart()));
???row2.createCell(2).setCellValue(new HSSFRichTextString(alarmLog.get(i).getUserEmail()));
???row2.createCell(3).setCellValue(new HSSFRichTextString(alarmLog.get(i).getUserTelephone()));
???row2.createCell(4).setCellValue(new HSSFRichTextString(df.format(alarmLog.get(i).getAlarmTime())));
???row2.createCell(5).setCellValue(new HSSFRichTextString(alarmLog.get(i).getAlarmContent()));
???row++;
??}
??try {
???hwb.write(os);
???os.flush();
???return new ByteArrayInputStream(hwb.getBytes());
??} catch (IOException e) {
???return null;
??}
?}
?
}
?
到此就成功导出了。