code for jsp

View Answers

September 17, 2008 at 11:47 AM

Hello Friend

I send the code you have to modify it by providin your driverclass, username and password

Data.java (ServletClass)
-------------------------

package com.rajanikant;

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{

System.out.println("inserv");
String value = req.getParameter("country");
PrintWriter out = res.getWriter();
String result="";
try{
Class.forName("driverclass");
Connection con = DriverManager.getConnection("url", "usernmae", "password");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("Select country from YourTableName Where country='" + value +"'");
while(rs.next()){
result = result + rs.getString("countryName") + ",";
}
}catch(Exception ex){

}
//result = "rajani,rani,sama,";
out.write(result);
}

}

selectDemo.jsp
-----------------

<html>
<head>

<script language="javascript">

var xmlObj = new ActiveXObject("Microsoft.XMLHTTP");
function getData(source, div){

var element = document.getElementById(div);
if(xmlObj){

xmlObj.open("GET", source);
xmlObj.onreadystatechange = function(){
if(xmlObj.readyState == 4 && xmlObj.status == 200){
alert(xmlObj.responseText);
element.innerHTML = xmlObj.responseText;
}
}
}
xmlObj.send(null);
}
function getDetail(source,div){
getData(source,div);
}
</script>
</head>
<body>
<h1> An Ajax Demo</h1>

<form>
<input type="button" value="From Servlet " onclick="getData('../../Data?r='+ new Date().getTime(),'show')">
</form>
<div id="show">
<p>Data fetched Here</p>
</div>
</body>
</html>

Thanks
Rajanikant

September 17, 2008 at 12:35 PM

Hi friend

sorry the jsp page for another program

look this file

<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;
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>1</option>
<option>2</option>
</select>
<select id="second"></select>
</form>
</body>
</html>

Thanks
Rajanikant

Ads