Struts2+Hibernate+Spring的整合

package com.lab.service.imp; import java.io.*; import jxl.*; import jxl.write.*; import jxl.format.*; import jxl.format.Colour; import java.util.*; import com.lab.service.ExportService; public class ExportServiceImp implements ExportService { private WritableWorkbook WorkBuk = null;// 一个可写表格文件 private WritableSheet ws = null;// 工作簿 private FileOutputStream fos = null;// 输出流 private InputStream is = null;// 输入流 private Workbook rwb = null;// 只读表格文件 private WritableFont wfc = new jxl.write.WritableFont(WritableFont.ARIAL, 10, WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK);// 设置字体 private WritableCellFormat wcfFC = null;// 设置格式 @Override public boolean closeExcel() { boolean rtn = false; try { rwb.close(); rtn = true; } catch (Exception e) { rtn = false; } return rtn; } @Override public boolean createExcel(String FileName) throws Exception { boolean rtn = false; try { fos = new FileOutputStream(FileName); WorkBuk = Workbook.createWorkbook(fos); rtn = true; } catch (Exception e) { rtn = false; } return rtn; } @Override public String getCellContent(int col, int row) { String cellContent = ""; try { // 默认打开第一张工作薄。 Sheet rs = rwb.getSheet(0); // 取得某一单元格的内容 Cell c00 = rs.getCell(col, row); cellContent = c00.getContents(); } catch (Exception e) { cellContent = ""; } return cellContent; } @Override public Date getCellDate(int col, int row) { Date cellContent = null; try { // 默认打开第一张工作薄。 Sheet rs = rwb.getSheet(0); Cell c00 = rs.getCell(col, row); DateCell labeldate00 = (DateCell) c00; cellContent = labeldate00.getDate(); } catch (Exception e) { cellContent = null; } return cellContent; } @Override public double getCellNum(int col, int row) { double cellContent = 0; try { // 默认打开第一张工作薄。 Sheet rs = rwb.getSheet(0); Cell c10 = rs.getCell(col, row); NumberCell numc10 = (NumberCell) c10; cellContent = numc10.getValue(); } catch (Exception e) { cellContent = 0; } return cellContent; } @Override public String getCellTex(int col, int row) { String cellContent = ""; try { // 默认打开第一张工作薄。 Sheet rs = rwb.getSheet(0); Cell c00 = rs.getCell(col, row); LabelCell labelc00 = (LabelCell) c00; cellContent = labelc00.getString(); } catch (Exception e) { cellContent = ""; } return cellContent; } @Override public String getCellType(int col, int row) { String typeStr = ""; try { // 读取第一张工作表 Sheet rs = rwb.getSheet(0); // 获得第一个单元格对象 Cell c00 = rs.getCell(col, row); // 判断单元格的类型, 做出相应的转化 if (c00.getType() == CellType.LABEL) { typeStr = "String"; } if (c00.getType() == CellType.DATE) { typeStr = "Date"; } if (c00.getType() == CellType.NUMBER) { typeStr = "Number"; } } catch (Exception e) { typeStr = ""; } return typeStr; } @Override public String[] getColArray(int col) { Sheet rs = rwb.getSheet(0); Cell[] getArray = rs.getColumn(col); String Str[] = new String[getArray.length]; try { for (int i = 0; i < getArray.length; i++) { Cell c00 = rs.getCell(col, i); Str[i] = c00.getContents(); } } catch (Exception e) { Str = null; } return Str; } @Override public int getColCount(int sheetIndex) { int colCnt = 0; try { Sheet rs = rwb.getSheet(sheetIndex); colCnt = rs.getColumns(); } catch (Exception e) { colCnt = 0; } return colCnt; } @Override public String[] getRowArray(int row) { Sheet rs = rwb.getSheet(0); Cell[] getArray = rs.getRow(row); String Str[] = new String[getArray.length]; try { for (int i = 0; i < getArray.length; i++) { Cell c00 = rs.getCell(i, row); Str[i] = c00.getContents(); } } catch (Exception e) { Str = null; } return Str; } @Override public int getRowCount(int sheetIndex) { int colCnt = 0; try { Sheet rs = rwb.getSheet(sheetIndex); colCnt = rs.getRows(); } catch (Exception e) { colCnt = 0; } return colCnt; } @Override public String getSheetName(int sheetIndex) { String sheetNam = ""; try { jxl.Sheet rs = rwb.getSheet(sheetIndex); sheetNam = rs.getName(); } catch (Exception e) { sheetNam = ""; } return sheetNam; } @Override public boolean openExcel(String fileName) { boolean rtn = false; try { is = new FileInputStream(fileName); rwb = Workbook.getWorkbook(is); rtn = true; } catch (Exception e) { rtn = false; } return rtn; } @Override public String[][] readExcel() { String[][] strTemp = null; try { Sheet rs = rwb.getSheet(0); int rows = rs.getRows(); int cols = rs.getColumns(); strTemp = new String[rows][cols]; for (int i = 0; i < rows; i++) { for (int j = 0; j < cols; j++) { Cell ctemp = rs.getCell(j, i); strTemp[i][j] = ctemp.getContents(); } } } catch (Exception ex) { ex.printStackTrace(); } return strTemp; } @Override public boolean saveExcel() { boolean rtn = false; try { // 写入Exel工作表 WorkBuk.write(); // 关闭Excel工作薄对象 WorkBuk.close(); rtn = true; } catch (Exception e) { rtn = false; } return rtn; } @Override public void setCellBgcolor(String colorStr) { try { wcfFC = new jxl.write.WritableCellFormat(wfc); if (colorStr == "red") { wcfFC.setBackground(Colour.RED); } else if (colorStr == "green") { wcfFC.setBackground(Colour.GREEN); } else if (colorStr == "blue") { wcfFC.setBackground(Colour.BLUE); } else if (colorStr == "yellow") { wcfFC.setBackground(Colour.YELLOW); } else if (colorStr == "brown") { wcfFC.setBackground(Colour.BROWN); } else if (colorStr == "dark_blue") { wcfFC.setBackground(Colour.DARK_BLUE); } else { wcfFC.setBackground(Colour.BLACK); } } catch (Exception e) { } } @Override public boolean setCellDate(int col, int row, Date txt, String bgcolor) { boolean rtn = false; try { wfc = new jxl.write.WritableFont(WritableFont.ARIAL, 10, WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK); setCellBgcolor(bgcolor); DateTime labelC = new DateTime(col, row, txt, wcfFC); ws.addCell(labelC); rtn = true; } catch (Exception e) { rtn = false; } return rtn; } @Override public boolean setCellDate(int col, int row, Date Txt, int format, int fontSize) { boolean rtn = false; try { setCellFont(format, fontSize); wcfFC = new jxl.write.WritableCellFormat(wfc); jxl.write.DateTime labelC = new jxl.write.DateTime(col, row, Txt, wcfFC); ws.addCell(labelC); rtn = true; } catch (Exception e) { rtn = false; } return rtn; } @Override public boolean setCellDate(int col, int row, Date Txt) { boolean rtn = false; try { // String dd=DateUtils.getInstance().format(Txt,"yyyy-mm-dd"); // System.out.println(dd); DateTime labelC = new DateTime(col, row, Txt); ws.addCell(labelC); rtn = true; } catch (Exception e) { rtn = false; } return rtn; } @Override public void setCellFont(int format, int fontSize) { if (format == 0) { // 字体 ARIAL 颜色红 wfc = new jxl.write.WritableFont(WritableFont.ARIAL, fontSize, WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.RED); } else if (format == 1) { // 字体 ARIAL 颜色红,加粗