poi导入excel,数据保存到数据库

1、controller

//导入excel
	@RequestMapping(value = "/import", method=RequestMethod.POST)
	public JsonDto importExcel(@RequestParam(value="file",required = false) MultipartFile file,
							   HttpServletRequest request,
							   HttpServletResponse response){
		return  functionProjectRelationService.readExcelFile(file);
	}

2、Service

public JsonDto readExcelFile(MultipartFile file) {
		JsonDto jsonDto = new JsonDto();
		//创建处理EXCEL的类
		ReadExcel readExcel = new ReadExcel();
		//解析excel，获取上传的事件单
		List<Map<String, Object>> userList = readExcel.getExcelInfo(file);
		//至此已经将excel中的数据转换到list里面了,接下来就可以操作list,可以进行保存到数据库,或者其他操作,
		for(Map<String, Object> user:userList){
			logger.info("姓名="+user.get("name")+";年龄="+Integer.parseInt(user.get("age").toString()));
		}
		jsonDto.setSuccess(Boolean.TRUE);
		jsonDto.setErrcode("200");
		jsonDto.setErrmsg("上传成功");
		jsonDto.setData(userList);
		return  jsonDto;
	}

3、ReadExcel

package com.elink.estos.common.utils.excel;


import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.web.multipart.MultipartFile;

/**
 *
 * @author hewangtong
 *
 */
public class ReadExcel {