一.配置文件名称、路径、内容：

 

二.controller

@RequestMapping(value = "/importAccountManager")    @ResponseBody    public ModelAndView importAccountManager(HttpServletRequest request, HttpServletResponse response,            @RequestParam("file") CommonsMultipartFile file) {        ModelAndView mav = new ModelAndView(new MappingJackson2JsonView());        try (InputStream inputXls = file.getInputStream();                InputStream inputXML = new BufferedInputStream(getClass().getClassLoader().getResourceAsStream(ACCOUNT_TEMPLATE_PATH));) {            XLSReader mainReader = ReaderBuilder.buildFromXML(inputXML);            List
     
       dataList = new ArrayList<>();            Map
      
        params = new HashMap<>();            params.put("dataList", dataList);            mainReader.read(inputXls, params);            String message = accountManagerService.importAccountManager(dataList);            if(StringUtils.isNotBlank(message)) {                mav.addObject("success", false);            } else {                mav.addObject("success", true);            }            mav.addObject("message", message);        } catch (Throwable e) {            LOGGER.error("importAccountManager causes inner exception:", e);            mav.addObject("success", false);            mav.addObject("message", e.getMessage());        }        return mav;    }
      
     

三.service

//serviceImpl  @Override    public String importAccountManager(List
     
       accountList) throws Exception {        List
      
        orgList = orgMapper.queryOrg();        String message = validate(accountList, orgList);        if(message == null) {            for(AccountManagerModel account : accountList) {                String consNo = account.getConsNo();                AccountManagerModel oldAccount = accountManagerMapper.queryByConsNo(consNo);                if(oldAccount == null) {                    insertAccountManager(account);                } else {                    editAccountManager(account, oldAccount);                }            }        }        return message;    }//interface/**     * 导入客户数据     *      * @param accountList     * @return     * @throws Exception     */    public String importAccountManager(List
       
         accountList) throws Exception;
       
      
     

四.mapper

//interface  /**     * 通过客户号查询企业     *      * @param consNo     * @return     * @throws throws Exception     */    public AccountManagerModel queryByConsNo(String consNo) throws Exception;//mapper映射xml

        select             a.cons_id,            a.cons_no,            a.cons_name,            a.cons_address,            a.legal_person,            a.legal_person_phone,            a.bill_person,            a.bill_person_phone,            a.electric_person,            a.electric_person_phone,            a.entrusted_person,            a.entrusted_person_phone,            a.cons_state,            a.org_no,            b.org_name       from be_cons_info a, o_org b      where a.org_no = b.org_no        and a.cons_no = #{consNo}    

五.Html

     
        
      新增        
      修改        
              
                  导入Excel                            
      导出Excel        
      下载模板    
     

六.js

function bindFileUploadEvent() {    $('#fileupload').fileupload({        url: basePath + 'accountManager/importAccountManager',        type: 'post',        dataType: 'json',        beforeSend: function(xhr){            xhr.setRequestHeader(header, token);        },        send: function(e, data) {            var file = data.files[0];            var fileName = file.name;            var fileSize = file.size;            var errorMsg = "请选择Excel文件！";            var pass = validateFileName(fileName, ".xls");            if(pass && fileSize >= 10485760) {                pass = false;                errorMsg = "选择的Excel文件须小于10M！";            }            if(!pass) {                $('#fileupload').val('');                errorDialog(errorMsg);            } else {                if(parent.progress) {                    parent.progress.show();                }            }            return pass;        },        done: function(e, data) {            var result = data.result;            if(result.success) {                queryAccountManager();                succDialog("客户数据导入成功！");            } else {                errorDialog(result.message);            }        },        fail: function(e, data) {            if(data.textStatus != null) {                errorDialog("系统发生故障，请联系系统管理员或稍后重试！");            }        },        always: function(e, data) {            if(parent.progress) {                parent.progress.hide();            }        }    });}