excel 处理
1.pom
<dependency>
<groupId>cn.hutool</groupId>
<artifactId>hutool-all</artifactId>
<version>5.7.18</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.1.2</version>
</dependency>
- 实体类
public class Dept {
private int did ;
private String dname ;
public int getDid() {
return did;
}
public void setDid(int did) {
this.did = did;
}
public String getDname() {
return dname;
}
public void setDname(String dname) {
this.dname = dname;
}
}
3.读操作
@Test
public void test01(){
ExcelReader reader = ExcelUtil.getReader("d:/aaa.xlsx");
List<Dept> all = reader.readAll(Dept.class);
for (Dept item:all) {
System.out.println(item.getDname());
}
}
4.写操作
@Test
public void test02(){
Dept dept = new Dept();
dept.setDid(10);
dept.setDname("王");
Dept dept1 = new Dept();
dept1.setDid(101);
dept1.setDname("王1");
List<Dept> depts =CollUtil.newArrayList(dept,dept1);
// 通过工具类创建writer
ExcelWriter writer = ExcelUtil.getWriter("d:/ccc.xlsx");
writer.addHeaderAlias("did", "编号");
writer.addHeaderAlias("dname", "姓名");
/* // 默认的,未添加alias的属性也会写出,如果想只写出加了别名的字段,可以调用此方法排除之
writer.setOnlyAlias(true);*/
// 合并单元格后的标题行,使用默认标题样式
writer.merge(1, "部门信息");
// 一次性写出内容,使用默认样式,强制输出标题
writer.write(depts, true);
// 关闭writer,释放内存
writer.close();
}
5.servlet 处理
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Dept dept = new Dept();
dept.setDid(10);
dept.setDname("王");
Dept dept1 = new Dept();
dept1.setDid(101);
dept1.setDname("王1");
List<Dept> depts = CollUtil.newArrayList(dept,dept1);
// 通过工具类创建writer,默认创建xls格式
ExcelWriter writer = ExcelUtil.getWriter();
// 一次性写出内容,使用默认样式,强制输出标题
writer.addHeaderAlias("did", "编号");
writer.addHeaderAlias("dname", "姓名");
/* // 默认的,未添加alias的属性也会写出,如果想只写出加了别名的字段,可以调用此方法排除之
writer.setOnlyAlias(true);*/
// 合并单元格后的标题行,使用默认标题样式
writer.merge(1, "部门信息");
// 一次性写出内容,使用默认样式,强制输出标题
writer.write(depts, true);
//out为OutputStream,需要写出到的目标流
//response为HttpServletResponse对象
response.setContentType("application/vnd.ms-excel;charset=utf-8");
//test.xls是弹出下载对话框的文件名,不能为中文,中文请自行编码
response.setHeader("Content-Disposition","attachment;filename=test.xls");
ServletOutputStream out=response.getOutputStream();
writer.flush(out, true);
// 关闭writer,释放内存
writer.close();
//此处记得关闭输出Servlet流
IoUtil.close(out);
}
mail 处理
- pom
<dependency>
<groupId>com.sun.mail</groupId>
<artifactId>javax.mail</artifactId>
<version>1.6.2</version>
</dependency>
2.配置
关于qq邮箱的pass 是授权码,参考如下地址生成授权码https://service.mail.qq.com/cgi-bin/help?subtype=1&&id=28&&no=1001256
3.代码
@Test
public void test01(){
MailUtil.send("ting.zhang@xx.com", "测试", "邮件来自Hutool测试", false);
}