1.在Controller中调用Service和dao
<span style="white-space:pre"> </span>List<Student> list=mySQLService.getALL() //此处从数据中取数据并封装到Student实体中
2.将查询出来的数据写入EXCEL中
<span style="white-space:pre"> </span>HSSFWorkbook wb=myService.createActExcle(list);
3.设置下载信息并将EXCEL文件写入流中
<span style="white-space:pre"> </span>response.setCharacterEncoding("utf-8");
response.setContentType("application/vnd.ms-excel");
String fileName = "XXXX";
String codedFileName=null;
String header=request.getHeader("User-Agent");
if(header.contains("Firefox")