reain values

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

View Answers

May 17, 2011 at 1:09 PM

1)checkusername.jsp:

<%@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