Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


gautamshetkar
reain values
1 Answer(s)      3 years and 6 months ago
Posted in : JSP-Servlet


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


Advertisement
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();
        }
    }
}


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
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
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
multiple select values
multiple select values   can you provide an example for multiple select values for html:select tag
percentage values for <TD WIDTH=...>
percentage values for   Can I use percentage values for <TD WIDTH=...>
Atomic values in Xml
Atomic values in Xml  Hi..... please give me the ans How you define atomic values in Xml? Thanks
disallow NULL values in a table.
disallow NULL values in a table.  How do I disallow NULL values in a table
Quotes around attribute values.
Quotes around attribute values.  Should I put quotes around attribute values
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
retrive values - JSP-Servlet
retrive values  how to get multiple values from html to jsp
select tag multiple values
select tag multiple values   I want to insert multiple values in database which i have selected from select tag
Java plateform dependent values
Java plateform dependent values  How will you get the platform dependent values like line separator, path separator, etc., ?  we will get the the platform dependent values like line separator, path separator
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
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
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
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
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
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
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
retrive values - JSP-Servlet
retrive values  how to retrive multiple values from html to jsp  Hi Friend, Try the following code: 1)calljsp.html: Enter Name: Enter Address: Gender:MF Qualification: Btech MBA MCA MSC
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
values in combobox - Java Beginners
values in combobox  how to fill values in combo box i.e. select tag in html using javascript?   Hi Friend, Try the following code: ComboBox var arr = new Array(); arr[0] = new Array("-select-"); arr[1
Replacing a template with actual values
holders with acutal value. The acutal values are in the map with key as the place
pass parameter names and values
pass parameter names and values  What is the <jsp:param> standard action?   The <jsp:param> standard action is used with <jsp:include> or <jsp:forward> to pass parameter names and values
 

 

 

DMCA.com