This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Struts and the fly likes Struts 1 - How to display data from different databases on one click? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Struts 1 - How to display data from different databases on one click?" Watch "Struts 1 - How to display data from different databases on one click?" New topic
Author

Struts 1 - How to display data from different databases on one click?

Teresa Lee
Greenhorn

Joined: Feb 01, 2008
Posts: 24
I am writing a search engine and on the result page, if something is found (an employee is found by the given ssn), I need to display all other critical information about this employee and all these infomation is stored in different oracle databases(like 20 tables involved). As we all know, database accesses are very expensive and my users need the critical info to be displayed fast (real rast). My first question is: Is there a way to get these info fast (I was confirmed that we cannot put the info into one table or one database)? My second question is: How to display them so the user can view all the info together like in one page? I have suggested that using tabs on the page and one tab for one set of info from one database so when the user click tab A, the link leads to Action A and then when user click tab B, goes to Action B and they just want to view all info in one click maximum and real quick. Please give me some ideas. Thanks.
Alaa Nassef
Ranch Hand

Joined: Jan 28, 2008
Posts: 460
Hello Teresa,

You can get the info you want from several tables using a database view or a more complex SQL statement joining the tables you want together. This really doesn't have a lot to do with struts.

As for the tabs option, I believe this is a great option, but I suggest that you get all the data one time, and separate them in the different tabs, so that you won'd make a lot of hits on the database.


Visit my blog: http://jnassef.blogspot.com/
Teresa Lee
Greenhorn

Joined: Feb 01, 2008
Posts: 24
Thank you Alaa for the reply. Besides using tab, if you have any other data representation solutions, please share with me. Your help is greatly appreciated.

Kira
Alaa Nassef
Ranch Hand

Joined: Jan 28, 2008
Posts: 460
Hello Again Teresa,

If the search returns more than one result, you can represent them in a table (I prefer using displaytag) where each row has the most important data needed, and each row has a link to a page that displays the full data you want (may be separated into tabs of course).
Teresa Lee
Greenhorn

Joined: Feb 01, 2008
Posts: 24
Alaa,

Thank you very much for sharing this with me.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Struts 1 - How to display data from different databases on one click?
 
Similar Threads
postback model and AJAX
JSP Tabs - struts 1.2.9
how to call a jsp function with in a hyperlink
Struts 2 with JQuery tab
Collection of bean input from form-problem