read value from database & alert it is available in database or not

how to read value from text box and alert whether it is available in database or not?

View Answers

February 16, 2012 at 5:29 PM

1)availability.jsp:

<html>
<head>
<script type="text/javascript">
function check(value){ 
xmlHttp=GetXmlHttpObject()
var url="check.jsp";
url=url+"?name="+value;
xmlHttp.onreadystatechange=stateChanged 
xmlHttp.open("GET",url,true)
xmlHttp.send(null)
}
function stateChanged(){ 
if(xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){ 
    var showdata = xmlHttp.responseText; 
    document.getElementById("mydiv").innerHTML= 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>
<body>
<form name="form">
 UserName: <input  type="text" name="name" id="name" onkeyup="check(this.value);"><font color="red"><div id="mydiv"></div></font>
</form>    

</body>
</html>

2)check.jsp:

<%@ page import="java.sql.*" %> 
<%
String name = request.getParameter("name").toString();
System.out.println(name);
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='"+name+"'");
int count=0;
          while(rs.next())
          {

                   count++;
          }

                    if(count>0)
          {
             data="Not Available";
          }
          else
          {
                      data="Available";
          }
out.println(data);
System.out.println(data);
}
catch (Exception e) {
System.out.println(e);
}
%>

Ads

Advertisements

code for insert the value from jsp to access database
code for insert the value from jsp to access database code for insert the value from jsp to access database

related retrieving value from oracle database
related retrieving value from oracle database how we get the value from database in the given textbox

check radio button on retrieving the value from database.
check radio button on retrieving the value from database. HI i am new to jsp.In my applcation i having a problem. I am retrieving user payment from... information from database the i want to show cash radio button checked.How can i do

how to select the row value that was retrived from the database ?
how to select the row value that was retrived from the database ? I am getting the data's from the table that was stored in database. Now in the page in which i am getting all the data from the database has an another select

Retrieve value of radio button from database to form
Retrieve value of radio button from database to form var gn=document.getElementsByName("empg"); //empg is name of radio input type. for(var i=0;i

how to read values from excel sheet and compare with database using jsp
how to read values from excel sheet and compare with database using jsp hi sir i am arun how to read values from excel sheet and compare...,serialno) values of excelsheet we have to compare with database value if these 3

Retrieving value from multiple table in database
Retrieving value from multiple table in database Hi fnds, I want to maintain the financial database of 20 users for 1 year and update the details... FROM ( SELECT * FROM month1 UNION ALL SELECT * FROM month2 UNION ALL

select value from autocomplete textbox using jquery in jsp from database.
select value from autocomplete textbox using jquery in jsp from database. Hii Sir, Lots of thnx to ur reply .I went through both... of selecting value from autocomplete textbox using jquery in jsp from mysql database

select value from autocomplete textbox using jquery in jsp from database.
select value from autocomplete textbox using jquery in jsp from database. ... but was unable to find out exact way to fullfill the solution of selecting value from autocomplete textbox using jquery in jsp from mysql database. Kindly send me

Read code from excel sheet and upload into database using JSP
Read code from excel sheet and upload into database using JSP I want to upload data to database from an excel worksheet using jsp ...Please help

I want to Populate ComBobox value from database that combox is Itemrenderer of DataGrid.
I want to Populate ComBobox value from database that combox is Itemrenderer of DataGrid. I want to Populate ComBobox value from database that combox is Itemrenderer of DataGrid

Read data from excel file and update database using jsp
Read data from excel file and update database using jsp read data from excel file and update database using jsp Hi, I am using a MySQL database... upload excel file and update database using JSP ? Thanks in Advance

retrieve value from database on the basis of maximum id number
retrieve value from database on the basis of maximum id number hi, i want to retrieve value of maximum id number from the database and show that value in jTextField.when the user clicks on the button that maximum id number

retrieve the data to text fields from database on clicking the value of combo box
retrieve the data to text fields from database on clicking the value of combo box retrieve the data to text fields from database on clicking... getting data into textarea from database table by clicking on the button

populating textbox value from the database using onchange function,
populating textbox value from the database using onchange function, ... dynamically from the database(mysql). after selecting the value from the dropd.... but the next textbox value is populated from database. plz help me guys

JDBC Video tutorial - How to read Data from MySQL Database?
JDBC Beginners tutorial for reading the data from MySQL database - RoseIndia.Net In this tutorial you will learn the code to read the data from the MySQL table and understand how to execute the query to get the data from database

Selecting a radio button in jquery autocomplete from database value
Selecting a radio button in jquery autocomplete from database value I can get the data from the database using PDO to my jquery.js file. How do I force the value (1 = Handicap, 2 = Scratch, 3 = Both) to select the appropriate

jsp code for a drop down box to retrive value from database
jsp code for a drop down box to retrive value from database my project needs to get the value from database in to the drop down box..... pls give me code for that ..... tan q 1)login.jsp: <html> <script>

how to display data from database according to entered value in search field
how to display data from database according to entered value in search...("SELECT M.MEMBER_ID, M.FNAME,M.LNAME,M.AGE,B.HEIGHT,B.WEIGHT, B.BMI_VALUE FROM...(); System.out.println("Disconnected from database"); } catch (Exception e

how to show value and percentage in piechart sections from database using jfreechart
how to show value and percentage in piechart sections from database using jfreechart Hii Sir, I made a pie chart from database using... = response.getOutputStream(); try { String query = "SELECT * from satya

how to show effect (visual) on jsp page using value from database
how to show effect (visual) on jsp page using value from database I... i want is when the value in booking status is "booked" then the pictures shown as seats should be displayed red. when the value in booking status

JPA read data from database example
JPA read data from database example ... data from database using JPA. Create a "JPARead.java" file and follows the following steps to reading data from database. Again, you create

JPA read data from database example
JPA read data from database example ... from database using JPA. Create a "JPARead.java" file and follows the following steps to reading data from database. Create "JPARead" class

download code from database
download code from database how to download files from database

Acess Record from database.
Acess Record from database. How to access records from database and how to display it on view page, with the help of hibernate

retrive data from database?
retrive data from database? hellow i have a database sheet name as db1. it's contain sixty(60) sn,name ,rollno(primary key),father's name etc... from db1 and enter value in text box according there name,rollno and save

delete an item from database
delete an item from database how to delete an item from the database using jsp

Ads