File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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 | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
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
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15286
    
    6

Moving to JDBC..


GenRocket - A Test Data Generation Platform
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

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://aspose.com/file-tools
 
subject: Searching for employee details in the MySQL database
 
Similar Threads
Confused with Constructor?
Append objects to List and show them.
Hibernate: Restrict fields in SELECT statement
help printing information
How can I map beans with static builder classes in CASTOR