reain values

Ads
 

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









Related Tutorials/Questions & Answers:
reain values
reain values  Sir I have Jsp page for regisering customers,when i... 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
duplicate values
duplicate values  My database having cursor that has duplicate values.i want to remove duplicate values through java application
Advertisements
Values to listbox
Values to listbox  I have two textboxes by the name street and city.I have an add button and a name listbox. When I enter street and city and press the add button ,all the names of the people residing there are listed in listbox
hibernate.archive.autodetection values
hibernate.archive.autodetection values  Hi, What are the hibernate.archive.autodetection values? How to use the hibernate.archive.autodetection in Hibernate project? Thanks   Hi, You can use the class, hbm as values
Retrive Values
Retrive Values  I want to retrive the values between the td by the id using the javascript.So please help me... html form like this <TABLE width="100%" bgColor=""> <TR> <TD ID="td1">Cell 1</TD>
JTable duplicate values in row
JTable duplicate values in row  JTable duplicate values in row
multiple select values
multiple select values   can you provide an example for multiple select values for html:select tag
how to set the values in jsp
how to set the values in jsp  how to set the values text boxs in jsp frm dbase via servlet
ModuleNotFoundError: No module named 'values'
ModuleNotFoundError: No module named 'values'  Hi, My Python... 'values' How to remove the ModuleNotFoundError: No module named 'values'... to install padas library. You can install values python with following command
fetch values in dropdown
fetch values in dropdown  in my application i want fetch dropdown values in jsp page through servlet. means i have to fetch the database fields values in array variable of servlet and then i have to print those values in dropdown
select tag multiple values
select tag multiple values   I want to insert multiple values in database which i have selected from select tag
Read Bit values
Read Bit values  how to read bit values in the program Please give suggestion, which is useful in Simplified DES Algorithm
Remove duplicate values
Remove duplicate values  i am trying to insert values into database... is primary key. other attributes can allow null. am trying to insert values...:subject],[CreatedBy])" + " values('"+Cname[i]+"','"+textdescription[i
passing values on button click
passing values on button click  Please help me to solve this issue.I want to pass a value assigned to button to another view upon button click in xcode
Sending hidden values
Sending hidden values  how to send more than one hidden values through javascript function . Main purpose is to remove href link (Query string should not appear in url bar
Retain jsp values
Retain jsp values  how to retain a jsp values without using session and cookies?   Hello Friend, You can use request.getParameter() and request.setAttribute() methods to get the jsp fields values. For more information
Hibernate hbm2ddl.auto values
Hibernate hbm2ddl.auto values  Hi, What are the values for Hibernate... of hbm2ddl.auto is set correctly. Hibernate hbm2ddl.auto values The possible values for this property are: validate: Its used to validate the schema
passing values in hyperlink
passing values in hyperlink  Hi. I have given a hyperlink in one jsp page. Can i able to pass that hyperlink label as a value to the next page its navigating when the user clicks it. Plz respond me quickly. Thanks in advance
passing values in hyperlink
passing values in hyperlink  Hi. I have given a hyperlink in one jsp page. Can i able to pass that hyperlink label as a value to the next page its navigating when the user clicks it. Plz respond me quickly. Thanks in advance
passing values in hyperlink
passing values in hyperlink  Hi. I have given a hyperlink in one jsp page. Can i able to pass that hyperlink label as a value to the next page its navigating when the user clicks it. Plz respond me quickly. Thanks in advance
passing values in hyperlink
passing values in hyperlink  Hi. I have given a hyperlink in one jsp page. Can i able to pass that hyperlink label as a value to the next page its navigating when the user clicks it. Plz respond me quickly. Thanks in advance
retaining textbox values
retaining textbox values  i have a calculator program, when i press a button the value displays but disappears when i press another button so how can i keep values to display when i press multiple buttons
passing values in hyperlink
passing values in hyperlink  Hi. I have given a hyperlink in one jsp page. Can i able to pass that hyperlink label as a value to the next page its navigating when the user clicks it. Plz respond me quickly. Thanks in advance
iterating hashmap values in struts2
iterating hashmap values in struts2  hi, i am not getting how to display this map values in jsp page using struts2 public class ViewOperation2 { public Map<String,Object> viewCustDetails(){ Map<String
Default Values
Default Values The elements which do not have any children can have default values. Default values are assigned automatically if no value is supplied. The "default" attribute of the xs:element element can be used
Replacing a template with actual values
holders with acutal value. The acutal values are in the map with key as the place
Hibernate envers revtype values
Hibernate envers revtype values  Hi, What are Hibernate envers revtype values? Thanks   Hi, Hibernate envers library automatically keep track of the changes made to the entity. It create a new table with _AUD suffix
Arraylist from row values
Arraylist from row values  Hello, can anyone please help on how to make an arraylist from the row values of a particular column from a database table? Thanks in advance!   import java.sql.*; import java.util.ArrayList
retrieve multiple attribute values
; What I would like is to retrieve both the attribute values of process
retrieve multiple attribute values
like is to retrieve both the attribute values of process:Output during execution
retrieve multiple attribute values
like is to retrieve both the attribute values of process:Output during execution

Ads