• 使用FreeMarker导出word文档(支持循环导出实时多张图片)

    续上一期的更新内容  ，导出的是单张图片，直接在路径的src  里面填写对应的占位符，就可以了，随着需求的变化，那么今天我们继续往下写一个循环导出多张图片到word里面。

    使用FreeMarker导出word文档(支持导出单张图片)

    首先我们需要进行在word 里面把对应的模版设置好。

    设置好点击另存为，目前我用的html 格式的，网上也有很多xml  形式的，每种写法还不一样

    接着我们用记事本进行打开，第一步一定要先修改编码格式为utf-8的

    然后我们将html 中head中的标签全部，如果编码不修改，head标签不删除，将来导出的时候就是乱码，这个坑是很深的，排查了好长时间才解决。

    这些都修改好后，我们点击另存为将这个模版改成后缀为ftl形式的

    接下来我们就开始编写代码

    1. 	@Override
    2. 	public void exporttdYsdWord(HttpServletRequest request,
    3. 			HttpServletResponse response, String objId, String gllx) {
    4. 		List<Map<String, String>> list = null;
    5. 		List<Map<String, String>> list3 = null;
    6. 		List<Map<String, String>> list5 = null;
    7. 		String ysdName = "";
    8. 		String ysdSql = "";
    9. 		String zpSql = "";
    10. 		String sdsgfa = "";
    11. 		String ysgjjd = "";
    12. 		String sdsgfaEname = "";
    13. 		if ("0".equals(gllx)) {
    14. 			sdsgfa = "sdsgfa";
    15. 			ysgjjd = "ysgjjd";
    16. 			sdsgfaEname = "sczbjys_sczbjys_sdsgfa";
    17. 			ysdName = "中间环节验收报告";
    18. 			ysdSql = "select t.gcmc,t.jgdw,t.jgdwfzr,t.jgdwfzrdh,"
    19. 						+ "t.tdsgdw,t.tdsgdwlxr,t.tdsgdwlxrdh,to_char(t.sqyssj,'yyyy-MM-dd') sqyssj,"
    20. 						+ "t.czwt,  (select a.username from gw_yhgl_user a where a.id = t.yxbzrm) yxbzrm, (select h.value  from gw_limit_enums h  where h.enumName like '%sczbjys_sczbjys_yxbz%' and h.key = t.yxbz) yxbz,(select t.value from   gw_limit_enums t   where   t.enumName like '%sczbjys_sczbjys_ysgjjd%'  and t.key=ysgjjd)  ysgjjd from GW_SCZBJYS_ZLC t where t.OBJ_ID = ?";
    21. 		}
    22. 		list = this.hibernateDao
    23. 				.queryForListWithSql(ysdSql,new String[]{objId});
    24.  
    25. 		Map<String, String> map0 = new HashMap<String, String>();
    26. 		Map<String, Object> map = new HashMap<String, Object>();
    27.         StringBuilder sb = new StringBuilder();
    28.         String aa="";
    29. 		zpSql="select   t.ipath ,t.dpt from   gw_pig_address_rw t   where  t.taskid=?   and t.ipath is not   null  and t.dpt='问题照片'  and t.dpt  is not null   and t.ipath   not  like '%dat%'" ;
    30. 				list3 = this.hibernateDao
    31. 				.queryForListWithSql(zpSql,new String[]{objId});
    32. 				
    33. 			String 	zpSqla="select   t.ipath ,t.dpt from   gw_pig_address_rw t   where  t.taskid=?   and t.ipath is not   null   and t.dpt  is not null   and t.ipath   not  like '%dat%'" ;
    34. 				list5 = this.hibernateDao
    35. 				.queryForListWithSql(zpSqla,new String[]{objId});
    36. 				if(list3.size()>0){
    37. 					
    38. 		            for (Map<String, String> stringObjectMap : list3) {
    39. 		                if (stringObjectMap.get("DPT").equals("问题照片")) {
    40. //		                	map.put("PSZP", "" + PlatformConfigUtil.getString("TASK_PIC_ADDRESS") + stringObjectMap.get("IPATH"));
    41. //		                     aa= String.valueOf(sb.append(PlatformConfigUtil.getString("TASK_PIC_ADDRESS")+ stringObjectMap.get("IPATH")).append(","));
    42. //		                	 aa= String.valueOf(sb.append("    src=\""+PlatformConfigUtil.getString("TASK_PIC_ADDRESS") + stringObjectMap.get("IPATH")).append(">").append(","));
    43.  
    44. 		                    aa= String.valueOf(sb.append("249\"  height=\"273\" src=\""+PlatformConfigUtil.getString("TASK_PIC_ADDRESS") + stringObjectMap.get("IPATH")+"\">").append(","));
    45.  
    46. 		                	
    47.  
    48. 		                }
    49. 		            }
    50. 				}else{
    51. 					
    52. 		            for (Map<String, String> stringObjectMap : list5) {
    53. 		                if (!stringObjectMap.get("DPT").equals("问题照片")) {
    54. //		                	map.put("PSZP", "" + PlatformConfigUtil.getString("TASK_PIC_ADDRESS") + stringObjectMap.get("IPATH"));
    55. //		                     aa= String.valueOf(sb.append(PlatformConfigUtil.getString("TASK_PIC_ADDRESS")+ stringObjectMap.get("IPATH")).append(","));
    56. 		        			String   hh="249\"  height=\"273\"  src=\"http://192.168.200.86:18080/XSGL/2023-07-27/20230802155008.jpg\",249\"  height=\"273\"  src=\"http://192.168.200.86:18080/XSGL/2023-07-27/20230802154952.jpg\"";
    57.  
    58. 		                    aa= String.valueOf(sb.append("249\"  height=\"273\" src=\""+PlatformConfigUtil.getString("TASK_PIC_ADDRESS") + stringObjectMap.get("IPATH")+"\">").append(","));
    59.  
    60.  
    61. 		                }
    62. 		            }
    63. 					
    64. 				}
    65. 				
    66. 				if(aa.length()>0){
    67. 				      String a1 = aa.substring(0, aa.length() - 1);
    68. 				      map.put("PSZP", a1);
    69. 				}else{
    70.  
    71. 					if(aa.length()>0){
    72. 						  String a1 = aa.substring(0, aa.length() - 1);
    73. 					      map.put("PSZP", a1);
    74. 					}else{
    75. 					      map.put("PSZP", "");
    76. 					}
    77. 				  
    78. 				}
    79.  
    80.  
    81. 		if (!Tool.isEmptyList(list)) {
    82. 			map0 = list.get(0);
    83. 			if (Tool.isEmptyStr(map0.get("gcmc"))) {
    84. 				map.put("GCMC", "");
    85. 			} else {
    86. 				map.put("GCMC", map0.get("gcmc"));
    87. 			}
    88. 			if (Tool.isEmptyStr(map0.get("jgdw"))) {
    89. 				map.put("JGDW", "");
    90. 			} else {
    91. 				map.put("JGDW",
    92. 						getEnumsValueFromEnumDB("sczbjys_sczbjys_jgdw",map0.get("jgdw")));
    93. 			}
    94.  
    95. 			if (Tool.isEmptyStr(map0.get("tdsgdw"))) {
    96. 				map.put("TDSGDW", "");
    97. 			} else {
    98. 				map.put("TDSGDW", map0.get("tdsgdw"));
    99. 			}
    100. 			if (Tool.isEmptyStr(map0.get("tdsgdwlxr"))) {
    101. 				map.put("TDSGDWLXR", "");
    102. 			} else {
    103. 				map.put("TDSGDWLXR", map0.get("tdsgdwlxr"));
    104. 			}
    105. 			if (Tool.isEmptyStr(map0.get("tdsgdwlxrdh"))) {
    106. 				map.put("TDSGDWLXRDH", "");
    107. 			} else {
    108. 				map.put("TDSGDWLXRDH", map0.get("tdsgdwlxrdh"));
    109. 			}
    110. 			if (Tool.isEmptyStr(map0.get("yxbz"))) {
    111. 				map.put("YXBZ", "");
    112. 			} else {
    113. 				map.put("YXBZ", map0.get("yxbz"));
    114. 			}
    115. 			if (Tool.isEmptyStr(map0.get("yxbzrm"))) {
    116. 				map.put("YXBZRM", "");
    117. 			} else {
    118. 				map.put("YXBZRM", map0.get("yxbzrm"));
    119. 			}
    120. 			
    121. 			if (Tool.isEmptyStr(map0.get("ysgjjd"))) {
    122. 				map.put("YSGJJD", "");
    123. 			} else {
    124. 				map.put("YSGJJD", map0.get("ysgjjd"));
    125. 			}
    126. 			if (Tool.isEmptyStr(map0.get("sqyssj"))) {
    127. 				map.put("SQYSSJ", "");
    128. 			} else {
    129. 				SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
    130. 				String string = map0.get("sqyssj"); 
    131. 				Date parse = null;
    132. 				try {
    133. 					parse = simpleDateFormat.parse(string);
    134. 				} catch (ParseException e) {
    135. 					// TODO Auto-generated catch block
    136. 					e.printStackTrace();
    137. 				}
    138. 			String format = simpleDateFormat.format(parse);
    139. 	        StringBuilder myName = new StringBuilder(format);
    140. 	        myName.setCharAt(4, '年');
    141. 	        myName.setCharAt(7, '月');
    142. 	        myName.append("日");
    143.  
    144. 	        System.out.println(myName);
    145. //  时间变成 年月日形式
    146. 				map.put("SQYSSJ", myName.toString());
    147. 			}
    148. 			if (Tool.isEmptyStr(map0.get("czwt"))) {
    149. 				map.put("CZWT", "");
    150. 			} else {
    151. 				map.put("CZWT", map0.get("czwt"));
    152. 			}
    153. 			map.put("SJDW", "设计单位");
    154. 			map.put("JLDW", "监理");
    155. 			map.put("BD", "121");
    156. 			map.put("SDJG", "结构好");
    157. 			map.put("CD", "长度1");
    158. 			map.put("JCJ", "井口1");
    159. 			
    160. 			String   hh="249\"  height=\"273\"  src=\"http://192.168.200.86:18080/XSGL/2023-07-27/20230802155008.jpg\",249\"  height=\"273\"  src=\"http://192.168.200.86:18080/XSGL/2023-07-27/20230802154952.jpg\"";
    161. 			map.put("TFT", "");
    162. //			map.put("PSZP", hh);
    163. //			map.put("YSGJJD", "飒飒");
    164. 			
    165. 			
    166. 		} else {
    167.  
    168. 			map.put("SJDW", "");
    169. 			map.put("JLDW", "");
    170. 			map.put("BD", "");
    171. 			map.put("SDJG", "");
    172. 			map.put("CD", "");
    173. 			map.put("JCJ", "");
    174. 			map.put("TFT", "");
    175. 		}
    176. 		try {
    177. 			WordUtils.exportWorde(request, response, map, "scbzjystd.ftl",
    178. 					ysdName);
    179. 		} catch (IOException e) {
    180. 			// TODO Auto-generated catch block
    181. //			e.printStackTrace();
    182. 		}
    183. 	}
    184. }

     

    图片的格式高宽度提前在代码里面设置好，然后我们在模版里面用一个占位符来进行替代就可以了。

     设置下载格式

    1. 	public static void exportWorde(HttpServletRequest request,
    2. 			HttpServletResponse response, Map<String, Object> map,
    3. 			String templateName, String fileName)  throws IOException {
    4. 		String pathString = request.getSession().getServletContext().getRealPath("/WEB-INF/templete/");
    5.     	logger.info("获取到的模板路径是：templetePath------->" + pathString);
    6.     	configuration.setDirectoryForTemplateLoading(new File(pathString));
    7.     	
    8.     	Template freemarkerTemplate = configuration.getTemplate(templateName);
    9.         File file = null;
    10.         InputStream fin = null;
    11.         ServletOutputStream out = null;
    12.         try {
    13.             // 调用工具类的createDoc方法生成Word文档
    14.             file = createDoce(map,freemarkerTemplate);
    15.             fin = new FileInputStream(file);
    16.  
    17.             response.setCharacterEncoding("utf-8");
    18.             response.setContentType("application/msword");
    19.             // 设置浏览器以下载的方式处理该文件名
    20.             fileName = fileName + DateUtil.currentDateToString() + ".doc";
    21.             response.setHeader("Content-Disposition", "attachment;filename="
    22.                     .concat(String.valueOf(URLEncoder.encode(fileName, "UTF-8"))));
    23.  
    24.             out = response.getOutputStream();
    25.             byte[] buffer = new byte[512];  // 缓冲区
    26.             int bytesToRead = -1;
    27.             // 通过循环将读入的Word文件的内容输出到浏览器中
    28.             while((bytesToRead = fin.read(buffer)) != -1) {
    29.                 out.write(buffer, 0, bytesToRead);
    30.             }
    31.         } finally {
    32.             if(fin != null) fin.close();
    33.             if(out != null) out.close();
    34.             if(file != null) file.delete(); // 删除临时文件
    35.         }
    36. 		
    37. 	}

    设置编码：

    1.     private static File createDoce(Map<String, Object> dataMap, Template template) {
    2.         String name =  ".doc";
    3.         File f = new File(name);
    4.         Template t = template;
    5.         try {
    6.             // 这个地方不能使用FileWriter因为需要指定编码类型否则生成的Word文档会因为有无法识别的编码而无法打开
    7.             Writer w = new OutputStreamWriter(new FileOutputStream(f), "utf-8");
    8.             t.process(dataMap, w);
    9.             w.close();
    10.         } catch (Exception ex) {
    11.             ex.printStackTrace();
    12.             throw new RuntimeException(ex);
    13.         }
    14.         return f;
    15.     }

     导出效果

    若本文对你有所帮助，请一键三连，说不定后期工作中就用到了。

  • 相关阅读:
    集合_Collection_LinkedList简述及增删机制源码简析
    【LLM】解析pdf文档生成摘要 | 智能文档概览
    电脑屏幕亮度怎么调节？台式电脑找不到屏幕亮度怎么办
    keil5 compiler6 -o1读取内部flash硬件错误的问题
    JVM的GC算法CMS和G1
    HTML+CSS实现按钮手风琴效果 ｜ 青训营笔记
    DLT645转modbus协议网关采集电表的数据方法
    AI for Security：智能化安全对抗的困境
    HCIP第十三天
    JSP编写自己的第一个WebServlet实现客户端与服务端交互
  • 原文地址：https://blog.csdn.net/m0_59239420/article/details/133900983