java实现Excl导入功代码.docVIP

java实现Excel功能代码 本源码来源于开源系统MyExam 大家可以去开源中国社区和各大下载站去下载myexam 本系统开放源代码，完全免费 前台代码： form id importForm method post enctype multipart/form-data fmt:message key questionimport/ table class yTable margintop fmt:message key selectfile/ ： input id files name files type file / div class Btn input id downloadBtn type button value fmt:message key downloadtemplate/ / input id importBtn type button value fmt:message key import/ / js文件： define function require var $ require jquery ; var contextPath $ #contextPath .val ; require dialog $ ; require uriTemplate $ ; var IFA require util ; require dateTimePicker $ ; require ../../../styles/cim/jquery-ui-1.8.14.custom.css ; $ #importBtn .click function var url contextPath+/question/import.do; $ #importForm .attr action,url ; $ #importForm .submit ; ; $ #downloadBtn .click function url contextPath+/download/questionTemplate.xlsx; location.href url; ; ; Java代码： /** * 导入试题 * * @author Eric * */ @SuppressWarnings unchecked @RequestMapping value /question/import.json, method RequestMethod.POST public String create final ExcelDTO excelDTO, final BindingResult result, final ModelMap model, HttpServletRequest request excelValidator.validate excelDTO, result ; // 插入数据的list List importQuestionList new LinkedList ; if result.hasErrors model.put importFileTypeError1, importFileTypeError ; else try final Map String, Object parse parseExcel excelDTO ; final boolean dataTooManyErrorFlag Boolean parse .get dataTooManyErrorFlag ; if dataTooManyErrorFlag model.put importFileDataTooManyErroFlag1, true ; else // 格式正确的list importQuestionList List parse.get formatCorrectList ; catch Exception e model.put importFileReadErrorMsg1, true ; return view model, importQuestionView, TopMenu.EXAM, SideMenu.QUESTION_MANAGEMENT ; final Map String, Object resultMap insertDB importQuestionList, request ; model.put lastId, resultMap.get insertLastId ; model.put count, resultMap.get successCoun