package com.imooc.servlet;
import com.imooc.entity.Student;
import com.imooc.service.ExcelService;
import org.apache.poi.ss.usermodel.Workbook;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;
@WebServlet(name = "ExportExcelServlet", urlPatterns = "/exportExcel")
public class ExportExcelServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
ExcelService excelService = new ExcelService();
List studentList = excelService.redExcel("c:/upload/Student.xlsx");
Workbook workbook = excelService.exportExcel(false, studentList);
response.setHeader("Context-Disposition", "attachment;filename=Students.xlsx");
ServletOutputStream outputStream = response.getOutputStream();
workbook.write(outputStream);
outputStream.flush();
outputStream.close();
workbook.close();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
}
package com.imooc.