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:
Expand|Select|Wrap|Line Numbers
- <html>
- <head>
- <body>
- <form name="form" >
- <table align="center">
- <script language="javascript">
- function sendData(){
- var sch=document.form.school.value;
- var cla=document.form.class_name.value;
- var y1=document.form.from_year.value;
- var y2=document.form.to_year.value;
- window.open("show.jsp?class_name="+cla+"&&from_year="+y1+"&&to_year="+y2+"&&school="+sch);
- alert(sch+" "+cla+ " "+y1+" "+y2);
- }
- function hide(){
- if (document.getElementById){
- document.getElementById('combo').style.visibility = 'hidden';
- }
- }
- function call(class_name){
- var val = class_name.options[class_name.selectedIndex].text;
- if((val=='11')||(val=='12')){
- document.getElementById('combo').style.visibility = 'visible';
- var arr = new Array();
- arr[11] = new Array("Art","Commerce","Science");
- arr[12] = new Array("Art","Commerce","Science");
- var comboValue = class_name.value;
- document.forms["form"].elements["combo2"].options.length=0;
- for (var i=0;i<arr[comboValue].length;i++)
- {
- var option = document.createElement("option");
- option.setAttribute('value',i+1);
- option.innerHTML = arr[comboValue][i];
- document.forms["form"].elements["combo2"].appendChild(option);
- }
- }
- else{
- document.getElementById('combo').style.visibility = 'hidden';
- }
- }
- </script>
- <body onload="hide();">
- <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>
- <tr><td style="width: 11px"> <span>From Year</td><td><select name="from_year">
- <%
- for(int j=2000;j<=2010;j++){
- %>
- <option value="<%=j%>"><%=j%></option>
- <%
- }
- %>
- </select></td></tr>
- <tr><td style="width: 11px"> <span>To Year</td><td><select name="to_year">
- <%
- for(int k=2000;k<=2010;k++){
- %>
- <option value="<%=k%>"><%=k%></option>
- <% } %>
- </select></td></tr><td></td>
- <tr><td style="width: 11px"> <span><input type="button" value="Result" onclick="sendData();"></td></tr>
- <tr><td><input type="hidden" name="school" value="<%=request.getParameter("school")%>"></td></tr>
- </table>
- </form>
- </body>
- </head>
- </html>
Expand|Select|Wrap|Line Numbers
- <%@ 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>
value for subject is Arts, Commerce and Science. how i make query from database base on the subject.
please help.