Index.jsp:
-------------
<form action="first.jsp" method="post" name="f1" onsubmit="return validate1()">
<%@include file="db.jsp" %>
<%
Statement st = con.createStatement();
ResultSet results = st.executeQuery("SELECT * FROM places");
while(results.next()){
String id = results.getString(1);
String name = results.getString(2);
%>
<option value="<% out.println(name); %>">
<%=name%>
</option>
<%} results.close(); %>
</select><br>
   To:          <select name="sel2" style="width: 100px"><option value="">To---></option>
<%
ResultSet results1 = st.executeQuery("select * from places ");
while(results1.next()){
String id1 =results1.getString(1) ;
String name1 = results1.getString(2);
%>
<option value="<% out.println(name1); %>">
<%=name1%>
</option>
<%} results1.close(); %>
</select><br>
   Date:       <input type="text" name="date" class="tcal" value="" style="width: 80px"><br>
<center><input type="submit" value="Findflights" name="s1" ></center>
First.jsp:
----------
String sel1 = request.getParameter("sel1");
String sel2 = request.getParameter("sel2");
String myParameter3 = request.getParameter("date");
sel1 ="'"+sel1 +"'";
if(myParameter7.equalsIgnoreCase("Findflights") )
{%>
<%@include file="db.jsp" %>
<% Statement st5=con.createStatement();
ResultSet resultset5= st5.executeQuery("Select * from places where place="+sel1);
while(resultset5.next())
{
String namep=resultset5.getString("palce");
out.println(namep);
}
%>