excel

heavilyarmed

package item;import java.io.FileOutputStream; import java.io.IOException; import java.io.OutputStream; import java.sql.ResultSet; import java.sql.SQLException; import java.util.*; import javax.swing.JOptionPane; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFFooter; import org.apache.poi.hssf.usermodel.HSSFHeader; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; public class PoiDemo { //表头public static final String[] tableHeader = {"id","姓名","密码"}; //创建工作本public static HSSFWorkbook demoWorkBook = new HSSFWorkbook(); //创建表public static HSSFSheet demoSheet = demoWorkBook.createSheet("用户信息"); //表头的单元格个数目public static final short cellNumber = (short)tableHeader.length; //数据库表的列数public static final int columNumber = 3; /** * 34.* 创建表头 35.* *  * @return 36. */ @SuppressWarnings("deprecation")public static void createTableHeader() {HSSFHeader header = demoSheet.getHeader(); header.setCenter("用户表"); HSSFRow headerRow = demoSheet.createRow((short) 0); for(int i = 0;i < cellNumber;i++) { HSSFCell headerCell = headerRow.createCell((short) i); headerCell.setEncoding(HSSFCell.ENCODING_UTF_16); headerCell.setCellValue(tableHeader[i]); }}/** * 50.* 创建行 51.* *  * @param cells *            52.* * @param rowIndex */ @SuppressWarnings("deprecation")public static void createTableRow(List<String> cells , short rowIndex) { //创建第rowIndex行HSSFRow row = demoSheet.createRow((short) rowIndex); for(short i = 0;i < cells.size();i++) { //创建第i个单元格HSSFCell cell = row.createCell((short) i); cell.setEncoding(HSSFCell.ENCODING_UTF_16); cell.setCellValue(cells.get(i)); } } /** * 68.* 创建整个Excel表 69.* *  * @throws SQLException *             70.* 71. */ public static void createExcelSheeet() throws SQLException { createTableHeader(); ResultSet rs = SheetDataSource.selectAllDataFromDB(); int rowIndex = 1; while(rs.next()) { List<String> list = new ArrayList<String>(); for(int i = 1;i <= columNumber;i++) { list.add(rs.getString(i)); } createTableRow(list,(short)rowIndex); rowIndex++; } } /** * 89.* 导出表格 90.* *  * @param sheet *            91.* * @param os *            92.* * @throws IOException *             93. */ public void exportExcel(HSSFSheet sheet,OutputStream os) throws IOException { sheet.setGridsPrinted(true); HSSFFooter footer = sheet.getFooter(); footer.setRight("Page " + HSSFFooter.page() + " of " + HSSFFooter.numPages()); demoWorkBook.write(os); } public static void main(String[] args) { String fileName = "D:\\用户信息.xls"; FileOutputStream fos = null; try { PoiDemo pd = new PoiDemo(); PoiDemo.createExcelSheeet(); fos = new FileOutputStream(fileName); pd.exportExcel(demoSheet,fos); JOptionPane.showMessageDialog(null, "表格已成功导出到 : "+fileName); } catch (Exception e) { JOptionPane.showMessageDialog(null, "表格导出出错，错误信息 ："+e+"\n错误原因可能是表格已经打开。"); e.printStackTrace(); } finally { try { fos.close(); } catch (Exception e) { e.printStackTrace(); } } } }