Hi Friend,

Try the following code:

<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<script>
function city(){
var cid=document.getElementById("country").selectedIndex;
var val = document.getElementById("country").options[cid].text
window.location.replace("http://localhost:8080/examples/jsp/country.jsp?id="+cid+"&&value="+val);
}
</script>
<%!
Connection conn = null;
ResultSet rs =null;
Statement st=null;
String query="";
int cid;
%>
<%
String value=request.getParameter("value");

Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root";, "root");
st = conn.createStatement();
rs = st.executeQuery("select * from country");
%>
<select id="country" onchange="city();">
<option value="0">--Please Select--</option>
<% while(rs.next()){ %>
<option value="<%=rs.getString("countryname")%>"><%=rs.getString("countryname")%></option>

<% if(rs.getString("countryname").equals(value)){%>
<option value="<%=value%>" selected disabled><%=value%></option>
<%
}
}
%>
</select>
<select>
<%
String id=request.getParameter("id");
rs=st.executeQuery("select * from city where countryid='"+id+"'");
while(rs.next()){
%>
<option value="<%=rs.getString("city")%>" ><%=rs.getString("city")%></option>
<%
}
%>
</select>
</body>
</html>

For the above code, we have created two database tables:
1)'country'
CREATE TABLE `country` (
`countryid` bigint(30) NOT NULL auto_increment,
`countryname` varchar(40) default NULL,
PRIMARY KEY (`countryid`)
)

2)'city'
CREATE TABLE `city` (
`id` bigint(40) NOT NULL auto_increment,
`countryid` int(20) default NULL,
`city` varchar(40) default NULL,
PRIMARY KEY (`id`)
)

Thanks