maven父子项目(java)+SSM（spring+springmvc+spring-mybatis）+quartz持久化到O...

package com.xxx.mps.common.util; import java.io.IOException; import java.io.OutputStream; import java.io.UnsupportedEncodingException; import java.util.ArrayList; import java.util.Date; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import org.apache.commons.lang3.StringUtils; 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.HSSFFont; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.BorderStyle; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.DateUtil; import org.apache.poi.ss.usermodel.HorizontalAlignment; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.util.CellRangeAddress; public class ExcelUtil { //excel默认宽度； 自动调整列宽 private static int width = -1; //默认字体 private static String excelfont = "微软雅黑"; /** * * 获取单元格里的数字，正常返回数字，有错返回 E * * @param cell * @return */ public static String getCellFormatValue(Cell cell) { String cellvalue = ""; if (cell != null) { // 判断当前Cell的Type switch (cell.getCellType()) { case Cell.CELL_TYPE_NUMERIC:// 如果当前Cell的Type为NUMERIC case Cell.CELL_TYPE_FORMULA: { // 判断当前的cell是否为Date if (DateUtil.isCellDateFormatted(cell)) { cellvalue = xxxConstant.ERROR; } else {// 如果是纯数字 // 取得当前Cell的数值 cellvalue = String.valueOf(cell.getNumericCellValue()); } break; } case Cell.CELL_TYPE_STRING:// 如果当前Cell的Type为STRING // 取得当前的Cell字符串 cellvalue = cell.getRichStringCellValue().getString(); break; default:// 默认的Cell值 cellvalue = xxxConstant.ERROR; } } else { cellvalue = ""; } return cellvalue; } /** * * 获取每一行第一列的值 * * @param cell * @return */ public static String getRowFistCellValue(Row row) { if(row==null){ return ""; } // 单元格 Cell cell = row.getCell(0); return getCellFormatValue(cell); } /** * * @param excelName 导出的EXCEL名字 * @param sheetName 导出的SHEET名字 当前sheet数目只为1 * @param headers 导出的表格的表头 * @param ds_titles 导出的数据 map.get(key) 对应的 key * @param ds_format 导出数据的样式 * 1:String left; * 2:String center * 3:String right * 4 int right * 5:float ###,###.## right * 6:number: #.00% 百分比 right * 101:date: yyyy-MM-dd left * @param widths 表格的列宽度 默认为 256*14 * @param data 数据集 List<Map> * @param response * @throws IOException */ public static void export(String excelName, String sheetName,String[] headers,String[] ds_titles,int[] ds_format,int[] widths, List<Map<String,Object>> data ,HttpServletRequest request, HttpServletResponse response) throws IOException { HttpSession session = request.getSession(); session.setAttribute("state", null); //设置文件名 String fileName = ""; if(StringUtils.isNotEmpty(excelName)){ fileName = excelName; } //创建一个工作薄 HSSFWorkbook wb = new HSSFWorkbook(); //创建sheet createSheet(wb,sheetName, headers, ds_titles,ds_format, widths, data,null); fileName=fileName+".xls"; String filename = ""; try{ filename =encodeChineseDownloadFileName(request,fileName); }catch(Exception e){ e.printStackTrace(); } // final String userAgent = request.getHeader("USER-AGENT"); // if(userAgent.indexOf( "MSIE")!=-1){//IE浏览器 // filename = URLEncoder.encode(fileName,"UTF8"); // }else if(userAgent.indexOf( "Mozilla")!=-1){//google,火狐浏览器 // filename = new String(fileName.getBytes(), "ISO8859-1"); // }else{ // filename = URLEncoder.encode(fileName,"UTF8");//其他浏览器 // } response.setHeader("Content-disposition", filename); response.setContentType("application/vnd.ms-excel"); response.setHeader("Content-disposition", "attachment;filename="+filename); response.setHeader("Pragma", "No-cache"); OutputStream ouputStream = response.getOutputStream(); wb.write(ouputStream); ouputStream.flush(); ouputStream.close(); session.setAttribute("state", "open"); } /** * * 导出Excel 多个sheet * @param excelName 导出的EXCEL名字 * @param sheetMapList sheet集合 ，里面包含 * * @param headers 导出的表格的表头 * @param ds_titles 导出的数据 map.get(key) 对应的 key * @param ds_format 导出数据的样式 * 1:String left; * 2:String center * 3:String right * 4 int right * 5:float ###,###.## right * 6:number: #.00% 百分比 right * 101:date: yyyy-MM-dd left * @param widths 表格的列宽度 默认为 256*14 * @param data 数据集 List<Map> * @param response * @throws IOException */ public static void exportMultiSheet(String excelName,List<Map> sheetMapList,HttpServletRequest request,HttpServletResponse response) throws IOException { HttpSession session = request.getSession(); session.setAttribute("state", null); //设置文件名 String fileName = ""; if(StringUtils.isNotEmpty(excelName)){ fileName = excelName; } //创建一个工作薄 HSSFWorkbook wb = new HSSFWorkbook(); //循环创建SHEET for(Map sheetMap:sheetMapList){ String sheetName= (String) sheetMap.get("sheetName"); String[] headers=(String[]) sheetMap.get("headers"); String[] ds_titles=(String[]) sheetMap.get("ds_titles"); int[] ds_format=(int[]) sheetMap.get("ds_format"); int[] widths=(int[]) sheetMap.get("widths"); List<int[]> regions=(List<int[]>) sheetMap.get("regions"); List<Map<String,Object>> data=(List<Map<String, Object>>) sheetMap.get("da