Java EE (Java Enterprise Edition) General Discussion

Hi, Friends

I like to query to extract data from my table with the help of radio button but I am not able to think what I should write to query. Plz help.
The radio button select jsp page code is-

<form action="queryservice.jsp" method="post">
<h3><strong>Services Available</strong></h3>
  <p>
    <label>
      <input type="radio" name="service" value="si"  />
      Institutions</label>
    <br />
    <label>
      <input type="radio" name="service" value="sc" />
      Corporate_Offices</label>
    <br />
    <label>
      <input type="radio" name="service" value="sr" />
      Restaurent_Cafe</label>
    <br />
    <label>
      <input type="radio" name="service" value="sb" />
      Bus_Stop</label>
    <br />
    <label>
      <input type="radio" name="service" value="sa" />
      Apartment</label>
    <br />
    <label>
      <input type="radio" name="service" value="sh" />
      Hotels</label>
    <br />
  </p>
  <label>
    <input type="submit" value="Submit" />
  </label>
</form>

And queryservice.jsp page is--

<%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql" %>
 
<sql:query var="xyz" scope="request">
 
   <% String var = request.getParameter("service"); %>
           
         if(var.equals("si")){ SELECT si FROM serviceTable}
	 else if(var.equals("sc")){ SELECT sc FROM serviceTable}
	 else if(var.equals("sr")){ SELECT sr FROM serviceTable}
	 else if(var.equals("sb")){ SELECT sb FROM serviceTable}
	 else if(var.equals("sa")){ SELECT sa FROM serviceTable}
	 else if(var.equals("sh")){ SELECT sh FROM serviceTable}
 
</sql:query>

And the Error Report-

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: javax.servlet.ServletException: javax.servlet.jsp.JspException: 
 
   
           
       if(var.equals("si")){ SELECT si FROM serviceTable }
	 else if(var.equals("sc")){ SELECT sc FROM serviceTable}
	 else if(var.equals("sr")){ SELECT sr FROM serviceTable}
	 else if(var.equals("sb")){ SELECT sb FROM serviceTable}
	 else if(var.equals("sa")){ SELECT sa FROM serviceTable}
	 else if(var.equals("sh")){ SELECT sh FROM serviceTable}
 
: Non supported SQL92 token at position: 57: SELECT
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:541)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause 
javax.servlet.ServletException: javax.servlet.jsp.JspException: 
 
   
           
       note The full stack trace of the root cause is available in the Apache Tomcat/6.0.14 logs.
 
Apache Tomcat/6.0.14
 

Need you people Help.