Access Data from Database By Submitting The select Values

i am making a program in a JSP. i have used some java script code in this program.

by this program i can find out the result for between years for any class.
i have three combo box for class_name, from_year, to_year. for class_name, Its value is 1 to 12. when i select class 11 or 12, an combox appear for subject having values Arts, comerce and science will be appeared.

in database for class 1 to 10 having subject values is AllSubject. and for class 11 or 12 having subject values arts, commerce and science.

my problem how i make the query which send for class 1 to 10 , assume subject values is all and for class 11 or 12 subject values arts, commerce and science with others combox values.

Here is JSP's files:

display.jsp:

<p></p><br><br><br><br><br><br>
<tr><td style="width: 11px"> <span>Class</td> <td><select name="class_name" onchange="call(this); >
<%

for( int i=1;i<=12;i++){
%>
<option value="<%=i%>"><%=i%></option>
<%
}
%>
</select><td>
<select id="combo" name="combo2">
</select></td>

show.jsp:

<%@ page language="java" import="java.lang.*" import="java.sql.*" import="java.io.*" import="java.net.*"%>
<html>
<body>
<%
String school=request.getParameter("school");
String class_name=(String)request.getParameter("class_name");
String from_year=(String)request.getParameter("from_year");
String to_year=(String)request.getParameter("to_year");
%>
<table align="center" border="1" align="center">
<br>
<tr align="center">
<td width="150"height="30"><font size="+1">Year</td></font>
<td width="150"height="30"><font size="+1">Class</td></font>
<td width="150"height="30"><font size="+1">Subject</td></font>
<td width="150"height="30"><font size="+1">Total Students</td></font>
<td width="150"height="30"><font size="+1">Passout Students</td></font>
<td width="150"height="30"><font size="+1">Marks Obtained 60 To 80</td></font>
<td width="150"height="30"><font size="+1">Marks Obtained over 80</td></font>
<td width="150"height="30"><font size="+1">Overall Result</td></font>
<td width="150"height="30"><font size="+1">School</td></font>
</tr>

<%
Connection con = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
con = DriverManager.getConnection("jdbc:odbc:sql;user=sa;password=1234");
System.out.println("Connection created");
Statement st=con.createStatement();
System.out.println("st going to execute");
String query="SELECT * FROM Result WHERE year BETWEEN '"+from_year+"' AND '"+to_year+"' and school='"+school+"'";
System.out.println("now data are selecting");
ResultSet rs=st.executeQuery(query);
System.out.println("now data in rs.....");
System.out.println("now going to rs block............");
while(rs.next())
{
%>
<tr align="center">
<td width="150"height="30"><%out.println(rs.getString(1));%>
<td width="150"height="30"><%out.println(rs.getString(2));%>
<td width="150"height="30"><%out.println(rs.getString(3));%>
<td width="150"height="30"><%out.println(rs.getString(4));%>
<td width="150"height="30"><%out.println(rs.getString(5));%>
<td width="150"height="30"><%out.println(rs.getString(6));%>
<td width="150"height="30"><%out.println(rs.getString(7));%>
<td width="150"height="30"><%out.println(rs.getInt(8));%>
<td width="150"height="30"><%out.println(rs.getString(9));%>
</tr>
<%
}
rs.close();
con.close();
}catch(Exception e){out.println(e);}
%>
</table>
</body>
</html>

the combo box for subject remain hide when i select class 1 to 10. but if i select class 11 or 12 then
value for subject is Arts, Commerce and Science. how i make query from database base on the subject.
if i select class 1 to 11 the value for subject is all. if i am selected class 11 or 12 then query include the value of combo box subject

please help.

Please indent your code. Without proper indentation even the simplest code, HTML, anything becomes a jumbled soup, impossible to understand.

<p></p><br><br><br><br><br><br>
            <tr>
                <td style="width: 11px"><span>Class</td>
                <td><select name="class_name" onchange="call(this); >
<%

for( int i=1;i<=12;i++){
%>
<option value="<%=i%>"><%=i%></option>
                        <%
}
%>
                    </select>
                <td>
                    <select id="combo" name="combo2">
                    </select></td>

show.jsp

<%@ page language="java" import="java.lang.*" import="java.sql.*" import="java.io.*" import="java.net.*" %>
<html>
<body>
<%
    String school = request.getParameter("school");
    String class_name = (String) request.getParameter("class_name");
    String from_year = (String) request.getParameter("from_year");
    String to_year = (String) request.getParameter("to_year");
%>
<table align="center" border="1" align="center">
    <br>
    <tr align="center">
        <td width="150" height="30"><font size="+1">Year</td>
        </font>
        <td width="150" height="30"><font size="+1">Class</td>
        </font>
        <td width="150" height="30"><font size="+1">Subject</td>
        </font>
        <td width="150" height="30"><font size="+1">Total Students</td>
        </font>
        <td width="150" height="30"><font size="+1">Passout Students</td>
        </font>
        <td width="150" height="30"><font size="+1">Marks Obtained 60 To 80</td>
        </font>
        <td width="150" height="30"><font size="+1">Marks Obtained over 80</td>
        </font>
        <td width="150" height="30"><font size="+1">Overall Result</td>
        </font>
        <td width="150" height="30"><font size="+1">School</td>
        </font>
    </tr>

<%
        Connection con = null;
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con = DriverManager.getConnection("jdbc:odbc:sql;user=sa;password=1234");
            System.out.println("Connection created");
            Statement st = con.createStatement();
            System.out.println("st going to execute");
            String query = "SELECT * FROM Result WHERE year BETWEEN '" + from_year + "' AND '" + to_year + "' and school='" + school + "'";
            System.out.println("now data are selecting");
            ResultSet rs = st.executeQuery(query);
            System.out.println("now data in rs.....");
            System.out.println("now going to rs block............");
            while (rs.next()) {
    %>
    <tr align="center">
        <td width="150" height="30"><%out.println(rs.getString(1));%>
        <td width="150" height="30"><%out.println(rs.getString(2));%>
        <td width="150" height="30"><%out.println(rs.getString(3));%>
        <td width="150" height="30"><%out.println(rs.getString(4));%>
        <td width="150" height="30"><%out.println(rs.getString(5));%>
        <td width="150" height="30"><%out.println(rs.getString(6));%>
        <td width="150" height="30"><%out.println(rs.getString(7));%>
        <td width="150" height="30"><%out.println(rs.getInt(8));%>
        <td width="150" height="30"><%out.println(rs.getString(9));%>
    </tr>
    <%
            }
            rs.close();
            con.close();
        } catch (Exception e) {
            out.println(e);
        }
    %>
</table>
</body>
</html>

You will also find that your HTML is malformed, in several areas, in several different ways.

There is no such thing as a "combo box" in HTML. Please read this for more information. I have adjusted your topic title for you.

I'm not quite sure what you're asking: are you asking how to make a request from the browser to the server, or how to show an element based on the value of another, or...? Could you try asking it in a different way?

Moving to JSP, although the HTML is very broken, and contains some suspicious tags, which should not be used.

Also note that you will be told not to do any Java programming in your JSP files--this is good advice.

In database for class 1 to 10 having value for subject is all. and for class 11 or 12, having value arts, commerce and science.

if i select class 1 to 10 from combo box for class then subject remains hide, after submit its show the result. it will show the result for a class having subject is all.
because in database for class 1 to 10 the subject value is all, but when i select class 11 or 12, then a combo box for subject appear and its value will be Arts, Commerce and Science. then when i select subject any one from these. suppose i select class 11 or select subject science, after submit it go for query from database for a class 11 and for subject science.

how i find the result for a science subject for a class 12.

i am not able to make query that find the result when i select class 11 or 12 for a particular subject.

please help.

if you are using hibernate then it is very easy to do it.....