首先,先放上js,给懒得看的人
// JavaScript Document
jQuery.extend({
createUploadIframe: function(id, uri)
{
//create frame
var frameId = 'jUploadFrame' + id;
if(window.ActiveXObject) {
var io = document.createElement('<iframe id="' + frameId + '" name="' + frameId + '" />');
if(typeof uri== 'boolean'){
io.src = 'javascript:false';
}
else if(typeof uri== 'string'){
io.src = uri;
}
}
else {
var io = document.createElement('iframe');
io.id = frameId;
io.name = frameId;
}
io.style.position = 'absolute';
io.style.top = '-1000px';
io.style.left = '-1000px';
document.body.appendChild(io);
return io;
},
createUploadForm: function(id, fileElementId)
{
//create form
var formId = 'jUploadForm' + id;
var fileId = 'jUploadFile' + id;
var form = jQuery('<form action="" method="POST" name="' + formId + '" id="' + formId + '" enctype="multipart/form-data"></form>');
var oldElement = jQuery('#' + fileElementId);
var newElement = jQuery(oldElement).clone();
jQuery(oldElement).attr('id', fileId);
jQuery(oldElement).before(newElement);
jQuery(oldElement).appendTo(form);
//set attributes
jQuery(form).css('position', 'absolute');
jQuery(form).css('top', '-1200px');
jQuery(form).css('left', '-1200px');
jQuery(form).appendTo('body');
return form;
},
ajaxFileUpload: function(s) {
// TODO introduce global settings, allowing the client to modify them for all requests, not only timeout
s = jQuery.extend({}, jQuery.ajaxSettings, s);
var id = s.fileElementId;
var form = jQuery.createUploadForm(id, s.fileElementId);
var io = jQuery.createUploadIframe(id, s.secureuri);
var frameId = 'jUploadFrame' + id;
var formId = 'jUploadForm' + id;
if( s.global && ! jQuery.active++ )
{
// Watch for a new set of requests
jQuery.event.trigger( "ajaxStart" );
}
var requestDone = false;
// Create the request object
var xml = {};
if( s.global )
{
jQuery.event.trigger("ajaxSend", [xml, s]);
}
var uploadCallback = function(isTimeout)
{
// Wait for a response to come back
var io = document.getElementById(frameId);
try
{
if(io.contentWindow)
{
xml.responseText = io.contentWindow.document.body?io.contentWindow.document.body.innerHTML:null;
xml.responseXML = io.contentWindow.document.XMLDocument?io.contentWindow.document.XMLDocument:io.contentWindow.document;
}else if(io.contentDocument)
{
xml.responseText = io.contentDocument.document.body?io.contentDocument.document.body.innerHTML:null;
xml.responseXML = io.contentDocument.document.XMLDocument?io.contentDocument.document.XMLDocument:io.contentDocument.document;
}
}catch(e)
{
jQuery.handleError(s, xml, null, e);
}
if( xml || isTimeout == "timeout")
{
requestDone = true;
var status;
try {
status = isTimeout != "timeout" ? "success" : "error";
// Make sure that the request was successful or notmodified
if( status != "error" )
{
// process the data (runs the xml through httpData regardless of callback)
var data = jQuery.uploadHttpData( xml, s.dataType );
if( s.success )
{
// ifa local callback was specified, fire it and pass it the data
s.success( data, status );
};
if( s.global )
{
// Fire the global callback
jQuery.event.trigger( "ajaxSuccess", [xml, s] );
};
} else
{
jQuery.handleError(s, xml, status);
}
} catch(e)
{
status = "error";
jQuery.handleError(s, xml, status, e);
};
if( s.global )
{
// The request was completed
jQuery.event.trigger( "ajaxComplete", [xml, s] );
};
// Handle the global AJAX counter
if(s.global && ! --jQuery.active)
{
jQuery.event.trigger("ajaxStop");
};
if(s.complete)
{
s.complete(xml, status);
} ;
jQuery(io).unbind();
setTimeout(function()
{ try
{
jQuery(io).remove();
jQuery(form).remove();
} catch(e)
{
jQuery.handleError(s, xml, null, e);
}
}, 100);
xml = null;
};
}
// Timeout checker
if( s.timeout > 0 )
{
setTimeout(function(){
if( !requestDone )
{
// Check to see ifthe request is still happening
uploadCallback( "timeout" );
}
}, s.timeout);
}
try
{
var form = jQuery('#' + formId);
jQuery(form).attr('action', s.url);
jQuery(form).attr('method', 'POST');
jQuery(form).attr('target', frameId);
if(form.encoding)
{
form.encoding = 'multipart/form-data';
}
else
{
form.enctype = 'multipart/form-data';
}
jQuery(form).submit();
} catch(e)
{
jQuery.handleError(s, xml, null, e);
}
if(window.attachEvent){
document.getElementById(frameId).attachEvent('onload', uploadCallback);
}
else{
document.getElementById(frameId).addEventListener('load', uploadCallback, false);
}
return {abort: function () {}};
},
uploadHttpData: function( r, type ) {
var data = !type;
data = type == "xml" || data ? r.responseXML : r.responseText;
// ifthe type is "script", eval it in global context
if( type == "script" )
{
jQuery.globalEval( data );
}
// Get the JavaScript object, ifJSON is used.
if( type == "json" )
{
eval( "data = " + data );
}
// evaluate scripts within html
if( type == "html" )
{
jQuery("<div>").html(data).evalScripts();
}
return data;
},
handleError: function( s, xhr, status, e ) {
// If a local callback was specified, fire it
if ( s.error ) {
s.error.call( s.context || s, xhr, status, e );
}
// Fire the global callback
if ( s.global ) {
(s.context ? jQuery(s.context) : jQuery.event).trigger( "ajaxError", [xhr, s, e] );
}
}
});
放上jsp部分
//上传
function ajaxFileUpload(){
var outStockId = $("#id").val();
if (outStockId){
parent.$.messager.progress({
title : '提示',
text : '数据处理中,请稍后....'
});
//重新绑定change事件
$("#file").change(function(){
var filename = $(this).val();
$("#file").val(filename);
});
$.ajaxFileUpload({
url:"${ctx}/stock/outStock/readExcel/"+outStockId,//用于文件上传的服务器端请求地址
secureuri:false ,//一般设置为false
fileElementId:'file',//文件上传控件的id属性 <input type="file" id="file" name="file" />
dataType: 'JSON',//返回值类型 一般设置为json
cache:false,
success: function (data, status){ //服务器成功响应处理函数
if(data=='success'){
parent.$.messager.show({ title : "提示",msg: "上传成功!", position: "bottomRight" });
successTip(status,dgDetail);
}else{
parent.$.messager.show({ title : "提示",msg: "数据错误,上传失败!", position: "bottomRight" });
}
parent.$.messager.progress('close');
},
complete: function(xmlHttpRequest) {
//重新绑定change事件
$("#file").replaceWith('<input type="file" id="file" name="file"/>');
$("#file").on("change", function(){
var filename = $(this).val();
$("#file").val(filename);
});
},
error: function (data, status, e){//服务器响应失败处理函数
parent.$.messager.alert({ title : "提示",msg: "服务器无响应,上传失败!", position: "bottomRight" });
parent.$.messager.progress('close');
}
});
}
return false;
}
jsp
<input type="file" id="file" name="file" />
<a href="#" class="easyui-linkbutton" data-options="iconCls:'icon-add'" οnclick="ajaxFileUpload()" plain="true">上传</a>
java
@ResponseBody
@RequestMapping(value = "readExcel/{outStockId}", method = RequestMethod.POST)
public String readExcel(@PathVariable("outStockId") String outStockId, @RequestParam("file") MultipartFile file) {
try {
outStockDetailService.importExcel(outStockId,file);
return "success";
} catch (IOException e) {
e.printStackTrace();
return "error";
}
}
最后数字问题,时间,日期
//判断从Excel文件中解析出来数据的格式
private static String getCellValue(HSSFCell cell){
String value = null;
if(cell!=null){
//简单的查检列类型
switch(cell.getCellType())
{
case HSSFCell.CELL_TYPE_STRING://字符串
value = cell.getRichStringCellValue().getString();
break;
case HSSFCell.CELL_TYPE_NUMERIC://数字
if (HSSFDateUtil.isCellDateFormatted(cell)) { //判断是日期类型
SimpleDateFormat dateformat = null;
// System.out.println(cell.getCellStyle().getDataFormat()+"======>");
if (cell.getCellStyle().getDataFormat() == 176) { //判断为时间HH:ss
dateformat = new SimpleDateFormat("HH:mm");
} else{
dateformat = new SimpleDateFormat("yyyy/MM/dd");
}
Date dt = HSSFDateUtil.getJavaDate(cell.getNumericCellValue());//获取成DATE类型
value = dateformat.format(dt);
}else{
DecimalFormat df = new DecimalFormat();
value = df.format(cell.getNumericCellValue());
}
break;
case HSSFCell.CELL_TYPE_BLANK:
value = "";
break;
case HSSFCell.CELL_TYPE_FORMULA:
value = String.valueOf(cell.getCellFormula());
break;
case HSSFCell.CELL_TYPE_BOOLEAN://boolean型值
value = String.valueOf(cell.getBooleanCellValue());
break;
case HSSFCell.CELL_TYPE_ERROR:
value = String.valueOf(cell.getErrorCellValue());
break;
default:
break;
}
}
return value;
}
如果想找相关的到这就可以走了,时间宝贵,如果想了解下可以继续====》》》
ajaxFileUpload主要会遇到3个bug;
1.不能传除了@RequestParam("file") MultipartFile file以外的参数,这个在js中已解决;
2.$.ajaxFileUpload({....中一直返回false 也就是error情况,这个主要是timeout bug造成;
3.不能重复上传,第一次有效,第二次必须刷新页面,这个是因为ajaxFileUpload把change方法覆盖,源码js中改的话牵扯太多,在这
//重新绑定change事件
$("#file").change(function(){
var filename = $(this).val();
$("#file").val(filename);
});
complete: function(xmlHttpRequest) {
//重新绑定change事件
$("#file").replaceWith('<input type="file" id="file" name="file"/>');
$("#file").on("change", function(){
var filename = $(this).val();
$("#file").val(filename);
});
},
这两段可以解决;
以上均个人观点,欢迎指正 proflier@163.com;
参考文档http://blog.csdn.net/jerome_s/article/details/38355547com
http://www.jb51.net/article/96665.htm
http://blog.csdn.net/zhanqizi/article/details/53486965