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