Retrieve data by clicking a link

Home Answers Viewqa JSP-Servlet Retrieve data by clicking a link

Nandini Mishra

Retrieve data by clicking a link
2 Answer(s) 2 years ago
Posted in : JSP-Servlet

In a page there are 5 links.Every link has a hidden value. According to that hidden value data should be retrieved from the database and data should be displayed in a new page.How to do it?Please help.

View Answers

May 24, 2011 at 12:32 PM

1)link.jsp:

<a href="display.jsp?id=1">Link1 </a><br>
<a href="display.jsp?id=2">Link2 </a><br>
<a href="display.jsp?id=3">Link3 </a><br>
<a href="display.jsp?id=4">Link4 </a><br>
<a href="display.jsp?id=5">Link5 </a>

2)display.jsp:

<%@page import="java.sql.*"%>
<table>
<%
String id=request.getParameter("id");
Class.forName("com.mysql.jdbc.Driver").newInstance();  
 Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");  
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("Select * from employee where id='"+id+"'");
if(rs.next()){
    %>
<tr><td>Name:</td><td><input type="text"  value="<%=rs.getString("name")%>"></td></tr>
<tr><td>Address:</td><td><input type="text"  value="<%=rs.getString("address")%>"></td></tr>
<tr><td>Contact No:</td><td><input type="text" value="<%=rs.getString("contactNo")%>"></td></tr>
<tr><td>Email:</td><td><input type="text" value="<%=rs.getString("email")%>"></td></tr>
<%
}
%>
</table>

May 24, 2011 at 12:32 PM

1)link.jsp:

<a href="display.jsp?id=1">Link1 </a><br>
<a href="display.jsp?id=2">Link2 </a><br>
<a href="display.jsp?id=3">Link3 </a><br>
<a href="display.jsp?id=4">Link4 </a><br>
<a href="display.jsp?id=5">Link5 </a>

2)display.jsp:

<%@page import="java.sql.*"%>
<table>
<%
String id=request.getParameter("id");
Class.forName("com.mysql.jdbc.Driver").newInstance();  
 Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");  
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("Select * from employee where id='"+id+"'");
if(rs.next()){
    %>
<tr><td>Name:</td><td><input type="text"  value="<%=rs.getString("name")%>"></td></tr>
<tr><td>Address:</td><td><input type="text"  value="<%=rs.getString("address")%>"></td></tr>
<tr><td>Contact No:</td><td><input type="text" value="<%=rs.getString("contactNo")%>"></td></tr>
<tr><td>Email:</td><td><input type="text" value="<%=rs.getString("email")%>"></td></tr>
<%
}
%>
</table>

Retrieve data by clicking a link
Retrieve data by clicking a link In a page there are 5 links.Every link has a hidden value. According to that hidden value data should be retrieved from the database and data should be displayed in a new page.How to do it?Please

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

link in the field of table on clicking he link the full data will displayed
link in the field of table on clicking he link the full data will displayed Hello... I am learning jsp and mysql. I am facing some problem. I am... that on clicking on any one of the name of the student, the whole data

link
link how can we give hyperlinks on data retrieved from the database... and details related to that link should be diaplay and stored in the database... which when clicked displays some data and "conference " is stored in another

link
to displays some data on click and post data using ajax. All these multiple

how to retrieve link - JSP-Servlet
how to retrieve link how to retrieve link of a web page and use it as input in the program

Retrieve data using Criteria api
Retrieve data using Criteria api import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Query; import... the following link: Hibernate Tutorials

How to Retrieve Data from Facebook Using PHP
How to Retrieve Data from Facebook Using PHP is this link has right content regards that?? http://techpdf.co.cc/blog/how-to-retrieve-data-from-facebook-using-php

how to retrieve blob data - JSP-Servlet
how to retrieve blob data How to retrieve the BLOB table having... as a table format? Hi friend, I am sending you a link. I hope that, this link will help you. Please visit for more information. http

Display alert box on clicking link
Display alert box on clicking link In this tutorial, we will display alert box... a "a href" link. On clicking this link ,a alert box prompt message... is used to display alert box on clicking link : $("a").click(function

attaching a link
attaching a link I want the program code for , creating an application form and it is attached to our code, by clicking on this link, the form should be open

How to read and retrieve jtable row values into jtextfield on clicking at particular row ...
How to read and retrieve jtable row values into jtextfield on clicking at particular row ... Hello Sir, I am developing a desktop application in which i have to display database records in jtable .now I want

how to retrieve data from table with runtime values in sql?
how to retrieve data from table with runtime values in sql? how to retrieve data from table with runtime values in sql? For example, I have table... to execute the command with the dates which I pass. I know how to retrieve a particular

store and retrieve data
store and retrieve data sir,i want to store the entering data in a word file and retrieve it when i need.i am try to develop a video portal.in which... Write data into word file For this, poi-scratchpad-3.7-20101029.jar is needed

How to retrieve data using combo box value in jsp? - JSP-Servlet
How to retrieve data using combo box value in jsp? Hi freind, I already post this question. I need urgent help from u. pl response me... the following link: http://www.roseindia.net/jsp/comboSelect.shtml Hope

Hyper link
Hyper link how to open a document in read only mode by clicking on a hyperlink 1)openexcel.jsp <a href="excelFile.jsp">Open Excel File</a> 2)excelFile.jsp: <% try{ Runtime rt = Runtime.getRuntime

how to retrieve data from database ?????/
how to retrieve data from database ?????/ how to retrieve data from database

how to store,retrieve,modify the data
how to store,retrieve,modify the data hello sir ,how to store,retrieve,modify the data using the swing please help me

Retrieve The Data From MySql Datbase
Retrieve The Data From MySql Datbase How to Retrieve The Data From MYSQL database TO Use Select the Emp_id Option.And Also Search Option

How to retrieve data by using combo box value in jsp? - JSP-Servlet
How to retrieve data by using combo box value in jsp? Hi Friends, When i click combobox value in jsp form page, it will diplay... the follwing link http://www.roseindia.net/jsp/comboSelect.shtml ull pointer

JavaScript link
JavaScript link...; In this section, you will learn about the text property of Link object in JavaScript. JavaScript's Link object has the property text which allow the user to get the text

retrieve data from database with hyperlink
retrieve data from database with hyperlink sir....i have one table called 'name' having two values i have to retrieve those data with a hyperlink... have values C C++ i have to retrieve and if i click C its sub categories should

Retrieve data from database by using sql tag of JSTL SQL library
Retrieve data from database by using sql tag of JSTL SQL library... we will see how retrieve data from database using sql query given by user.../retrieve_database_SqlJstlTag.jsp' or click on this link. Output of the program

retrieve data from mysql database
retrieve data from mysql database hi am not familiar in php.....even... selected value on combobox which is to be retrieve the relevant data from mysql...;'; } ?> finally the result is whole data is displayed where the data

retrieve data into textbox - Swing AWT
retrieve data into textbox Hi! I am writing a program using java swing to create a front end in which a user enters his name and roll no. and gets... there is a table called student in which all records are kept..how can i retrieve

Data retrieve from mysql database
Data retrieve from mysql database Hi sir, please give some example... from the dropdown, related data will get displayed on the textboxes. Here we have...("name").toString(); String data=""; Connection conn = null; String url = "jdbc

retrieve data from database in java swing form using prev n next buttons
retrieve data from database in java swing form using prev n next buttons ...),avdRed(float),avgGreen(float),avgBlue(float) i have to retrieve all the fields of various rows from database in labels by clicking previous and next

how to use bean to retrieve data from database
how to use bean to retrieve data from database how to use bean to retrieve data from database poda sendru

Image retrieve
to mysql database... Now I want to retrieve the data from directory using path that store in a data base... How is it possible... Please help me.. Please reply...Image retrieve HI.. store image path/data Java Coding

link to other frame - Applet
link to other frame how a button to open to another frame? and the frame can keyin the data and it can show at the previous frame

Download LINK - JSP-Servlet
Download LINK sorry i am the new1 to java. I am learning and doing the project, can you please send me the complete code. So that i can understand easily. i want the code like by Clicking DOWNLOAD button the SAVE as dialog box

Retrieve multiple data from database into Table.....
Retrieve multiple data from database into Table..... hi........... I want to Retrieve multiple data from database into Table but i am not able to.... i am only able to retrieve one value not more than that. means in my

retrieve data from database using jsf
retrieve data from database using jsf Hello I want an example of source code to retrieve data from database i have a database (oracle) name as db1...),, name ,and city I want after enter value in textbox according idauthor i retrieve

JSP and XML .data store nd retrieve
JSP and XML .data store nd retrieve I have made a form in jsp having emp id, projectname and emp name.I want to store data related to employee in xml file.How can i store data entered by user in XML file and later retrieve data

link
the link the table is displayed and other links were hidden if i want to click the next link i have to refresh the page instead i want to do is when i click the link the table should display and again when i click the link the table should

I have to retrieve these data from the field table
I have to retrieve these data from the field table Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai,trichy,kanchipuram for a single record. I have to retrieve these data from

MYSQL retrieve record from Data table
MYSQL retrieve record from Data table Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai,trichy,kanchipuram for a single record. I have to retrieve these data from the field

LINK
LINK Thank you friend.cant we use single click instead of double click and also for four link u has given the example but i have 14 links in that case wat i should do

Retrieve data from xml using servlets
Retrieve data from xml using servlets Hi plz send me the code for retrieving the data from xml File using Servlets. Hi, Do you want... Thanks Hi, Learn Get Data From the XML File. Thanks

LINK
LINK I have four links which link to a table,if i click one link... i want to ask is when i click the link the table is displayed and other links were hidden if i want to click the next link i have to refresh the page instead i

Possible ways to Retrieve Data - Development process
Possible ways to Retrieve Data Hi Deepak, Can u explain me, how manys we can retrive data from database. am confused with ,1)using beans like set property and get property 2)using JSTL tags and apart frm

retrieve data from mysql database and store it in a variable ?
retrieve data from mysql database and store it in a variable ? sir , I am working on a project , in which I have to apply operation on input data... to store that data in int variable. how to do this ? Here is an example

how to insert, retrieve data from,to db(code)....
how to insert, retrieve data from,to db(code).... Hi..... i ve created login page n in that a registration form also.... my doubt is-when... that data will b stored in db(m using sybase). 2.also hw to retrieve the data from

to display like and dislike votes for a link
to display like and dislike votes for a link Am new to php i wrote a code for posting the links but now i want to add like and dislike for that each link which is visible on retrieve page i think it can be done by using Ajax

Retrieve data from databse using where in JSP
Retrieve data from databse using where in JSP Hi, can somebody help me? I have a jsp page. in that i want to get data from the database where username is matched. i tried it. but can't get the output. here is the code. please

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics