QuestionAsk Questions?
View Answers
June 12, 2009 at 4:51 PM
Hi Friend,
To run this code we have created two tables country(id,country_name) and city(cityId, id,city_name). Now when we select the country from the first
combobox it will fetch the name of the cities according to the country Id.
Here is the JSP page code as follows :
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<%!
Connection conn = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "mysql";
String user = "root";
String pass = "root";
ResultSet rs =null;
Statement st=null;
String query="";
int mid;
%>
<%
if(request.getParameter("mid")!=null){
mid=Integer.parseInt(request.getParameter("mid"));
}else {
mid=0;
}
Class.forName("com.mysql.jdbc.Driver") ;
conn = DriverManager.getConnection(url+db, user, pass);
st = conn.createStatement();
rs = st.executeQuery("select * from country");
%>
<html>
<head>
<script type="text/javascript">
function selectCity(){
var mid=document.getElementById("countryId").selectedIndex;
window.location.replace("http://localhost:8080/examples/jsp/newCombo.jsp?mid="+mid);
}
</script>
</head>
<body>
<select id="countryId" name="countryId" onchange="selectCity(this)">
<option value="0">--Please Select--</option>
<% while(rs.next()){ %>
<option value='<%=rs.getString("id")%>'><%=rs.getString("country_name")%></option>
<%}%>
</select>
<select>
<option value="0">--Please Select--</option>
<%
System.out.println(mid);
rs = st.executeQuery("select * from city where id='"+mid+"'");
while(rs.next()){ %>
<option value='<%=rs.getString("id")%>'><%=rs.getString("city_name")%></option>
<%}%>
</select>
</body>
</html>
Thanks
To run this code we have created two tables country(id,country_name) and city(cityId, id,city_name). Now when we select the country from the first
combobox it will fetch the name of the cities according to the country Id.
Here is the JSP page code as follows :
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<%!
Connection conn = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "mysql";
String user = "root";
String pass = "root";
ResultSet rs =null;
Statement st=null;
String query="";
int mid;
%>
<%
if(request.getParameter("mid")!=null){
mid=Integer.parseInt(request.getParameter("mid"));
}else {
mid=0;
}
Class.forName("com.mysql.jdbc.Driver") ;
conn = DriverManager.getConnection(url+db, user, pass);
st = conn.createStatement();
rs = st.executeQuery("select * from country");
%>
<html>
<head>
<script type="text/javascript">
function selectCity(){
var mid=document.getElementById("countryId").selectedIndex;
window.location.replace("http://localhost:8080/examples/jsp/newCombo.jsp?mid="+mid);
}
</script>
</head>
<body>
<select id="countryId" name="countryId" onchange="selectCity(this)">
<option value="0">--Please Select--</option>
<% while(rs.next()){ %>
<option value='<%=rs.getString("id")%>'><%=rs.getString("country_name")%></option>
<%}%>
</select>
<select>
<option value="0">--Please Select--</option>
<%
System.out.println(mid);
rs = st.executeQuery("select * from city where id='"+mid+"'");
while(rs.next()){ %>
<option value='<%=rs.getString("id")%>'><%=rs.getString("city_name")%></option>
<%}%>
</select>
</body>
</html>
Thanks
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
