文件上传与模板下载实现-优快云博客

本文链接：https://blog.youkuaiyun.com/tyjlearning/article/details/78953347

1.触发点击事件跳转到选择文件页面

function showImportDialog(){
var upUrl = sname + '/subjectorgController/importExcel?';
var fmt= 'xls|xlsx';
var maxSize= 51200;
var dnUrl ='/ExcelTemplate/subjectorgMSG.xlsx';
var dnName = '预算信息导入模板.xlsx';
$('#win').dialog({
title: '导入预算信息',
width: 415,
height:265,
closed: false,
cache: false,
href: sname+'/uploadController/pageJumpImport?oldOrNew=oldOrNew&upUrl='+upUrl
+'&dnUrl='+dnUrl+'&fmt='+fmt+'&maxSize='+maxSize+'&dnName='+encodeURI(encodeURI(dnName)),
modal: true
});
}

2.//跳转页面时保存参数到request中

@RequestMapping("/pageJumpImport")
public String pageJumpImport() {
String upUrl = request.getParameter("upUrl");
String dnUrl = request.getParameter("dnUrl");
String param = request.getParameter("param");
String fmt = request.getParameter("fmt");
String fid = request.getParameter("functionId");
String dnName = StringUtil.stringUncode(request.getParameter("dnName"));
int maxSize = StringUtil.stringToInt(request.getParameter("maxSize"));
String oldOrNew = request.getParameter("oldOrNew");
request.setAttribute("upUrl", upUrl);
request.setAttribute("dnUrl", dnUrl);
request.setAttribute("param", param);
request.setAttribute("maxSize", maxSize);
request.setAttribute("fmt", fmt);
request.setAttribute("dnName", dnName);
request.setAttribute("functionId", fid);
request.setAttribute("oldOrNew", oldOrNew);
return "uploadFile";
}

//3.选择文件页面（选择文件，模板下载，提交）

<body>
<div>
<form id="FormUpdate" action="" method="post" enctype="multipart/form-data" οnsubmit="return check();">
<div style="padding-top:20px;border-bottom:solid 1px #ededed;padding-bottom:20px;margin-bottom:10px;padding-left:58px;">

<lable><span class="requried">*</span>信息文件：</lable><input class="easyui-filebox" id="filename" name="filename" style="width:180px" value="" buttonText="请选择">
</div>
</form>
</body>
<div class="operation_pg">说明：导入的excel需要遵循规定的格式</div>
<div class="operation_pg1"><a href="javascript:void(0);" οnclick="downLand()" class="easyui-linkbutton" style="padding-bottom: 3px;">点击这里</a>下载导入的excel数据模板</div>
<div class="btn_auto">
<a href="javascript:void(0)" class="easyui-linkbutton btn2" οnclick="submitForm()">提交</a>
<a href="javascript:void(0)" class="easyui-linkbutton btn2" οnclick="cleanForm()">取消</a>
</div>
<script language="javascript">
var sname = '<%=request.getContextPath()%>';
/****** 文件数组 ******/
var fileArr = new Array();
var deleteArr = new Array();
var booled = false;
/******** 文件对象 ********/
function fObj(i, n, s) {
this.sourceName = i;
this.saveName = n;
this.state = s;
}

var maxSize = null;
var format = null;
var upUrl = null;
var dnUrl = null;
var param = null;
var dnName = null;
var funcId = null;
var oldOrNew;
$(function(){
//初始化工具栏
maxSize = '${maxSize}';
format = '${fmt}';
upUrl = '${upUrl}';
dnUrl = '${dnUrl}';
param = '${param}';
dnName = '${dnName}';
funcId = '${functionId}';
oldOrNew = '${oldOrNew}';
});

function check() {
var excel_file = $("#excel_file").val();
if (excel_file == "" || excel_file.length == 0) {
alert("请选择文件路径！");
return false;
} else {
return true;
}
}

function downLand(){
var url = sname+dnUrl+'?fileName='+ dnName;
if(oldOrNew){
url = sname + '/uploadController/download?download=' + dnUrl + '&fileName='
+ coding(dnName);
}
window.location.href = url;
}
//删除权限
function ondelPri(that){
$(that).closest("tr").remove();
}
//关闭
function cleanForm(){
$('#win').dialog('close');
}

//提交表单
function submitForm(){
$("#win").children().hide();
$("#win").append("<span>Loading...</span>");
$('#FormUpdate').form('submit', {
url: upUrl,
//url: sname+'uploadController/upload',
onSubmit: function () { //表单提交前的回调函数
var isValid = $(this).form('validate');//验证表单中的一些控件的值是否填写正确，比如某些文本框中的内容必须是数字

if (!isValid) {
}
return isValid; // 如果验证不通过，返回false终止表单提交
},
success: function (data) { //表单提交成功后的回调函数，里面参数data是我们调用/BasicClass/ModifyClassInfo方法的返回值。
$("#win").children().show();
data= JSON.parse(data)
if (data.message!=null&&data.message!="") {
$.messager.show({
width:500,
height:300,
title: '提示消息',
msg: data.message,
showType: 'show',
timeout: 0,
style: {
right: '',
bottom: ''
}
});
$('#dg').datagrid('reload'); // 重新载入当前页面数据
$('#win').window('close'); //关闭窗口
} else {
$.messager.alert('提示信息', data.messgae, 'warning');
}
}
});

}

</script>
</body>

excel数据导入