//建立邮件消息,发送简单邮件和html邮件的区别
MimeMessage mailMessage = mailSender.createMimeMessage();
//true表示启用 multipart模式,不然发送附件会失败,"utf-8"不然中文会乱码
MimeMessageHelper messageHelper = new MimeMessageHelper(mailMessage, true, "utf-8");
//设置收件人,寄件人
messageHelper.setTo(new String[]{"419066357@qq.com","guanxianghui@shhxzq.com"});
messageHelper.setCc("419066357@163.com");
messageHelper.setFrom("guanxianghui@shhxzq.com");
messageHelper.setSubject("测试HTML邮件!");
//true 表示启动HTML格式的邮件
messageHelper.setText("<table width=\"1280\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" style=\"border-collapse:collapse;width:768pt;\">\n"+
"<colgroup><col width=\"303\" style=\"width:182pt;\">\n"+
"<col width=\"113\" style=\"width:68pt;\">\n"+
"<col width=\"115\" style=\"width:69pt;\">\n"+
"<col width=\"370\" style=\"width:222pt;\">\n"+
"<col width=\"75\" style=\"width:45pt;\">\n"+
"<col width=\"303\" style=\"width:182pt;\">\n"+
"</colgroup>\n"+
"<tbody><tr height=\"25\" style=\"height:15pt;\">\n"+
"<td colspan=\"6\" width=\"1280\" align=\"center\" valign=\"bottom\" style=\"width:768pt;height:15pt;text-align:center;background-color:#F4B084;padding-top:1px;padding-right:1px;padding-left:1px;border-width:1px;border-style:solid;border-color:windowtext black windowtext windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;background-color:#F4B084;\">南粤超网代付交易统计[2017年05月]</span></font></td>\n"+
"</tr>\n"+
"<tr height=\"25\" style=\"height:15pt;\">\n"+
"<td align=\"center\" valign=\"bottom\" style=\"height:15pt;text-align:center;background-color:#D9D9D9;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid solid;border-right-width:1px;border-bottom-width:1px;border-left-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;border-left-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;background-color:#D9D9D9;\">总笔数:</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">16</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;background-color:#D9D9D9;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;background-color:#D9D9D9;\">总金额:</span></font></td>\n"+
"<td colspan=\"3\" align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:solid solid solid none;border-top-width:1px;border-right-width:1px;border-bottom-width:1px;border-top-color:windowtext;border-right-color:black;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">87694.37元</span></font></td>\n"+
"</tr>\n"+
"<tr height=\"25\" style=\"height:15pt;\">\n"+
"<td align=\"center\" valign=\"bottom\" style=\"height:15pt;text-align:center;background-color:#D9D9D9;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid solid;border-right-width:1px;border-bottom-width:1px;border-left-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;border-left-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;background-color:#D9D9D9;\">覆盖收款银行:</span></font></td>\n"+
"<td colspan=\"5\" align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:solid solid solid none;border-top-width:1px;border-right-width:1px;border-bottom-width:1px;border-top-color:windowtext;border-right-color:black;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">南粤银行</span></font></td>\n"+
"</tr>\n"+
"<tr height=\"25\" style=\"height:15pt;\">\n"+
"<td colspan=\"6\" valign=\"bottom\" style=\"height:15pt;background-color:#BDD7EE;padding-top:1px;padding-right:1px;padding-left:1px;border-width:1px;border-style:solid;border-color:windowtext black windowtext windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;background-color:#BDD7EE;\">维度一</span></font></td>\n"+
"</tr>\n"+
"<tr height=\"25\" style=\"height:15pt;\">\n"+
"<td align=\"center\" valign=\"bottom\" style=\"height:15pt;text-align:center;background-color:#D9D9D9;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid solid;border-right-width:1px;border-bottom-width:1px;border-left-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;border-left-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;background-color:#D9D9D9;\"><b>结果</b></span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;background-color:#D9D9D9;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;background-color:#D9D9D9;\"><b>笔数</b></span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;background-color:#D9D9D9;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;background-color:#D9D9D9;\"><b>金额</b></span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;background-color:#D9D9D9;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;background-color:#D9D9D9;\"><b>金额</b></span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;background-color:#D9D9D9;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;background-color:#D9D9D9;\"><b>率</b></span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;background-color:#D9D9D9;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;background-color:#D9D9D9;\"><b>率</b></span></font></td>\n"+
"</tr>\n"+
"<tr height=\"25\" style=\"height:15pt;\">\n"+
"<td align=\"center\" valign=\"bottom\" style=\"height:15pt;text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid solid;border-right-width:1px;border-bottom-width:1px;border-left-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;border-left-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">成功</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">16</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">成功总金额</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">87694.37元</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">成功率</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;background-color:#A9D08E;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;background-color:#A9D08E;\">100.00%</span></font></td>\n"+
"</tr>\n"+
"<tr height=\"25\" style=\"height:15pt;\">\n"+
"<td align=\"center\" valign=\"bottom\" style=\"height:15pt;text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid solid;border-right-width:1px;border-bottom-width:1px;border-left-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;border-left-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">失败</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">0</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">失败总金额</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">0元</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">失败率</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;background-color:#A9D08E;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;background-color:#A9D08E;\">0.00%</span></font></td>\n"+
"</tr>\n"+
"<tr height=\"25\" style=\"height:15pt;\">\n"+
"<td colspan=\"4\" valign=\"bottom\" style=\"height:15pt;background-color:#BDD7EE;padding-top:1px;padding-right:1px;padding-left:1px;border-width:1px;border-style:solid;border-color:windowtext black windowtext windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;background-color:#BDD7EE;\">维度二</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\"></span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\"></span></font></td>\n"+
"</tr>\n"+
"<tr height=\"25\" style=\"height:15pt;\">\n"+
"<td align=\"center\" valign=\"bottom\" style=\"height:15pt;text-align:center;background-color:#D9D9D9;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid solid;border-right-width:1px;border-bottom-width:1px;border-left-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;border-left-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;background-color:#D9D9D9;\"><b>是否同行</b></span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;background-color:#D9D9D9;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;background-color:#D9D9D9;\"><b>笔数</b></span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;background-color:#D9D9D9;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;background-color:#D9D9D9;\"><b>平均耗时</b></span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;background-color:#D9D9D9;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;background-color:#D9D9D9;\"><b>是否发起查询</b></span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\"></span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\"></span></font></td>\n"+
"</tr>\n"+
"<tr height=\"25\" style=\"height:15pt;\">\n"+
"<td align=\"center\" valign=\"bottom\" style=\"height:15pt;text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid solid;border-right-width:1px;border-bottom-width:1px;border-left-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;border-left-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">同行代付</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">16</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">2.19秒</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">-</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\"></span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\"></span></font></td>\n"+
"</tr>\n"+
"<tr height=\"25\" style=\"height:15pt;\">\n"+
"<td align=\"center\" valign=\"middle\" style=\"height:15pt;text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid solid;border-right-width:1px;border-bottom-width:1px;border-left-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;border-left-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">跨行代付</span></font></td>\n"+
"<td align=\"center\" valign=\"middle\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">0</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">-</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none solid solid none;border-right-width:1px;border-bottom-width:1px;border-right-color:windowtext;border-bottom-color:windowtext;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\">-</span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\"></span></font></td>\n"+
"<td align=\"center\" valign=\"bottom\" style=\"text-align:center;padding-top:1px;padding-right:1px;padding-left:1px;border-style:none;\">\n"+
"<font face=\"黑体-简\" size=\"3\" color=\"black\"><span style=\"font-size:12pt;\"></span></font></td>\n"+
"</tr>\n"+
"</tbody></table>",true);
File file = new File("/Users/guanxianghui/Documents/01.files/be/南粤超网代付交易统计(2017年05月).xlsx");
String fileNm = file.getName();
messageHelper.addAttachment(fileNm, file);
//发送邮件
mailSender.send(mailMessage);