Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

database results in a pane

 
Murasoli Maran
Ranch Hand
Posts: 193
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
in my present app,i have to display database search results to a java pane.
the results needs to have in different colour codings for different results.for eg if a person searches in a Products(for eg) table, the results should be shown in a pane and if the product costs more than 500$ the result should be shown in red color(like that).
which swing pane is ideal for this?..
how can i restrict 10 results in a page and by clicking next page link the user should able to view results from 10 to 20 ..just as seen in web pages.but how can it be implemented in a java standalone program using swing pane to display the database search results?
anyone please help
 
Chris Brat
Ranch Hand
Posts: 108
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sounds like a JTable work for you:
- can set background and foreground colours
- can define number of rows and columns easily
- can also restrict particular rows, columns, cells to be read only
also not too difficult to implement once you get the hang of it
 
Jason Steele
Ranch Hand
Posts: 100
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Chris is right.
JTable would be your best bet. As for limiting the rows returned, well, you could do that the same way that it's done on the web. Use a LIMIT condition on your SQL SELECT statement and track your current position. However, if you are going to limit the size of a JTable's contents, do it by about 50,000 rows! The reason that a lot of pages(like shopping carts) have the previous/next system is not because there is too much data, but because of the nature of the web. Not only do the static page contents have to be rendered and displayed, but also other scripts and calls to sql servers. Add to that images and Flash, whatever, time is of the essence if you want your visitors to come back.
An application is much faster and unless you have a couple hundred thousand + rows to return, why not return them all?
Uh...I'm just sayin!
 
Murasoli Maran
Ranch Hand
Posts: 193
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks and regards,good help.i use JTable but page selection like (previous,1,2,3,4...last,next) will be a better utility in JTable class.sun may notice?
thanks again
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic