aspose file tools
The moose likes JDBC and the fly likes Searching for employee details in the MySQL database Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Searching for employee details in the MySQL database" Watch "Searching for employee details in the MySQL database" New topic
Author

Searching for employee details in the MySQL database

vernon mweetwa
Greenhorn

Joined: Nov 26, 2004
Posts: 24
hi all,

i am developing a program that needs to be used to search for employee details in our organisation. I would like either the firstname or the surname to be used as a search string. What i mean is if anyone wants to search for another person's details then they have to enter either the firstname or the surname to view their information.

How do i wrute a program that would iterate through the database and bring any records that would match the name provided by the user?

Your response will be highly appreciated.
Ben Souther
Sheriff

Joined: Dec 11, 2004
Posts: 13410

I would start by searching the web for some JDBC and SQL tutorials.
I would then look for a servlet/JSP tutorial.

If you haven't already, you should follow some Java tutorials before starting either of the above.


Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
magic zha
Greenhorn

Joined: Mar 25, 2005
Posts: 24
Refer to some JDBC tutorials.
It is very easy.I think you will solve it in 20 minutes.
Gregg Bolinger
Ranch Hand

Joined: Jul 11, 2001
Posts: 15230

Moving to JDBC..
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1076

though your post is now in JDBC forum but answer is same as Ben said

Shailesh


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Searching for employee details in the MySQL database
 
Similar Threads
Append objects to List and show them.
How can I map beans with static builder classes in CASTOR
Hibernate: Restrict fields in SELECT statement
Confused with Constructor?
help printing information