jxl问题,急呀,帮忙,
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 6 in the jsp file: /web1/web/shiyan.jsp
Generated servlet error:
[javac] Compiling 1 source file
D:\Tomcat4\work\Standalone\localhost\_\web1\web\shiyan_jsp.java:60: cannot resolve symbol
symbol : variable rwb
location: class org.apache.jsp.shiyan_jsp
jxl.Sheet rs = rwb.getSheet(0);
^
An error occurred at line: 6 in the jsp file: /web1/web/shiyan.jsp
Generated servlet error:
D:\Tomcat4\work\Standalone\localhost\_\web1\web\shiyan_jsp.java:74: cannot resolve symbol
symbol : variable content
location: class org.apache.jsp.shiyan_jsp
content=cell.getContents();//getContents()灏?ell涓??瀛??杞?负瀛??涓?
^
An error occurred at line: 6 in the jsp file: /web1/web/shiyan.jsp
Generated servlet error:
D:\Tomcat4\work\Standalone\localhost\_\web1\web\shiyan_jsp.java:75: cannot resolve symbol
symbol : variable sql1
location: class org.apache.jsp.shiyan_jsp
sql1="insert into xzqf(nsrsbh)values('"+content+"')";
^
An error occurred at line: 6 in the jsp file: /web1/web/shiyan.jsp
Generated servlet error:
D:\Tomcat4\work\Standalone\localhost\_\web1\web\shiyan_jsp.java:75: cannot resolve symbol
symbol : variable content
location: class org.apache.jsp.shiyan_jsp
sql1="insert into xzqf(nsrsbh)values('"+content+"')";
^
An error occurred at line: 6 in the jsp file: /web1/web/shiyan.jsp
Generated servlet error:
D:\Tomcat4\work\Standalone\localhost\_\web1\web\shiyan_jsp.java:76: cannot resolve symbol
symbol : variable sql
location: class org.apache.jsp.shiyan_jsp
Statement rs1=sb.executeUpdata(sql);
^
An error occurred at line: 6 in the jsp file: /web1/web/shiyan.jsp
Generated servlet error:
D:\Tomcat4\work\Standalone\localhost\_\web1\web\shiyan_jsp.java:81: cannot resolve symbol
symbol : variable content
location: class org.apache.jsp.shiyan_jsp
content=cell.getContents();//getContents()灏?ell涓??瀛??杞?负瀛??涓?
^
An error occurred at line: 6 in the jsp file: /web1/web/shiyan.jsp
Generated servlet error:
D:\Tomcat4\work\Standalone\localhost\_\web1\web\shiyan_jsp.java:82: cannot resolve symbol
symbol : variable sql1
location: class org.apache.jsp.shiyan_jsp
sql1="insert into xzqf(yb)values('"+content+"')";
^
An error occurred at line: 6 in the jsp file: /web1/web/shiyan.jsp
Generated servlet error:
D:\Tomcat4\work\Standalone\localhost\_\web1\web\shiyan_jsp.java:82: cannot resolve symbol
symbol : variable content
location: class org.apache.jsp.shiyan_jsp
sql1="insert into xzqf(yb)values('"+content+"')";
^
An error occurred at line: 6 in the jsp file: /web1/web/shiyan.jsp
Generated servlet error:
D:\Tomcat4\work\Standalone\localhost\_\web1\web\shiyan_jsp.java:83: cannot resolve symbol
symbol : variable sql1
location: class org.apache.jsp.shiyan_jsp
Statement rs2=sb.executeUpdata(sql1);
^
9 errors
at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:85)
at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:248)
at org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:315)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:328)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:427)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:142)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
--------------------------------------------------------------------------------
问题点数：20、回复次数：5Top
1 楼tongxin9377（）回复于 2006-03-07 12:59:40 得分 0
源代码如下
<%
String path="c:\\djrd.xls";//Excel文件URL
InputStream is = new FileInputStream(path);//写入到FileInputStream
jxl.Workbook wb = Workbook.getWorkbook(is); //得到工作薄
jxl.Sheet st = wb.getSheet(0);//得到工作薄中的第一个工作表
jxl.Sheet rs = rwb.getSheet(0);
int rsColumns = rs.getColumns();//得到工作簿的列数
//jxl.Sheet rs = rwb.getSheet(0);
int rsRows = rs.getRows();//得到工作簿的总行数
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\Tomcat4\\webapps\\ROOT\\web1\\web\\db1.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url);
Statement sb=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
int j=0;
for(;j<=rsRows;j++){
//for(i<=rsColumns;i++{
Cell cell=st.getCell(0,j);//得到工作表的第一个单元格,即A1
content=cell.getContents();//getContents()将Cell中的字符转为字符串
sql1="insert into xzqf(nsrsbh)values('"+content+"')";
Statement rs1=sb.executeUpdata(sql);
}
for(;j<=rsRows;j++){
//for(i<=rsColumns;i++{
Cell cell=st.getCell(1,j);//得到工作表的第一个单元格,即A1
content=cell.getContents();//getContents()将Cell中的字符转为字符串
sql1="insert into xzqf(yb)values('"+content+"')";
Statement rs2=sb.executeUpdata(sql1);
}
wb.close();
is.close();
%>Top
2 楼tongxin9377（）回复于 2006-03-07 13:57:08 得分 0
顶起来，Top
3 楼TomyGuan（）回复于 2006-03-07 16:56:15 得分 20
InputStream is = new FileInputStream(path);//写入到FileInputStream
jxl.Workbook wb = Workbook.getWorkbook(is); //得到工作薄
jxl.Sheet st = wb.getSheet(0);//得到工作薄中的第一个工作表
jxl.Sheet rs = rwb.getSheet(0);
int rsColumns = rs.getColumns();//得到工作簿的列数
//jxl.Sheet rs = rwb.getSheet(0);
int rsRows = rs.getRows();//得到工作簿的总行数
你仔細看一下。
wb寫成了rwb了。
改為：
jxl.Sheet rs = wb.getSheet(0);
然就說是sql1沒定義。
你是不是COPY人家的代碼的呀，還是你不想看呀。這樣都看不出？不是吧!!!Top
4 楼yuzhenhao（【◎沃玛教主◎】）回复于 2006-03-09 00:08:10 得分 0
帮他干吗？？？？
只提问题不结贴。Top
5 楼yuzhenhao（【◎沃玛教主◎】）回复于 2006-03-09 00:13:05 得分 0
http://community.csdn.net/Expert/TopicView3.asp?id=4592555
这个是他原贴，都懒得动脑子，服了。Top
相关问题
关键词
得分解答快速导航
相关链接
广告也精彩
反馈
