在项目开发过程中，用到了基于用户操作的数据库表格导出，记录下来，以备下次使用：
后台代码实现（基于SpringMvc）：
import java.io.File; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.io.UnsupportedEncodingException; import java.net.URLEncoder; import java.util.ArrayList; import java.util.Date; import java.util.List; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Qualifier; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; import org.springframework.web.multipart.MultipartFile; import com.chengpai.person.bean.Person; import com.chengpai.person.bean.bumenMidObject; import com.chengpai.person.service.PersonService; import util.Mobile; import util.Upload; @Controller public class PersonController { @RequestMapping(value = "testex.do", method = RequestMethod.GET) @ResponseBody public Mobile ll(HttpServletRequest request, HttpServletResponse response) { response.setContentType("text/html;charset=UTF-8"); Person p = new Person(); p.setId(0); p.setName("zhangsan"); p.setPassword("123"); Person p1 = new Person(); p1.setId(1); p1.setName("zhangsansan"); p1.setPassword("1234"); List<Person> list = new ArrayList<Person>(); list.add(p); list.add(p1); // 创建一个excel文件 HSSFWorkbook demoexcel = new HSSFWorkbook(); // 创建Sheet对象 HSSFSheet demoSheet = demoexcel.createSheet("用户列表1"); // 创建excel文件标题 String[] tableHeader = { "用户编号", "用户名", "用户密码" }; // 创建行的对象 HSSFRow row = demoSheet.createRow(0);// 参数为行下标,下标从0开始 // 创建单元格 for (int i = 0; i < tableHeader.length; i++) { HSSFCell cell = row.createCell(i);// 在一行中创建N个单元格,单元格下标从0开始 // 将标题信息添加入单元格 cell.setCellValue(tableHeader[i]); } for (int i = 0; i < list.size(); i++) { HSSFRow row1 = demoSheet.createRow(i + 1); HSSFCell cell1 = row1.createCell(0); cell1.setCellValue(list.get(i).getId()); HSSFCell cell2 = row1.createCell(1); cell2.setCellValue(list.get(i).getName()); HSSFCell cell3 = row1.createCell(2); cell3.setCellValue(list.get(i).getPassword()); } // 设置以网格的形式输出对象 demoSheet.setGridsPrinted(true); String filename = "aaa用户信息.xls"; try { response.addHeader("Content-DisPosition", "attachment;filename=" + URLEncoder.encode(filename, "UTF-8")); } catch (UnsupportedEncodingException e) { // TODO Auto-generated catch block e.printStackTrace(); } // 将内存中的对象写入到硬盘 try { OutputStream os = response.getOutputStream(); demoexcel.write(os); os.flush(); os.close(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } boolean a = true; Mobile mo = null; if (a) { mo = new Mobile("1", "添加成功", null); } else { mo = new Mobile("0", "添加失败", null); } return mo; } }前台H5界面的实现，（ajax触发请求）： <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <script type="text/javascript" src="js/jquery.min.js"></script> <title>文件上传</title> <script type="text/javascript"> $(document).ready(function () { $("#btnImportOK").click(function () { var formData = new FormData($("#uploadForm")[0]); $.ajax({ type: "POST", data: formData, url: "testex.do", contentType: false, processData: false, }).success(function (data) { if (data.status) { console.log(data.url); } else { console.log(data.msg); } }).error(function (data) { alert(data); console.log(data); }); }); }); </script> </head> <body> <a href="testex.do" >下载</a> </body> </html> 打开网页，浏览器会自动打开文件保存路径。