使用插件导入Excel表到数据库

<script type="text/javascript" src="${ctxStatic}/admin/js/Huploadify/jquery.Huploadify.js"></script>

在使用插件之前首先到入js库

$('#excle').Huploadify({
        'uploader': '${ctx}/meeting/import',
        'fileObjName': 'fileToUpload',
        'fileTypeExts': '*.xlsx; *.xsl;',
        'auto': true,
        'multi': false,
        'fileObjName': 'file',
        'fileSizeLimit': 20480 * 60,
        'showUploadedPercent': true,
        'showUploadedSize': true,
        'onUploadSuccess': function (file, data) {
//            var josobj = JSON.parse(data);
//            var url=josobj.src;
//            var fileName=josobj.name;
//            $("#picture_address").val(url);
            if(data=='2'){
                layer.msg("导入会议签到表失败",{icon:2});
            }
            if(data ==""){
                layer.msg("有非参会人员签到，请确认信息是否正确!导入失败",{icon:2});
            }
            if(data =='1'){
                layer.msg("导入会议签到表成功",{icon:1});
            }
            //window.location.reload();
            //$('#file_picShow').html(' <span class="picSpan"><img class="picture" height="80px" width="80px" vedioSrc="' + josobj.src + '"  src="${ctxStatic}/Huploadify/fujian.png"></img>' + josobj.name + '</span>');
        },
        'onUploadError': function (file, errorCode, errorMsg, errorString) {
            alert('文件' + file.name + ' 上传错误: ' + errorMsg);
        },
    });
将一个div绑定上面的事件，在后台将导入的Excel数据存入磁盘
/**
 * 导入Excel数据
 */
@RequiresPermissions(value = {"meeting:meeting:import", "meetingParticipants:meetingParticipants:export"}, logical = Logical.OR)
@RequestMapping(value = "import", method = RequestMethod.POST)
@ResponseBody
public String importFile(MultipartFile file, RedirectAttributes redirectAttributes, Meeting meeting,Model model,HttpServletRequest request) {
    String filepath = "";
    LayFileJsonData data = new LayFileJ