excel导出前台jsp

最新推荐文章于 2020-02-26 15:22:44 发布

智航云科技

最新推荐文章于 2020-02-26 15:22:44 发布

阅读量181

点赞数

分类专栏： java 文章标签： java

本文链接：https://blog.csdn.net/G_whang/article/details/100066605

版权

java 专栏收录该内容

128 篇文章 1 订阅

订阅专栏

本jsp为略写导出的步骤未导入jquery包如需使用，自行导入即可

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<script>


    function exportXml(){
        var typeFlag=$("#typeFlag").combobox('getValue');
        if(""==typeFlag || null==typeFlag){
            typeFlag = "01";
        }
        var selected = $('#accountTable').datagrid('getSelections');
        if(selected.length >= 1){
            $.messager.confirm('确认', '您确认导出Xml吗?', function (r) {
                if (r) {
                    showLoading({loadMsg:'处理中,请稍后...'});
                    var uuid = getIds(selected,'ticUuid');
                    $('#xmlUuid').val(uuid);
                    $('#xmlTypeFlag').val(typeFlag);
                    var host= window.location.host;
                    var protocol= window.location.protocol;
                    var strPath=window.location.pathname;
                    var arr= new Array();
                    arr=strPath.split("/");
                    var virtualPath=arr[1];
                    var url = protocol+'//'+host+'/'+virtualPath+'/ExportController/exportXml';
                    document.exportForm.action=url;
                    document.exportForm.submit();
                    hideLoading();
                }
            });
        }else{
            $.messager.alert("提示信息", "请选择要导出的数据！",'info');
        }
    }

    function exportExcel(){
        var typeFlag=$("#typeFlag").combobox('getValue');
        if(""==typeFlag || null==typeFlag){
            typeFlag = "01";
        }
        var selected = $('#accountTable').datagrid('getSelections');
        if(selected.length >= 1){
            $.messager.confirm('确认', '您确认导出Excel吗?', function (r) {
                if (r) {
                    showLoading({loadMsg:'处理中,请稍后...'});
                    var uuid = getIds(selected,'ticUuid');
                    debugger;
                    $('.excelUuid').val(uuid);
                    $('.excelTypeFlag').val(typeFlag);
                    var host= window.location.host;
                    var protocol= window.location.protocol;
                    var strPath=window.location.pathname;
                    var arr= new Array();
                    arr=strPath.split("/");
                    var virtualPath=arr[1];
                    var url = protocol+'//'+host+'/'+virtualPath+'/ExportController/exportExcel';
                    document.exportExcelForm.action=url;
                    document.exportExcelForm.submit();
                    hideLoading();
                }
            });
        }else{
            $.messager.alert("提示信息", "请选择要导出的数据！",'info');
        }
    }

    //获取选中的id
    function getIds(selected,field){
        var ids = "";
        $.each(selected,function(index,item){
            if(ids == ""){
                ids ="'"+item[field]+"'";
            }else{
                ids +=",'" + item[field]+"'";
            }
        });
        return ids;
    }

</script>
<body>
<table id="tableBut" style="margin-top: -3px;">
    <tbody>
    <tr>
        <td>
            <form id="exportForm" name="exportForm" action="" method="post">
                <input type="hidden" id="xmlUuid" name="xmlUuid"/>
                <input type="hidden" id="xmlTypeFlag" name="xmlTypeFlag"/>
                <input type="hidden" id="externalUuid" name="externalUuid"/>
                <input type="hidden" id="Type" name="Type"/>
                <a href="javascript:void(0)" class="easyui-linkbutton view" iconcls="icon-publish" plain="true"
                   onclick="exportXml()" style="margin-right:8px;">导出XML</a>
            </form>
        </td>
        <td>
            <form id="exportExcelForm" name="exportExcelForm" action="" method="post">
                <input type="hidden" name="excelUuid" class="excelUuid"/>
                <input type="hidden" class="excelTypeFlag" name="excelTypeFlag"/>
                <a href="javascript:void(0)" class="easyui-linkbutton view" iconcls="icon-excel" plain="true"
                   onclick="exportExcel()" style="margin-right:8px;">导出EXCEL</a>
            </form>
        </td>
    </tr>
    </tbody>
</table>

</body>
</html>

智航云科技

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
excel导出前台jsp

本jsp为略写导出的步骤未导入jquery包如需使用，自行导入即可<!DOCTYPE html><html lang="en"><head> <meta charset="UTF-8"> <title>Title</title></head><script> fu...
复制链接

扫一扫