数据库导出成Excel示例

package excel.bean; import java.io.FileOutputStream; import java.io.IOException; import java.io.OutputStream; import java.sql.ResultSet; import java.util.List; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFCellStyle; import org.apache.poi.hssf.usermodel.HSSFDataFormat; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; public class ExcelBean { private HSSFWorkbook wb=null; public ExcelBean(){ wb=new HSSFWorkbook(); } public void createFixationSheet(List<Question> list,FileOutputStream os){ HSSFSheet sheet=wb.createSheet("new sheet"); wb.setSheetName(0, "问题表",HSSFWorkbook.ENCODING_UTF_16); HSSFRow row=sheet.createRow((short)0); sheet.createFreezePane(0, 1); cteateCell(wb,row,(short)0,"维度号"); cteateCell(wb,row,(short)1,"问题号"); cteateCell(wb,row,(short)2,"绝对题号"); cteateCell(wb,row,(short)3,"问题题目"); cteateCell(wb,row,(short)4,"附加题目"); cteateCell(wb,row,(short)5,"重复题标记"); cteateCell(wb,row,(short)6,"问题类型"); for(int i=1;i<=list.size();i++){ HSSFRow row2=sheet.createRow((short)i); //for(int j=0;j<7;j++){ String ss=list.get(i-1).getDimensionalityNo(); cteateCell(wb,row2,(short)0,list.get(i-1).getDimensionalityNo()); System.out.println(list.get(i-1).getDimensionalityNo()); cteateCell(wb,row2,(short)1,list.get(i-1).getQuestionNo()); cteateCell(wb,row2,(short)2,list.get(i-1).getAbsoluteNo()); cteateCell(wb,row2,(short)3,list.get(i-1).getQuestionTitle()); cteateCell(wb,row2,(short)4,list.get(i-1).getExtendTitle()); cteateCell(wb,row2,(short)5,list.get(i-1).getRepeatFlag()); cteateCell(wb,row2,(short)6,list.get(i-1).getQuestionTypeNo()); //} } try { //for (int j=0;j<list.size();j++) //{ //for (int k=0;k<7;k++) //{ // wb //} //} wb.write(os); os.flush(); os.close(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } private void cteateCell(HSSFWorkbook wb,HSSFRow row,short col,String val){ HSSFCell cell=row.createCell(col); cell.setEncoding(HSSFCell.ENCODING_UTF_16); cell.setCellValue(val); HSSFCellStyle cellstyle=wb.createCellStyle(); cellstyle.setAlignment(HSSFCellStyle.ALIGN_CENTER_SELECTION); cell.setCellStyle(cellstyle); } }