Spring mvc 自定义视图解析（pdf和excel）

最新推荐文章于 2020-10-28 12:37:32 发布

junyi0107

最新推荐文章于 2020-10-28 12:37:32 发布

阅读量595

点赞数

文章标签： spring mvc pdf excel

本文链接：https://blog.csdn.net/junyi0107/article/details/78972827

版权

1.首先我们需要导入两个必备的jar包

poi-3.16.jar、itext-2.1.7.jar

2.生成pdf
首先创建一个继承于AbstractPdfView类的class，重写其中的方法

public class MyPdfView extends AbstractPdfView  {

    @Override
    protected void buildPdfDocument(Map<String, Object> model, Document document, PdfWriter writer, HttpServletRequest request,
            HttpServletResponse response) throws Exception {

        List list = (List) model.get("list");
        for (int i = 0; i < list.size(); i++) {
            //将数据加载到视图上
            document.add(new Paragraph((String)(list.get(i))));
        }

    }

在controller中

@RequestMapping("/pdf")
    public ModelAndView mypdf() {
        ModelAndView mav = new ModelAndView();
        //添加自定义视图
        mav.setView(new MyPdfView());
        List list = new ArrayList<>();
        for (int i = 0; i < 10; i++) {
            list.add(i+"");
        }
        mav.addObject("list", list);
        return mav;
    }

--------pdf视图就做完了 ，直接访问url即可

3.自定义的excel视图解析，跟自定义pdf视图很像

public class MyExcelView extends AbstractExcelView  {

    @Override
    protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request,
            HttpServletResponse response) throws Exception {
        // TODO Auto-generated method stub
        HSSFSheet sheet;//工作簿的名字
        HSSFRow sheetRow;//行
        HSSFCell cell;//单元格

        sheet = workbook.createSheet("spring");
        sheet.setDefaultColumnWidth(12);

        List list =  (List) model.get("list");
        for (int i = 0; i < list.size(); i++) {
            //三个参数，第一个为工作簿，第二个为行，第三个为单元格
            cell = getCell(sheet, 0, i);
            setText(cell, (String) list.get(i));
            cell = getCell(sheet, i+1, 2);
            setText(cell, (String) list.get(i));
        }
    }

controller中

@RequestMapping("/excle")
    public ModelAndView myexcle() {
        ModelAndView mav = new ModelAndView();
        //添加视图
        mav.setView(new MyExcelView());
        List list = new ArrayList<>();
        for (int i = 0; i < 10; i++) {
            list.add(i+"");
        }
        mav.addObject("list", list);
        return mav;
    }

    *over*