《java实现Excel导入功代码》由会员分享，可在线阅读，更多相关《java实现Excel导入功代码（9页珍藏版）》请在金锄头文库上搜索。
1、java 实现 Excel 功能代码本源码来源于开源系统 MyExam大家可以去开源中国社区和各大下载站去下载 myexam本系统开放源代码，完全免费前台代码： / /js 文件：define(function(require)var $ = require(jquery);var contextPath=$(#contextPath).val();require(dialog)($);require(uriTemplate)($);var IFA = require(util);require(dateTimePicker)($);require(./././styles/cim/jquer
2、y-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* */Suppres
3、sWarnings(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);/ 插入数据的listList importQuestionList = new Li
4、nkedList();if (result.hasErrors() model.put(importFileTypeError1, importFileTypeError); else try final Map parse = parseExcel(excelDTO);final boolean dataTooManyErrorFlag = (Boolean) parse.get(dataTooManyErrorFlag);if (dataTooManyErrorFlag) model.put(importFileDataTooManyErroFlag1, true); else / 格式正
5、确的listimportQuestionList = (List) parse.get(formatCorrectList); catch (Exception e) model.put(importFileReadErrorMsg1, true);return view(model, importQuestionView, TopMenu.EXAM,SideMenu.QUESTION_MANAGEMENT);final Map resultMap = insertDB(importQuestionList, request);model.put(lastId, resultMap.get(i
6、nsertLastId);model.put(count, resultMap.get(successCount);model.put(importVoucherSuccessFlag1, true);return view(model, importQuestionView, TopMenu.EXAM,SideMenu.QUESTION_MANAGEMENT);/* * Description: 插入数据* * * author Eric*/private Map insertDB(List questionList,HttpServletRequest request) final Dat
7、e date = new Date();final Integer creatorAndModifier = (Integer) securityHelper.getID(request);for (importQuestionDTO questionDTO : questionList) setDefaultValue(date, creatorAndModifier, questionDTO);/return personProfileService.importClubCustomer(clubCustomerList);return null;/* * Description: 设置其
8、他默认必须数据* * * author Eric*/private void setDefaultValue(final Date date,final Integer creatorAndModifier,importQuestionDTO questionDTO) questionDTO.setCreationDate(new Date();questionDTO.setCreator(creatorAndModifier);questionDTO.setModificationDate(new Date();questionDTO.setModifier(creatorAndModifi
9、er);questionDTO.setOrigin(import);/* * Description: 解析 excel* * * author Eric*/private Map parseExcel(final ExcelDTO excelDTO)throws BiffException, IOException final Map map = new HashMap(3);Workbook workbook = null;try CommonsMultipartFile file=(CommonsMultipartFile) excelDTO.getFiles().get(0);Stri
10、ng fileName = file.getFileItem().getName();String extension = fileName.substring(fileName.lastIndexOf(.) + 1);InputStream is = file.getInputStream();/ if (xlsx.equals(extension) / XSSFWorkbook workbook2007 = new XSSFWorkbook(is);/ final XSSFSheet sheet = workbook2007.getSheetAt(0);/ final int totalR
11、ows = sheet.getLastRowNum();/ if (totalRows 3000) / map.put(dataTooManyErrorFlag, true);/ else / map.putAll(packagePersonProfile2007(sheet, totalRows);/ map.put(dataTooManyErrorFlag, false);/ / workbook = Workbook.getWorkbook(is);final Sheet sheet = workbook.getSheet(0);final int totalRows = sheet.g
12、etRows();if (totalRows 3000) map.put(dataTooManyErrorFlag, true); else map.putAll(packagePersonProfile(sheet, totalRows);map.put(dataTooManyErrorFlag, false); catch (BiffException e) throw e; catch (IOException e) throw e; finally if (workbook != null) workbook.close();return map;/* * Description: 将
13、excel2003封装成list* * * author Eric*/private Map packagePersonProfile(final Sheet sheet, final Integer totalRows) final List formatCorrectList = new LinkedList();final Map packageResult = new HashMap(2);for (int i = 1; i optionDTO=new ArrayList();final String content = sheet.getCell(0, i).getContents(
14、).trim();final String analyse = sheet.getCell(1, i).getContents().trim();final String answer = sheet.getCell(2, i).getContents().trim();final String category = sheet.getCell(3, i).getContents().trim();int num=num(sheet, i);for (int k = num; k 3; k-) OptionDTO optionDTO2=new OptionDTO(); optionDTO2.s
15、etContent(sheet.getCell(k, i).getContents().trim();optionDTO.add(optionDTO2);try questionDTO = constructclubCustomerDTO(content, analyse,answer, category, (ArrayList) optionDTO);formatCorrectList.add(questionDTO); catch (NumberFormatException e) /log.catching(e);packageResult.put(formatCorrectList, formatCorrectList);return packageResult;/* * Description: 封装所需的 DTO* * * author Eric*/private importQuestionDTO constructclubCustomerDTO(String content,String analyse, String answer, String category, ArrayList optionDTO) final importQuestionDTO importQuestionDTO
