前台下载后台Excel文件流对象

最新推荐文章于 2023-12-19 18:25:26 发布

java_快乐小学生

最新推荐文章于 2023-12-19 18:25:26 发布

阅读量408

点赞数

文章标签： java html

本文链接：https://blog.csdn.net/weixin_45796679/article/details/103741121

版权

欢迎使用Markdown编辑器

Controller层

package com.lzy.controller;

import com.alibaba.dubbo.config.annotation.Reference;
import com.lzy.domain.renwu;
import com.lzy.service.CheckItemService;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.util.List;
import java.util.UUID;

/**
 * @author 影 @Date: 2019/12/27/18:29
 */
@RestController
@RequestMapping("/aa")
public class Test {
    @Reference
    private CheckItemService checkItemService;
	private HSSFWorkbook workbook = null;
	
    @RequestMapping("/bb")
    public void xiazai(String gender, String banben, HttpServletResponse response) throws IOException {
        workbook = new HSSFWorkbook();
        OutputStream out = null;
        UUID uuid = UUID.randomUUID();
        String fileName = null;
        try {
            out = response.getOutputStream();
            if (banben.equals("2003")) {
                fileName = uuid + "test.xls";
            } else if (banben.equals("2007")) {
                fileName = uuid + "test.xlsx";
            }
            response.setContentType("application/x-msdownload");
            response.setHeader("Content-Disposition", "attachment; filename=" + URLEncoder.encode(fileName, "UTF-8"));
            
            List<renwu> xiazai = checkItemService.xiazai(gender);
            XSSFWorkbook workbook = new XSSFWorkbook();
            XSSFSheet sheet1 = workbook.createSheet("sheet1");
            XSSFRow row = sheet1.createRow(0);
            row.createCell(0).setCellValue("编号");
            row.createCell(1).setCellValue("名称");
            row.createCell(2).setCellValue("性别");
            for (int i = 1; i < xiazai.size(); i++) {
                XSSFRow row1 = (XSSFRow) sheet1.createRow(i);
                row1.createCell(0).setCellValue(xiazai.get(i).getId());
                row1.createCell(1).setCellValue(xiazai.get(i).getName());
                row1.createCell(2).setCellValue(xiazai.get(i).getGender());
            }
            workbook.write(out);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                out.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }
}

HTML页面


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <link rel="stylesheet" href="https://unpkg.com/element-ui/lib/theme-chalk/index.css">
    <script src="https://unpkg.com/vue/dist/vue.js"></script>
    <script src="https://unpkg.com/element-ui/lib/index.js"></script>
</head>
<body>
<div id="app">
    <el-form ref="form" :model="form" :rules="rules" label-width="80px">
        <el-form-item label="按性别搜索" prop="region">
            <el-select v-model="form.gender" placeholder="请选择搜索条件">
                <el-option label="男" value="男"></el-option>
                <el-option label="女" value="女"></el-option>
            </el-select>
        </el-form-item>
        <el-form-item label="下载版本" prop="region">
            <el-select v-model="form.banben" placeholder="请选择Excel版本">
                <el-option label="2003" value="2003"></el-option>
                <el-option label="2007" value="2007"></el-option>
            </el-select>
        </el-form-item>
        </el-form-item>
        <el-form-item>
            <el-button type="primary" @click="onSubmit(form)">立即下载</el-button>
        </el-form-item>
    </el-form>
</div>
</body>
<script src="../js/vue.js"></script>
<script src="../plugins/elementui/index.js"></script>
<script type="text/javascript" src="../js/jquery.min.js"></script>
<script src="../js/axios-0.18.0.js"></script>
<script>
    new Vue({
        el: '#app',
        data: {
            form: {
                gender: '',
                banben: '',
            },
        },
        methods: {
            onSubmit(form) {
                location.href = "/aa/bb.do?gender=" + form.gender + "&&banben=" + form.banben;
            },
        }
    });
</script>
</html>