老师看看哪儿出错了？

<%@page language="java" contentType="text/html;charset=UTF-8" pageEncoding="UTF-8" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core_rt" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
   <head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
      <meta http-equiv="X-UA-Compatible" content="IE=9; IE=8; IE=7; IE=EDGE"/>
      <title></title>
      <link rel="stylesheet" type="text/css" href="css/all.css"/>
      <link rel="stylesheet" type="text/css" href="css/pop.css"/>
      <link rel="stylesheet" type="text/css" href="css/main.css"/>
      <script type="text/javascript">
         function bodyInit() {
            if('${result.msg}'){
               alert('${result.msg}');
            }
         }
      </script>
   </head>
   <body style="background: #e1e9eb;" onload="bodyInit()">
      <form action="" id="mainForm" method="post">
         <div class="right">
            <div class="current">
               当前位置：<a href="#">导入/导出</a> &gt; 导入结果
            </div>
            <div class="rightCont">
               <p class="g_title fix">导入结果展示</p>
               <table class="tab1">
                  <tbody>
                     <tr>
                        <td align="right" width="80">标题：</td>
                        <td>${result.title}</td>
                     </tr>
                  </tbody>
               </table>
               <div class="zixun fix">
                  <table class="tab2" width="100%">
                     <tbody>
                        <tr>
                           <th>序号</th>
                           <th>姓名</th>
                           <th>年龄</th>
                           <th>出生日期</th>
                        </tr>
                        <c:forEach items="result.studentList" var="item" varStatus="s">
                           <tr>
                              <td>${s.count}</td>
                              <td>${item.name}</td>
                              <td>${item.age}</td>
                              <td><fmt:formatDate value="${item.time}" pattern="yyyy-MM-dd"/></td>
                           </tr>
                        </c:forEach>
                     </tbody>
                  </table>
               </div>
            </div>
         </div>
      </form>
   </body>
</html>

package org.imocc.service;

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.ss.usermodel.WorkbookFactory;
import org.imocc.dto.ImportExcelParamDto;
import org.imocc.dto.ImportExcelResultDto;
import org.imocc.entity.Student;
import org.imocc.util.FileUtil;

import javax.resource.spi.work.Work;
import java.io.File;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

public class ExcelService {
    public ImportExcelResultDto imp(ImportExcelParamDto dto){
        ImportExcelResultDto result = new ImportExcelResultDto();
        result.setTitle(dto.getTitle());
        List<Student> studentList = new ArrayList<>();


//        String fileName = null;
//        try {
//            fileName = FileUtil.save(dto.getExcel(),FileUtil.SAVE_PATH);
//        } catch (Exception e) {
//            e.printStackTrace();
//            result.setMsg("保存上传文件失败了");
//        }

        Workbook workbook = null;
        try {
            workbook = WorkbookFactory.create(dto.getExcel().getInputStream());
            Sheet sheet = workbook.getSheetAt(0);
            int rowNum = sheet.getLastRowNum();
            for (int i = 1; i <=rowNum ; i++) {
                Row row = sheet.getRow(i);
//                    System.out.println();
//                    System.out.println("姓名：" + row.getCell(0).getStringCellValue());
//                    System.out.println("年龄：" + row.getCell(1).getNumericCellValue());
//                    System.out.println("时间：" + row.getCell(2).getDateCellValue());
                Student student = new Student();
                student.setName(row.getCell(0).getStringCellValue());
                student.setAge((int)row.getCell(1).getNumericCellValue());
                student.setTime(row.getCell(2).getDateCellValue());
                studentList.add(student);

            }
        } catch (Exception e) {
            e.printStackTrace();
            result.setMsg("解析Excel失败了");
        } finally {
            if(workbook!=null){
                try {
                    workbook.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
        return result;


    }
}

package org.imocc.entity;

import java.util.Date;

public class Student {
    private String name;
    private int age;
    private Date time;

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public Date getTime() {
        return time;
    }

    public void setTime(Date time) {
        this.time = time;
    }
}

package org.imocc.dto;

import org.apache.commons.fileupload.FileItem;

public class ImportExcelParamDto {
    private String title;
    //解析好的FileItem
    private FileItem excel;

    public String getTitle() {
        return title;
    }

    public void setTitle(String title) {
        this.title = title;
    }

    public FileItem getExcel() {
        return excel;
    }

    public void setExcel(FileItem excel) {
        this.excel = excel;
    }
}

package org.imocc.dto;

import org.imocc.entity.Student;

import java.util.List;

public class ImportExcelResultDto {
    private String title;
    private List<Student> studentList;
    private String msg;

    public String getMsg() {
        return msg;
    }

    public void setMsg(String msg) {
        this.msg = msg;
    }

    public String getTitle() {
        return title;
    }

    public void setTitle(String title) {
        this.title = title;
    }

    public List<Student> getStudentList() {
        return studentList;
    }

    public void setStudentList(List<Student> studentList) {
        this.studentList = studentList;
    }
}

package org.imocc.dto;

import org.apache.commons.fileupload.FileItem;

import java.util.HashMap;
import java.util.Map;

public class ParamDto {
    private Map<String,String> paramMap;
    private Map<String, FileItem> fileMap;

    public ParamDto(){
        paramMap = new HashMap<String,String>();
        fileMap = new HashMap<String, FileItem>();
    }

    public Map<String, String> getParamMap() {
        return paramMap;
    }

    public void setParamMap(Map<String, String> paramMap) {
        this.paramMap = paramMap;
    }

    public Map<String, FileItem> getFileMap() {
        return fileMap;
    }

    public void setFileMap(Map<String, FileItem> fileMap) {
        this.fileMap = fileMap;
    }
}

package org.imocc.servlet;

import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.FileUploadException;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;
import org.imocc.dto.ImportExcelParamDto;
import org.imocc.dto.ImportExcelResultDto;
import org.imocc.dto.ParamDto;
import org.imocc.service.ExcelService;
import org.imocc.util.RequestUtil;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.IOException;
import java.util.List;

public class ImportExcelServlet extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req, resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        if(ServletFileUpload.isMultipartContent(req)){
            ParamDto dto = RequestUtil.parseParam(req);
            ImportExcelParamDto paramDto = new ImportExcelParamDto();
            paramDto.setTitle(dto.getParamMap().get("title"));
            paramDto.setExcel(dto.getFileMap().get("excel"));
            ExcelService service = new ExcelService();
            ImportExcelResultDto resultDto =service.imp(paramDto);

            req.setAttribute("result",resultDto);
        }else {
//            req.getParameter();
        }
        //知道表单是上传文件表单还是普通表单？
        req.getRequestDispatcher("WEB-INF/jsp/importExcelResult.jsp").forward(req,resp);
    }

}

package org.imocc.servlet;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

public class ImportExcelInitServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req, resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.getRequestDispatcher("/WEB-INF/jsp/importExcel.jsp").forward(req,resp);
    }
}

package org.imocc.servlet;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

public class IndexServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req, resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.getRequestDispatcher("/WEB-INF/jsp/index.jsp").forward(req,resp);
    }
}

package org.imocc.util;

import org.apache.commons.fileupload.FileItem;

import java.io.File;

public class FileUtil {
    //上传文件的保存路径
    public  static  final String SAVE_PATH ="d:/JAVA/JavaWeb/web/upload/";

    //保存上传的文件
    public static String save(FileItem fileItem,String path) throws Exception{
        String fileName = System.currentTimeMillis() + "_" + fileItem.getName();

        fileItem.write(new File(path+fileName));
        return  fileName;

    }
}

package org.imocc.util;

import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.FileUploadException;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;
import org.imocc.dto.ParamDto;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.util.List;

public class RequestUtil {
    /**\
     * 从request流中解析参数与上传的文件
     * @param request
     */
    public static ParamDto parseParam(HttpServletRequest request){
        ParamDto result = new ParamDto();
        ServletFileUpload upload = new ServletFileUpload(new DiskFileItemFactory());
        upload.setHeaderEncoding("UTF-8");
        //解析request流
        try {
            //把整个表单中的文件全部拿进list
            List<FileItem> fileItemList = upload.parseRequest(request);
            for (FileItem item:fileItemList){
                if(item.isFormField()){
                    try {
                        result.getParamMap().put(item.getFieldName(),item.getString("UTF-8"));
                    } catch (UnsupportedEncodingException e) {
                        e.printStackTrace();
                    }
                }else {
                    result.getFileMap().put(item.getFieldName(),item);
                }
            }
        } catch (FileUploadException e) {
            e.printStackTrace();
        }
        return  result;
    }
}

96年的nash 2019-04-04

源自：项目：Java导入导出 2-6 导入Excel-4

0

收起

4回答

好帮手慕珊 2019-04-05 21:45:35

你好！如下图所示，ExcelService中的result和studentList没有关系吧，最后应该返回的是list吧

因为返回的是result，而result和list也没关系，所以result.studentList是一个无法通过forEach遍历的数据，所以就报错了。

祝学习愉快！

好帮手慕珊 2019-04-05 09:59:20

你好！下面选中的这个地方写错了，应该改为${result.studentList}

如果我的回答解决了你的疑惑，请采纳！祝学习愉快！

提问者 96年的nash #1

还是报同样的错误，老师 WEB-INF/jsp/importExcelResult.jsp (line: [46], column: [8]) According to TLD or attribute directive in tag file, attribute [items] does not accept any expressions

2019-04-05 13:53:21

chrismorgen 2019-04-04 17:55:34

你好同学，请问你引入的jstl的jar包是什么版本呢？根据报错提示来看，问题出在了jstl上，建议你使用如下导包代码试试，看是否可以运行成功，祝学习愉快~

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

提问者 96年的nash #1

改了老师，还是无法运行，500

2019-04-04 20:56:11

提问者 96年的nash 2019-04-04 13:22:04

还请老师答疑的快一点，全天候学习找不到错误很难受，老师辛苦了

相似问题

麻烦老师看看哪里出错了

老师帮看看是哪里出错了

老师这个是哪儿错了

请老师看看哪儿错了

老师看这里！我的URL错在哪里了？为什么会报错？

登录后可查看更多问答，登录/注册

从网页搭建入门Java Web2018版

参与学习人
提交作业 1088 份
解答问题 10204 个

如果你有Java语言基础，又想以后从事Java Web开发，那么本路径是你的不二选择！本路径从网页搭建开始入手，通过大量案例来学习Java Web基础。定能助你完成Java Web小白的蜕变！

本课精华内容

问答作业

为什么这样不报错？

6 1

老师请问一下

1 4

老师这样写可以嘛

2 1

老师这样写可以吗

7 1

我为了实现两行三列的效果，设置了三级div。老师您看，这样编程符合要求吗

10 1

查看更多本课问答

请稍等 ...

购课补贴
联系客服咨询优惠详情

帮助反馈 APP下载

慕课网APP
您的移动学习伙伴

扫描二维码
关注慕课网微信公众号