Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Mar 2008
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to retrieve data from database(MYSQL) in JSP

    Hi,

    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.

    Reply Soon.

    Thanks in advance.

  • #2
    Regular Coder
    Join Date
    Jan 2008
    Location
    Willow Grove, PA
    Posts
    169
    Thanks
    1
    Thanked 27 Times in 27 Posts
    http://www.codingforums.com/rules.htm

    Hate to break it to ya:

    1.5) No homework assignments - Do not post your entire homework assignment and request that other members do it for you. This is considered cheating, and your thread may even be used by your school to prove your guilt. Now, you may ask for advice or help on a specific aspect of your assignment that you're having trouble with. Use common sense as far as what's acceptable in terms of soliciting help with homework assignments.

    That being said, MySQL has a ton of documentation on how to connect to a database and run SQL statements.

    http://dev.mysql.com/doc/refman/5.0/...-examples.html


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •