POI.rar_597_BDJM_java POI

package com.z.DBUntil; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.List; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.xssf.streaming.SXSSFWorkbook; import com.z.bean.*; import com.z.dao.*; public class ExportOne { public static void main(String[] args) throws ClassNotFoundException { // TODO Auto-generated method stub FileOutputStream fos=null; try { fos = new FileOutputStream("D:\\sheet.xlsx"); } catch (FileNotFoundException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } int i = 1; Date d=new Date(); String start=new SimpleDateFormat().format(d); System.out.println("开始生成："+start); Workbook wb = new SXSSFWorkbook(); // //得到Excel工作表的对象 Sheet sheet = wb.createSheet("报表"); //得到Excel工作表的行 //表头行 Row row = sheet.createRow(0); //得到Excel工作表指定行的单元格 Cell cell0 = row.createCell(0); cell0.setCellValue("品牌"); //使单元格生效上述样式 //cell0.setCellStyle(style); Cell cell1 = row.createCell(1); cell1.setCellValue("机型"); //cell1.setCellStyle(style); Cell cell2 = row.createCell(2); cell2.setCellValue("终端类型"); Cell cell3 = row.createCell(3); cell3.setCellValue("制式"); Cell cell4 = row.createCell(4); cell4.setCellValue("省份"); Cell cell5 = row.createCell(5); cell5.setCellValue("地市"); Cell cell6 = row.createCell(6); cell6.setCellValue("终端数量"); MobileDAO dao = new MobileDAO(); List<MobileBean> list = dao.selectFenpi(); System.out.println("总数据量："+list.size()); //数据行 for(int j = 0;j < list.size();j+=100){ List<MobileBean> newlist = null; if((j+99)>=list.size()){ newlist = list.subList(j,list.size()); }else{ newlist = list.subList(j,j+100); } for(MobileBean a : newlist){ Row dataRow = sheet.createRow(i); Cell dcell0 = dataRow.createCell(0); dcell0.setCellValue(a.getA()); Cell dcell1 = dataRow.createCell(1); dcell1.setCellValue(a.getB()); Cell dcell2 = dataRow.createCell(2); dcell2.setCellValue(a.getC()); Cell dcell3 = dataRow.createCell(3); dcell3.setCellValue(a.getD()); Cell dcell4 = dataRow.createCell(4); dcell4.setCellValue(a.getE()); Cell dcell6 = dataRow.createCell(5); dcell6.setCellValue(a.getF()); Cell dcell7 = dataRow.createCell(6); dcell7.setCellValue(a.getG()); i++; } } //写文件 try { wb.write(fos); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ try { fos.close(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } Date d1=new Date(); //System.err.println(end); System.out.println("生成用时："+(d1.getTime()-d.getTime())); } }