JDBC ResultSet in a web form with scrollbar


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 6 of 6

Thread: JDBC ResultSet in a web form with scrollbar

  1. #1
    Join Date
    Jan 2006
    Location
    Ireland
    Posts
    35

    JDBC ResultSet in a web form with scrollbar

    Hi,
    I was wondering if anybody has any ideas how I could display a ResultSet from JDBC in a web form with a scroll bar. I thought I could put the JDBC in an iframe but I think the src attribute of an iframe only takes file paths not ResultSets. Has anybody got any other ideas?

  2. #2
    Join Date
    Mar 2005
    Location
    UK, London
    Posts
    150
    u want it in a web form in your desktop application or on the web in ur browser. Use jsp for ur browser. if u want to use it in ur application then u can use a Jlabel with a Jscrollpane, but u will not be able to click any links, for that u will need to over ride some mouse methods. hope that helps.

  3. #3
    Join Date
    Jan 2006
    Location
    Ireland
    Posts
    35
    Thank you for your reply Major,

    I would like the scrollable ResultSet to appear in a browser so it looks like I am going to have to learn some JSP to do this, at the moment I use my servlet to generate html so I wondered if there was a html solution. This assignment is due this week so I dont really have the time to learn JSP so I'm still interested to hear other suggestions. One compromise solution I'm thinking of is to use the mySQL LIMIT command to only show the first 20 results then a button to show the next 20 and the next and so on. This is not as nice as a scrollbar but I may end up doing this.

    Thanks for your reply anyway, and I shall learn some JSP once I get time.

  4. #4
    Join Date
    Mar 2005
    Location
    UK, London
    Posts
    150
    No problem, funny im handing in a serverlet/jsp assignment after easter.

  5. #5
    Join Date
    Feb 2006
    Location
    Cologne - Germany
    Posts
    271
    One compromise solution I'm thinking of is to use the mySQL LIMIT command to only show the first 20 results then a button to show the next 20 and the next and so on. This is not as nice as a scrollbar but I may end up doing this
    when you do so, don't forget to order your data, or your select statements will return your data in different order on each invokation.
    i suggest to use the autogenerated primary key to dort ascending (if you have).

  6. #6
    Join Date
    Jan 2006
    Location
    Ireland
    Posts
    35
    Yes, good point graviton

    Thanks

Similar Threads

  1. Free ASP.NET Web Matrix Design/Editor Tool Released
    By ASPSmith Training in forum dotnet.announcements
    Replies: 0
    Last Post: 06-18-2002, 03:39 AM
  2. open url from hyperlink - inside web form
    By Phil Weber in forum .NET
    Replies: 3
    Last Post: 06-14-2002, 10:05 AM
  3. Re: Do consumers even want web services?
    By Robert Lantry in forum .NET
    Replies: 278
    Last Post: 03-27-2002, 01:00 PM
  4. Replies: 0
    Last Post: 04-19-2001, 07:54 AM
  5. Replies: 3
    Last Post: 04-14-2001, 04:18 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center