Display combo box value/Database value on same JSP page

[rajasri]

Today we are going to learn how to

Display combo box value/Database value on same JSP page

Here we are getting values from a combo box and check it with the database and display the values in the same jsp page.
First create the table

create table Result(year varchar(20),class varchar(20),Subject varchar(20),total_students varchar(20),passout_students varchar(20),marks_obtained_60_to_80varchar(20),marks_obtained_above_80 varchar(20),overall_result varchar(20));

Now in the jsp page itself we are displaying a combo box and a button when we press the button the corresponding class values is displayed in the below field.

<%@page import="java.sql.*,java.io.*;"%>

Quote:<tr>

<td width="60"height="30">
<form name="s" action="#" method="get">
<select name='class_name'>

<%

for(int i=1;i<12;i++)

{

out.println("<option value="+i+">"+i+"</option>");

}

%>

</td>

<select name='from_year'>

<%

for(int i=2010;i>2000;i--)

{

out.println("<option value="+i+">"+i+"</option>");

}

%>

</td>

<td>

<select name='to_year'>

<%

for(int i=2010;i>2000;i--)

{

out.println("<option value="+i+">"+i+"</option>");

}

%>

Quote: </td>

<td>

<input type="submit" name="submit" value="Go" ></td>
</form>
</tr>

<table align="center" border="1" align="center">

<br>

<tr bgcolor="#36559E" 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>

</tr>

<%

String submit=request.getParameter("submit");

if(submit!=null && (submit.equals("Go")))

{

String class_name=request.getParameter("class_name");

out.println("class_name is"+

class_name);

Connection con ;

try {

// Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;

Class.forName("com.mysql.jdbc.Driver") ;

// con = DriverManager.getConnection("jdbc:odbc:sql;user=sa;password=1234");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
out.println("First connection ok.");

out.println("Connection created");

Statement st=con.createStatement();

out.println("st going to execute");

String query="select year, class, Subject, total_students, passout_students,

marks_obtained_60_to_80, marks_obtained_above_80, overall_result from Result where

class='"+class_name+"' ";

out.println("now data are selecting");

ResultSet rs=st.executeQuery(query);

System.out.println("now data in rs.....");

out.println("now going to rs block............");

while(rs.next())

{out.println("now in rs block............");

%>

Quote:<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.getString(8));%>
</tr>

<%
}
rs.close();
con.close();
}

catch(Exception e){out.println(e);}
}

%>

Now you can able to get the same value from the database in same page.

Happy coding