QuestionAsk Questions?
View Answers
September 17, 2008 at 1:48 PM
Hello
You have to change here your database name , tablename, column name
Data.java(Through this class you retrieve statename of a selected country)
--------------------------------------------------
package com.roseindia;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Data extends HttpServlet {
public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException{
String value = req.getParameter("country");
String dbQuery = "Select StateName FROM STATES WHERE CountryName='" + value +"'";
PrintWriter out = res.getWriter();
String result="";
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase";, "root", "");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(dbQuery);
while(rs.next()){
result = result + rs.getString("StateName") + ",";
}
}catch(Exception ex){
System.out.println(ex.getMessage());
}
out.write(result);
}
}
Look this jsp here only i took two select box in one contain contry name and in oter it disp;lay corresponding states
SelectDemo.jsp
---------------
<html>
<head>
<script language="javascript">
var xmlObj = new ActiveXObject("Microsoft.XMLHTTP");
function selctData(form)
{
var source = (form.first.options[form.first.selectedIndex].text)
var url = "../Data?country="+source + "&r=" + new Date().getTime() ;
alert(url);
xmlObj.open("GET", url)
alert("3");
xmlObj.onreadystatechange = function()
{
if(xmlObj.readystate == 4 && xmlObj.status == 200)
{
var id = document.getElementById("second");
var result = xmlObj.responseText;
var s = result.split(',');
var indx = 0;
for(indx=0; indx < s.length; indx++)
{
id.options[indx] = new Option(s[indx],s[indx]);
}
}
}
xmlObj.send(null);
}
</script>
</head>
<body>
<h1>On Select change data of another Select</h1>
<br>
<form>
<select id="first" onchange="selctData(this.form)">
<option value="">Select One </option>
<option>india</option>
<option>saudi</option>
</select>
<select id="second"></select>
</form>
</body>
</html>
Thanks
Rajanikant
You have to change here your database name , tablename, column name
Data.java(Through this class you retrieve statename of a selected country)
--------------------------------------------------
package com.roseindia;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Data extends HttpServlet {
public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException{
String value = req.getParameter("country");
String dbQuery = "Select StateName FROM STATES WHERE CountryName='" + value +"'";
PrintWriter out = res.getWriter();
String result="";
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase";, "root", "");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(dbQuery);
while(rs.next()){
result = result + rs.getString("StateName") + ",";
}
}catch(Exception ex){
System.out.println(ex.getMessage());
}
out.write(result);
}
}
Look this jsp here only i took two select box in one contain contry name and in oter it disp;lay corresponding states
SelectDemo.jsp
---------------
<html>
<head>
<script language="javascript">
var xmlObj = new ActiveXObject("Microsoft.XMLHTTP");
function selctData(form)
{
var source = (form.first.options[form.first.selectedIndex].text)
var url = "../Data?country="+source + "&r=" + new Date().getTime() ;
alert(url);
xmlObj.open("GET", url)
alert("3");
xmlObj.onreadystatechange = function()
{
if(xmlObj.readystate == 4 && xmlObj.status == 200)
{
var id = document.getElementById("second");
var result = xmlObj.responseText;
var s = result.split(',');
var indx = 0;
for(indx=0; indx < s.length; indx++)
{
id.options[indx] = new Option(s[indx],s[indx]);
}
}
}
xmlObj.send(null);
}
</script>
</head>
<body>
<h1>On Select change data of another Select</h1>
<br>
<form>
<select id="first" onchange="selctData(this.form)">
<option value="">Select One </option>
<option>india</option>
<option>saudi</option>
</select>
<select id="second"></select>
</form>
</body>
</html>
Thanks
Rajanikant
September 17, 2008 at 1:48 PM
Hello
You have to change here your database name , tablename, column name
Data.java(Through this class you retrieve statename of a selected country)
--------------------------------------------------
package com.roseindia;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Data extends HttpServlet {
public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException{
String value = req.getParameter("country");
String dbQuery = "Select StateName FROM STATES WHERE CountryName='" + value +"'";
PrintWriter out = res.getWriter();
String result="";
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase";, "root", "");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(dbQuery);
while(rs.next()){
result = result + rs.getString("StateName") + ",";
}
}catch(Exception ex){
System.out.println(ex.getMessage());
}
out.write(result);
}
}
Look this jsp here only i took two select box in one contain contry name and in oter it disp;lay corresponding states
SelectDemo.jsp
---------------
<html>
<head>
<script language="javascript">
var xmlObj = new ActiveXObject("Microsoft.XMLHTTP");
function selctData(form)
{
var source = (form.first.options[form.first.selectedIndex].text)
var url = "../Data?country="+source + "&r=" + new Date().getTime() ;
alert(url);
xmlObj.open("GET", url)
alert("3");
xmlObj.onreadystatechange = function()
{
if(xmlObj.readystate == 4 && xmlObj.status == 200)
{
var id = document.getElementById("second");
var result = xmlObj.responseText;
var s = result.split(',');
var indx = 0;
for(indx=0; indx < s.length; indx++)
{
id.options[indx] = new Option(s[indx],s[indx]);
}
}
}
xmlObj.send(null);
}
</script>
</head>
<body>
<h1>On Select change data of another Select</h1>
<br>
<form>
<select id="first" onchange="selctData(this.form)">
<option value="">Select One </option>
<option>india</option>
<option>saudi</option>
</select>
<select id="second"></select>
</form>
</body>
</html>
Thanks
Rajanikant
You have to change here your database name , tablename, column name
Data.java(Through this class you retrieve statename of a selected country)
--------------------------------------------------
package com.roseindia;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Data extends HttpServlet {
public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException{
String value = req.getParameter("country");
String dbQuery = "Select StateName FROM STATES WHERE CountryName='" + value +"'";
PrintWriter out = res.getWriter();
String result="";
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase";, "root", "");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(dbQuery);
while(rs.next()){
result = result + rs.getString("StateName") + ",";
}
}catch(Exception ex){
System.out.println(ex.getMessage());
}
out.write(result);
}
}
Look this jsp here only i took two select box in one contain contry name and in oter it disp;lay corresponding states
SelectDemo.jsp
---------------
<html>
<head>
<script language="javascript">
var xmlObj = new ActiveXObject("Microsoft.XMLHTTP");
function selctData(form)
{
var source = (form.first.options[form.first.selectedIndex].text)
var url = "../Data?country="+source + "&r=" + new Date().getTime() ;
alert(url);
xmlObj.open("GET", url)
alert("3");
xmlObj.onreadystatechange = function()
{
if(xmlObj.readystate == 4 && xmlObj.status == 200)
{
var id = document.getElementById("second");
var result = xmlObj.responseText;
var s = result.split(',');
var indx = 0;
for(indx=0; indx < s.length; indx++)
{
id.options[indx] = new Option(s[indx],s[indx]);
}
}
}
xmlObj.send(null);
}
</script>
</head>
<body>
<h1>On Select change data of another Select</h1>
<br>
<form>
<select id="first" onchange="selctData(this.form)">
<option value="">Select One </option>
<option>india</option>
<option>saudi</option>
</select>
<select id="second"></select>
</form>
</body>
</html>
Thanks
Rajanikant
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
