Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Java Databases Discussion specific to working with Java Databases. For other Java topics, please see related Java forums. For database discussions not specific to Java, please see the Database category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Java Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 23rd, 2005, 11:30 PM
Registered User
 
Join Date: Jul 2005
Location: bangalore, , India.
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default java/jsp and MySQL

my application is a web based library system.
and i have implement search facility of books.
i want to know how to get the resultset of a search to a web page's table(html table)
i.e, when search is done through excecuteQuery object how to send the result set to a table to show the output.
thanks in advance


 
Old July 29th, 2005, 02:31 AM
Authorized User
 
Join Date: Jul 2005
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You can use a 'for' loop and iterate through the query results and write each query result in string format to table rows.

John Dirk
Programming Consulant
http://www.programminghelp4u.com - P.../Project) Help
 
Old August 2nd, 2005, 02:07 AM
Authorized User
 
Join Date: Aug 2004
Location: cluj, romania, Romania.
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to olupas
Default



Hi ,

It depends on what you are using...
1.PHP --iterating the query resuts in a table tag
2.JSP -
a.the best approach is using Struts tag iterator over a collection of value object....in a html tag
b. write a scriplet...but it's a not a "wonderfull" approach :D whithin a JSP
3.Servlet .... the same as PHP

Hope this helps

LOOP





Similar Threads
Thread Thread Starter Forum Replies Last Post
JSP-n-MySQL simple example anshul BOOK: Beginning JavaServer Pages 1 April 12th, 2006 05:31 AM
jsp/java tomcat and mysql harshika JSP Basics 1 August 8th, 2005 03:01 PM
java and jsp harshika Apache Tomcat 1 August 6th, 2005 05:15 PM
JSP-n-MySQL anshul JSP Basics 0 May 31st, 2005 02:21 AM
JSP + MYsql MAK_NUST Java Databases 5 October 27th, 2004 05:46 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.