jsp

Expert:keerthi
<%@ page import = "java.sql.*;" errorPage = "Error.jsp" %>

<%!
Connection con;
Statement st;
ResultSet rs;
ResultSetMetaData rsmd;
boolean flag = false;
%>

<html>
<body bgcolor = "abcdef">
<center>
<br><br><br>
<table border = 2>
<tr>

<%

String origin = request.getParameter("src");
String dest = request.getParameter("dest");

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("driver is loaded........");
con = DriverManager.getConnection("jdbc:odbc:msdsn");
System.out.println("got the con object ");
st = con.createStatement();
System.out.println("got the st object ");
rs = st.executeQuery("select * from FlightDetails where Source="+src+ "and Destination="+dest);
System.out.println("got the rs object");

rsmd = rs.getMetaData();
System.out.println("got the rsmd object");
int cnt = rsmd.getColumnCount();
System.out.println("after the cnt " + cnt);

for(int i=1;i<=cnt;i++)
{
%>
<td bgcolor = "##ffccccc"> <%= rsmd.getColumnName(i) %> </td>
<%
}
%>
</tr>

<%
while(rs.next())
{
%>
<tr>
<%
for(int i=1;i<=cnt;i++)
{
%>
<td> <%= rs.getString(i)%></td>

<%
}
%>
</tr>
<%
}

%>

result:
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: 20 in the jsp file: /Flightdetails.jsp

Generated servlet error:
[javac] Compiling 1 source file

C:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\Airlines-Project\org\apache\jsp\Flightdetails_jsp.java:69: cannot find symbol
symbol : variable src
location: class org.apache.jsp.Flightdetails_jsp
rs = st.executeQuery("select * from FlightDetails where Source="+src+ "and Destination="+dest);
^
1 error

org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:127)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:351)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:418)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:461)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:442)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:552)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:291)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

note The full stack trace of the root cause is available in the Tomcat logs.

--------------------------------------------------------------------------------

Apache Tomcat/5.0.14

Answers

Hi keerthi,

U r using wrong variables in query expression.

U have to use "origin" not src in query expression as src is only request parameter but not local variable. Thats y it is telling "undefined symbol:src". Please change it.

Another thing is,

origin & dest are strings here. Ur syntax of query expression is wrong. Please change it as follows:

"select * from FlightDetails where Source='"+origin+"' and Destination='"+dest+"'"

If U have to use them as integers in the query, first convert them into integers and use them as follows:

"select * from FlightDetails where Source="+origin+" and Destination="+dest"

I think it will work fine.

Regards,
Sreenivas

More Questions

Post Answers

Ask Question Facing Programming Problem?