Hello,

I have a html form in which there are 4 fields and 1 button.
1. Employee Number
2. Employee Name
3. Salary
4. Address
5. Retrive button
And I have a table in database named "employee".

I want to retrieve employee information in the above text fields to be filled up(i.e employee name, salary, address) when I enter the employee number and hit Enter Retrieve button corresponding to that employee number.

How do I do that?
Plz help me in doing this.

Thank you.

JDBC, but not in a JSP.

What jwenting mean by that is as follows. In JSP create form that collect data. On button click submit collected data to servlet for validation (you can do validation also on JSP if you know scripting languages). Once data found valid connect to database and request employee info. Collected data from data from DB servlet will pass another JSP

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.