jsp导出excel，可传动态参数

1.jsp代码

<%
    String exportToExcel = request.getParameter("exportToExcel");
    if (exportToExcel != null
            && exportToExcel.equalsIgnoreCase("YES")) {
        response.setContentType("application/vnd.ms-excel");
        response.setHeader("Content-Disposition", "inline; filename="
                + "excel.xls");
    }
    String sdeptCode = request.getParameter("sdeptCode");
    String smallUnitType2 = request.getParameter("smallUnitType2");
    String isSum = request.getParameter("isSum");
%>
<%
    if (exportToExcel == null) {
%>
<a id="importExcel">导出表格至Excel</a>
<%
    }
%>

2.js控制动态标签

<script type="text/javascript">
    $(function () {
        var sdeptCode = "<%=sdeptCode %>";//获取sdeptCode参数值
        var smallUnitType2 = "<%=smallUnitType2 %>";//获取smallUnitType2参数值
        var isSum = "<%=isSum %>";//获取isSum参数值
        if (sdeptCode == "null") {
            sdeptCode = '';
        }
        if (smallUnitType2 == "null") {
            smallUnitType2='';
        }
        if (isSum == "null") {
            isSum = '';
        }

        $("#importExcel").attr("href","first.htm?exportToExcel=YES&sdeptCode=" + sdeptCode + "&smallUnitType2=" + smallUnitType2 + "&isSum=" + isSum);
    })

</script>

效果图