Ads
Sir I have Jsp page for regisering customers,when i submit form it goes to servlet in servelets it checks for the username if it already exits i m using reuest.sendredirect to same jsp but all textbox values are cleard, i want to retain all values in textboxs after request.sendredirect .Please Hlp Thanks
1)checkusername.jsp:
Share on Google+<%@page import="java.sql.*"%>
<html>
<head>
<script type="text/javascript">
function showData(){
var user=document.getElementById("uname").value;
var pass=document.getElementById("pass").value;
var add=document.getElementById("address").value;
var email=document.getElementById("email").value;
xmlHttp=GetXmlHttpObject()
var url="../AjaxServlet";
url=url+"?user="+user+"&&pass="+pass+"&&address="+add+"&&email="+email;
xmlHttp.onreadystatechange=stateChanged
xmlHttp.open("GET",url,true)
xmlHttp.send(null)
}
function stateChanged() {
if(xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){
var showdata = xmlHttp.responseText;
alert(showdata);
}
}
function GetXmlHttpObject(){
var xmlHttp=null;
try {
xmlHttp=new XMLHttpRequest();
}
catch (e){
try {
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e){
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}
</script>
</head>
<form name="employee">
<div id="mydiv"></div>
<table>
<tr><td>Username</td><td><input type="text" id="uname"></td></tr>
<tr><td>Password</td><td><input type="password" id="pass"></td></tr>
<tr><td>Address</td><td><input type="text" id="address"></td></tr>
<tr><td>Email</td><td><input type="text" id="email"></td></tr>
<tr><td></td><td> <input type="button" value="check" onclick="showData();"></td></tr>
</table>
</form>
</html>
2)AjaxServlet.java:
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class AjaxServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String user = request.getParameter("user");
String pass = request.getParameter("pass");
String address = request.getParameter("address");
String email = request.getParameter("email");
System.out.println(user);
int count = 0;
String data = "";
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/test", "root", "root");
Statement st = con.createStatement();
ResultSet rs = st
.executeQuery("select * from login where username='" + user
+ "'");
while (rs.next()) {
count++;
}
if (count > 0) {
data = "Username Already Exists";
} else {
int i = st
.executeUpdate("insert into login(username,password,address,email) values('"
+ user
+ "','"
+ pass
+ "','"
+ address
+ "','"
+ email + "')");
data = "Inserted Successfully!";
}
out.println(data);
System.out.println(data);
} catch (Exception e) {
System.out.println(e);
e.printStackTrace();
}
}
}
Ads
Ads