用java把excel导入数据库表中

悬赏园豆：50 [已关闭问题] 关闭于 2017-02-24 15:00

@RequestMapping(value = "importTest", method = RequestMethod.POST,produces = "text/html;charset=UTF-8")
    @ResponseBody
    public  String importTest(@RequestParam(required = false)MultipartFile file,BsAllguaranteechange bsAllguaranteechange, Model model, RedirectAttributes redirectAttributes) {
        JSONObject json = new JSONObject();
        Map<String, Object> returnMap = Maps.newHashMap();
        int result = 0;
        if (file.getSize()==0) {
            json.put("isSuccess", true);
            json.put("msg", "无添加");
            return json.toString();
        }
        try {
        ImportExcel ei = new ImportExcel(file, 1, 0);
        List<BsAllguaranteechange> bsAllguaranteechangelist = ei.getDataList(BsAllguaranteechange.class);
        for (int i = 0; i < bsAllguaranteechangelist.size(); i++) {
　　　　　　//....省略
                    
                    
                } 
        }
        catch (Exception e) {
            addMessage(redirectAttributes, OperationMessage.ERROR.toString());
            e.printStackTrace();
        }
            
        if(result!=0){
            json.put("isSuccess", true);
            json.put("x", "su");
            json.put("msg", "添加成功");
            return json.toString();
        }
        
        CommonFunctionUtil.operateDB(returnMap, result);
        return json.toString();
    }

前台代码：

<form id="importForm" action="${ctx}/business/bsAllguaranteechange/importTest" 
            modelAttribute="bsAllguaranteechange"
            method="post" enctype="multipart/form-data"
            class="form-horizontal" 
            style="padding-left:20px;text-align:center;" 
            onsubmit="loading('正在导入，请稍等...');"><br/>
            <input id="uploadFile" name="file" type="file" style="width:330px"/><br/><br/>　　
            <input id="btnImportSubmit" class="btn btn-primary" type="submit" value="   导    入   "/>
    
            </form>

<script type="text/javascript">

     $("#btnImportSubmit").click(function () {$('#importForm').form('submit', {
           url:"${ctx}/business/bsAllguaranteechange/importTest",
           success:function(result){
            alert(1); 
        
         
           }
       });
   });
</script>