ajax and jsp code

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

September 17, 2008 at 1:48 PM