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);
}
%>

Advertisements

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

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

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

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

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

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

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

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

use data from database table as hyperlink value - JSP-Servlet
use data from database table as hyperlink value I'm creating a web page that allows user to search my database. The page will display partial results of my database, then the first column of the resultset was converted

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

how to retrieve data from database using combobox value without using request.getParameter in jsp - JSP-Servlet
how to retrieve data from database using combobox value without using request.getParameter in jsp Answer pl

Read the value from XML in java
Read the value from XML in java Hi, i have an XML... the permissions on that file.So how can i read that value. This is little urgent.... <param name="file" value="D:/Lakki

connect to the database from JSP
connect to the database from JSP How do you connect to the database from JSP? A Connection to a database can be established from a jsp page by writing the code to establish a connection using a jsp scriptlets

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

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

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

How to retrieve data from database by using combo box value in jsp? - JSP-Servlet
How to retrieve data from database by using combo box value in jsp? ...; } function showEmp(emp_value) { if(document.getElementById("emp_id").value!="-1") { xmlHttp=GetXmlHttpObject() if (xmlHttp==null) { alert ("Browser

how to read data from excel file through browse and insert into oracle database using jsp or oracle???
how to read data from excel file through browse and insert into oracle database... be inserted into oracle database.. please help me sir... hi friend..., in these examples MySQL is used as database system if you want to use the Oracle

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

selecting data from database
selecting data from database how to select data from database using Dao in struts Hi, You have to load the data from database using... Please read at http://www.roseindia.net/struts/hibernate-spring/index.shtml Let's

How to read data from txt file and save to database MySql - Java Beginners
How to read data from txt file and save to database MySql Please help me again ,my problem right know is how to read data from txt file then data save to database from JButton.Please give me a tutorial and source code

Update Database from jsp
Update Database from jsp I want to update my oracle database column from a text box ,so whenever I input some text value in the text box and click UPDATE button the database field should be updated . I have a drop down menu

retrive data from database
retrive data from database hi.. i made a application form. it's have attribute s.no,name,roll no and i enter a few records. now i want to view all record not in database access sheet i want to view it at any another

Fetching image from database
Fetching image from database I have uploaded image path and image name in database so, now how can i display that image using JSP or HTML page... in database is:E:\1003\54175\20110407121554 image name i have stored

ACCESS DATABASE FROM HTML
ACCESS DATABASE FROM HTML I want to access sql 2008 database in html page without help of ADODB connection.. because if access through ADODB means there is a security problem. so, Access database in html page(client side

display date to jsp from database
display date to jsp from database display date to jsp from database to calender if the start date and end date is available than calender date... not available in database field than show in green color and clickable. NOTE :- Date

Database
Database from java code i have to retrieve some data from a database... in database timezone is 9PM 15APR2012. I want to retrieve something from database... will be able to retrieve data from database according to the database time. for example

searching from database
searching from database how to search data from data base throug search...such as contact no./lastname /firstname should give whole information from database... Please visit the following link: Servlet search

get information from database
get information from database get information from database Please visit the following links: http://www.roseindia.net/sql/mysql-table/mysql-php-select.shtml http://www.roseindia.net/sql/mysql-example/select

Delete points from database
Delete points from database I have a polygon on a web page and a delete button. The polygon is saved in the database in one table and in another... in database. However the points are not getting deleted. I used this code

change color according to the database value
change color according to the database value any one know how to get values from database ( 1 or 0 ) and according to that change the color ( red or green) of given list

about value taken in java database - JDBC
about value taken in java database how to take value from Serial port communication Hyperterminal to the java database

Ads