在JSP上使用Apache POI时出现异常(Exception while using Apache POI on a JSP)
我正在尝试实现Apache POI以将Excel文件中的数据显示在我的网页上的某些输入中。 我得到了这个例外:
exception org.apache.jasper.JasperException: Unable to compile class for JSP org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:677) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:364) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) root cause java.lang.IllegalArgumentException: Page directive: invalid value for import org.apache.jasper.compiler.Node$PageDirective.validateImport(Node.java:628) org.apache.jasper.compiler.Node$PageDirective.addImport(Node.java:611) org.apache.jasper.compiler.Parser.parsePageDirective(Parser.java:352) org.apache.jasper.compiler.Parser.parseDirective(Parser.java:473) org.apache.jasper.compiler.Parser.parseFileDirectives(Parser.java:1773) org.apache.jasper.compiler.Parser.parse(Parser.java:135) org.apache.jasper.compiler.ParserController.doParse(ParserController.java:242) org.apache.jasper.compiler.ParserController.parseDirectives(ParserController.java:119) org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:194) org.apache.jasper.compiler.Compiler.compile(Compiler.java:374) org.apache.jasper.compiler.Compiler.compile(Compiler.java:354) org.apache.jasper.compiler.Compiler.compile(Compiler.java:341) org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:662) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:364) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)这是我在.jsp文件中的代码:
<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ page import="java.io.FileInputStream, java.io.FileNotFoundException, java.io.IOException, org.apache.poi.hssf.usermodel.HSSFCell, org.apache.poi.hssf.usermodel.HSSFRow, org.apache.poi.hssf.usermodel.HSSFSheet, org.apache.poi.hssf.usermodel.HSSFWorkbook;"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head></head> <body> <% HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream("excel.xls")); HSSFSheet sheet = workbook.getSheetAt(0); HSSFRow row = sheet.getRow(1); double Something,Something1,Something2,Something3,Something4; Something= row.getCell(0).getNumericCellValue(); Something1= row.getCell(1).getNumericCellValue(); Something2= row.getCell(2).getNumericCellValue(); Something3= row.getCell(3).getNumericCellValue(); Something4= row.getCell(4).getNumericCellValue(); %> <div> <table> <tr> <td>Something: </td> <td><input type="text" value="<% Something %>"></td> </tr> <tr> <td>Something1: </td> <td><input type="text" value="<% Something1 %>"></td> </tr> <tr> <td>Something2: </td> <td><input type="text" value="<% Something2 %>"></td> </tr> <tr> <td>Something3: </td> <td> <input type="text" value="<% Something3 %>"></td> </tr> <tr> <td>Something4: </td> <td><input type="text" value="<% Something4 %>"></td> </tr> </table> </div> </body> </html>有谁知道问题出在哪里?
I'm trying to implement Apache POI to display the data on an Excel file into some inputs on my web page. I'm getting this exception:
exception org.apache.jasper.JasperException: Unable to compile class for JSP org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:677) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:364) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) root cause java.lang.IllegalArgumentException: Page directive: invalid value for import org.apache.jasper.compiler.Node$PageDirective.validateImport(Node.java:628) org.apache.jasper.compiler.Node$PageDirective.addImport(Node.java:611) org.apache.jasper.compiler.Parser.parsePageDirective(Parser.java:352) org.apache.jasper.compiler.Parser.parseDirective(Parser.java:473) org.apache.jasper.compiler.Parser.parseFileDirectives(Parser.java:1773) org.apache.jasper.compiler.Parser.parse(Parser.java:135) org.apache.jasper.compiler.ParserController.doParse(ParserController.java:242) org.apache.jasper.compiler.ParserController.parseDirectives(ParserController.java:119) org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:194) org.apache.jasper.compiler.Compiler.compile(Compiler.java:374) org.apache.jasper.compiler.Compiler.compile(Compiler.java:354) org.apache.jasper.compiler.Compiler.compile(Compiler.java:341) org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:662) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:364) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)And this the code I have on my .jsp file:
<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ page import="java.io.FileInputStream, java.io.FileNotFoundException, java.io.IOException, org.apache.poi.hssf.usermodel.HSSFCell, org.apache.poi.hssf.usermodel.HSSFRow, org.apache.poi.hssf.usermodel.HSSFSheet, org.apache.poi.hssf.usermodel.HSSFWorkbook;"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head></head> <body> <% HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream("excel.xls")); HSSFSheet sheet = workbook.getSheetAt(0); HSSFRow row = sheet.getRow(1); double Something,Something1,Something2,Something3,Something4; Something= row.getCell(0).getNumericCellValue(); Something1= row.getCell(1).getNumericCellValue(); Something2= row.getCell(2).getNumericCellValue(); Something3= row.getCell(3).getNumericCellValue(); Something4= row.getCell(4).getNumericCellValue(); %> <div> <table> <tr> <td>Something: </td> <td><input type="text" value="<% Something %>"></td> </tr> <tr> <td>Something1: </td> <td><input type="text" value="<% Something1 %>"></td> </tr> <tr> <td>Something2: </td> <td><input type="text" value="<% Something2 %>"></td> </tr> <tr> <td>Something3: </td> <td> <input type="text" value="<% Something3 %>"></td> </tr> <tr> <td>Something4: </td> <td><input type="text" value="<% Something4 %>"></td> </tr> </table> </div> </body> </html>Does someone knows where's the problem?
最满意答案
不确定您使用的是哪个服务器。 但是如果它是Tomcat 7.0.57或更高版本(也看看这个链接 ),那么你需要在import指令的末尾删除分号(;)。 尝试删除它,它应该工作。
Not sure which server you are using. But if it is Tomcat 7.0.57 or later(Have a look at this link too), then you need to remove the semicolon (;) at the end of import directives. Try removing that and it should work.
更多推荐
发布评论