关于ＳｐｒｉｎｇＭＶＣ上传与导出ｅｘｃｅｌ问题

最新推荐文章于 2019-10-21 17:39:48 发布

ranz12

最新推荐文章于 2019-10-21 17:39:48 发布

阅读量701

点赞数

CC 4.0 BY-SA版权

分类专栏：导出文章标签： excel

本文链接：https://blog.csdn.net/ranz12/article/details/46651307

导出专栏收录该内容

2 篇文章

订阅专栏

导入ｅｘｃｅｌ方法

1.首先在前端ＪＳＰ中：

<input type="button" value="Excel导入" class="btn_bg"
onclick="openPage('<c:url value="/person.do?action=showImport"/>','Excel导入',600,400);" />

2.写ｉｍｐｏｒｔ．ｊｓｐ

3．在ｃｏｎｔｒｏｌｌｅｒ中书写跳转网页

/**显示导入文件
   *
   *
   */
   @RequestMapping(params="action=showImport")
   public String showImport(Model model){
       return "person/import";
   }

4.执行导入
   /**执行导入
   *
   *
   */
   @RequestMapping(params = "action=doImport")
   public String doUploadContactPerson(Model model, HttpServletRequest request,
           @RequestParam(value = "personId", required = false) Long personId ) {
       MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
       MultipartFile uploadFile = multipartRequest.getFile("excelFile");
       ExcelUtil excelUtil = new ExcelUtil();

       List<Person> personList = null;
       try {
           // personList = excelUtil.getList(Villager.class,
           // uploadFile.getInputStream(),0,1,1);
           personList = excelUtil.getList(Person.class, uploadFile
                   .getInputStream());
           Object pertsonId;
           //分配组
           if(personId!=null && personList!=null && personList.size()>0){
               for(Person v :personList ){
                   v.setPersonId(personId);
               }
           }

           personService.insertBatch(personList);
           model.addAttribute("message", "导入成功");
       } catch (Exception e) {
           logger.error("导入失败，出错原因：" + e);
           model.addAttribute("message", "失败," + e.toString());
       }
       return "person/import";
   }
5.在ｓｅｒｖｉｃｅ中提供服务

/**
   * 批量处理
   *
   * @param list
   * @throws Exception
   */
   public void insertBatch(List<Person> list) {
       try {
           int i = 1;
           super.getSqlMapClient().startBatch();
           for (Person o : list) {
               super.insert(o);
               i++;
               if (i % 100 == 0)
                   super.getSqlMapClient().executeBatch();
           }
           super.getSqlMapClient().executeBatch();
       } catch (Exception e) {
           logger.error("批量出错" + this.getClass() + e);
       }

以上为ｅｘｃｅｌ导入内容，，，

二：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：：

导出ｅｘｃｅｌ

1.前端ＪＳＰ书写

在ｊｓ中

function exportExcel() {
           document.queryForm.setAttribute("action", "<c:url value='/person.do?action=doExportDetail'/>");
           document.queryForm.submit();
       }

2.在ｃｏｎｔｒｏｌｌｅｒ中导入

ｐｒｉｖａｔｅ　Ｅｘｐｏｒｔ　ｅｘｐｏｒｔ；

/**导出excel
       *
       *
       */
   @RequestMapping(params = "action=doExportDetail")
   public void doExportDetailFee(@ModelAttribute("o")
   Person o, HttpServletResponse response) {
       List<List<String>> details = personService.queryDetailFeeList(o);
       List<String> titles = new ArrayList<String>();
       titles.add("用户名");
       titles.add("密    码");
       titles.add("姓    名");
       titles.add("性    别");
       titles.add("部    门");
       titles.add("电    话");
       titles.add("邮    件");

       export.export("个人信息报表", titles, details, "个人信息报表.xls", response);
       details = null;
       titles = null;
       Runtime.getRuntime().gc();
   }

3.在ｓｅｒｖｉｃｅ中

public List<List<String>> queryDetailFeeList(Person o) {
       StringBuffer sb = new StringBuffer();
//       sb.append(" select feeOne.fee,tz.zzName as orgName,tz.zzCode as orgCode,feeOne.feeTime from ");
//       sb.append(" (select tf.orgId,tf.tfMoney as fee,tf.jfTime as feeTime from t_tfgl tf where 1=1 ");
//       sb.append(SqlMakerUtil.popuBeginDateMysql("tf", "jfTime", o.getBeginTime()));
//       sb.append(SqlMakerUtil.popuEndDateMysql("tf", "jfTime", o.getEndTime()));
//       sb.append(" ) as feeOne ");
//       sb.append(" left join t_tzz tz on feeOne.orgId = tz.id where 1=1 ");
//       sb.append("SELECT tp.`userName`,tp.`passWord`,tp.`readName`,tp.`sex`,tp.`department`,");
//       sb.append("tp.`telephone`,tp.`email`FROM t_person tp ");
//       sb.append("   WHERE 1=1");

／／以上为查询语句。。。。。。。。
       sb.append("select tp.*from t_person tp where 1=1");
       List<Person> personList = super.find(sb.toString());
       List<List<String>> list = new ArrayList<List<String>>();
       List<String> detailList = null;
       for (Person vo : personList) {
           detailList = new ArrayList<String>();
           detailList.add(vo.getUserName());
           detailList.add(vo.getPassWord());
           detailList.add(vo.getReadName());
           detailList.add(vo.getSex());
           detailList.add(vo.getDepartment());
           detailList.add(vo.getTelephone());
           detailList.add(vo.getEmail());
           list.add(detailList);
       }
       return list;
   }

完成