笔记：poi学习之实现合同打印

xiaoxiao2026-05-05 3

思路：页面获取id,通过id查询数据库得到数据，把数据加到excel模板中。

效果：

操作：

第一步：在根路径创建make/xlsprint/目录，把空的excel文件（tCONTRACT.xls）放进去。相当创建好了一个模板。

第二步：导入依赖

<dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.9</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>3.9</version> </dependency> <dependency> <groupId>jfree</groupId> <artifactId>jfreechart</artifactId> <version>1.0.13</version> </dependency>第三步：jsp页面安放打印按钮

<a href="print.html?id=${contract.id}" >打印</a>第四步：controller

/* *打印 * */ @RequestMapping(value = "print", method = RequestMethod.GET) public void print(@RequestParam("id") String id, HttpServletRequest request, HttpServletResponse response){ //实例化ContractPrint类（相当于一个工具类） ContractPrint cp = new ContractPrint(); //查询数据 Contract contract = contractService.view(id); //路径 String path = request.getSession().getServletContext().getRealPath("/"); //调用ContractPrint的print方法 cp.print(contract, path, response); }第五步：写ContractPrint类和PoiUtil类（具体业务逻辑都在里面）

ContractPrint：

package cn.itcast.jk.print; import java.io.ByteArrayOutputStream; import java.io.FileInputStream; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletResponse; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFCellStyle; import org.apache.poi.hssf.usermodel.HSSFFont; import org.apache.poi.hssf.usermodel.HSSFPatriarch; 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.hssf.util.CellRangeAddress; import cn.itcast.jk.vo.ContractProduct; import cn.itcast.util.DownloadUtil; import cn.itcast.util.UtilFuns; import cn.itcast.util.file.PoiUtil; public class ContractPrint{ /** *打印业务逻辑 **/ public void print(cn.itcast.jk.vo.Contract contract,String path, HttpServletResponse response) throws Exception{ //相同厂家的信息一起打印 List<ContractProduct> oList = contract.getContractProducts(); UtilFuns utilFuns = new UtilFuns(); String tempXlsFile = path + "make/xlsprint/tCONTRACT.xls"; //获取模板文件 //填写每页的内容，之后在循环每页读取打印 Map<String,String> pageMap = null; List<Map> pageList = new ArrayList(); //打印页 ContractProduct oProduct = null; String stars = ""; for(int j=0;j<contract.getImportNum();j++){ //重要程度 stars += "★"; } String oldFactory = ""; for(int i=0;i<oList.size();i++){ oProduct = oList.get(i); //获得货物 pageMap = new HashMap(); //每页的内容 pageMap.put("Offeror", "收购方：" + contract.getOfferor()); pageMap.put("Factory", "生产工厂：" + oProduct.getFactory().getFactoryName()); pageMap.put("ContractNo", "合同号：" + contract.getContractNo()); pageMap.put("Contractor", "联系人：" + oProduct.getFactory().getContractor()); pageMap.put("SigningDate", "签单日期："+UtilFuns.formatDateTimeCN(UtilFuns.dateTimeFormat(contract.getSigningDate()))); pageMap.put("Phone", "电话：" + oProduct.getFactory().getPhone()); pageMap.put("InputBy", "制单：" + contract.getInputBy()); pageMap.put("CheckBy", "审单："+ utilFuns.fixSpaceStr(contract.getCheckBy(),26)+"验货员："+utilFuns.convertNull(contract.getInspector())); pageMap.put("Remark", " "+contract.getRemark()); pageMap.put("Request", " "+contract.getCrequest()); pageMap.put("ProductImage", oProduct.getProductImage()); pageMap.put("ProductDesc", oProduct.getProductDesc()); pageMap.put("Cnumber", String.valueOf(oProduct.getCnumber().doubleValue())); if(oProduct.getPackingUnit().equals("PCS")){ pageMap.put("PackingUnit", "只"); }else if(oProduct.getPackingUnit().equals("SETS")){ pageMap.put("PackingUnit", "套"); } pageMap.put("Price", String.valueOf(oProduct.getPrice().doubleValue())); pageMap.put("ProductNo", oProduct.getProductNo()); oldFactory = oProduct.getFactory().getFactoryName(); if(contract.getPrintStyle().equals("2")){ i++; //读取第二个货物信息 if(i<oList.size()){ oProduct = oList.get(i); if(oProduct.getFactory().getFactoryName().equals(oldFactory)){ //厂家不同另起新页打印，除去第一次的比较 pageMap.put("ProductImage2", oProduct.getProductImage()); pageMap.put("ProductDesc2", oProduct.getProductDesc()); pageMap.put("Cnumber2", String.valueOf(oProduct.getCnumber().doubleValue())); if(oProduct.getPackingUnit().equals("PCS")){ pageMap.put("PackingUnit2", "只"); }else if(oProduct.getPackingUnit().equals("SETS")){ pageMap.put("PackingUnit2", "套"); } pageMap.put("Price2", String.valueOf(oProduct.getPrice().doubleValue())); //pageMap.put("Amount2", String.valueOf(oProduct.getAmount().doubleValue())); //在excel中金额采用公式，所以无需准备数据 pageMap.put("ProductNo2", oProduct.getProductNo()); }else{ i--; //tip:list退回 } }else{ pageMap.put("ProductNo2", null); //后面依据此判断是否有第二个货物 } } pageMap.put("ContractDesc", stars+" 货物描述"); //重要程度 + 货物描述 pageList.add(pageMap); } int cellHeight = 96; //一个货物的高度用户需求，一个货物按192高度打印，后来又嫌难看，打印高度和2款高度一样。 // if(contract.getPrintStyle().equals("2")){ // cellHeight = 96; //两个货物的高度 // } PoiUtil poiUtil = new PoiUtil(); HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(tempXlsFile)); //打开excel文件 HSSFFont defaultFont10 = poiUtil.defaultFont10(wb); //设置字体 HSSFFont defaultFont12 = poiUtil.defaultFont12(wb); //设置字体 HSSFFont blackFont = poiUtil.blackFont12(wb); //设置字体 Short rmb2Format = poiUtil.rmb2Format(wb); //设置格式 Short rmb4Format = poiUtil.rmb4Format(wb); //设置格式 HSSFSheet sheet = wb.getSheetAt(0); //选择第一个工作簿 wb.setSheetName(0, "购销合同"); //设置工作簿的名称 //sheet.setDefaultColumnWidth((short) 20); // 设置每列默认宽度 // POI分页符有BUG，必须在模板文件中插入一个分页符，然后再此处删除预设的分页符；最后在下面重新设置分页符。 // sheet.setAutobreaks(false); // int iRowBreaks[] = sheet.getRowBreaks(); // sheet.removeRowBreak(3); // sheet.removeRowBreak(4); // sheet.removeRowBreak(5); // sheet.removeRowBreak(6); CellRangeAddress region = null; HSSFPatriarch patriarch = sheet.createDrawingPatriarch(); //add picture HSSFRow nRow = null; HSSFCell nCell = null; int curRow = 0; //打印每页 Map<String,String> printMap = null; for(int p=0;p<pageList.size();p++){ printMap = pageList.get(p); if(p>0){ sheet.setRowBreak(curRow++); //在第startRow行设置分页符 } //设置logo图片 poiUtil.setPicture(wb, patriarch, path+"make/xlsprint/logo.jpg", curRow, 2, curRow+4, 2); //header nRow = sheet.createRow(curRow++); nRow.setHeightInPoints(21); nCell = nRow.createCell((3)); nCell.setCellValue("SHAANXI"); nCell.setCellStyle(headStyle(wb)); //header nRow = sheet.createRow(curRow++); nRow.setHeightInPoints(41); nCell = nRow.createCell((3)); nCell.setCellValue(" JK INTERNATIONAL "); nCell.setCellStyle(tipStyle(wb)); curRow++; //header nRow = sheet.createRow(curRow++); nRow.setHeightInPoints(20); nCell = nRow.createCell((1)); nCell.setCellValue(" 西经济技术开发区西城一路27号无迪大厦19楼"); nCell.setCellStyle(addressStyle(wb)); //header nCell = nRow.createCell((6)); nCell.setCellValue(" CO., LTD."); nCell.setCellStyle(ltdStyle(wb)); //header nRow = sheet.createRow(curRow++); nRow.setHeightInPoints(15); nCell = nRow.createCell((1)); nCell.setCellValue(" TEL: 0086-29-86339371 FAX: 0086-29-86303310 E-MAIL: ijackix@glass.cn"); nCell.setCellStyle(telStyle(wb)); //line nRow = sheet.createRow(curRow++); nRow.setHeightInPoints(7); poiUtil.setLine(wb, patriarch, curRow, 2, curRow, 8); //draw line //header nRow = sheet.createRow(curRow++); nRow.setHeightInPoints(30); nCell = nRow.createCell((4)); nCell.setCellValue(" 购销合同"); nCell.setCellStyle(titleStyle(wb)); //Offeror nRow = sheet.createRow(curRow++); nRow.setHeightInPoints(20); nCell = nRow.createCell((1)); nCell.setCellValue(printMap.get("Offeror")); nCell.setCellStyle(poiUtil.titlev12(wb, blackFont)); //Facotry nCell = nRow.createCell((5)); nCell.setCellValue(printMap.get("Factory")); nCell.setCellStyle(poiUtil.titlev12(wb, blackFont)); //ContractNo nRow = sheet.createRow(curRow++); nRow.setHeightInPoints(20); nCell = nRow.createCell(1); nCell.setCellValue(printMap.get("ContractNo")); nCell.setCellStyle(poiUtil.titlev12(wb, blackFont)); //Contractor nCell = nRow.createCell(5); nCell.setCellValue(printMap.get("Contractor")); nCell.setCellStyle(poiUtil.titlev12(wb, blackFont)); //SigningDate nRow = sheet.createRow(curRow++); nRow.setHeightInPoints(20); nCell = nRow.createCell(1); nCell.setCellValue(printMap.get("SigningDate")); nCell.setCellStyle(poiUtil.titlev12(wb, blackFont)); //Phone nCell = nRow.createCell(5); nCell.setCellValue(printMap.get("Phone")); nCell.setCellStyle(poiUtil.titlev12(wb, blackFont)); //画单元格的框,否则下面合并后底部无边线 int endk = 0; if(contract.getPrintStyle().equals("1") || UtilFuns.isEmpty(printMap.get("ProductNo2"))){ //一个货物 endk = 2; }else if(contract.getPrintStyle().equals("2")){ endk = 4; } for(int k=-1;k<endk;k++){ nRow = sheet.createRow(curRow+1+k); for(int j=1;j<9;j++){ region = new CellRangeAddress(curRow+1, curRow+1, 1, 3); //横向合并单元格 sheet.addMergedRegion(region); nCell = nRow.createCell(j); nCell.setCellValue("q23"); nCell.setCellStyle(poiUtil.notehv10_BorderThin(wb, defaultFont10)); } } //importNum nRow = sheet.createRow(curRow++); nRow.setHeightInPoints(24); region = new CellRangeAddress(curRow-1, curRow-1, 1, 3); //纵向合并单元格 sheet.addMergedRegion(region); nCell = nRow.createCell(1); nCell.setCellValue("产品"); nCell.setCellStyle(thStyle(wb)); nCell = nRow.createCell(2); nCell.setCellStyle(poiUtil.notehv10_BorderThin(wb, defaultFont10)); nCell = nRow.createCell(3); nCell.setCellStyle(poiUtil.notehv10_BorderThin(wb, defaultFont10)); nCell = nRow.createCell(4); nCell.setCellValue(printMap.get("ContractDesc")); nCell.setCellStyle(thStyle(wb)); region = new CellRangeAddress(curRow-1, curRow-1, 5, 6); //纵向合并单元格 sheet.addMergedRegion(region); nCell = nRow.createCell(5); nCell.setCellValue("数量"); nCell.setCellStyle(thStyle(wb)); nCell = nRow.createCell(6); nCell.setCellStyle(poiUtil.notehv10_BorderThin(wb, defaultFont10)); nCell = nRow.createCell(7); nCell.setCellValue("单价"); nCell.setCellStyle(thStyle(wb)); nCell = nRow.createCell(8); nCell.setCellValue("总金额"); nCell.setCellStyle(thStyle(wb)); nRow = sheet.createRow(curRow++); nRow.setHeightInPoints(96); region = new CellRangeAddress(curRow-1, curRow-1, 1, 3); //纵向合并单元格 sheet.addMergedRegion(region); //插入产品图片 if(UtilFuns.isNotEmpty(printMap.get("ProductImage"))){ System.out.println(printMap.get("ProductImage")); poiUtil.setPicture(wb, patriarch, path+"ufiles/jquery/"+printMap.get("ProductImage"), curRow-1, 1, curRow, 3); } nCell = nRow.createCell(2); nCell.setCellStyle(poiUtil.notehv10_BorderThin(wb, defaultFont10)); nCell = nRow.createCell(3); nCell.setCellStyle(poiUtil.notehv10_BorderThin(wb, defaultFont10)); //ProductDesc region = new CellRangeAddress(curRow-1, curRow, 4, 4); //纵向合并单元格 sheet.addMergedRegion(region); nCell = nRow.createCell(4); nCell.setCellValue(printMap.get("ProductDesc")); nCell.setCellStyle(poiUtil.notehv10_BorderThin(wb, defaultFont10)); //Cnumber region = new CellRangeAddress(curRow-1, curRow, 5, 5); //纵向合并单元格 sheet.addMergedRegion(region); nCell = nRow.createCell(5); nCell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); nCell.setCellValue(Double.parseDouble(printMap.get("Cnumber"))); nCell.setCellStyle(poiUtil.numberrv10_BorderThin(wb, defaultFont10)); //Unit region = new CellRangeAddress(curRow-1, curRow, 6, 6); //纵向合并单元格 sheet.addMergedRegion(region); nCell = nRow.createCell(6); nCell.setCellValue(printMap.get("PackingUnit")); nCell.setCellStyle(poiUtil.moneyrv10_BorderThin(wb, defaultFont10, rmb4Format)); //Price region = new CellRangeAddress(curRow-1, curRow, 7, 7); //纵向合并单元格 sheet.addMergedRegion(region); nCell = nRow.createCell(7); nCell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); nCell.setCellValue(Double.parseDouble(printMap.get("Price"))); nCell.setCellStyle(poiUtil.moneyrv10_BorderThin(wb, defaultFont10, rmb4Format)); //Amount region = new CellRangeAddress(curRow-1, curRow, 8, 8); //纵向合并单元格 sheet.addMergedRegion(region); nCell = nRow.createCell(8); if(UtilFuns.isNotEmpty(printMap.get("Cnumber")) && UtilFuns.isNotEmpty(printMap.get("Price"))){ nCell.setCellType(HSSFCell.CELL_TYPE_FORMULA); nCell.setCellFormula("F"+String.valueOf(curRow)+"*H"+String.valueOf(curRow)); } nCell.setCellStyle(poiUtil.moneyrv10_BorderThin(wb, defaultFont10, rmb4Format)); curRow++; region = new CellRangeAddress(curRow-1, curRow-1, 1, 3); //纵向合并单元格 sheet.addMergedRegion(region); //ProductNo nRow = sheet.createRow(curRow-1); nRow.setHeightInPoints(24); nCell = nRow.createCell(1); nCell.setCellValue(printMap.get("ProductNo")); nCell.setCellStyle(poiUtil.notecv10_BorderThin(wb, defaultFont10)); for(int j=2;j<9;j++){ nCell = nRow.createCell(j); nCell.setCellStyle(poiUtil.notehv10_BorderThin(wb, defaultFont10)); } if(contract.getPrintStyle().equals("2") && UtilFuns.isNotEmpty(printMap.get("ProductNo2"))){ nRow = sheet.createRow(curRow++); nRow.setHeightInPoints(96); region = new CellRangeAddress(curRow-1, curRow-1, 1, 3); //纵向合并单元格 sheet.addMergedRegion(region); //插入产品图片 if(UtilFuns.isNotEmpty(printMap.get("ProductImage2"))){ System.out.println(printMap.get("ProductImage2")); poiUtil.setPicture(wb, patriarch, path+"ufiles/jquery/"+printMap.get("ProductImage2"), curRow-1, 1, curRow, 3); } //ProductDesc region = new CellRangeAddress(curRow-1, curRow, 4, 4); //纵向合并单元格 sheet.addMergedRegion(region); nCell = nRow.createCell(4); nCell.setCellValue(printMap.get("ProductDesc2")); nCell.setCellStyle(poiUtil.notehv10_BorderThin(wb, defaultFont10)); //Cnumber region = new CellRangeAddress(curRow-1, curRow, 5, 5); //纵向合并单元格 sheet.addMergedRegion(region); nCell = nRow.createCell(5); nCell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); nCell.setCellValue(Double.parseDouble(printMap.get("Cnumber2"))); nCell.setCellStyle(poiUtil.numberrv10_BorderThin(wb, defaultFont10)); //Unit region = new CellRangeAddress(curRow-1, curRow, 6, 6); //纵向合并单元格 sheet.addMergedRegion(region); nCell = nRow.createCell(6); nCell.setCellValue(printMap.get("PackingUnit2")); nCell.setCellStyle(poiUtil.moneyrv10_BorderThin(wb, defaultFont10, rmb4Format)); //Price region = new CellRangeAddress(curRow-1, curRow, 7, 7); //纵向合并单元格 sheet.addMergedRegion(region); nCell = nRow.createCell(7); nCell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); nCell.setCellValue(Double.parseDouble(printMap.get("Price2"))); nCell.setCellStyle(poiUtil.moneyrv10_BorderThin(wb, defaultFont10, rmb4Format)); //Amount region = new CellRangeAddress(curRow-1, curRow, 8, 8); //纵向合并单元格 sheet.addMergedRegion(region); nCell = nRow.createCell(8); if(UtilFuns.isNotEmpty(printMap.get("Cnumber2")) && UtilFuns.isNotEmpty(printMap.get("Price2"))){ nCell.setCellType(HSSFCell.CELL_TYPE_FORMULA); nCell.setCellFormula("F"+String.valueOf(curRow)+"*H"+String.valueOf(curRow)); } nCell.setCellStyle(poiUtil.moneyrv10_BorderThin(wb, defaultFont10, rmb4Format)); curRow++; region = new CellRangeAddress(curRow-1, curRow-1, 1, 3); //纵向合并单元格 sheet.addMergedRegion(region); nRow = sheet.createRow(curRow-1); nRow.setHeightInPoints(24); nCell = nRow.createCell(1); nCell.setCellValue(printMap.get("ProductNo2")); nCell.setCellStyle(poiUtil.notecv10_BorderThin(wb, defaultFont10)); //合并单元格画线 for(int j=2;j<9;j++){ nCell = nRow.createCell(j); nCell.setCellStyle(poiUtil.notehv10_BorderThin(wb, defaultFont10)); } } //InputBy nRow = sheet.createRow(curRow++); nRow.setHeightInPoints(24); nCell = nRow.createCell(1); nCell.setCellValue(printMap.get("InputBy")); nCell.setCellStyle(poiUtil.bnormalv12(wb,defaultFont12)); //CheckBy+inspector nCell = nRow.createCell(4); nCell.setCellValue(printMap.get("CheckBy")); nCell.setCellStyle(poiUtil.bnormalv12(wb,defaultFont12)); //if(contract.getPrintStyle().equals("2") && UtilFuns.isNotEmpty(printMap.get("ProductNo2"))){ nCell = nRow.createCell(7); nCell.setCellValue("总金额："); nCell.setCellStyle(bcv12(wb)); //TotalAmount nRow = sheet.createRow(curRow-1); nRow.setHeightInPoints(24); if(UtilFuns.isNotEmpty(printMap.get("Cnumber"))&&UtilFuns.isNotEmpty(printMap.get("Price"))){ nCell = nRow.createCell(8); nCell.setCellType(HSSFCell.CELL_TYPE_FORMULA); nCell.setCellFormula("SUM(I"+String.valueOf(curRow-4)+":I"+String.valueOf(curRow-1)+")"); nCell.setCellStyle(poiUtil.moneyrv12_BorderThin(wb,defaultFont12,rmb2Format)); } //} //note nRow = sheet.createRow(curRow++); nRow.setHeightInPoints(21); nCell = nRow.createCell(2); nCell.setCellValue(printMap.get("Remark")); nCell.setCellStyle(noteStyle(wb)); //Request region = new CellRangeAddress(curRow, curRow, 1, 8); //指定合并区域 sheet.addMergedRegion(region); nRow = sheet.createRow(curRow++); float height = poiUtil.getCellAutoHeight(printMap.get("Request"), 12f); //自动高度 nRow.setHeightInPoints(height); nCell = nRow.createCell(1); nCell.setCellValue(printMap.get("Request")); nCell.setCellStyle(requestStyle(wb)); //space line nRow = sheet.createRow(curRow++); nRow.setHeightInPoints(20); //duty nRow = sheet.createRow(curRow++); nRow.setHeightInPoints(32); nCell = nRow.createCell(1); nCell.setCellValue("未按以上要求出货而导致客人索赔，由供方承担。"); nCell.setCellStyle(dutyStyle(wb)); //space line nRow = sheet.createRow(curRow++); nRow.setHeightInPoints(32); //buyer nRow = sheet.createRow(curRow++); nRow.setHeightInPoints(25); nCell = nRow.createCell(1); nCell.setCellValue(" 收购方负责人："); nCell.setCellStyle(dutyStyle(wb)); //seller nCell = nRow.createCell(5); nCell.setCellValue("供方负责人："); nCell.setCellStyle(dutyStyle(wb)); curRow++; } ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream(); //生成流对象 wb.write(byteArrayOutputStream); //将excel写入流 //工具类，封装弹出下载框： String outFile = "购销合同.xls"; DownloadUtil down = new DownloadUtil(); down.download(byteArrayOutputStream, response, outFile); } //-----------------------下面都是一些具体的样式设置----------------------- private HSSFCellStyle leftStyle(HSSFWorkbook wb){ HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setWrapText(true); //换行 HSSFFont curFont = wb.createFont(); //设置字体 curFont.setCharSet(HSSFFont.DEFAULT_CHARSET); //设置中文字体，那必须还要再对单元格进行编码设置 //fTitle.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); //加粗 curFont.setFontHeightInPoints((short)10); curStyle.setFont(curFont); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); //单元格垂直居中 curStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); //实线右边框 curStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); //实线右边框 return curStyle; } private HSSFCellStyle headStyle(HSSFWorkbook wb){ HSSFCellStyle curStyle = wb.createCellStyle(); HSSFFont curFont = wb.createFont(); //设置字体 curFont.setFontName("Comic Sans MS"); curFont.setCharSet(HSSFFont.DEFAULT_CHARSET); //设置中文字体，那必须还要再对单元格进行编码设置 curFont.setItalic(true); curFont.setFontHeightInPoints((short)16); curStyle.setFont(curFont); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); //单元格垂直居中 return curStyle; } private HSSFCellStyle tipStyle(HSSFWorkbook wb){ HSSFCellStyle curStyle = wb.createCellStyle(); HSSFFont curFont = wb.createFont(); //设置字体 curFont.setFontName("Georgia"); curFont.setCharSet(HSSFFont.DEFAULT_CHARSET); //设置中文字体，那必须还要再对单元格进行编码设置 curFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); //加粗 curFont.setFontHeightInPoints((short)28); curStyle.setFont(curFont); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); //单元格垂直居中 return curStyle; } private HSSFCellStyle addressStyle(HSSFWorkbook wb){ HSSFCellStyle curStyle = wb.createCellStyle(); HSSFFont curFont = wb.createFont(); //设置字体 curFont.setFontName("宋体"); curFont.setCharSet(HSSFFont.DEFAULT_CHARSET); //设置中文字体，那必须还要再对单元格进行编码设置 //fTitle.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); //加粗 curFont.setFontHeightInPoints((short)10); curStyle.setFont(curFont); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); //单元格垂直居中 return curStyle; } private HSSFCellStyle ltdStyle(HSSFWorkbook wb){ HSSFCellStyle curStyle = wb.createCellStyle(); HSSFFont curFont = wb.createFont(); //设置字体 curFont.setFontName("Times New Roman"); curFont.setCharSet(HSSFFont.DEFAULT_CHARSET); //设置中文字体，那必须还要再对单元格进行编码设置 curFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); //加粗 curFont.setItalic(true); curFont.setFontHeightInPoints((short)16); curStyle.setFont(curFont); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); //单元格垂直居中 return curStyle; } private HSSFCellStyle telStyle(HSSFWorkbook wb){ HSSFCellStyle curStyle = wb.createCellStyle(); HSSFFont curFont = wb.createFont(); //设置字体 curFont.setFontName("宋体"); curFont.setCharSet(HSSFFont.DEFAULT_CHARSET); //设置中文字体，那必须还要再对单元格进行编码设置 //fTitle.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); //加粗 curFont.setFontHeightInPoints((short)9); curStyle.setFont(curFont); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); //单元格垂直居中 return curStyle; } private HSSFCellStyle titleStyle(HSSFWorkbook wb){ HSSFCellStyle curStyle = wb.createCellStyle(); HSSFFont curFont = wb.createFont(); //设置字体 curFont.setFontName("黑体"); curFont.setCharSet(HSSFFont.DEFAULT_CHARSET); //设置中文字体，那必须还要再对单元格进行编码设置 curFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); //加粗 curFont.setFontHeightInPoints((short)18); curStyle.setFont(curFont); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); //单元格垂直居中 return curStyle; } private HSSFCellStyle requestStyle(HSSFWorkbook wb){ HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setWrapText(true); //换行 HSSFFont curFont = wb.createFont(); //设置字体 curFont.setFontName("宋体"); curFont.setCharSet(HSSFFont.DEFAULT_CHARSET); //设置中文字体，那必须还要再对单元格进行编码设置 curFont.setFontHeightInPoints((short)10); curStyle.setFont(curFont); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); //单元格垂直居中 return curStyle; } private HSSFCellStyle dutyStyle(HSSFWorkbook wb){ HSSFCellStyle curStyle = wb.createCellStyle(); HSSFFont curFont = wb.createFont(); //设置字体 curFont.setFontName("黑体"); curFont.setCharSet(HSSFFont.DEFAULT_CHARSET); //设置中文字体，那必须还要再对单元格进行编码设置 curFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); //加粗 curFont.setFontHeightInPoints((short)16); curStyle.setFont(curFont); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); //单元格垂直居中 return curStyle; } private HSSFCellStyle noteStyle(HSSFWorkbook wb){ HSSFCellStyle curStyle = wb.createCellStyle(); HSSFFont curFont = wb.createFont(); //设置字体 curFont.setFontName("宋体"); curFont.setCharSet(HSSFFont.DEFAULT_CHARSET); //设置中文字体，那必须还要再对单元格进行编码设置 curFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); //加粗 curFont.setFontHeightInPoints((short)12); curStyle.setFont(curFont); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); //单元格垂直居中 return curStyle; } public HSSFCellStyle thStyle(HSSFWorkbook wb){ HSSFCellStyle curStyle = wb.createCellStyle(); HSSFFont curFont = wb.createFont(); //设置字体 curFont.setFontName("宋体"); curFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); //加粗 curFont.setFontHeightInPoints((short)12); curFont.setCharSet(HSSFFont.DEFAULT_CHARSET); //设置中文字体，那必须还要再对单元格进行编码设置 curStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); //实线右边框 curStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); //实线右边框 curStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); //实线右边框 curStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); //实线右边框 curStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); //单元格垂直居中 return curStyle; } public HSSFCellStyle bcv12(HSSFWorkbook wb){ HSSFCellStyle curStyle = wb.createCellStyle(); HSSFFont curFont = wb.createFont(); //设置字体 curFont.setFontName("Times New Roman"); curFont.setCharSet(HSSFFont.DEFAULT_CHARSET); //设置中文字体，那必须还要再对单元格进行编码设置 curFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); //加粗 curFont.setFontHeightInPoints((short)12); curStyle.setFont(curFont); curStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); //实线 curStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); //粗实线 curStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); //实线 curStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); //实线 curStyle.setAlignment(HSSFCellStyle.ALIGN_RIGHT); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); //单元格垂直居中 return curStyle; } } PoiUtil：

package cn.itcast.util.file; import java.awt.image.BufferedImage; import java.io.*; import java.util.regex.Pattern; import org.apache.poi.hssf.usermodel.*; import org.apache.poi.hssf.util.HSSFColor; import javax.imageio.ImageIO; public class PoiUtil { private static final String ENFONT = "Times New Roman"; //设置10号字体 public HSSFFont defaultFont10(HSSFWorkbook wb) { HSSFFont curFont = wb.createFont(); // 设置字体 curFont.setFontName(this.ENFONT); curFont.setCharSet(HSSFFont.DEFAULT_CHARSET); // 设置中文字体，那必须还要再对单元格进行编码设置 curFont.setFontHeightInPoints((short) 10); return curFont; } //设置10号加粗字体 public HSSFFont defaultFont10Blod(HSSFWorkbook wb) { HSSFFont curFont = wb.createFont(); // 设置字体 curFont.setFontName(this.ENFONT); curFont.setCharSet(HSSFFont.DEFAULT_CHARSET); // 设置中文字体，那必须还要再对单元格进行编码设置 curFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); // 加粗 curFont.setFontHeightInPoints((short) 10); return curFont; } //设置12号字体 public HSSFFont defaultFont12(HSSFWorkbook wb) { HSSFFont curFont = wb.createFont(); // 设置字体 curFont.setFontName(this.ENFONT); curFont.setCharSet(HSSFFont.DEFAULT_CHARSET); // 设置中文字体，那必须还要再对单元格进行编码设置 curFont.setFontHeightInPoints((short) 12); return curFont; } //设置12号黑体字体 public HSSFFont blackFont12(HSSFWorkbook wb) { HSSFFont theFont = wb.createFont(); // 设置字体 theFont.setFontName("黑体"); theFont.setCharSet(HSSFFont.DEFAULT_CHARSET); // 设置中文字体，那必须还要再对单元格进行编码设置 theFont.setFontHeightInPoints((short) 12); return theFont; } //设置16号宋体字体 public HSSFFont songBoldFont16(HSSFWorkbook wb) { HSSFFont curFont = wb.createFont(); // 设置字体 curFont.setFontName("宋体"); curFont.setCharSet(HSSFFont.DEFAULT_CHARSET); // 设置中文字体，那必须还要再对单元格进行编码设置 curFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); // 加粗 curFont.setFontHeightInPoints((short) 16); return curFont; } //设置价格格式#,###,###.0 public short money1Format(HSSFWorkbook wb) { HSSFDataFormat format = wb.createDataFormat(); return format.getFormat("#,###,###.0"); // 设置格式 } //设置价格格式#,###,###.00 public short money2Format(HSSFWorkbook wb) { HSSFDataFormat format = wb.createDataFormat(); return format.getFormat("#,###,###.00"); // 设置格式 } //设置人民币价格格式 public short rmb2Format(HSSFWorkbook wb) { HSSFDataFormat format = wb.createDataFormat(); return format.getFormat("\"￥\"#,###,###.00"); // 设置格式 } //设置人民币价格格式 public short rmb4Format(HSSFWorkbook wb) { HSSFDataFormat format = wb.createDataFormat(); return format.getFormat("\"￥\"#,###,##0.00"); // 设置格式 } //设置日期格式 public short datevENFormat(HSSFWorkbook wb) { HSSFDataFormat format = wb.createDataFormat(); return format.getBuiltinFormat("m/d/yy"); // 设置格式 } //设置图片指定图片类型为jpg public void setPicture(HSSFWorkbook wb, HSSFPatriarch patriarch, String pic, int iRow, int iCol) throws IOException { // 判断文件是否存在 File imgFile = new File(pic); if (imgFile.exists()) { // 图片处理 ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream(); BufferedImage bufferImg = ImageIO.read(new File(pic)); ImageIO.write(bufferImg, "jpg", byteArrayOut); HSSFClientAnchor anchor = new HSSFClientAnchor(190, 0, 1000, 0, (short) (iCol), iRow - 1, (short) (iCol + 1), iRow); patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG)); } } //设置图片指定图片类型为jpg public void setPicture(HSSFWorkbook wb, HSSFPatriarch patriarch, String pic, int iRowStart, int iColStart, int iRowStop, int iColStop) throws IOException { // 判断文件是否存在 File imgFile = new File(pic); if (imgFile.exists()) { // 图片处理 ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream(); BufferedImage bufferImg = ImageIO.read(new File(pic)); ImageIO.write(bufferImg, "jpg", byteArrayOut); // 左,上(0-255),右(0-1023),下 HSSFClientAnchor anchor = new HSSFClientAnchor(20, 1, 1018, 0, (short) (iColStart), iRowStart, (short) (iColStop), iRowStop); patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG)); } } // 设置画线 public void setLine(HSSFWorkbook wb, HSSFPatriarch patriarch, int iRowStart, int iColStart, int iRowStop, int iColStop) { HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 350, 0, (short) (iColStart), iRowStart, (short) (iColStop), iRowStop); HSSFSimpleShape lineShape = patriarch.createSimpleShape(anchor); lineShape.setShapeType(HSSFSimpleShape.OBJECT_TYPE_LINE); } // 计算行高度，实现行自动适应高度 defaultRowHeight = 12.00f; //每一行的高度指定目前只实现根据回车多行来判断，不能根据单元格宽度自动回行来判断 public float getCellAutoHeight(String str, float defaultRowHeight) { if (str == null) { return defaultRowHeight; } float height = 0.00f; int n = 0; if (str.endsWith("\n")) { n = str.split("\n").length; // 回车个数 } else { n = str.split("\n").length + 1; // 回车个数 } height = defaultRowHeight * n; return height; // 计算 } //计算字符串高度 public float getregex(String charStr) { if (charStr.equals(" ")) { return 0.5f; } if (Pattern.compile("^[A-Za-z0-9]+$").matcher(charStr).matches()) { return 0.5f; } // 判断是否为全角 if (Pattern.compile("^[\u4e00-\u9fa5]+$").matcher(charStr).matches()) { return 1.00f; } if (Pattern.compile("^x00-xff]+$").matcher(charStr).matches()) { return 1.00f; } return 0.5f; } //-----------------------下面都是一些具体的样式设置----------------------- public HSSFCellStyle titlev12(HSSFWorkbook wb, HSSFFont blackFont) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setFont(blackFont); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 单元格垂直居中 return curStyle; } public HSSFCellStyle nobox(HSSFWorkbook wb) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setBorderTop(HSSFCellStyle.BORDER_NONE); // 实线右边框 curStyle.setBorderRight(HSSFCellStyle.BORDER_NONE); // 实线右边框 curStyle.setBorderBottom(HSSFCellStyle.BORDER_NONE); // 实线右边框 curStyle.setBorderLeft(HSSFCellStyle.BORDER_NONE); // 实线右边框 curStyle.setTopBorderColor((short) 0); return curStyle; } // 实现打印时为白框，目的就是实现涂去上行的下边框线 by tony 20110709 public HSSFCellStyle whiteBox(HSSFWorkbook wb) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setTopBorderColor(HSSFColor.WHITE.index); curStyle.setRightBorderColor(HSSFColor.WHITE.index); curStyle.setBottomBorderColor(HSSFColor.WHITE.index); curStyle.setLeftBorderColor(HSSFColor.WHITE.index); curStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // 实线右边框 return curStyle; } public HSSFCellStyle normalv12(HSSFWorkbook wb, HSSFFont defaultFont12) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setFont(defaultFont12); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 单元格垂直居中 return curStyle; } public HSSFCellStyle normalv10(HSSFWorkbook wb, HSSFFont defaultFont10) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setFont(defaultFont10); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 单元格垂直居中 return curStyle; } public HSSFCellStyle bnormalv12(HSSFWorkbook wb, HSSFFont defaultFont12) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setFont(defaultFont12); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 单元格垂直居中 return curStyle; } public HSSFCellStyle moneyrv10_BorderThin(HSSFWorkbook wb, HSSFFont defaultFont10, short rmb4Format) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setFont(defaultFont10); curStyle.setDataFormat(rmb4Format); curStyle.setAlignment(HSSFCellStyle.ALIGN_RIGHT); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 单元格垂直居中 curStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // 实线右边框 return curStyle; } public HSSFCellStyle numberrv10_BorderThin(HSSFWorkbook wb, HSSFFont defaultFont10) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setFont(defaultFont10); curStyle.setAlignment(HSSFCellStyle.ALIGN_RIGHT); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 单元格垂直居中 curStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // 实线右边框 return curStyle; } public HSSFCellStyle moneyrv12_BorderThin(HSSFWorkbook wb, HSSFFont defaultFont12, short rmb2Format) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setFont(defaultFont12); curStyle.setDataFormat(rmb2Format); curStyle.setAlignment(HSSFCellStyle.ALIGN_RIGHT); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 单元格垂直居中 curStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // 实线右边框 return curStyle; } public HSSFCellStyle money1(HSSFWorkbook wb, HSSFFont defaultFont10, short money1Format) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setFont(defaultFont10); curStyle.setDataFormat(money1Format); curStyle.setAlignment(HSSFCellStyle.ALIGN_RIGHT); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 单元格垂直居中 return curStyle; } public HSSFCellStyle money2(HSSFWorkbook wb, HSSFFont defaultFont10, short money2Format) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setFont(defaultFont10); curStyle.setDataFormat(money2Format); curStyle.setAlignment(HSSFCellStyle.ALIGN_RIGHT); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 单元格垂直居中 return curStyle; } public HSSFCellStyle datevEN(HSSFWorkbook wb, HSSFFont defaultFont10, short datevENFormat) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setFont(defaultFont10); curStyle.setDataFormat(datevENFormat); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 单元格垂直居中 return curStyle; } public HSSFCellStyle notet10(HSSFWorkbook wb) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setWrapText(true); // 换行 curStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_TOP); // 单元格垂直居中 return curStyle; } public HSSFCellStyle notevt10(HSSFWorkbook wb, HSSFFont defaultFont10) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setWrapText(true); // 换行 curStyle.setFont(defaultFont10); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_TOP); // 单元格垂直居中 return curStyle; } public HSSFCellStyle noterv10(HSSFWorkbook wb, HSSFFont defaultFont10) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setWrapText(true); // 换行 curStyle.setFont(defaultFont10); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 单元格垂直居中 return curStyle; } public HSSFCellStyle noterv10NoWrap(HSSFWorkbook wb, HSSFFont defaultFont10) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setWrapText(false); //换行 curStyle.setFont(defaultFont10); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); //单元格垂直居中 return curStyle; } public HSSFCellStyle notehv10(HSSFWorkbook wb, HSSFFont defaultFont10) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setWrapText(true); // 换行 curStyle.setFont(defaultFont10); curStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 单元格垂直居中 return curStyle; } // 横向居左，垂直居中 public HSSFCellStyle notehlv10(HSSFWorkbook wb, HSSFFont defaultFont10) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setWrapText(true); // 换行 curStyle.setFont(defaultFont10); curStyle.setAlignment(HSSFCellStyle.ALIGN_LEFT); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 单元格垂直居中 return curStyle; } // 横向居右，垂直居中 public HSSFCellStyle notehrv10(HSSFWorkbook wb, HSSFFont defaultFont10) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setWrapText(true); // 换行 curStyle.setFont(defaultFont10); curStyle.setAlignment(HSSFCellStyle.ALIGN_RIGHT); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 单元格垂直居中 return curStyle; } public HSSFCellStyle notehv10_BorderThin(HSSFWorkbook wb, HSSFFont defaultFont10) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setWrapText(true); // 换行 curStyle.setFont(defaultFont10); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 单元格垂直居中 curStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // 实线右边框 return curStyle; } public HSSFCellStyle notecv10_BorderThin(HSSFWorkbook wb, HSSFFont defaultFont10) { HSSFCellStyle curStyle = wb.createCellStyle(); curStyle.setWrapText(true); // 换行 curStyle.setFont(defaultFont10); curStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 单元格垂直居中 curStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); // 实线右边框 curStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // 实线右边框 return curStyle; } } 上面用到的两个工具类

UtilFuns：

package cn.itcast.util; import java.sql.Timestamp; import java.text.SimpleDateFormat; import java.text.ParseException; import java.util.Iterator; import java.util.List; import java.util.Set; import java.util.StringTokenizer; import java.util.ArrayList; import java.text.DecimalFormat; import java.net.URLEncoder; import java.net.URLDecoder; import java.util.Date; /** UtilFuns is a JavaBean. */ public class UtilFuns { static public String newLine(){ return System.getProperty("line.separator"); } /* 验证数组是否为空 */ public static boolean arrayValid(Object[] objects) { if (objects != null && objects.length > 0) { return true; } else { return false; } } /* 验证list是否为空 */ public boolean listValid(List list) { if (list != null && list.size() > 0) { return true; } else { return false; } } //获得年龄 public int age(String dateStart, String dateEnd) throws Exception{ int yearStart = Integer.parseInt(dateStart.substring(0,4)); int yearEnd = Integer.parseInt(dateEnd.substring(0,4)); return yearEnd-yearStart; } //是否为奇数 public boolean isOdd(int i){ if(i%2==0){ return false; }else{ return true; } } public String cutStr(String str,int len){ try{ str = str.substring(0,len); }catch(Exception e){ return str; } return str; } //返回固定长度串，空白地方用空格填充 by tony 20110926 public String fixSpaceStr(String str,int len){ StringBuffer sBuf = new StringBuffer(); try{ if(str.length()>len){ return str; }else{ sBuf.append(str); for(int i=0;i<(len-str.length());i++){ sBuf.append(" "); } return sBuf.toString(); } }catch(Exception e){ return str; } } public String fixSpaceStr(int number,int len){ return fixSpaceStr(String.valueOf(number),len); } //前缀空格 public String prefixSpaceStr(String str,int len){ StringBuffer sBuf = new StringBuffer(); try{ if(str.length()>len){ return str; }else{ for(int i=0;i<(len-str.length());i++){ sBuf.append(" "); } sBuf.append(str); return sBuf.toString(); } }catch(Exception e){ return str; } } //截取字符,如果超过长度,截取并加省略号 by tony 20101108 public String suspensionStr(String str,int len){ try{ str = str.substring(0,len) + "..."; }catch(Exception e){ return str; } return str; } //url get方式传递参数 by tony 20110328 public static String joinUrlParameter(List<String> sList){ StringBuffer sBuf = new StringBuffer(); for(Iterator it = sList.iterator(); it.hasNext();){ sBuf.append("&").append(it.next()).append("=").append(it.next()); } return sBuf.substring(1, sBuf.length()); //去掉第一个&符号 } /** SplitStr 功能：返回分割后的数组 * 输入参数：String str 设置返回系统时间样式 * 输入参数：String SplitFlag 设置分割字符 * 输出参数：string[] 返回分割后的数组 * 作者：陈子枢 * 时间：2003-9-7 * 用法： */ /* String s[] = SplitStr("asd asd we sd"," "); for (int i=0;i<s.length;i++){ System.out.println(s[i]); } */ static public String[] splitStr(String str,String SplitFlag){ int i =0; try{ StringTokenizer st = new StringTokenizer(str, SplitFlag); String tokens[] = new String[st.countTokens()]; //System.out.println(st.countTokens()); while (st.hasMoreElements()) { tokens[i] = st.nextToken(); //System.out.println(tokens[i]); i++; } return tokens; }catch(Exception e){ return null; } } //类似google那样实现多个关键字的查询，关键字之间用空格或逗号隔开 by tony 20110523 //支持的分隔符英文逗号,中文逗号,空格 public String[] splitFindStr(String str){ if(str==null){ return null; } String[] aStr = null; str = str.replaceAll(",", " "); //英文逗号 str = str.replaceAll("，", " "); //中文逗号 aStr = this.splitStr(str, " "); //空格 return aStr; } /* 阶梯函数,例如，a,b,c 返回 a;a,b;a,b,c by tony 20110330 */ static public String[] splitStair(String str,String SplitFlag){ try{ String[] _temp = splitStr(str, SplitFlag); for(int i=1;i<_temp.length;i++){ _temp[i] = _temp[i-1]+SplitFlag+_temp[i]; } return _temp; }catch(Exception e){ return null; } } /** SplitStr 功能：将数组合并为一个字符串 * 输入参数：String aStr 要合并数组 * 输入参数：String SplitFlag 设置分割字符 * 输出参数：String 要合并数组 * 作者：陈子枢 * 时间：2004-1-9 * 用法： */ static public String joinStr(String[] aStr,String SplitFlag){ StringBuffer sBuffer = new StringBuffer(); if (aStr != null){ for (int i=0;i<aStr.length;i++){ sBuffer.append(aStr[i]).append(SplitFlag); } sBuffer.delete(sBuffer.length() - 1, sBuffer.length()); //去掉最后的分隔符 SplitFlag }else{ sBuffer = sBuffer.append(""); } return sBuffer.toString(); } /* 链接,但中间无链接符号 add by tony 20100322 */ static public String joinStr(String[] aStr){ StringBuffer sBuffer = new StringBuffer(); if (aStr != null){ for (int i=0;i<aStr.length;i++){ sBuffer.append(aStr[i]); } }else{ sBuffer = sBuffer.append(""); } return sBuffer.toString(); } /** JoinStr * 功能：将数组合并为一个字符串 * 输入参数：String sPrefix 数组元素加的前缀 * 输入参数：String sSuffix 数组元素加的后缀 * 输入参数：String SplitFlag 设置分割字符 * 输出参数：String 合并后的字符串 * 作者：陈子枢 * 时间：2005-3-17 * 用法： */ static public String joinStr(String[] aStr,String sPrefix,String sSuffix,String SplitFlag){ StringBuffer sBuffer = new StringBuffer(); if (aStr != null){ for (int i=0;i<aStr.length;i++){ sBuffer.append(sPrefix).append(aStr[i]).append(sSuffix).append(SplitFlag); } sBuffer.delete(sBuffer.length() - SplitFlag.length(), sBuffer.length()); //去掉最后的分隔符 SplitFlag }else{ sBuffer = sBuffer.append(""); } return sBuffer.toString(); } /* 返回用于in查询的串 'x','y' */ static public String joinInStr(String[] aStr){ StringBuffer sBuffer = new StringBuffer(); if (aStr != null){ for (int i=0;i<aStr.length;i++){ sBuffer.append("'").append(aStr[i]).append("'").append(","); } sBuffer.delete(sBuffer.length() - 1, sBuffer.length()); }else{ sBuffer = sBuffer.append(""); } return sBuffer.toString(); } /* 链接,但中间无链接符号 add by tony 20100322 */ static public String joinStr(String[] aStr,String sPrefix,String sSuffix){ StringBuffer sBuffer = new StringBuffer(); if (aStr != null){ for (int i=0;i<aStr.length;i++){ sBuffer.append(sPrefix).append(aStr[i]).append(sSuffix); } }else{ sBuffer = sBuffer.append(""); } return sBuffer.toString(); } /* 链接len(s)个symbol符号 add by tony 20100407 */ static public String joinStr(String s, String symbol){ StringBuffer sBuf = new StringBuffer(); for (int i=0;i<s.length();i++){ sBuf.append(symbol); } return sBuf.toString(); } static public String joinStr(int len, String symbol){ StringBuffer sBuf = new StringBuffer(); for (int i=0;i<len;i++){ sBuf.append(symbol); } return sBuf.toString(); } /** SysTime 功能：返回系统时间 * 输入参数：int style 设置返回系统时间样式 * 输出参数：string 返回系统时间样式 * 作者：陈子枢 * 时间：2003-6-24 * 存在问题：中文乱码，但JSP中显示正常。 */ static public String SysTime(String strStyle){ String s = ""; if (strStyle.compareTo("")==0){ strStyle = "yyyy-MM-dd HH:mm:ss"; //default } java.util.Date date=new java.util.Date(); SimpleDateFormat dformat=new SimpleDateFormat(strStyle); s = dformat.format(date); return s; } static public String sysTime(){ String s = ""; java.util.Date date=new java.util.Date(); SimpleDateFormat dformat=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); s = dformat.format(date); return s; } static public String sysDate(){ String s = ""; java.util.Date date=new java.util.Date(); SimpleDateFormat dformat=new SimpleDateFormat("yyyy-MM-dd"); s = dformat.format(date); return s; } /* add by tony 20091113 */ public static boolean isNull(Object obj){ try{ if(obj==null){ return true; } return false; }catch(Exception e){ return false; } } public static boolean isNotNull(Object obj){ try{ if(obj==null){ return false; } return true; }catch(Exception e){ return true; } } public static boolean isEmpty(String str){ try{ if(str==null || str.equals("null") || str.equals("")){ return true; } return false; }catch(Exception e){ return false; } } public static boolean isEmpty(String strs[]){ try{ if(strs==null || strs.length<=0){ return true; } return false; }catch(Exception e){ return false; } } public static boolean isNotEmpty(String str){ try{ if(str==null || str.equals("null") || str.equals("")){ return false; } return true; }catch(Exception e){ return true; } } public static boolean isNotEmpty(Object obj){ try{ if(obj==null || obj.toString().equals("null") || obj.toString().equals("")){ return false; } return true; }catch(Exception e){ return true; } } public static boolean isNotEmpty(List obj){ try{ if(obj==null || obj.size()<=0){ return false; } return true; }catch(Exception e){ return true; } } /** 功能：用于转换为null的字段。 * 入参：String strvalue 设置要转换的字符串 * 出参：不为“null”的返回原串；为“null”返回""。 * 作者：陈子枢 * 时间：2003-9-16 * 用法：optionFuns.convertNull(String.valueOf(oi.next())) */ public static String convertNull(String strvalue) { try{ if(strvalue.equals("null") || strvalue.length()==0){ return ""; }else{ return strvalue.trim(); } }catch(Exception e){ return ""; } } public static String[] convertNull(String[] aContent) { try{ for(int i=0;i<aContent.length;i++){ if(aContent[i].toLowerCase().compareTo("null")==0){ aContent[i] = ""; } } return aContent; }catch(Exception e){ return null; } } public static String convertNull(Object o) { try{ String strvalue = String.valueOf(o); if(strvalue.equals(null) || strvalue.equals("null") || strvalue.length()==0){ return ""; }else{ return strvalue.trim(); } }catch(Exception e){ return ""; } } //将为null的数据转为0，用在数值的值从数据库中读出的情况 public static int ConvertZero(Object o) { try{ String s = convertNull(o); if(s==""){ return 0; }else{ return Integer.parseInt(s); } }catch(Exception e){ return 0; } } //将为null的数据转为0，用在数值的值从数据库中读出的情况 public static int cvtPecrent(Object o) { try{ String s = convertNull(o); if(s==""){ return 0; }else{ return Integer.parseInt(s); } }catch(Exception e){ return 0; } } //if 0 then return ""; public static String FormatZero(Object o) { try{ String s = convertNull(o); if(s.compareTo("")==0){ return ""; }else{ return String.valueOf(s); } }catch(Exception e){ return ""; } } //if 0 then return ""; public static String FormatZero(String s) { try{ if(s.compareTo("0")==0){ return ""; }else{ return s; } }catch(Exception e){ return ""; } } //patter="####.000" public static String FormatNumber(Object o,String patter) { double d = 0; try { d = Double.parseDouble(String.valueOf(o)); DecimalFormat df = new DecimalFormat(patter); return df.format(d); } catch (Exception e) { System.out.println(e.getMessage()); return ""; } } //patter="####.00" public static String FormatNumber(String s) { double d = 0; try { d = Double.parseDouble(s); DecimalFormat df = new DecimalFormat(",###.00"); return df.format(d); } catch (Exception e) { System.out.println(e.getMessage()); return ""; } } //只用在表格的输出 public static String ConvertTD(String strvalue) { try{ strvalue = strvalue.trim(); if(strvalue.equals("null") || strvalue.length()==0){ return " "; }else{ return strvalue; } }catch(Exception e){ return " "; } } public static String ConvertSpaceTD(Object o) { try{ String strvalue = String.valueOf(o); strvalue = strvalue.trim(); if(strvalue.equals("null") || strvalue.length()==0){ return " "; }else{ return " " + strvalue.trim(); } }catch(Exception e){ return " "; } } /* 只转中文，不处理null 读取记录时去掉数据两边的空格；而录入数据时，维持用户的输入，哪怕用户多输入了空格原因在于有时可能用户有意输入空格。例如：备注字段原来有内容，现在用户想清空。 */ public static String ConvertCH(String strvalue) { System.out.println("ConvertCH:"+strvalue); try{ if(strvalue==null){ return "null"; }else if(strvalue.length()==0){ return ""; }else{ strvalue = new String(strvalue.getBytes("ISO8859_1"), "GB2312"); return strvalue; } }catch(Exception e){ return ""; } } public static String ConvertCStr(String strvalue) { try{ strvalue = convertNull(strvalue); if(strvalue.equals("")){ return ""; }else{ strvalue = new String(strvalue.getBytes("ISO8859_1"), "GB2312"); return strvalue; } }catch(Exception e){ return ""; } } public static String ConvertCStr(Object o) { String strvalue = ""; try{ strvalue = String.valueOf(o); strvalue = convertNull(strvalue); if(strvalue.equals("")){ return ""; }else{ strvalue = new String(strvalue.getBytes("ISO8859_1"), "GB2312"); return strvalue; } }catch(Exception e){ System.out.println("ConvertCStr:" + e.toString()); return ""; } } /** *UrlEncoder 进行URL编码 */ public String UrlEncoder(String s) { String s1 = ""; if(s == null) return ""; try { s1 = URLEncoder.encode(s); } catch(Exception e) { System.out.println("URL Encoder :" + e.toString()); s1 = ""; } return s1; } /** *URLDecoder 进行URL解码 */ public String UrlDecoder(String s) { String s1 = ""; if(s == null) return ""; try { s1 = URLDecoder.decode(s); } catch(Exception e) { System.out.println("URL Encoder :" + e.toString()); s1 = ""; } return s1; } /** * 将字符串转化成首字母大写，其余字母小写的格式 * @param source 传入字符串 * @return String */ public static String format_Aaa(String source) { if (source==null) return null; if (source.equals("")) return ""; String a; a = source.substring(0, 1); a = a.toUpperCase(); return a + source.substring(1); } /** * 将字符串转换成Long型 * @param param 传入字符串 * @return 长整形 */ public static long parseLong(String param) { long l=0; try { l = Long.parseLong(param); } catch (Exception e) { } return l; } /** * 将字符串转换成Float型 * @param param 传入字符串 * @return 浮点型 */ public static float parseFloat(String param) { float l=0; try { l = Float.parseFloat(param); } catch (Exception e) { } return l; } /** * 将字符串转换成Integer型 * @param param 传入字符串 * @return 整形 */ public static int parseInt(String param) { int l=0; try { l = Integer.parseInt(param); } catch (Exception e) { } return l; } public static Date parseDate(String currDate, String format) { SimpleDateFormat dtFormatdB = null; try { dtFormatdB = new SimpleDateFormat(format); return dtFormatdB.parse(currDate); }catch (Exception e){ dtFormatdB = new SimpleDateFormat("yyyy-MM-dd"); try { return dtFormatdB.parse(currDate); }catch (Exception ex){} } return null; } public static Date parseDate(String currDate) { SimpleDateFormat dtFormatdB = null; dtFormatdB = new SimpleDateFormat("yyyy-MM-dd"); try { return dtFormatdB.parse(currDate); }catch (Exception e){ try { return dtFormatdB.parse(currDate); }catch (Exception ex){} } return null; } public static Date parseTime(String currDate, String format) { SimpleDateFormat dtFormatdB = null; try { dtFormatdB = new SimpleDateFormat(format); return dtFormatdB.parse(currDate); }catch (Exception e){ dtFormatdB = new SimpleDateFormat("HH:mm:ss"); try { return dtFormatdB.parse(currDate); }catch (Exception ex){} } return null; } public static Date parseDateTime(String currDate, String format) { SimpleDateFormat dtFormatdB = null; try { dtFormatdB = new SimpleDateFormat(format); return dtFormatdB.parse(currDate); }catch (Exception e){ dtFormatdB = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); try { return dtFormatdB.parse(currDate); }catch (Exception ex){} } return null; } /** * 将字符串转换成Double型 * @param param 传入字符串 * @return double型 */ public static double parseDouble(String param) { double l=0; try { l = Double.parseDouble(param); } catch (Exception e) { } return l; } /** * s是否存在ArrayList中，存在返回数组下标，不存在返回-1 */ public static int existElements(String s,ArrayList aList) { try{ for (int i = 0; i < aList.size(); i ++) { if (s.equals(aList.get(i))){ return i; } } }catch(Exception e){ } return -1; } /** * s是否存在String数组中，存在返回数组下标，不存在返回-1 */ public static int existElements(String s,String[] a) { try{ for (int i = 0; i < a.length; i ++) { if (s.compareTo((a[i].trim()))==0){ return i; } } }catch(Exception e){ } return -1; } /** * 判断对象o是否存在于set对象集合中 create by tony 20090611 */ public static boolean existElements(Object o, Set set) { boolean isExists = false; Iterator it = set.iterator(); while(it.hasNext()) { Object obj = it.next(); if(o.equals(obj)) { isExists=true; break; } } return isExists; } /** * s是否存在ArrayList中，存在返回数组下标，不存在返回-1 */ public static int IsIndexOfElements(String s,ArrayList aList) { try{ String s1 = ""; for (int i = 0; i < aList.size(); i ++) { s1 = String.valueOf(aList.get(i)); if (s1.indexOf(s)!=-1){ return i; } } }catch(Exception e){ } return -1; } /** * 将ArrayList转换为一维String数组，并把其中的null换成空字符串 * @param aList 传入的Arraylist */ public String[] ArrayListToString(ArrayList aList) { String[] s = new String[aList.size()]; for (int i = 0; i < aList.size(); i ++) { s[i] = this.convertNull(aList.get(i)); } return s; } /** * 将数组中的null换成空字符串 * @param al 传入的Arraylist，同时也是输出结果 */ public static void formatArrayList(ArrayList al) { for (int i = 0; i < al.size(); i ++) { if (al.get(i) == null) al.set(i, ""); } } /** ComboList 功能：选定在下拉列表框中与查找到数据,相符的那一项内容 * 输入参数：String CurrentValue 查找出的数据库中的数据 * String[] content 需要输出的所有下拉列表框的内容 * 输出参数：返回下拉列表 * 注意事项：values为0开始,而且中间不能断开 */ public String ComboList(String CurrentValue, String[] content) { int i = 0; StringBuffer sBuf = new StringBuffer(); String selected = " selected"; try{ sBuf.append("<option value='' selected>--请选择--</option>"); for (i = 0; i < content.length; i++) { sBuf.append("\n<option value='").append(i).append("'"); if (CurrentValue.compareTo(String.valueOf(i)) == 0) { sBuf.append(selected); } sBuf.append(">").append(content[i]).append("</option>"); } return sBuf.toString(); }catch(Exception e){ return ""; } } public String ComboListMust(String CurrentValue, String[] content) { int i = 0; StringBuffer sBuf = new StringBuffer(); String selected = " selected"; try{ for (i = 0; i < content.length; i++) { sBuf.append("\n<option value='").append(i).append("'"); if (CurrentValue.compareTo(String.valueOf(i)) == 0) { sBuf.append(selected); } sBuf.append(">").append(content[i]).append("</option>"); } return sBuf.toString(); }catch(Exception e){ return ""; } } /** ComboList 功能：选定在下拉列表框中与查找到数据,相符的那一项内容 * 输入参数：String CurrentValue 查找出的数据库中的数据 * String[] values 需要输出的所有下拉列表框的内容所对应的值 * String[] content 需要输出的所有下拉列表框的内容 * 输出参数：返回下拉列表 * 修改：陈子枢 * 修改时间：2003-9-4 * 注意事项：values和content数组个数必须相同.适合从数据库中取值 <% String[] aContextOPERATE_TYPE = {"定检","轮换","抽检"}; out.print(optionFuns.ComboList("",aContextOPERATE_TYPE,aContextOPERATE_TYPE)); %> */ public String ComboList(String CurrentValue,String[] values, String[] content) { int i = 0; StringBuffer sBuf = new StringBuffer(); String selected = " selected"; try{ if(CurrentValue==null){ CurrentValue = ""; } sBuf.append("<option value='' selected>--请选择--</option>"); for (i = 0; i < content.length; i++) { sBuf.append("<option value='").append(values[i]).append("'"); if (CurrentValue.compareTo(values[i]) == 0) { sBuf.append(selected); } sBuf.append(">").append(content[i]).append("</option>"); } return sBuf.toString(); }catch(Exception e){ return ""; } } public String ComboListMust(String CurrentValue,String[] values, String[] content) { int i = 0; StringBuffer sBuf = new StringBuffer(); String selected = " selected"; try{ for (i = 0; i < content.length; i++) { sBuf.append("<option value='").append(values[i]).append("'"); if (CurrentValue.compareTo(values[i]) == 0) { sBuf.append(selected); } sBuf.append(">").append(content[i]).append("</option>"); } return sBuf.toString(); }catch(Exception e){ return ""; } } /** StrToTimestamp 功能：将字符串转换为Timestamp 。 * 输入参数：String timestampStr 设置要转换的字符串 * String pattern 要转换的format * 输出参数：如果格式正确返回格式后的字符串。 * 不正确返回系统日期。 * 作者：陈子枢 * 时间：2003-8-26 */ public static Timestamp StrToTimestamp(String timestampStr,String pattern) throws ParseException { java.util.Date date = null; SimpleDateFormat format = new SimpleDateFormat(pattern); try { date = format.parse(timestampStr); } catch (ParseException ex) { throw ex; } return date == null ? null : new Timestamp(date.getTime()); } //ex:utilFuns.StrToDateTimeFormat("2005-12-01 00:00:00.0,"yyyy-MM-dd") public static String StrToDateTimeFormat(String timestampStr,String pattern) throws ParseException { String s =""; try{ s = String.valueOf(StrToTimestamp(timestampStr, pattern)); s = s.substring(0,pattern.length()); }catch(Exception e){ } return s; } //ex:utilFuns.StrToDateTimeFormat("2005-12-01 00:00:00.0,"yyyy-MM-dd") public static String dateTimeFormat(Date date,String pattern) throws ParseException { String s =""; try{ SimpleDateFormat dformat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); s = dformat.format(date); s = String.valueOf(StrToTimestamp(s, pattern)); s = s.substring(0,pattern.length()); }catch(Exception e){ } return s; } public static String dateTimeFormat(Date date) throws ParseException { String s =""; try{ SimpleDateFormat dformat = new SimpleDateFormat("yyyy-MM-dd"); s = dformat.format(date); s = String.valueOf(StrToTimestamp(s, "yyyy-MM-dd")); s = s.substring(0,"yyyy-MM-dd".length()); }catch(Exception e){ } return s; } //add by tony 20100228 转换中文格式必须为："yyyy-MM-dd HH:mm:ss"的一部分 public static String formatDateTimeCN(String date) throws ParseException { String s =""; try{ if(UtilFuns.isEmpty(date)){ return ""; } if(date.indexOf(".")>-1){ date = date.substring(0, date.indexOf(".")); } if(date.length()==4){ //yyyy s = date+"年"; }else if(date.length()==7){ //yyyy-MM s = date.replaceAll("-0", "-").replaceFirst("-", "年")+"月"; }else if(date.length()==10){ //yyyy-MM-dd s = date.replaceAll("-0", "-").replaceFirst("-", "年").replaceFirst("-", "月")+"日"; }else if(date.length()==2){ //HH s = date+"时"; }else if(date.length()==5){ //HH:mm s = date.replaceAll(":0", ":").replaceFirst(":", "时")+"分"; }else if(date.length()==8){ //HH:mm:ss s = date.replaceAll(":0", ":").replaceFirst(":", "时").replaceFirst(":", "分")+"秒"; }else if(date.length()==13){ //yyyy-MM-dd HH s = date.replaceAll("-0", "-").replaceFirst("-", "年").replaceFirst("-", "月").replaceAll(" 0", " ").replaceFirst(" ", "日")+"时"; }else if(date.length()==16){ //yyyy-MM-dd HH:mm s = date.replaceAll("-0", "-").replaceFirst("-", "年").replaceFirst("-", "月").replaceAll(" 0", " ").replaceFirst(" ", "日").replaceAll(":0", ":").replaceFirst(":", "时")+"分"; }else if(date.length()==19){ //yyyy-MM-dd HH:mm:ss s = date.replaceAll("-0", "-").replaceFirst("-", "年").replaceFirst("-", "月").replaceAll(" 0", " ").replaceFirst(" ", "日").replaceAll(":0", ":").replaceFirst(":", "时").replaceFirst(":", "分")+"秒"; } s = s.replaceAll("0[时分秒]", ""); //正则 0时0分0秒的都替换为空 }catch(Exception e){ } return s; } //add by tony 2011-07-26 返回英文格式日期 oct.10.2011 public static String formatDateEN(String date) throws ParseException { String s =""; int whichMonth = 1; try{ if(UtilFuns.isEmpty(date)){ return ""; } String[] aString = date.replaceAll("-0", "-").split("-"); whichMonth = Integer.parseInt(aString[1]); if(whichMonth==1){ s = "Jan"; }else if(whichMonth==2){ s = "Feb"; }else if(whichMonth==3){ s = "Mar"; }else if(whichMonth==4){ s = "Apr"; }else if(whichMonth==5){ s = "May"; }else if(whichMonth==6){ s = "Jun"; }else if(whichMonth==7){ s = "Jul"; }else if(whichMonth==8){ s = "Aug"; }else if(whichMonth==9){ s = "Sept"; }else if(whichMonth==10){ s = "Oct"; }else if(whichMonth==11){ s = "Nov"; }else if(whichMonth==12){ s = "Dec"; } s = s+"."+aString[2]+","+aString[0]; }catch(Exception e){ } return s; } //返回年月格式 2010-7 public String formatShortMonth(String strDate){ return strDate.substring(0,7).replaceAll("-0", "-"); } //返回年月格式 2010-07 public String formatMonth(String strDate){ return strDate.substring(0,7); } //删除最后1个字符 public static String delLastChar(String s){ try{ if(s.length()>0){ s = s.substring(0,s.length()-1); } }catch(Exception e){ return ""; } return s; } //删除最后len个字符 public static String delLastChars(String s,int len){ try{ if(s.length()>0){ s = s.substring(0,s.length()-len); } }catch(Exception e){ return ""; } return s; } //替换网页用字符-配合FCKEditor使用 .replaceAll("'","'") //for viewpage public String htmlReplaceAll(String s){ try{ StringBuffer sBuf = new StringBuffer(); //.replaceAll("\\\\","\\\\\\\\").replaceAll("&","&") sBuf.append(s.replaceAll(" "," ").replaceAll("<","<").replaceAll(">",">").replaceAll("\"",""").replaceAll("\n","<br\\>")); return sBuf.toString(); }catch(Exception e){ return ""; } } //for viewpage by jstl/make html public static String htmlNewline(String s){ try{ //如不替换空格,html解释时会自动把多个空格显示为一个空格,这样当我们通过空格来布局时就出现textarea中和html页面展现不一致的情况 tony //s.replaceAll(" "," ") 不能进行空格的替换，否则页面内容中如果有<img src="xxx.jpg" \>等标签，内容就会显示乱；<img src="xxx.jpg"nbsp;\> return s.replaceAll(" "," ").replaceAll("\n","<br\\>"); }catch(Exception e){ return ""; } } /** getPassString 功能：用于转换为后几位的为*。 * 输入参数：String strvalue 设置要转换的字符串 * int Flag 位数。 * 输出参数：。 * 作者：范波 * 时间：2006-8-7 * 存在问题： * 用法： * <%=utilFuns.ConvertString("abcdef",3)%> */ public static String getPassString( String strvalue, int Flag ) { try { if ( strvalue.equals("null") || strvalue.compareTo("")==0){ return ""; } else { int intStrvalue = strvalue.length(); if ( intStrvalue > Flag ) { strvalue = strvalue.substring( 0, intStrvalue - Flag ); } for ( int i = 0; i < Flag; i++ ) { strvalue = strvalue + "*"; } //System.out.print( "strvalue:" + strvalue ); return strvalue; } } catch (Exception e) { return strvalue; } } /** getPassString 功能：用于转换为后几位的为*。 * 输入参数：String strvalue 设置要转换的字符串 * int Flag 起位数。 * int sFlag 末位数。 * 输出参数：。 * 作者：范波 * 时间：2006-8-7 * 存在问题： * 用法： * <%=optionFuns.getPassString(String.valueOf(oi.next()),3)%> */ public static String getPassString( String strvalue, int Flag, int sFlag ,int iPassLen ) { try { if ( strvalue.equals( "null" ) ) { return ""; } else { String strvalue1=""; String strvalue2=""; int intStrvalue = strvalue.length(); if(sFlag>=Flag){ if ( intStrvalue > Flag ) { strvalue1 = strvalue.substring( 0, Flag ); strvalue2 = strvalue.substring( sFlag, intStrvalue ); } else { strvalue1 = ""; strvalue2 = ""; } for ( int i = 0; i < iPassLen; i++ ) { strvalue1 = strvalue1 + "*"; } strvalue=strvalue1+strvalue2; } //System.out.print( "strvalue:" + strvalue ); return strvalue; } } catch (Exception e) { return strvalue; } } /* by czs 2006-8-17 OPTION: 取得字符串iStartPos位置到iEndPos位置，将中间这部分转换iPatternLen个sPattern EXSAMPLE: getPatternString("CHEN ZISHU",5,7,"*",3) RESULT: CHEN ***SHU getPatternString("CHEN ZISHU",10,0,".",3) RESULT: CHEN****** */ public static String getPatternString( String s, int iStartPos, int iEndPos, String sPattern, int iPatternLen ) { try { if (iEndPos==0) { iEndPos = s.length(); } String sStartStr = ""; String sCenterStr = ""; String sEndStr = ""; if ( s.equals("null")){ return ""; } else { int ints = s.length(); if ( ints > iStartPos ) { sStartStr = s.substring( 0, iStartPos ); }else{ return s; } if ( ints > iEndPos) { sEndStr = s.substring( iEndPos, ints ); } for ( int i = 0; i < iPatternLen; i++ ) { sCenterStr = sCenterStr + sPattern; } return sStartStr + sCenterStr + sEndStr; } } catch (Exception e) { System.out.println(e); return s; } } public static String getPatternString( String s, int iStartPos, String sPattern, int iPatternLen ) { return getPatternString(s,iStartPos,0,sPattern,iPatternLen); } public static String getPatternString( String s, int iStartPos, String sPattern ) { return getPatternString(s,iStartPos,0,sPattern,3); } /** getQQString 功能：用于转换为后几位的为*。 * 输入参数：String strvalue 设置要转换的字符串 * * 输出参数：。 * 作者：范波 * 时间：2006-8-7 * 存在问题： * 用法： * <%=optionFuns.getQQString(String.valueOf(oi.next()))%> */ public static String getQQString( String strvalue ) { try { String QQ=""; if ( strvalue.equals("") ) { return ""; } else { QQ="<img src=\"http://wpa.qq.com/pa?p=1:"+strvalue +":4\">" +" "+strvalue+""; } strvalue=QQ; //System.out.print( "strvalue:" + strvalue ); return strvalue; } catch (Exception e) { return strvalue; } } public String getNoExistString(String allString, String existString){ return this.getNoExistString(this.splitStr(allString, ","), existString); } /* 返回existString中的每个字串不在allString中的 */ public String getNoExistString(String[] allString, String existString){ existString = existString + ","; if(allString==null&&allString.length==0){ return ""; } StringBuffer sBuf = new StringBuffer(); for(int i=0;i<allString.length;i++){ if(existString.indexOf(allString[i])==-1){ sBuf.append(allString[i]).append(","); } } if(sBuf.length()>1){ sBuf.delete(sBuf.length()-1, sBuf.length()); } return sBuf.toString(); } public static void main(String[] args) throws Exception { // // // java.util.List aList = new ArrayList(); // System.out.println(UtilFuns.isNotEmpty(aList)); // // System.out.println(uf.formatDateTimeCN("2011")); // System.out.println(uf.formatDateTimeCN("2011-01")); // System.out.println(uf.formatDateTimeCN("2011-01-02")); // System.out.println(uf.formatDateTimeCN("2011-01-02 03")); // System.out.println(uf.formatDateTimeCN("2011-01-02 13:05")); // System.out.println(uf.formatDateTimeCN("2011-01-02 13:05:05")); // System.out.println(uf.formatDateTimeCN("03")); // System.out.println(uf.formatDateTimeCN("13:05")); // System.out.println(uf.formatDateTimeCN("13:05:05")); // UtilFuns uf = new UtilFuns(); // System.out.println(uf.getNoExistString("1,2,3", "1,2,3,4")); // System.out.println(uf.getNoExistString("安全,生产,营销", "生产,营销")); // System.out.println("finish!"); // Set<String> set = new HashSet<String>(); // set.add("abc"); // set.add("xyz"); // set.add("abc"); // for(Iterator<String> it = set.iterator();it.hasNext();){ // System.out.println(it.next()); // } /* System.out.println(SysTime("yyyy-MM-dd")); System.out.println(SysTime("yyyy-MM-dd HH:mm:ss")); System.out.println(Double.parseDouble("12.11")); System.out.println(FormatNumber("12.11000000000f")); System.out.println(getPatternString("CHEN ZISHU",8,0,".",3)); */ //System.out.println(SysTime("yyyy年MM月")); //System.out.println(SysTime("yyyyMM")); //System.out.println(ConvertSpaceTD("")); //System.out.println(ConvertTD("")); /* process the stat data Start Statement stmt1 = conn.createStatement(); String sTableName = find_Type; String sUserName = findName; StringBuffer sBuffer = new StringBuffer(); //Step 1 clear Table userState sBuffer.append("delete * from userStat;"); //Step 2 read username from User_P and write inputnum in it sBuffer.append("select User_P.loginname,").append(sTableName).append(".createby,count(").append(sTableName).append(".createby)") .append(" from ").append(sTableName).append("") .append(" right join") .append(" User_P") .append(" on User_P.loginname=").append(sTableName).append(".createby") .append(" where 1=1"); if (find_Name.compareTo("")!=0){ sBuffer.append(" and ").append(sTableName).append(".createby='").append(sTableName).append("'"); } if (find_DateStart.compareTo("")!=0){ sBuffer.append(" and createdate<='").append(find_DateStart).append(" 00:00:00'"); } if (find_DateStart.compareTo("")!=0){ sBuffer.append(" and createdate>='").append(find_DateEnd).append(" 23:59:59'"); } sBuffer.append(" group by ").append(sTableName).append(".createby") .append(";"); //Step 3 read updatenum sBuffer.append("select count(updateby) from ").append(sTableName).append("") .append(" where ").append(sTableName).append(".updateby=''") .append(" and updatedate<='").append(find_DateStart).append(" 00:00:00'") .append(" and updatedate>='").append(find_DateEnd).append(" 23:59:59'") .append(";"); //Step 4 update the userStat.updatenum value sBuffer.append("update userStat set updatenum='3' where updateby='").append(sTableName).append("'") .append(";"); sBuffer.toString(); process the stat data End */ /* try{ System.out.println(SysDate()); System.out.println(StrToDateTimeFormat("2003-08-21 18:28:47", "yyyy-MM-")); }catch(Exception e){ } String s[] = SplitStr("asd,asd,we,sd",","); for (int curLayNum=0;curLayNum<s.length;curLayNum++){ System.out.println(s[curLayNum]); } System.out.println(JoinStr(s,",")); System.out.println(ReturnSysTime("yyyy-MM-dd")); //System.out.println(CoverDate(ReturnSysTime("yyyy-MM-dd HH:mm:ss"),"yyyy-MM-dd")); try { System.out.println(StrToTimestamp("2003-08-21 18:28:47", "yyyy-MM")); System.out.println(StrToDateTimeFormat("2003-08-21 18:28:47", "yyyy-MM")); } catch (ParseException ex) { } try { System.out.println(StrToTimestamp("2003-08-26", "yyyy-MM-dd")); } catch (ParseException ex) { System.out.println("StrToTimestamp error."); }*/ System.out.println("finish!"); } /* <script language=JavaScript> var today = new Date(); var strDate = (today.getFullYear() + "年" + (today.getMonth() + 1) + "月" + today.getDate() + "日 "); var n_day = today.getDay(); switch (n_day) { case 0:{ strDate = strDate + "星期日" }break; case 1:{ strDate = strDate + "星期一" }break; case 2:{ strDate = strDate + "星期二" }break; case 3:{ strDate = strDate + "星期三" }break; case 4:{ strDate = strDate + "星期四" }break; case 5:{ strDate = strDate + "星期五" }break; case 6:{ strDate = strDate + "星期六" }break; case 7:{ strDate = strDate + "星期日" }break; } document.write(strDate); </script> */ public String replaceLast(String string, String toReplace, String replacement) { int pos = string.lastIndexOf(toReplace); if (pos > -1) { return string.substring(0, pos) + replacement + string.substring(pos + toReplace.length(), string.length()); } else { return string; } } public static String getROOTPath(){ UtilFuns uf = new UtilFuns(); return uf.getClass().getResource("/").getPath().replace("/WEB-INF/classes/", "/").substring(1); } public String getClassRootPath(){ return this.getClass().getResource("/").getPath(); } } DownloadUtil：

package cn.itcast.util; import java.io.ByteArrayOutputStream; import java.io.File; import java.io.FileInputStream; import java.io.IOException; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServletResponse; public class DownloadUtil { /** * @param filePath 要下载的文件路径 * @param returnName 返回的文件名 * @param response HttpServletResponse * @param delFlag 是否删除文件 */ protected void download(String filePath,String returnName,HttpServletResponse response,boolean delFlag){ this.prototypeDownload(new File(filePath), returnName, response, delFlag); } /** * @param file 要下载的文件 * @param returnName 返回的文件名 * @param response HttpServletResponse * @param delFlag 是否删除文件 */ protected void download(File file,String returnName,HttpServletResponse response,boolean delFlag){ this.prototypeDownload(file, returnName, response, delFlag); } /** * @param file 要下载的文件 * @param returnName 返回的文件名 * @param response HttpServletResponse * @param delFlag 是否删除文件 */ public void prototypeDownload(File file,String returnName,HttpServletResponse response,boolean delFlag){ // 下载文件 FileInputStream inputStream = null; ServletOutputStream outputStream = null; try { if(!file.exists()) return; response.reset(); //设置响应类型 PDF文件为"application/pdf"，WORD文件为："application/msword"， EXCEL文件为："application/vnd.ms-excel"。 response.setContentType("application/octet-stream;charset=utf-8"); //设置响应的文件名称,并转换成中文编码 //returnName = URLEncoder.encode(returnName,"UTF-8"); returnName = response.encodeURL(new String(returnName.getBytes(),"iso8859-1")); //保存的文件名,必须和页面编码一致,否则乱码 //attachment作为附件下载；inline客户端机器有安装匹配程序，则直接打开；注意改变配置，清除缓存，否则可能不能看到效果 response.addHeader("Content-Disposition", "attachment;filename="+returnName); //将文件读入响应流 inputStream = new FileInputStream(file); outputStream = response.getOutputStream(); int length = 1024; int readLength=0; byte buf[] = new byte[1024]; readLength = inputStream.read(buf, 0, length); while (readLength != -1) { outputStream.write(buf, 0, readLength); readLength = inputStream.read(buf, 0, length); } } catch (Exception e) { e.printStackTrace(); } finally { try { outputStream.flush(); } catch (IOException e) { e.printStackTrace(); } try { outputStream.close(); } catch (IOException e) { e.printStackTrace(); } try { inputStream.close(); } catch (IOException e) { e.printStackTrace(); } //删除原文件 if(delFlag) { file.delete(); } } } /** * by tony 2013-10-17 * @param byteArrayOutputStream 将文件内容写入ByteArrayOutputStream * @param response HttpServletResponse 写入response * @param returnName 返回的文件名 */ public void download(ByteArrayOutputStream byteArrayOutputStream, HttpServletResponse response, String returnName) throws IOException{ response.setContentType("application/octet-stream;charset=utf-8"); returnName = response.encodeURL(new String(returnName.getBytes(),"iso8859-1")); //保存的文件名,必须和页面编码一致,否则乱码 response.addHeader("Content-Disposition", "attachment;filename=" + returnName); response.setContentLength(byteArrayOutputStream.size()); ServletOutputStream outputstream = response.getOutputStream(); //取得输出流 byteArrayOutputStream.writeTo(outputstream); //写到输出流 byteArrayOutputStream.close(); //关闭 outputstream.flush(); //刷数据 } }

转载请注明原文地址: https://ju.6miu.com/read-1309374.html

最新回复(0)