jsp programe for displaying data from database

i am using JSP.i want to insert data into database and also want to display the things i have entered in the same page inside the corresponding fields in which i have entered these data.plz some one help me..i m going to submit my project next week..

View Answers

April 4, 2012 at 4:15 PM

1)employee.jsp:

<html>
<head>
<script>
var xmlHttp;
function showState(){
    var str1=document.getElemenetByID("txt1").value;
    var str2=document.getElemenetByID("txt2").value;
    var str3=document.getElemenetByID("txt3").value;

if(typeof XMLHttpRequest != "undefined"){
xmlHttp= new XMLHttpRequest();
}
else if (window.ActiveXObject){
xmlHttp= new ActiveXObject("Microsoft.XMLHTTP");
}
if (xmlHttp==null){
alert ("Browser does not support XMLHTTP Request")
return
}
var url= "emp.jsp";
url += "?val1=" +str1+"&&val2="+str2+"&&val3="+str3;
xmlHttp.onreadystatechange = stateChange;
xmlHttp.open("GET", url, true);
xmlHttp.send(null);
}
function stateChange(){
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){
var v=xmlHttp.responseText;
var strar = v.split(":");

        document.getElementById("txt1").value= strar[1];
        document.getElementById("txt2").value= strar[2];
        document.getElementById("txt3").value= strar[3];
}
}
</script>
</head>
<body>

<table>
<tr><td>Enter Name:</td><td><input type="text" id="txt1"></td></tr>
<tr><td>Enter Address:</td><td><input type="text" id="txt2"></td></tr>
<tr><td>Enter Email:</td><td><input type="text" id="txt3"> </td></tr>

<tr><td><input type="button" value="Submit" onclick="showState();"></td><td>
</table>
</body>
</html>

2)emp.jsp:

<%@page language="java" import ="java.sql.*" %>
<%

String val1 = request.getParameter("val1").toString();
String val2 = request.getParameter("val2").toString();
String val3 = request.getParameter("val3").toString();

String data="";
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root";);
Statement stmt = con.createStatement();
stmt.executeUpdate("insert into data(name,address,email) values('"+val1+"','"+val2+"','"+val3"')");
ResultSet rs = stmt.executeQuery( "SELECT * FROM data");
String id="";
               while(rs.next())
                {
                    data = ":" + rs.getString("name") + ":" + rs.getString("address") +":"+ rs.getString("email");
                }
                out.println(data);




%>

For more information, visit the folowing links:

http://www.roseindia.net/answers/viewqa/WebSevices/19592-retriving-data-from-sql-server-using-jsp-code-and-placing-them-in-text-fields-of-html-code.html

http://www.roseindia.net/answers/viewqa/JSP-Servlet/9584-JSP-Servlet-Search-and-Edit.html

http://www.roseindia.net/jsp/comboSelect.shtml

Advertisements

displaying data retrieved from a database in a jsp page
displaying data retrieved from a database in a jsp page the page should display username, emailid, telephone in addition to tthe tagline however... sql = "select billid, customerid, billdate, status from customerbills where

Connecting to MySQL database and retrieving and displaying data in JSP page
Connecting to MySQL database and retrieving and displaying data in JSP page...; This tutorial shows you how to connect to MySQL database and retrieve the data from the database. In this example we will use tomcat version 4.0.3 to run our

how to display data from database in jsp
how to display data from database in jsp how to display data from database in jsp

displaying List of records from database in a jsp using ajax
displaying List of records from database in a jsp using ajax Sir, I need to retrieve the records from the database for every 7 seconds and display... data from the database. After getting the response from the servlet am unable

Displaying file from database
Displaying file from database I have list of files in my database. I... that corresponding file from database. I have list of file id related to search. I want... = "select file_data from file where id="+id; ResultSet rs = st.executeQuery

data are not display in JSP from database - JSP-Servlet
data are not display in JSP from database i want to finding some data through a SQL query from SQL server database to a JSP page based on some... of this jsp page. like.. School Result and three request parameters 'class', 'from

Display Data from Database in JSP
, to show data from the database click on the link that calls another .jsp file named...;/head> <body> <h2>Data from the table 'stu_info' of database... page,that calls this jsp page and show all data from the table. ADS

Data displaying with limited records in jsp
Data displaying with limited records in jsp How to display table with limited 10 records , after clicking next button another 10 records from database upto last record please help me

how to get data from database into dropdownlist in jsp
tutorial go through the link JSP Get Data Into Dropdown list From Database �...how to get data from database into dropdownlist in jsp Can anybody tell me what is the problem in this code as i am not able to fetch the data from

How to show data from database in textbox in jsp
How to show data from database in textbox in jsp How to show data from database in textbox in jsp Here is an example that retrieve the particular record from the database and display it in textbox using JSP. <

data retrival from database throw simple jsp..
data retrival from database throw simple jsp.. We can retrieve the the data from data base simple jsp page: Jsp Page:retrive.jsp <...; Statement stmt = null; String Query="SELECT * FROM STUD"; try

how to display data from jsp file into database
how to display data from jsp file into database this is a jsp file...+",'"+email+"')"); out.println("Data is successfully inserted into database...(); in the below example. the error is "cannot convert from java.sql.Statement

displaying data
displaying data how to display data from database on jsp using struts2

how to get data from database into dropdownlist in jsp
how to get data from database into dropdownlist in jsp //Customer Name: <select name="name"> <% try{ Class.forName...="select * from staff"; ResultSet rs=st.executeQuery(sql); while(rs.next

retrive data from database using jsp in struts?
retrive data from database using jsp in struts? *search.jsp* <%@taglib uri="http://struts.apache.org/tags-html" prefix="html"%> <... searchProduct(SearchDTO sdto) { String query="select * from product

how to get data from database into dropdownlist in jsp
how to get data from database into dropdownlist in jsp Customer Name:<select name="name"> <% try{ Class.forName...=con.createStatement(); String sql="select * from staff"; ResultSet rs

design chart takes data from database and through jsp page
design chart takes data from database and through jsp page how can I design chart takes data from database and through in jsp page

displaying List of records from database in a jsp using ajax, onclick it should display the results ?? its urgent can u help me
displaying List of records from database in a jsp using ajax, onclick it should display the results ?? its urgent can u help me displaying List of records from database in a jsp using ajax, onclick it should display the results

JSP Get Data From Database
JSP Get Data From Database In this section we will discuss about how to get data from database using JSP. To get data from database to a JSP page we... giving a simple example which lets you understand to fetch data from database

How to Retrieve data from database in jsp
How to Retrieve data from database in jsp In this section we will discuss about how to fetch data from database table. We will give a simple example which will demonstrate you about fetching data from database table. Example We

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

displaying data for a single column from Mysql database in the list box in php form
displaying data for a single column from Mysql database in the list box in php form I have a form in php.want to display data from a single column...; $data = @mysql_query("select * from names"); echo "Select a Name: n"; echo "<

Displaying data from combobox on the web page
Displaying data from combobox on the web page Sir, I have to make a project in which a data from the database is to be displayed in combo box and depending on the choice made in combo box the data pertaining to it from

How we delete a data of database from front end jsp page
How we delete a data of database from front end jsp page I make a website and featch a data from data base and now i want that a delete button put... deleted from jsp page as well as from database.I used mysql and jsp. Please help me

retrieve related data from database using jsp and mysql
retrieve related data from database using jsp and mysql Hi sir, please give some example of jsp code for retrieving mysql database values in multiple dropdown list. if we change a value in a dropdown its related value must

dynamic retrivel of data from mysql database in table format at jsp
the data from database and display it as table format in jsp... For example, i have...dynamic retrivel of data from mysql database in table format at jsp �...... At jsp, if i choose A1 from the dropdown list then the corresponding details

retrive the data from access database to drop down list box in jsp
retrive the data from access database to drop down list box in jsp hai, im new to jsp now im using the jsp along with access database.in table i load all the data's i need to retrive the data from database to dropdown list box

By dropdownlist retrive data from database and show in textbox in jsp.
By dropdownlist retrive data from database and show in textbox in jsp. Hello Sir, I am doing project in jsp.I have to retrive data from database, when I select value from dropdownlist, and that data I want to show in textbox

How to get the data from the database using Servlet or JSP program
How to get the data from the database using Servlet or JSP program hello My Netizen friend has given the answer to retrieve data from the database... database using JSP Get data from database using JSP

jsp code for display of data from database and snap shot of the output
jsp code for display of data from database and snap shot of the output i am using JSP.i want to insert data into database and also want to display... the following link: http://www.roseindia.net/jsp/displaydatafrom_database1.shtml

Data needs to be gathered in XML file from the database (MySql) using JSP
Data needs to be gathered in XML file from the database (MySql) using JSP�... data regarding particular id from the database table. Data needs to be gathered in XML file from the database (MySql) using appropriate JSP/Java Bean functions

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

url parameter using retrive data from database in jsp
url parameter using retrive data from database in jsp the user can... clicks the Preview button, you have to create a dynamic jsp which should read the contents from the db based on the event id. But this jsp url should be a public

How to get data from Oracle database using JSP
problem in jsp in the sense to get data from the database like oracle . I have... data from the database like oracle), I have created one jsp program like... the answer to retrieve data from the database by using servlet or jsp program

how to store the data in a array retrived from the database - JSP-Servlet
how to store the data in a array retrived from the database hi... in database,and i need to disply all the employees record in a single jsp. pls can any one tell me how to do it this using jsp. thankyou, Hi nagaraj

how to add data dynamically from database into a dropdown list in a jsp
how to add data dynamically from database into a dropdown list in a jsp hi friends i am doing a project in jsp and oracle as my database.In my... get dynamically from the database and whenever a new person has registered his

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

Dynamic retrieval od data from database and display it in the table at jsp
the data from the mysql database... pls its urgent.. help me frnds.... Here is a jsp code that retrieves the data from the database and display...Dynamic retrieval od data from database and display it in the table at jsp�

url parameter using retrive data from database in jsp
url parameter using retrive data from database in jsp The user can... clicks the Preview button, you have to create a dynamic jsp which should read the contents from the db based on the event id. But this jsp url should be a public url

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 hibernate and send the data in a Java file object to jsp page.ADS_TO_REPLACE_1

Acees data from database using combo box - JSP-Servlet
Acees data from database using combo box please let me how i access the data from database when i select combo box combo2 having values Arts... value 11 or 12, otherwise combo box combo2 remain hide. Here is JSP's files

image displaying from database with some other information
image displaying from database with some other information hi, in the following section of code when i am not displaying the image it is working... only a cross mark is shows. same code runs if i am not retriveing any data from

jfreechart displaying chart from access database
jfreechart displaying chart from access database I have these 2 codes. array.java----in which i retrieve the values from the database . import... javax.servlet.http.HttpServletResponse; /** * * @author AARUSHI */ class database { int roll; String

jsp programe for displaying data from database

Questions by Category