大概的截图。很简单的小功能
注：使用的是MyEclipse 10.0 javaee 6.0 tomcat 6.0 导出指定列名。使用VO接受参数。
SpringMVC+Hibernate +MySql+ EasyUI实现POI导出Excel(二) 和 批量删除数据 小功能的实现
1.datagrid新加的导出按钮代码
/*导出excel 按钮*/ toolbar:[{ id:'btnsave', text:'导出', iconCls:'icon-save', handler:function(){ var url = '${ctx}/export?method=sheetsExport'; window.location.href=url; } }] 2.批量删除的js代码和html代码
/****批量删除******/ $(function(){ $("#deletes").bind("click",function(){ var selrow = $("#dg").datagrid("getSelections"); if(selrow.length==0){ alert("至少选择一条数据"); return false; } var ids=[]; for(var i = 0; i < selrow.length; i++){ var id = selrow[i].id; ids.push(id); } if(confirm("您确定批量删除")){ $.getJSON("${ctx}/user/delall",{"array[]":ids}, function(data){ alert(data.msg); if(true == data.success){ $("#dg").datagrid("reload"); } }) } }) })html 批量删除 3.导出Controller代码
package com.xs.demo.controller;import java.io.OutputStream;import java.net.URLEncoder;import java.text.SimpleDateFormat;import java.util.Date;import java.util.List;import java.util.Map;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.apache.poi.ss.formula.functions.T;import org.springframework.stereotype.Controller;import org.springframework.web.bind.ServletRequestUtils;import org.springframework.web.bind.annotation.RequestMapping;import com.xs.demo.dao.UserDao;import com.xs.demo.entity.Userinfo;import com.xs.demo.service.ExportExcel;import com.xs.demo.service.UserService;import com.xs.demo.util.ExcelUtils;import com.xs.demo.util.JsGridReportBase;import com.xs.demo.util.StringUtil;import com.xs.demo.util.TableData;/** * * 类名称:ExportController * @author 宗潇帅 * 2014-11-18 */@Controller@RequestMapping(value="/export")public class ExportController { UserService userService; UserDao userDao; ExportExcel excelService = new ExportExcel (); /** * * @param request * @param response * @throws Exception */ @SuppressWarnings({ "rawtypes", "unchecked" }) @RequestMapping(params="method=sheetsExport") public void exportSheets(HttpServletRequest request, HttpServletResponse response)throws Exception { Userinfo userinfo = new Userinfo(); List list = userService.lists(userinfo);//查询所有的数据 String haders[] = new String []{"序号","名称","年龄","生日","地址","学号"}; SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); String filename = format.format(new Date().getTime())+".xls"; response.setContentType("application/ms-excel;charset=UTF-8"); response.setHeader("Content-Disposition", "attachment;filename=" .concat(String.valueOf(URLEncoder.encode(filename, "UTF-8")))); OutputStream out = response.getOutputStream(); try { excelService.exportExcel(haders,list,out); System.out.println("success"); } catch (Exception e) { System.out.println("error"); }finally{ out.close(); } } public UserService getUserService() { return userService; } public void setUserService(UserService userService) { this.userService = userService; } public UserDao getUserDao() { return userDao; } public void setUserDao(UserDao userDao) { this.userDao = userDao; } public ExportExcel getExcelService() { return excelService; } public void setExcelService(ExportExcel excelService) { this.excelService = excelService; } } 3. 工具类代码在这里。
4.userdao代码
public Listlists(Userinfo userinfo) { return super.list(Userinfo.class); }
http://yun.baidu.com/pcloud/album/info?query_uk=3724757956&album_id=3094796070610213829源代码和jar包。讲本页面所需要的代码复制相应的位置即可。
个人微博 http://weibo.com/zxshuai319
个人博客
公开QQ 783021975
个人联盟