java发送邮件-获取包含表格的html内容

Ability Liao

已于 2023-05-06 16:16:42 修改

阅读量709

点赞数

分类专栏： Java开发包文章标签： java 发送邮件表格 html

于 2023-05-04 16:53:06 首次发布

本文链接：https://blog.csdn.net/J_bean/article/details/130490234

版权

Java开发包专栏收录该内容

23 篇文章 0 订阅

订阅专栏

1 依赖

<dependency>
    <groupId>commons-beanutils</groupId>
    <artifactId>commons-beanutils</artifactId>
    <version>1.9.4</version>
</dependency>

2 工具类

/**
 * 获取包含表格的html内容
 * @param titleMap 表头
 * @param propsMap 字段属性
 * @param attachList 表格数据
 * @return
 */
public static String getHtmlContent(Map<String, String[]> titleMap, Map<String, String[]> propsMap, Map<String, List> attachList) {
    if (titleMap.isEmpty() || propsMap.isEmpty() || attachList.isEmpty()) {
        return null;
    }

    StringBuilder stringBuilder = new StringBuilder();
    stringBuilder.append("\r\n");

    stringBuilder.append("<html><head></head><body>");
    for (Map.Entry<String, List> entry : attachList.entrySet()) {
        String tableName = entry.getKey();

        stringBuilder.append("<h3>" + tableName + "</h3>");
        stringBuilder.append("<table border=\"1\" cellspacing=\"0\" style=\"font-family:微软雅黑\">");

        String[] titles = titleMap.get(tableName);
        if (titles == null) {
            log.warn("表头为空。sheetName：{}", tableName);
            stringBuilder.append("表头为空");
            stringBuilder.append("\r\n");
            continue;
        }

        String[] props = propsMap.get(tableName);
        if (props == null) {
            log.warn("属性名称为空。tableName：{}", tableName);
            stringBuilder.append("属性名称为空");
            stringBuilder.append("\r\n");
            continue;
        }

        List list = entry.getValue();
        if (CollectionUtils.isEmpty(list)) {
            log.warn("暂无数据。tableName：{}", tableName);
            stringBuilder.append("暂无数据");
            stringBuilder.append("\r\n");
            continue;
        }

        // 设置表格表头
        stringBuilder.append("<tr style=\"background-color: #428BCA; color:#ffffff\">");
        for (String title : titles) {
            stringBuilder.append("<th width=\"100px\">" + title + "</th>");
        }
        stringBuilder.append("</tr>");

        // 设置表格内容
        for (Object obj : list) {
            stringBuilder.append("</tr>");
            for (String prop : props) {
                try {
                    Object fieldValue = PropertyUtils.getProperty(obj, prop);
                    if (fieldValue == null) {
                        fieldValue = "";
                    }
                    stringBuilder.append("<td style=\"text-align:center\">" + fieldValue + "</td>");
                } catch (Exception e) {
                    log.error("填充列表失败", e);
                }
            }
            stringBuilder.append("</tr>");
        }
        stringBuilder.append("</table>");
        stringBuilder.append("\r\n");
    }

    stringBuilder.append("</body></html>");
    return stringBuilder.toString();
}

3 测试

public static void main(String[] args) {
    List<VerifyResultDto> list4VerifyOverview = new ArrayList<>();
    List<VerifyResultDto> list4Warehouse = new ArrayList<>();

    String[] titles4VerifyOverview = new String[]{"", "总审核次数", "审核通过次数", "审核不通过次数", "审核不通过率"};
    String[] titles4WarehouseVerify = new String[]{"商家", "总审核次数", "审核通过次数", "审核不通过次数", "审核不通过率"};
    String[] props4VerifyNum = new String[]{"desc", "totalVerifyNum", "verifyPassNum", "verifyRefuseNum", "verifyRefuseRatio"};

    // 表头
    Map<String, String[]> titleMap = new HashMap<>();
    titleMap.put("审核数量概览", titles4VerifyOverview);
    titleMap.put("各仓审核数量统计", titles4WarehouseVerify);

    // 字段属性
    Map<String, String[]> propsMap = new HashMap<>();
    propsMap.put("审核数量概览", props4VerifyNum);
    propsMap.put("各仓审核数量统计", props4VerifyNum);

    // 表格数据
    Map<String, List> dataMap = new LinkedHashMap<>();
    dataMap.put("审核数量概览", list4VerifyOverview);
    dataMap.put("各仓审核数量统计", list4Warehouse);

    String htmlContent = getHtmlContent(titleMap, propsMap, dataMap);
}

VerifyResultDto

@Data
public class VerifyResultDto implements Serializable {
    private static final long serialVersionUID = -2391266072403916849L;

    /**
     * 描述
     */
    private String desc;
    /**
     * 总审核次数
     */
    private Long totalVerifyNum;
    /**
     * 审核通过次数
     */
    private Long verifyPassNum;
    /**
     * 审核不通过次数
     */
    private Long verifyRefuseNum;
    /**
     * 审核不通过率
     */
    private String verifyRefuseRatio;

}

4 备注

包含表格的html页面的基本结构

<html><head></head><body>
    <h3>定义标题</h3>
    <table>
     <tr>
      <th>定义表头</th>
     </tr>
    
     <tr>
      <td>定义单元格</td>
     </tr>
    </table>
</body></html>