devbox
Li_阴宅
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

(新手笔记分享)Spring MVC根据查询生成Excel（导出数据+图片）以流的方式返回给前端下载- 摘取片段，仅供参考_springmvc 生成excel写入响应流

作者：Li_阴宅 | 2024-07-17 23:23:21

赞

踩

springmvc 生成excel写入响应流

查询的效果图

表格数据结构

查看的表格效果图

导出表格的Excel效果图

控制层:

  1. @ResponseBody
  2. 	@RequestMapping(value = "excleDownload")
  3. 	public void excleDownload(HttpServletRequest request, HttpServletResponse response,Integer id) throws IOException {
  4. 		List<ljCheckInstanceM> ljListInfo = dailyInService.queryContentInfo(id);//查询内容  ljCheckInstanceM是实体类
  5. 		List<ljCheckInstanceM> ljListPhoto = dailyInService.queryPhotoInfo(id);//查询id下对应的图片
  6. 		Map<String, String> fileQD = ExportExcelUtil.excleDownload(request.getServletContext(), null, ljListInfo, ljListPhoto);//生成Excel文件并返回地址
  7. 		String excelPathP = fileQD.get("path");//路径
  8. 		String excelNameP = fileQD.get("name");//名称
  9. 		//文件流的方式导出Excel
  10. 		try {
  11. 	        // 输出响应正文的输出流
  12. 	        OutputStream out;
  13. 	        // 读取本地文件的输入流
  14. 	        InputStream in;
  15. 	        // 获得本地输入流
  16. 	        File file = new File("C:\\"+ excelPathP + excelNameP);
  17. 	        in = new FileInputStream(file);
  18. 	        // 设置响应正文的MIME类型
  19. 	        response.setContentType("application/octet-stream;charset=UTF-8");
  20. 	        String fileName = new String(excelNameP.getBytes("gb2312"), "iso8859-1");
  21. 	        response.setHeader("Content-disposition", "attachment;filename=" + fileName);
  22. 	        // 把本地文件发送给客户端
  23. 	        out = response.getOutputStream();
  24. 	        int byteRead = 0;
  25. 	        byte[] buffer = new byte[512];
  26. 	        while ((byteRead = in.read(buffer)) != -1) {
  27. 	            out.write(buffer, 0, byteRead);
  28. 	        }
  29. 	        in.close();
  30. 	        out.flush();
  31. 	        out.close();
  32. 		} catch (Exception e) {
  33.             e.printStackTrace();
  34.             logger.error("文件下载出现异常", e); 
  35.         } 
  36. 	}

生成Excel的工具类

  1. package com.cyl.util;
  2.  
  3. import java.awt.image.BufferedImage;
  4. import java.io.ByteArrayOutputStream;
  5. import java.io.File;
  6. import java.io.FileNotFoundException;
  7. import java.io.FileOutputStream;
  8. import java.io.IOException;
  9. import java.io.UnsupportedEncodingException;
  10. import java.text.SimpleDateFormat;
  11. import java.util.HashMap;
  12. import java.util.List;
  13. import java.util.Map;
  14.  
  15. import javax.imageio.ImageIO;
  16. import javax.servlet.ServletContext;
  17.  
  18. import org.apache.commons.lang3.StringUtils;
  19. import org.apache.log4j.Logger;
  20. import org.apache.poi.ss.usermodel.Cell;
  21. import org.apache.poi.ss.usermodel.CellStyle;
  22. import org.apache.poi.ss.util.CellRangeAddress;
  23. import org.apache.poi.ss.util.RegionUtil;
  24. import org.apache.poi.xssf.usermodel.XSSFCellStyle;
  25. import org.apache.poi.xssf.usermodel.XSSFClientAnchor;
  26. import org.apache.poi.xssf.usermodel.XSSFDrawing;
  27. import org.apache.poi.xssf.usermodel.XSSFFont;
  28. import org.apache.poi.xssf.usermodel.XSSFRow;
  29. import org.apache.poi.xssf.usermodel.XSSFSheet;
  30. import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  31.  
  32. import com.cyl.model.ljCheckBodyTarget;
  33. import com.cyl.model.ljCheckInstanceM;
  34.  
  35. public class ExportExcelUtil {
  36.  
  37. 	private static Logger log = Logger.getLogger(ExportExcelUtil.class);
  38. 	
  39. 	/**
  40. 	 * 导出Excel
  41. 	 * @param context 上下文会话对象
  42. 	 * @param dicument 生成文件的目錄文件名,參數為空時默認為excel
  43. 	 * @param ljListInfo 类数据集
  44. 	 * @param ljListPhoto 类数据集-图片地址
  45. 	 * @param sheetName sheet名称
  46. 	 * @param title 标题
  47. 	 * @return
  48. 	 * @throws UnsupportedEncodingException 
  49. 	 */
  50. 	public static Map<String, String> excleDownload(ServletContext context, String dicument,
  51. 			List<ljCheckInstanceM> ljListInfo, List<ljCheckInstanceM> ljListPhoto) {
  52.  
  53. 		Map<String, String> result = new HashMap<String, String>();
  54. 		//创建工作薄
  55. 		XSSFWorkbook wb = new XSSFWorkbook();
  56. 		//创建表格
  57. 		XSSFSheet sheet = wb.createSheet();
  58. 		//设置列宽
  59. 		sheet.setColumnWidth(0,4000);
  60. 		sheet.setColumnWidth(1,5500);
  61. 		sheet.setColumnWidth(2,5700);
  62. 		sheet.setColumnWidth(3,5700);
  63. 		sheet.setColumnWidth(4,3500);
  64. 		sheet.setColumnWidth(5,3500);
  65. 		sheet.setColumnWidth(6,3500);
  66. 		sheet.setColumnWidth(7,3500);
  67. 		sheet.setColumnWidth(8,3500);
  68. 		sheet.setColumnWidth(9,3500);
  69. 		/*************边框、居中、加粗、仿宋用于 标题样式********************/ 
  70. 		//创建样式1
  71.         XSSFCellStyle style = wb.createCellStyle();
  72.         //设置背景色
  73.         style.setFillForegroundColor((short)71);//浅蓝色
  74.         style.setFillPattern(XSSFCellStyle.SOLID_FOREGROUND);
  75.         //设置边框样式
  76.         style.setBorderBottom(CellStyle.BORDER_THIN);
  77.         style.setBorderLeft(CellStyle.BORDER_THIN);
  78.         style.setBorderRight(CellStyle.BORDER_THIN);
  79.         style.setBorderTop(CellStyle.BORDER_THIN);
  80.         // 指定单元格居中对齐     
  81.         style.setAlignment(XSSFCellStyle.ALIGN_CENTER);     
  82.         // 指定单元格垂直居中对齐     
  83.         style.setVerticalAlignment(XSSFCellStyle.VERTICAL_CENTER);
  84.         //设置字体
  85.   		XSSFFont font = wb.createFont();  
  86.   		font.setFontName("仿宋_GB2312");//设置字体样式
  87.   		font.setColor((short)1);//设置字体颜色
  88.   		font.setBoldweight(XSSFFont.BOLDWEIGHT_BOLD);//粗体显示  
  89.   		font.setFontHeightInPoints((short) 12); 
  90.   		style.setFont(font);//选择需要用到的字体格式
  91.   		/****************结束******************/
  92.   		
  93. 		/*************边框、居中、加粗、仿宋用于 副标题样式********************/
  94. 		//创建样式1
  95.         XSSFCellStyle style1 = wb.createCellStyle();
  96.         //设置样式
  97.         style1.setBorderBottom(CellStyle.BORDER_THIN);
  98.         style1.setBorderLeft(CellStyle.BORDER_THIN);
  99.         style1.setBorderRight(CellStyle.BORDER_THIN);
  100.         style1.setBorderTop(CellStyle.BORDER_THIN);
  101.         // 指定单元格居中对齐     
  102.         style1.setAlignment(XSSFCellStyle.ALIGN_CENTER);     
  103.         // 指定单元格垂直居中对齐     
  104.         style1.setVerticalAlignment(XSSFCellStyle.VERTICAL_CENTER);
  105.         //设置字体
  106.   		XSSFFont font1 = wb.createFont();  
  107.   		font1.setFontName("仿宋_GB2312");
  108.   		font1.setBoldweight(XSSFFont.BOLDWEIGHT_BOLD);//粗体显示  
  109.   		font1.setFontHeightInPoints((short) 12); 
  110.   		style1.setFont(font1);//选择需要用到的字体格式
  111.   		/****************结束******************/
  112.   		
  113.   		/****************用于内容设置样式******************/
  114.         XSSFCellStyle style2 = wb.createCellStyle();//创建样式2
  115.         
  116.         style2.setBorderBottom(CellStyle.BORDER_THIN);
  117.         style2.setBorderLeft(CellStyle.BORDER_THIN);
  118.         style2.setBorderRight(CellStyle.BORDER_THIN);
  119.         style2.setBorderTop(CellStyle.BORDER_THIN);
  120.         style2.setAlignment(XSSFCellStyle.ALIGN_CENTER); // 指定单元格居中对齐         
  121.         style2.setVerticalAlignment(XSSFCellStyle.VERTICAL_CENTER);// 指定单元格垂直居中对齐 
  122.         style2.setWrapText(true);//自动换行
  123.         //设置字体
  124.   		XSSFFont font2 = wb.createFont();  
  125.   		font2.setFontName("仿宋_GB2312");
  126.   		font2.setFontHeightInPoints((short) 12); 
  127.   		style2.setFont(font2);//选择需要用到的字体格式
  128.   		/****************结束******************/
  129.   		
  130.   		/****************用于内容设置样式3******************/
  131.         XSSFCellStyle style3 = wb.createCellStyle();//创建样式2
  132.         style3.setFillForegroundColor((short)70);//浅灰色 颜色参考地址 https://blog.csdn.net/w779050550/article/details/81094221
  133.         style3.setFillPattern(XSSFCellStyle.SOLID_FOREGROUND);
  134.         style3.setBorderBottom(CellStyle.BORDER_THIN);//设置边框
  135.         style3.setBorderLeft(CellStyle.BORDER_THIN);
  136.         style3.setBorderRight(CellStyle.BORDER_THIN);
  137.         style3.setBorderTop(CellStyle.BORDER_THIN);
  138.         style3.setAlignment(XSSFCellStyle.ALIGN_CENTER); // 指定单元格居中对齐         
  139.         style3.setVerticalAlignment(XSSFCellStyle.VERTICAL_CENTER);// 指定单元格垂直居中对齐
  140.         //设置字体
  141.   		XSSFFont font3 = wb.createFont();  
  142.   		font3.setFontName("仿宋_GB2312");
  143.   		font3.setFontHeightInPoints((short) 12); 
  144.   		style3.setFont(font3);//选择需要用到的字体格式
  145.   		/****************结束******************/
  146.   		
  147.         //行
  148. 		XSSFRow row = null;
  149. 		FileOutputStream out = null;
  150. 		String fileName = TUtil.format("yyyy_MM_dd_HHmmssSSSSSS");
  151. 		// 日期格式转为字符串输出
  152. 		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  153. 		
  154. 		String filePath = null;//路径
  155. 		CellRangeAddress region = null;//合并单元格
  156. 		Cell cell = null;
  157. 		
  158. 		BufferedImage bufferImg = null;
  159. 	    int index = 1;//序号计数
  160. 	    
  161. 		try {
  162. 			row = sheet.createRow(0);//Excel表格第一行
  163. 			cell = row.createCell(0);
  164. 			cell.setCellStyle(style);
  165. 			cell.setCellValue("详细信息");
  166. 			//合并单元格  first row last row first column last column
  167. 			region = new CellRangeAddress(0, 0, 0, 8 );
  168. 			sheet.addMergedRegion(region);
  169. 			setBorderStyle(XSSFCellStyle.BORDER_THIN, region, sheet, wb);   //给合并过的单元格加边框
  170. 			Map<String, Object>  needmegMap =  new  HashMap<String,Object>();//为了大项合并，name标记大项值，firstRow标记在Excel中的行号
  171. 			Map<String, Object>  needmegMapSub =  new  HashMap<String,Object>();//为了子项合并，name标记大项值，firstRow标记在Excel中的行号
  172. 			
  173. 			for (int i = 0; i < ljListInfo.size(); i++) {
  174. 				ljCheckInstanceM data = ljListInfo.get(i);
  175. 				if (i == 0) {
  176. 					//为了合并大项  初始化标记的map
  177. 					needmegMap.put("firstRow", i + 3);//firstRow标记在Excel中的行号
  178. 					needmegMap.put("name", "");//name标记大项值
  179. 					
  180. 					needmegMapSub.put("firstRow", i + 3);//firstRow标记在Excel中的行号
  181. 					needmegMapSub.put("name", "");//name标记子项值
  182. 					
  183. 					
  184. 					fileName += "_"+ data.getSignature();//以时间+小区(单位)名为文件名
  185. 					fileName += ".xlsx";
  186. 					row = sheet.createRow(1);//Excel表格第二行
  187. 					
  188. 					cell = row.createCell(0);
  189. 					cell.setCellStyle(style1);
  190. 					cell.setCellValue("镇/街道");
  191. 					
  192. 					cell = row.createCell(1);
  193. 					cell.setCellStyle(style2);
  194. 					cell.setCellValue(data.getAttr1());
  195. 					
  196. 					cell = row.createCell(2);
  197. 					cell.setCellStyle(style1);
  198. 					cell.setCellValue("小区(单位)名");
  199. 					
  200. 					cell = row.createCell(3);
  201. 					cell.setCellStyle(style2);
  202. 					cell.setCellValue(data.getSignature());
  203. 					
  204. 					cell = row.createCell(4);
  205. 					cell.setCellStyle(style1);
  206. 					cell.setCellValue("总得分");
  207. 					region = new CellRangeAddress(1, 1, 4, 5 );
  208. 					sheet.addMergedRegion(region);
  209. 					setBorderStyle(XSSFCellStyle.BORDER_THIN, region, sheet, wb);   //给合并过的单元格加边框
  210. 					
  211. 					cell = row.createCell(6);
  212. 					cell.setCellStyle(style2);
  213. 					cell.setCellValue(data.getTotalScore());
  214. 					
  215. 					cell = row.createCell(7);
  216. 					cell.setCellStyle(style1);
  217. 					cell.setCellValue("检查日期");
  218. 					
  219. 					String endTIme = sdf.format(data.getCheckDate());
  220. 					cell = row.createCell(8);
  221. 					cell.setCellStyle(style2);
  222. 					cell.setCellValue(endTIme);
  223. 					
  224. 					row = sheet.createRow(2);//Excel表格第三行
  225. 					cell = row.createCell(0);
  226. 					cell.setCellStyle(style1);
  227. 					cell.setCellValue("序号");
  228. 					
  229. 					cell = row.createCell(1);
  230. 					cell.setCellStyle(style1);
  231. 					cell.setCellValue("检查内容");
  232. 					
  233. 					cell = row.createCell(2);
  234. 					cell.setCellStyle(style1);
  235. 					cell.setCellValue("检查子项");
  236. 					
  237. 					cell = row.createCell(3);
  238. 					cell.setCellStyle(style1);
  239. 					cell.setCellValue("指标");
  240. 					
  241. 					cell = row.createCell(4);
  242. 					cell.setCellStyle(style1);
  243. 					cell.setCellValue("评分");
  244. 					
  245. 					cell = row.createCell(5);
  246. 					cell.setCellStyle(style1);
  247. 					cell.setCellValue("说明");
  248. 					
  249. 					cell = row.createCell(6);
  250. 					cell.setCellStyle(style1);
  251. 					cell.setCellValue("图片");
  252. 					region = new CellRangeAddress(2, 2, 6, 8);
  253. 					sheet.addMergedRegion(region);
  254. 					setBorderStyle(XSSFCellStyle.BORDER_THIN, region, sheet, wb);   //给合并过的单元格加边框
  255. 				}
  256. 				
  257. 				if(i == 0 || i > 0){
  258. 					
  259. 					row = sheet.createRow(i + 3);//动态创建第四行...N行
  260. 					
  261. 					//检查内容 大项合并行
  262. 					cell = row.createCell(1);
  263. 					cell.setCellStyle(style2);
  264. 					cell.setCellValue(data.getAttr2());
  265. 					
  266. 					if (!needmegMap.get("name").equals(data.getAttr2())) {
  267. 						cell = row.createCell(0);
  268. 						cell.setCellStyle(style2);
  269. 						cell.setCellValue(index++);
  270. 						if (!needmegMap.get("name").equals("")) {
  271. 							region = new CellRangeAddress((int) needmegMap.get("firstRow"), i + 3 - 1, 0, 0);//合并单元格(开始行，结束行，开始列，结束列)
  272. 							sheet.addMergedRegion(region);
  273. 							region = new CellRangeAddress((int) needmegMap.get("firstRow"), i + 3 - 1, 1, 1);
  274. 							sheet.addMergedRegion(region);
  275. 							setBorderStyle(XSSFCellStyle.BORDER_THIN, region, sheet, wb);   //给合并过的单元格加边框
  276. 						}
  277. 						needmegMap.put("firstRow", i + 3);
  278. 						needmegMap.put("name", data.getAttr2());
  279. 					}
  280. 					
  281. 					if (i == ljListInfo.size() - 1) {//最后一个合并
  282. 						if (!needmegMap.get("name").equals("")) {
  283. 							region = new CellRangeAddress((int) needmegMap.get("firstRow"), ljListInfo.size() + 2, 0, 0);
  284. 							sheet.addMergedRegion(region);
  285. 							setBorderStyle(XSSFCellStyle.BORDER_THIN, region, sheet, wb);   //给合并过的单元格加边框
  286. 							region = new CellRangeAddress((int) needmegMap.get("firstRow"), ljListInfo.size() + 2, 1, 1);
  287. 							sheet.addMergedRegion(region);
  288. 							setBorderStyle(XSSFCellStyle.BORDER_THIN, region, sheet, wb);   //给合并过的单元格加边框
  289. 						}
  290. 					}
  291. 					
  292. 					cell = row.createCell(2);
  293. 					cell.setCellStyle(style2);
  294. 					cell.setCellValue(data.getAttr3());
  295. 					
  296. 					if (!needmegMapSub.get("name").equals(data.getAttr3())) {
  297. 						if (!needmegMapSub.get("name").equals("")) {
  298. 							region = new CellRangeAddress((int) needmegMapSub.get("firstRow"), i + 3 - 1, 2, 2);
  299. 							sheet.addMergedRegion(region);
  300. 							setBorderStyle(XSSFCellStyle.BORDER_THIN, region, sheet, wb);   //给合并过的单元格加边框
  301. 						}
  302. 						needmegMapSub.put("firstRow", i + 3);
  303. 						needmegMapSub.put("name", data.getAttr3());
  304. 					}
  305. 					
  306. 					if (i == ljListInfo.size() - 1) {//最后一个合并
  307. 						if (!needmegMapSub.get("name").equals("")) {
  308. 							region = new CellRangeAddress((int) needmegMapSub.get("firstRow"), ljListInfo.size() + 2, 2, 2);
  309. 							sheet.addMergedRegion(region);
  310. 							setBorderStyle(XSSFCellStyle.BORDER_THIN, region, sheet, wb);   //给合并过的单元格加边框
  311. 						}
  312. 					}
  313. 					
  314. 					cell = row.createCell(3);
  315. 					cell.setCellStyle(style2);
  316. 					cell.setCellValue(data.getAttr4());
  317. 					
  318. 					cell = row.createCell(4);
  319. 					cell.setCellValue(data.getsScore());
  320. 					double sScore = data.getStandardScore();
  321. 					double Score = data.getsScore();
  322. 					if (sScore > Score) {
  323. 						cell.setCellStyle(style3);
  324. 					}else {
  325. 						cell.setCellStyle(style2);
  326. 					}
  327. 					
  328. 					cell = row.createCell(5);
  329. 					cell.setCellStyle(style2);
  330. 					cell.setCellValue(data.getSignature2());
  331. 					
  332. 					cell = row.createCell(6);
  333. 					cell.setCellStyle(style2);
  334. 					
  335. 					cell = row.createCell(7);
  336. 					cell.setCellStyle(style2);
  337. 					
  338. 					cell = row.createCell(8);
  339. 					cell.setCellStyle(style2);
  340. 					
  341. 				}
  342. 				if (data.getAttr6() != null) {
  343. 					int col = 6;//记录当前开始列
  344. 					for (int j = 0; j < ljListPhoto.size(); j++) {
  345. 						ljCheckInstanceM dataPh = ljListPhoto.get(j);
  346. 						if (data.getAttr6().equals(dataPh.getAttr2())) {
  347. 							row.setHeight((short)1500);//设置行高度
  348. 							// 先把读进来的图片放到一个ByteArrayOutputStream中，以便产生ByteArray
  349. 							ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
  350. 							try {
  351. 								String file = "C:\\" + dataPh.getAttr4();//获取地址
  352. 								bufferImg = ImageIO.read(new File(file));
  353. 								ImageIO.write(bufferImg, "png", byteArrayOut);
  354. 							} catch (IOException e) {
  355. 								//e.printStackTrace();
  356. 								continue;
  357. 							}
  358. 							XSSFDrawing patriarch = sheet.createDrawingPatriarch();
  359. 							XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 0, 0, col, i + 3, col + 1, i + 4);
  360. 							// 插入图片
  361. 							patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), XSSFWorkbook.PICTURE_TYPE_JPEG));
  362. 							sheet.setColumnWidth(col, 256 * 20);//列宽
  363. 							col++;
  364. 						}
  365. 					}
  366. 				}
  367. 			}
  368. 			String relpath = (StringUtils.isBlank(dicument) ? "excel" : dicument) + "/";
  369. 			filePath = "C:\\" + relpath;// 文件存放路径
  370. 			File fileDir = new File(filePath);
  371. 			if (!(fileDir.exists() && fileDir.isDirectory())) {
  372. 				new File(filePath).mkdirs();
  373. 			}
  374. 			result.put("path", relpath);
  375. 			result.put("name", fileName);
  376. 			out = new FileOutputStream(filePath + fileName);
  377. 			wb.write(out);
  378. 		} catch (FileNotFoundException e) {
  379. 			e.printStackTrace();
  380. 			log.error(e.getMessage());
  381. 		} catch (IOException e) {
  382. 			e.printStackTrace();
  383. 			log.error(e.getMessage());
  384. 		} finally {
  385. 			try {
  386. 				if (out != null)
  387. 					out.close();
  388. 			} catch (IOException e) {
  389. 				e.printStackTrace();
  390. 			}
  391. 		}
  392. 		return result;// 返回下载结果
  393.     }
  394. 	
  395.     //解决合并单元格边框显示不完整的问题
  396. 	public static void setBorderStyle(int border, CellRangeAddress region, XSSFSheet sheet, XSSFWorkbook wb){
  397.         RegionUtil.setBorderBottom(border, region, sheet, wb); //下边框
  398.         RegionUtil.setBorderLeft(border, region, sheet, wb);     //左边框
  399.         RegionUtil.setBorderRight(border, region, sheet, wb);    //右边框
  400.         RegionUtil.setBorderTop(border, region, sheet, wb);      //上边框
  401.     }
  402. }

基础类

  1. package com.cyl.util;
  2.  
  3. import java.io.BufferedReader;
  4. import java.io.File;
  5. import java.io.IOException;
  6. import java.io.InputStream;
  7. import java.io.InputStreamReader;
  8. import java.text.ParseException;
  9. import java.text.SimpleDateFormat;
  10. import java.util.Calendar;
  11. import java.util.Date;
  12. import java.util.HashSet;
  13. import java.util.List;
  14. import java.util.StringTokenizer;
  15.  
  16. import org.apache.log4j.Logger;
  17.  
  18. /**
  19.  * 基础类
  20.  * 
  21.  * @author Qiang1_Zhang
  22.  */
  23. public class TUtil {
  24. 	static Logger log = Logger.getLogger(TUtil.class);
  25.  
  26. 	/**
  27. 	 * 日期转换函数
  28. 	 * 
  29. 	 * @param format
  30. 	 *            需要转换的格式
  31. 	 * @return 转换后的日期
  32. 	 */
  33. 	public static String format(String format) {
  34.  
  35. 		return new SimpleDateFormat(format).format(new Date());
  36. 	}
  37.  
  38. 	/**
  39. 	 * 日期转换函数
  40. 	 * 
  41. 	 * @param format
  42. 	 *            需要转换的格式
  43. 	 * @return 转换后的日期
  44. 	 */
  45. 	public static String format(Date date, String format) {
  46. 		return new SimpleDateFormat(format).format(date);
  47. 	}
  48.  
  49. 	/**
  50. 	 * 打印函数
  51. 	 * 
  52. 	 * @param str
  53. 	 *            对象类型
  54. 	 */
  55. 	public static void print(Object str) {
  56. 		System.out.println(str);
  57. 	}
  58.  
  59. 	/**
  60. 	 * 计算距今指定天数的日期
  61. 	 * 
  62. 	 * @param day
  63. 	 *            相差的天数，可为负数
  64. 	 * @return 计算之后的日期
  65. 	 */
  66. 	public static String GetDay(int day) {
  67. 		Calendar cal = Calendar.getInstance();
  68. 		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  69. 		cal.setTime(new Date());// 设置日历时间
  70. 		cal.add(Calendar.DAY_OF_MONTH, day);// 天数
  71. 		String strDate = sdf.format(cal.getTime());// 得到你想要的天数
  72.  
  73. 		return strDate;
  74. 	}
  75.  
  76. 	/**
  77. 	 * 获取报表模板路径
  78. 	 * 
  79. 	 * @return
  80. 	 */
  81. 	public static String getURL() {
  82. 		String dir = System.getProperty("user.dir");
  83. 		print("dir=" + dir);
  84. 		dir = dir.substring(0, dir.lastIndexOf("\\"));
  85. 		String filePath = dir;
  86. 		return filePath;
  87. 	}
  88.  
  89. 	/**
  90. 	 * String类型日期转换为长整型
  91. 	 * 
  92. 	 * @param date
  93. 	 *            String类型日期
  94. 	 * @param format
  95. 	 *            日期格式
  96. 	 * @return long
  97. 	 */
  98. 	public static long strDateToLong(String date, String... format) {
  99. 		String format1 = null;
  100. 		if (format.length != 0) {
  101. 			format1 = format[0];
  102. 		} else {
  103. 			format1 = "yyyy-MM-dd HH:mm:ss";
  104. 		}
  105. 		String sDt = date;
  106. 		SimpleDateFormat sdf = new SimpleDateFormat(format1);
  107. 		long lTime = 0;
  108. 		try {
  109. 			Date dt2 = sdf.parse(sDt);
  110. 			lTime = dt2.getTime();
  111. 			print(lTime);
  112. 		} catch (ParseException e) {
  113. 			e.printStackTrace();
  114. 		}
  115. 		return lTime;
  116. 	}
  117.  
  118. 	public static void longToString(long l) {
  119. 		format("");
  120. 	}
  121.  
  122. 	/**
  123. 	 * 获取文件创建时间
  124. 	 * 
  125. 	 * @param file
  126. 	 *            文件目录
  127. 	 */
  128. 	public static String getCreateTime(File file) {
  129. 		// file = new File("e:/1.xls");
  130. 		String date = "";
  131. 		// file.lastModified();
  132. 		try {
  133. 			Process process = Runtime.getRuntime().exec(
  134. 					"cmd.exe /c dir " + file.getAbsolutePath() + "/tc");
  135. 			InputStream is = process.getInputStream();
  136. 			BufferedReader br = new BufferedReader(new InputStreamReader(is));
  137. 			for (int i = 0; i < 5; i++) {// 前五行是其他的信息
  138. 				br.readLine();
  139. 			}
  140. 			String createDateLine = br.readLine();
  141. 			StringTokenizer tokenizer = new StringTokenizer(createDateLine);
  142. 			date = tokenizer.nextToken() + " " + tokenizer.nextToken();
  143. 			br.close();
  144. 			// print(date);
  145. 		} catch (IOException e) {
  146. 			log.error("" + e.getMessage());
  147. 		}
  148. 		return date;
  149. 	}
  150.  
  151. 	/**
  152. 	 * 获取文件最后修改时间
  153. 	 * 
  154. 	 * @param filePath
  155. 	 *            文件目录
  156. 	 */
  157. 	public static void getLastModifyTime(File filePath) {
  158. 		filePath = new File(
  159. 				"\\\\10.131.18.8\\rt3生產機種\\ProductionReprot\\TraceAlterReprot-reprot");
  160. 		File[] list = filePath.listFiles();
  161. 		// for(File file : list){
  162. 		// print(file.getAbsolutePath()+"\tcreate time:"+getCreateTime(file));
  163. 		// }
  164. 		for (File file : list) {
  165. 			Date date = new Date(file.lastModified());
  166. 			print(format(date, "yyyy-MM-dd"));
  167. 		}
  168. 	}
  169.  
  170. 	public static void getFile() {
  171. 		String root = "\\\\10.131.18.8\\rt3生產機種\\ProductionReprot";
  172. 		File filePath = new File(root);
  173. 		File[] list = filePath.listFiles();
  174. 		for (File file : list) {
  175. 			print(file.getName()
  176. 					+ "\t"
  177. 					+ new File(file.getAbsolutePath() + "\\"
  178. 							+ TUtil.format("yyyy-MM-dd") + ".xls").exists());
  179. 		}
  180. 	}
  181.  
  182. 	static void test() {
  183. 		String today = TUtil.format("yyyy-MM-dd");
  184. 		String dest = ReadProperties.ReadProprety("server.report.path")
  185. 				+ "TraceAlterReprot-reprot" + "\\" + today + "\\";
  186. 		print(dest);
  187. 		File dir = new File(dest);// 创建当天目录
  188. 		if (!dir.exists()) {
  189. 			dir.mkdir();
  190. 		}
  191. 	}
  192.  
  193. 	public static void getTimeDifference() {
  194. 		try {
  195. 			Date d1 = new SimpleDateFormat("yyyy-MM-dd").parse("2014-09-15");
  196.  
  197. 			Date d2 = new SimpleDateFormat("yyyy-MM-dd").parse("2014-09-14");
  198. 			print((d2.getTime() - d1.getTime()) / 1000 / 60 / 60 / 24);
  199. 		} catch (ParseException e) {
  200. 			e.printStackTrace();
  201. 		}
  202. 	}
  203.  
  204. 	public List<String> distinctList(List<String> list) {
  205. 		HashSet<String> h = new HashSet<String>(list);
  206. 		list.clear();
  207. 		list.addAll(h);
  208. 		return list;
  209. 	}
  210. 	
  211. 	public List<Object> removeDuplicate(List<Object> list) {
  212. 		HashSet<Object> h = new HashSet<Object>(list);
  213. 		list.clear();
  214. 		list.addAll(h);
  215. 		return list;
  216. 	}
  217. 	
  218. 	/**
  219. 	 * 获取四舍五入的整数
  220. 	 * @param input 乘数
  221. 	 * @param rate 比率
  222. 	 * @return 取整后的结果
  223. 	 */
  224. 	public double getRound(int input,double rate){
  225. 		double tmp = input * rate;
  226. 		return Math.round(tmp);
  227. 	}
  228. 	
  229. 	/**
  230. 	 * 获取四舍五入的整数
  231. 	 * @param input 乘数
  232. 	 * @param rate 比率
  233. 	 * @return 取整后的结果
  234. 	 */
  235. 	public double ceil(int input,double rate){
  236. 		double tmp = input * rate;
  237. 		return Math.ceil(tmp);
  238. 	}
  239. }

前端

  1. /* 我这里是动态拼接的,摘取下载按钮那一条，仅供参考 */
  2. ...省略
  3. str +=  "<a class='btt btn-link' data-title='详细信息'  onclick = 'excleDownload("+ data[i].id +")' href='javascript:;'><i class='Hui-iconfont'>&#xe641;</i> 下载</a>";
  4. ...省略
  5.  
  6.  
  7.  
  8. //方法
  9. //下载文件
  10. function excleDownload(id) {
  11. 	window.location.href = "<%=basePath%>inspection/excleDownload.cyl?id="+ id;
  12. }

 

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/Li_阴宅/article/detail/842504
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号