Simple J2EE form
Step 1: Create a web page(state.jsp) to show a form.
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*,java.util.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>States List</title>
<script type="text/javascript" src="states.js"></script>
<link rel="stylesheet" href="layout.css" type="text/css" media="screen">
</head>
<body onload="get2()" >
<form name="states list" method="get" action="states" >
<table align="center">
<tr>
<td><h2><u><b>STATES LIST</b></u></h2></td></tr>
<tr>
</table>
<hr/>
<table rules="all" align="center">
<tr>
<td>State Code:</td><td><input type="text" onmouseover="window.status = 'hello!'; return true" onkeypress="return isCharKey(event)" maxlength="2" size="20" name="sc" id="t1" onblur="this.value=this.value.toUpperCase()" onkeypress="return isNumberKey(event)"></input></td>
</tr>
<tr>
<td>State Name:</td><td><input type="text" name="sn" id="t2" onblur="call23('Check','null')" onkeypress="return isCharKey(event)"></input></td>
</tr>
</table>
<br>
<br>
<hr/>
<table rules="groups" align="center">
<tr>
<td><input type="button" value="ADD" onClick="add()"></input></td>
<td><input type="button" value="MODIFY" onClick="mod()"></input></td>
<td><input type="button" value="DELETE" onClick="del()"></input></td>
<td><input type="button" value="LIST" onClick="list()"></input></td>
<td><input type="reset" value="CLEAR" onClick="clean()"></input></td>
<td><input type="button" value="EXIT" onClick="exit()"></input></td>
</tr>
</table>
<br>
<br>
<br>
<hr/>
<hr/>
<br><table id="tab" rules="all" cellspacing="3" cellpadding="3" border="2" align="center" style="width: 55%; ">
<tr><th width="83" BGCOLOR="#99CCFF"><div align="center"> SELECT</div></th>
<th width= "143" BGCOLOR="#99CCFF"><div align="center"> STATE CODE</div></th>
<th width= "200" BGCOLOR="#99CCFF"><div align="center"> STATE NAME</div></th>
</tr>
</table>
<table rules="all" id="state" cellspacing="3" cellpadding="3" border="2" align="center" style="width: 55%; ">
</table>
</form>
</body>
</html>
Step:2 Create a javascript (state.js) to connect servlet and jsp.
var scarray=new Array();
var snarray=new Array();
var stnam;
function chk()
{
//alert("hi");
var sc=document.getElementById("t1").value;
var sn=document.getElementById("t2").value;
if((sc=="")||(sn==""))
{
alert("Enter the Value");
return false;
}
else
if((sc.length>2)||(sc.length<2))
{
alert("State Code Should be atleast 2 Characters Only");
window.location.reload();
return false;
}
else
{
return true;
}
}
function isCharKey(evt)
{
var charCode = (evt.which) ? evt.which : evt.keyCode;
if ((charCode >=65 && charCode <= 90)||(charCode >= 97)&&(charCode <=122) || (charCode == 31) || (charCode == 8)|| (charCode == 32))
{
return true;
}
else
{
alert("Enter Character only");
return false;
}
}
function call23(command)
{
if (command == "Check") {
var state_code = document.getElementById("t1").value;
url9 = "states?command=check&state_code=" + state_code;
//alert(url9);
var req=getTransport();
req.open("get",url9,true);
req.onreadystatechange=function()
{
viewResponse(req);
};
req.send(null);
}
}
function add()
{
//alert("hi");
var va=chk();
if(va==true)
{
var sc=document.getElementById("t1").value.toUpperCase();
var sn=document.getElementById("t2").value.toUpperCase();
var url="states?command=add&sc="+sc+"&sn="+sn;
//alert(url);
var req=getTransport();
req.open("get",url,true);
req.onreadystatechange=function()
{
viewResponse(req);
};
req.send(null);
}
}
function mod()
{
var vm=chk();
if(vm==true)
{
var sc=document.getElementById("t1").value;
var sn=document.getElementById("t2").value;
var url="states?command=modify&sc="+sc+"&sn="+sn;
//alert(url);
var req=getTransport();
req.open("get",url,true);
req.onreadystatechange=function()
{
viewResponse(req);
};
req.send(null);
}
}
function del()
{
var sc=document.getElementById("t1").value;
//var sn=document.getElementById("t2").value;
var url="states?command=del&sc="+sc;
//alert(url);
var req=getTransport();
req.open("get",url,true);
req.onreadystatechange=function()
{
viewResponse(req);
};
req.send(null);
}
function get2()
{
var item=document.getElementById("state");
var child=item.childNodes;
for(var c=child.length-1;c>=0;c--)
{
item.removeChild(child[c]);
}
var url1="states?command=get";
//alert(url1);
var req=getTransport();
req.open("get",url1,true);
req.onreadystatechange=function()
{
viewResponse(req);
};
req.send(null);
}
function getTransport()
{
var req = false;
try
{
req= new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
try
{
req = new ActiveXObject("Microsoft.XMLHTTP");
}
catch (e2)
{
req = false;
}
}
if (!req && typeof XMLHttpRequest != 'undefined')
{
req = new XMLHttpRequest();
}
return req;
}
function viewResponse(req)
{
if(req.readyState==4)
{
if(req.status==200)
{
var baseresponse=req.responseXML.getElementsByTagName("response")[0];
var tagCommand=baseresponse.getElementsByTagName("command")[0];
var command=tagCommand.firstChild.nodeValue;
if(command=="add")
{
var flag=baseresponse.getElementsByTagName("flag")[0].firstChild.nodeValue;
if(flag=='success')
{
alert("Record Added1 Successfully");
document.getElementById("t1").value="";
document.getElementById("t2").value="";
get2();
}
else
{
alert("Process Failure");
}
}
if(command=="get")
{
var itemcombo=document.getElementById("state");
var flag=baseresponse.getElementsByTagName("flag")[0].firstChild.nodeValue;
if(flag=='successget')
{
var count=baseresponse.getElementsByTagName("count");
for(var i=0;i<count.length;i++)
{
var sce=baseresponse.getElementsByTagName("scod")[i].firstChild.nodeValue;
var sne=baseresponse.getElementsByTagName("snam")[i].firstChild.nodeValue;
scarray[i]=sce;
snarray[i]=sne;
var row=document.createElement("tr");
var td=document.createElement("td");
td.setAttribute("height", "20");
td.setAttribute("width", "138");
td.setAttribute("align", "center");
var a=document.createElement("a");
a.setAttribute("href", "#");
a.setAttribute("onclick", "setvalue("+i+")");
var text=document.createTextNode("Edit");
a.appendChild(text);
td.appendChild(a);
row.appendChild(td);
var td=document.createElement("td");
td.setAttribute("height", "20");
td.setAttribute("width", "240");
td.setAttribute("align", "center");
var text=document.createTextNode(sce);
td.appendChild(text);
row.appendChild(td);
var td=document.createElement("td");
td.setAttribute("align", "center");
var text=document.createTextNode(sne);
td.appendChild(text);
row.appendChild(td);
itemcombo.appendChild(row);
}
}
else
{
alert("Fields Are Empty");
}
}
if(command=="del")
{
alert("check del");
var flag=baseresponse.getElementsByTagName("flag")[0].firstChild.nodeValue;
if(flag=='successdel')
{
alert("Record Deleted1 Successfully");
document.getElementById("t1").value="";
document.getElementById("t2").value="";
get2();
}
else
{
alert("Values Not Selected");
}
}
if(command=="updat")
{
alert("updcheck");
var flag=baseresponse.getElementsByTagName("flag")[0].firstChild.nodeValue;
if(flag=='successupdat')
{
alert("Record Updated1 Successfully");
document.getElementById("t1").value="";
document.getElementById("t2").value="";
get2();
}
else
{
alert("Process Failure");
}
}
if(command=="check23")
{
//alert("check");
var flag=baseresponse.getElementsByTagName("flag")[0].firstChild.nodeValue;
if (flag == "success45")
{
var count=baseresponse.getElementsByTagName("count");
for(var i=0;i<count.length;i++)
{
alert("State Code Already Exists..!! Do u Want Update...?! ");
document.getElementById("t1").disabled = true;
stnam = baseresponse.getElementsByTagName("snam")[i].firstChild.nodeValue;
// alert(stnam);
document.getElementById("t2").value =stnam;
}
}
}
}
}
}
function setvalue(val)
{
document.getElementById("t1").value=scarray[val];
document.getElementById("t2").value=snarray[val];
}
function exit()
{
//alert("gng to exit");
var e=confirm("Do u want to Exit..?");
if(e==true)
{
window.alert("Thanks..!!");
window.close();
}
else
{
window.location.reload();
}
}
Step:3 Create a servlet (states.java) to connect the data to database.
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
* Servlet implementation class states
*/
public class states extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public states() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
try
{
String xml="";
Connection con=null;
ResultSet rs=null;
PreparedStatement ps=null;
String com;
xml=xml+"<response>";
String scod=request.getParameter("sc");
String snam=request.getParameter("sn");
com=request.getParameter("command");
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521","student", "student");
//System.out.println("db conn success");
if(com.equalsIgnoreCase("add"))
{
xml=xml+"<command>add</command>";
int i=0;
ps=con.prepareStatement("insert into states_master values(?,?)");
ps.setString(1, scod);
ps.setString(2, snam);
i=ps.executeUpdate();
// System.out.println("hi");
if(i>0)
{
xml=xml+"<flag>success</flag>";
}
else
{
xml=xml+"<flag>failed</flag>";
}
}
if(com.equalsIgnoreCase("del"))
{
xml=xml+"<command>del</command>";
int i1=0;
//System.out.println(i1);
ps=con.prepareStatement("delete from states_master where state_code=?");
ps.setString(1,scod);
i1=ps.executeUpdate();
if(i1>0)
{
xml=xml+"<flag>successdel</flag>";
}
else
xml=xml+"<flag>failure</flag>";
}
if(com.equalsIgnoreCase("get"))
{
xml=xml+"<command>get</command>";
ps=con.prepareStatement("select * from states_master order by state_code");
rs=ps.executeQuery();
int cnt=0;
while(rs.next())
{
xml=xml+"<count><scod>"+rs.getString("state_code")+"</scod>";
xml=xml+"<snam>"+rs.getString("state_name")+"</snam></count>";
cnt++;
}
if(cnt>0)
{
xml=xml+"<flag>successget</flag>";
}
else
{
xml=xml+"<flag>fail</flag>";
}
}
if(com.equalsIgnoreCase("modify"))
{
xml=xml+"<command>updat</command>";
int i=0;
ps=con.prepareStatement("update states_master set state_name=? where state_code=?");
ps.setString(1,snam);
ps.setString(2,scod);
//System.out.println("update");
i=ps.executeUpdate();
if(i>0)
{
xml=xml+"<flag>successupdat</flag>";
}
else
{
xml=xml+"<flag>failed</flag>";
}
}
if (com.equalsIgnoreCase("check"))
{
//System.out.println("inside check");
xml=xml+"<command>check23</command>";
//System.out.println(xml);
String state_cod = request.getParameter("state_code"); // 2
//System.out.println(state_cod);
ps=con.prepareStatement ( "select * from states_master where state_code='"+state_cod+"'");
//System.out.println(ps);
rs = ps.executeQuery();
int ct=0;
if (rs.next())
{
xml=xml+"<count><scod>"+rs.getString("state_code")+"</scod>";
xml =xml+ "<snam>"+rs.getString("state_name")+"</snam></count>";
ct++;
//System.out.println(xml);
}
//System.out.println(ct);
if(ct>0)
{
//System.out.println(ct);
xml=xml+"<flag>success45</flag>";
}
else
{
//System.out.println(ct);
xml = "<flag>success1</flag>";
}
}
xml=xml+"</response>";
PrintWriter out=response.getWriter();
out.println(xml);
}
catch(Exception e)
{
System.out.println(e);
}
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
}
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*,java.util.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>States List</title>
<script type="text/javascript" src="states.js"></script>
<link rel="stylesheet" href="layout.css" type="text/css" media="screen">
</head>
<body onload="get2()" >
<form name="states list" method="get" action="states" >
<table align="center">
<tr>
<td><h2><u><b>STATES LIST</b></u></h2></td></tr>
<tr>
</table>
<hr/>
<table rules="all" align="center">
<tr>
<td>State Code:</td><td><input type="text" onmouseover="window.status = 'hello!'; return true" onkeypress="return isCharKey(event)" maxlength="2" size="20" name="sc" id="t1" onblur="this.value=this.value.toUpperCase()" onkeypress="return isNumberKey(event)"></input></td>
</tr>
<tr>
<td>State Name:</td><td><input type="text" name="sn" id="t2" onblur="call23('Check','null')" onkeypress="return isCharKey(event)"></input></td>
</tr>
</table>
<br>
<br>
<hr/>
<table rules="groups" align="center">
<tr>
<td><input type="button" value="ADD" onClick="add()"></input></td>
<td><input type="button" value="MODIFY" onClick="mod()"></input></td>
<td><input type="button" value="DELETE" onClick="del()"></input></td>
<td><input type="button" value="LIST" onClick="list()"></input></td>
<td><input type="reset" value="CLEAR" onClick="clean()"></input></td>
<td><input type="button" value="EXIT" onClick="exit()"></input></td>
</tr>
</table>
<br>
<br>
<br>
<hr/>
<hr/>
<br><table id="tab" rules="all" cellspacing="3" cellpadding="3" border="2" align="center" style="width: 55%; ">
<tr><th width="83" BGCOLOR="#99CCFF"><div align="center"> SELECT</div></th>
<th width= "143" BGCOLOR="#99CCFF"><div align="center"> STATE CODE</div></th>
<th width= "200" BGCOLOR="#99CCFF"><div align="center"> STATE NAME</div></th>
</tr>
</table>
<table rules="all" id="state" cellspacing="3" cellpadding="3" border="2" align="center" style="width: 55%; ">
</table>
</form>
</body>
</html>
Step:2 Create a javascript (state.js) to connect servlet and jsp.
var scarray=new Array();
var snarray=new Array();
var stnam;
function chk()
{
//alert("hi");
var sc=document.getElementById("t1").value;
var sn=document.getElementById("t2").value;
if((sc=="")||(sn==""))
{
alert("Enter the Value");
return false;
}
else
if((sc.length>2)||(sc.length<2))
{
alert("State Code Should be atleast 2 Characters Only");
window.location.reload();
return false;
}
else
{
return true;
}
}
function isCharKey(evt)
{
var charCode = (evt.which) ? evt.which : evt.keyCode;
if ((charCode >=65 && charCode <= 90)||(charCode >= 97)&&(charCode <=122) || (charCode == 31) || (charCode == 8)|| (charCode == 32))
{
return true;
}
else
{
alert("Enter Character only");
return false;
}
}
function call23(command)
{
if (command == "Check") {
var state_code = document.getElementById("t1").value;
url9 = "states?command=check&state_code=" + state_code;
//alert(url9);
var req=getTransport();
req.open("get",url9,true);
req.onreadystatechange=function()
{
viewResponse(req);
};
req.send(null);
}
}
function add()
{
//alert("hi");
var va=chk();
if(va==true)
{
var sc=document.getElementById("t1").value.toUpperCase();
var sn=document.getElementById("t2").value.toUpperCase();
var url="states?command=add&sc="+sc+"&sn="+sn;
//alert(url);
var req=getTransport();
req.open("get",url,true);
req.onreadystatechange=function()
{
viewResponse(req);
};
req.send(null);
}
}
function mod()
{
var vm=chk();
if(vm==true)
{
var sc=document.getElementById("t1").value;
var sn=document.getElementById("t2").value;
var url="states?command=modify&sc="+sc+"&sn="+sn;
//alert(url);
var req=getTransport();
req.open("get",url,true);
req.onreadystatechange=function()
{
viewResponse(req);
};
req.send(null);
}
}
function del()
{
var sc=document.getElementById("t1").value;
//var sn=document.getElementById("t2").value;
var url="states?command=del&sc="+sc;
//alert(url);
var req=getTransport();
req.open("get",url,true);
req.onreadystatechange=function()
{
viewResponse(req);
};
req.send(null);
}
function get2()
{
var item=document.getElementById("state");
var child=item.childNodes;
for(var c=child.length-1;c>=0;c--)
{
item.removeChild(child[c]);
}
var url1="states?command=get";
//alert(url1);
var req=getTransport();
req.open("get",url1,true);
req.onreadystatechange=function()
{
viewResponse(req);
};
req.send(null);
}
function getTransport()
{
var req = false;
try
{
req= new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
try
{
req = new ActiveXObject("Microsoft.XMLHTTP");
}
catch (e2)
{
req = false;
}
}
if (!req && typeof XMLHttpRequest != 'undefined')
{
req = new XMLHttpRequest();
}
return req;
}
function viewResponse(req)
{
if(req.readyState==4)
{
if(req.status==200)
{
var baseresponse=req.responseXML.getElementsByTagName("response")[0];
var tagCommand=baseresponse.getElementsByTagName("command")[0];
var command=tagCommand.firstChild.nodeValue;
if(command=="add")
{
var flag=baseresponse.getElementsByTagName("flag")[0].firstChild.nodeValue;
if(flag=='success')
{
alert("Record Added1 Successfully");
document.getElementById("t1").value="";
document.getElementById("t2").value="";
get2();
}
else
{
alert("Process Failure");
}
}
if(command=="get")
{
var itemcombo=document.getElementById("state");
var flag=baseresponse.getElementsByTagName("flag")[0].firstChild.nodeValue;
if(flag=='successget')
{
var count=baseresponse.getElementsByTagName("count");
for(var i=0;i<count.length;i++)
{
var sce=baseresponse.getElementsByTagName("scod")[i].firstChild.nodeValue;
var sne=baseresponse.getElementsByTagName("snam")[i].firstChild.nodeValue;
scarray[i]=sce;
snarray[i]=sne;
var row=document.createElement("tr");
var td=document.createElement("td");
td.setAttribute("height", "20");
td.setAttribute("width", "138");
td.setAttribute("align", "center");
var a=document.createElement("a");
a.setAttribute("href", "#");
a.setAttribute("onclick", "setvalue("+i+")");
var text=document.createTextNode("Edit");
a.appendChild(text);
td.appendChild(a);
row.appendChild(td);
var td=document.createElement("td");
td.setAttribute("height", "20");
td.setAttribute("width", "240");
td.setAttribute("align", "center");
var text=document.createTextNode(sce);
td.appendChild(text);
row.appendChild(td);
var td=document.createElement("td");
td.setAttribute("align", "center");
var text=document.createTextNode(sne);
td.appendChild(text);
row.appendChild(td);
itemcombo.appendChild(row);
}
}
else
{
alert("Fields Are Empty");
}
}
if(command=="del")
{
alert("check del");
var flag=baseresponse.getElementsByTagName("flag")[0].firstChild.nodeValue;
if(flag=='successdel')
{
alert("Record Deleted1 Successfully");
document.getElementById("t1").value="";
document.getElementById("t2").value="";
get2();
}
else
{
alert("Values Not Selected");
}
}
if(command=="updat")
{
alert("updcheck");
var flag=baseresponse.getElementsByTagName("flag")[0].firstChild.nodeValue;
if(flag=='successupdat')
{
alert("Record Updated1 Successfully");
document.getElementById("t1").value="";
document.getElementById("t2").value="";
get2();
}
else
{
alert("Process Failure");
}
}
if(command=="check23")
{
//alert("check");
var flag=baseresponse.getElementsByTagName("flag")[0].firstChild.nodeValue;
if (flag == "success45")
{
var count=baseresponse.getElementsByTagName("count");
for(var i=0;i<count.length;i++)
{
alert("State Code Already Exists..!! Do u Want Update...?! ");
document.getElementById("t1").disabled = true;
stnam = baseresponse.getElementsByTagName("snam")[i].firstChild.nodeValue;
// alert(stnam);
document.getElementById("t2").value =stnam;
}
}
}
}
}
}
function setvalue(val)
{
document.getElementById("t1").value=scarray[val];
document.getElementById("t2").value=snarray[val];
}
function exit()
{
//alert("gng to exit");
var e=confirm("Do u want to Exit..?");
if(e==true)
{
window.alert("Thanks..!!");
window.close();
}
else
{
window.location.reload();
}
}
Step:3 Create a servlet (states.java) to connect the data to database.
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
* Servlet implementation class states
*/
public class states extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public states() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
try
{
String xml="";
Connection con=null;
ResultSet rs=null;
PreparedStatement ps=null;
String com;
xml=xml+"<response>";
String scod=request.getParameter("sc");
String snam=request.getParameter("sn");
com=request.getParameter("command");
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521","student", "student");
//System.out.println("db conn success");
if(com.equalsIgnoreCase("add"))
{
xml=xml+"<command>add</command>";
int i=0;
ps=con.prepareStatement("insert into states_master values(?,?)");
ps.setString(1, scod);
ps.setString(2, snam);
i=ps.executeUpdate();
// System.out.println("hi");
if(i>0)
{
xml=xml+"<flag>success</flag>";
}
else
{
xml=xml+"<flag>failed</flag>";
}
}
if(com.equalsIgnoreCase("del"))
{
xml=xml+"<command>del</command>";
int i1=0;
//System.out.println(i1);
ps=con.prepareStatement("delete from states_master where state_code=?");
ps.setString(1,scod);
i1=ps.executeUpdate();
if(i1>0)
{
xml=xml+"<flag>successdel</flag>";
}
else
xml=xml+"<flag>failure</flag>";
}
if(com.equalsIgnoreCase("get"))
{
xml=xml+"<command>get</command>";
ps=con.prepareStatement("select * from states_master order by state_code");
rs=ps.executeQuery();
int cnt=0;
while(rs.next())
{
xml=xml+"<count><scod>"+rs.getString("state_code")+"</scod>";
xml=xml+"<snam>"+rs.getString("state_name")+"</snam></count>";
cnt++;
}
if(cnt>0)
{
xml=xml+"<flag>successget</flag>";
}
else
{
xml=xml+"<flag>fail</flag>";
}
}
if(com.equalsIgnoreCase("modify"))
{
xml=xml+"<command>updat</command>";
int i=0;
ps=con.prepareStatement("update states_master set state_name=? where state_code=?");
ps.setString(1,snam);
ps.setString(2,scod);
//System.out.println("update");
i=ps.executeUpdate();
if(i>0)
{
xml=xml+"<flag>successupdat</flag>";
}
else
{
xml=xml+"<flag>failed</flag>";
}
}
if (com.equalsIgnoreCase("check"))
{
//System.out.println("inside check");
xml=xml+"<command>check23</command>";
//System.out.println(xml);
String state_cod = request.getParameter("state_code"); // 2
//System.out.println(state_cod);
ps=con.prepareStatement ( "select * from states_master where state_code='"+state_cod+"'");
//System.out.println(ps);
rs = ps.executeQuery();
int ct=0;
if (rs.next())
{
xml=xml+"<count><scod>"+rs.getString("state_code")+"</scod>";
xml =xml+ "<snam>"+rs.getString("state_name")+"</snam></count>";
ct++;
//System.out.println(xml);
}
//System.out.println(ct);
if(ct>0)
{
//System.out.println(ct);
xml=xml+"<flag>success45</flag>";
}
else
{
//System.out.println(ct);
xml = "<flag>success1</flag>";
}
}
xml=xml+"</response>";
PrintWriter out=response.getWriter();
out.println(xml);
}
catch(Exception e)
{
System.out.println(e);
}
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
}
Comments
Post a Comment