create hyperlink on a field (empno) in a table to display that record

archanasweety

hi, i am facing a problem while creating a hyperlink. what exactly i want to ask is : i have emp table with empno, name, addr. now i want to display all empno from table in a htmp page & create hyperlink on empno so that when clicked on any empno, it should display the respective record details. please help and fast.

mgalmoguera

: hi, i am facing a problem while creating a hyperlink. what exactly i want to ask is : i have emp table with empno, name, addr. now i want to display all empno from table in a htmp page & create hyperlink on empno so that when clicked on any empno, it should display the respective record details. please help and fast.
:


you may assign to a variable the empno:

e.g.
<% string EmpNo = rs.getstring("empno");%>

on your link:

e.g.
"


On EmployeeDetails.jsp you can get the value by using the request.getParameter();

e.g. requet.getParameter("EMPNO");

hope it will work!!!