java jdbc excel_详解poi+springmvc+springjdbc导入导出excel实例

工作中常遇到导入导出excel的需求，本獂有一简答实例与大家分享。

废话不多说，

1.所需jar包：

2.前端代码：

ieport.jsp：

导入\导出页面

function exportFile(){

window.location.href = "/export.go";

}

文件：

success.jsp：

成功页面

// var secUserList = '${secUserList}';

// alert(secUserList);

导入成功！

Id：${secUser.userId} | Name：${secUser.userName} | Password：${secUser.userPassword}

导出成功！

3.后台代码：

controller:

package com.controller;

import java.io.File;

import java.util.List;

import javax.annotation.Resource;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestParam;

import org.springframework.web.multipart.MultipartFile;

import org.springframework.web.servlet.ModelAndView;

import com.domain.SecUser;

import com.service.IEportService;

@Controller

public class IEportController {

@Resource

private IEportService ieportService;

@RequestMapping("/import")

public ModelAndView importFile(@RequestParam(value="uploadFile")MultipartFile mFile, HttpServletRequest request, HttpServletResponse response){

String rootPath = request.getSession().getServletContext().getRealPath(File.separator);

List secUserList = ieportService.importFile(mFile, rootPath);

ModelAndView mv = new ModelAndView();

mv.addObject("type", "import");

mv.addObject("secUserList", secUserList);

mv.setViewName("/success");

return mv;

}

@RequestMapping("/export")

public ModelAndView exportFile(HttpServletResponse response) {

ieportService.exportFile(response);

ModelAndView mv = new ModelAndView();

mv.addObject("type", "export");

mv.setViewName("/success");

return mv;

}

}

service:

package com.service;

import java.io.File;

import java.io.FileInputStream;

import java.io.InputStream;

import java.io.OutputStream;

import java.net.URLEncoder;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.Date;

import java.util.List;

import javax.annotation.Resource;

import javax.servlet.http.HttpServletResponse;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.ss.usermodel.CellStyle;

import org.apache.poi.ss.usermodel.Font;

import org.apache.poi.xssf.usermodel.XSSFCell;

import org.apache.poi.xssf.usermodel.XSSFFont;

import org.apache.poi.xssf.usermodel.XSSFRow;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import org.springframework.stereotype.Service;

import org.springframewo