How to retrieve data from database(MYSQL) in JSP
I'm creating a Web Application for my Final Year Project i need ur help people im new to this.
Im using Netbeans. I have created Jsp pages n Im using MySql for Database.
I had problems with connecting to the Database now that is done.
Can anyone tell me how can i retrieve data from database using a search field. Like if i want a record of an employee whos id is "123" then i'l write 123 n click search and will get the record of employee whos id is "123".
What code should i write to get this data and where should i write it for retrieving the data?
If possible please write the whole code...i.e. from start to end..with connection.
Thanks in advance.