jsp related question

I am satish.I am doing a project in jsp.I have a table called employee,in that i have 6 cloumns(fields).The first column is employee number ,the second is employee name and etc.I want to view the details of the employees in the jsp page,thereby i am establishing a connection to the database to retive form it.I the jsp page i am using a select option & textfields to retive the details of the employees,thereby in the select option the employee number will be coming,once u select the number form it,the other details such as employee name & etc should appear in the text box.I need the solution for this.kindly if u can send the source it will be helpful.

With Regards

Satish.

[728 byte] By [bsatish30] at [2007-9-26 2:13:07]
# 1

I won't offer database source, but, once you have the ResultSet, just do this

<%

out.println("<select name=\"name\">");

while(rs.next()) {

out.println("<option value=\"" + rs.getString("column") + "\">" + rs.getString("column") + ">");

}

out.println("</select>");

rvflannery at 2007-6-29 9:07:12 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...