Galera na boa?
Aqui estou bem o inicio da minha saga para adquirir o tal conhecimento JSP… estou com uma duvida que peço a ajuda de meus amigos.
Quero saber o valor de uma consulta SUM … tenho uma tabela que possui uma coluna onde quero saber o valor total deste dados.
Segue o código:
<%@ page session=“false” %>
<%@ page import=“java.sql.*” %>
<%
try {
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
System.out.println(“JDBC driver loaded”);
}
catch (ClassNotFoundException e) {
System.out.println(e.toString());
}
%>
Quantidades:
Efetuadas: |
10.000 | Recebidas: | <% out.print(custo); %> |
|---|
| Ramal | Numero Discado |
Data |
Valor |
|---|
<% out.print(rs.getString(1)); %>
|
<% out.print(rs.getString(3)); %>
|
<% out.print(rs.getString(4)); %>
|
<% out.print(rs.getString(10)); %>
|
Estou recebendo o seguinte erro:
HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 43 in the jsp file: /obdc.jsp
Generated servlet error:
C:\Documents and Settings\valmir.netbeans\5.5\apache-tomcat-5.5.17_base\work\Catalina\localhost\AplicacaoWeb1\org\apache\jsp\obdc_jsp.java:85: cannot find symbol
symbol : variable custo
location: class org.apache.jsp.obdc_jsp
out.print(custo);
^
An error occurred at line: 62 in the jsp file: /obdc.jsp
Generated servlet error:
C:\Documents and Settings\valmir.netbeans\5.5\apache-tomcat-5.5.17_base\work\Catalina\localhost\AplicacaoWeb1\org\apache\jsp\obdc_jsp.java:106: cannot find symbol
symbol : class custo
location: class org.apache.jsp.obdc_jsp
int custo = new custo();
^
2 errors
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper
.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.jav
a:368)
root cause
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 43 in the jsp file: /obdc.jsp
Generated servlet error:
C:\Documents and Settings\valmir.netbeans\5.5\apache-tomcat-5.5.17_base\work\Catalina\localhost\AplicacaoWeb1\org\apache\jsp\obdc_jsp.java:85: cannot find symbol
symbol : variable custo
location: class org.apache.jsp.obdc_jsp
out.print(custo);
^
An error occurred at line: 62 in the jsp file: /obdc.jsp
Generated servlet error:
C:\Documents and Settings\valmir.netbeans\5.5\apache-tomcat-5.5.17_base\work\Catalina\localhost\AplicacaoWeb1\org\apache\jsp\obdc_jsp.java:106: cannot find symbol
symbol : class custo
location: class org.apache.jsp.obdc_jsp
int custo = new custo();
^
2 errors
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.ja
va:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:328)
org.apache.jasper.compiler.AntCompiler.generateClass(AntCompiler.java:249)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:297)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:276)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:264)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:563)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:303)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.jav
a:368)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs.
Apache Tomcat/5.5.17
Por favor me ajudem…
Vlw galera obrigado
Abraços
