DATABASE MYSQL Question,
September 21, 2010 at 5:07 AM
Good Morning Sir/Mam, I like your site for it was really helpful for our researches. Most of your approach when giving examples for a certain topic are very easy to learn. For this, I would like to ask a question if you could give me or teach me how to retrieve data from database from the entered keyword in textbox.
Let's say, I have a database with rows named as NO, TITLE, AUTHOR & SUBJECT and has data 1, Software Engineering, Kathleen Reyes & COMPUTER entered respectively. Now, I have a GUI where I can search the contents of the database through keywords.
For example, I will enter a word COMPUTER (which is under the column SUBJECT) in the textbox. Now, the only output I want to be retrieved is the NO & TITLE only. How will I do that in Java? Is it possible to use keywords from other columns but I want the TITLE of the SUBJECT to be the output in the frame.