my question is why code below else cause wont execute.
if u know what's going on here..please tell me..
thank u
here is code
====================
<html>
<head>
</head>
<%@ page language="java" import="java.sql.*" %>
<body>
<CENTER><H1>Search Result</H1></CENTER><BR>
<%
try
{
Class.forName("org.gjt.mm.mysql.Driver");
}
catch(Exception e)
{
e.getMessage();
System.err.println("Unable to load driver.");
}
try
{
Connection myConn =
DriverManager.getConnection("jdbc:mysql://localhost/RDB?user=root&password=");
Statement stmt = myConn.createStatement();
String rname= request.getParameter("rname");
String state= request.getParameter("state");
String cuisine= request.getParameter("cuisine");
if (rname != null )
{
String query = "select * from restaurant where rname="+"'"+rname+"'";
ResultSet myResultSet = stmt.executeQuery(query);
if (myResultSet != null)
{
while (myResultSet.next())
{
//specify the field name
String oname = myResultSet.getString("rname");
String ostate= myResultSet.getString("state");
String ocuisine= myResultSet.getString("cuisine");
}
}
}
else ///??? why below code below else wont execute???
{ String query2 = "select * from restaurant";
ResultSet myResultSet = stmt.executeQuery(query2);
if (myResultSet != null)
{
while (myResultSet.next())
{
String oname = myResultSet.getString("rname");
String ostate= myResultSet.getString("state");
String ocuisine= myResultSet.getString("cuisine");
%>
<B><%= oname %></B>
<%=ostate %>
<%=ocuisine %><br>
<%
}
}
// Clean up ourselves
stmt.close();
myConn.close();
}
catch (SQLException E)
{
System.out.println("SQLException: " + E.getMessage());
System.out.println("SQLState: " + E.getSQLState());
System.out.println("VendorError: " + E.getErrorCode());
}
%>
</body>
</html>