File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Servlets and the fly likes Designing Webapp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "Designing Webapp" Watch "Designing Webapp" New topic
Author

Designing Webapp

Servin Park
Greenhorn

Joined: May 10, 2002
Posts: 26
Hello all,
I bought a package from a Web Hosting Company and am building a webapp that can serve as a community news site. what I would like to accomplish is this:
1. Editors can add, modify their columns any time they want.
2. Readers can read the most up-to-date information all the time.
I thought about two solutions:
1. Each time an editor add a column (essay, news, information, events, etc.), write a html file in a designated folder. When a user accesses particular page, just include the html in the jsp. I just need to figure out a way to sort all the html out so that they get included correctly.
2. Save all the columns in database. When a user accesses particular page, get the content from a table in the database.
The first solution will work fine for me, but I don't like too much File I/O happening in the server. The second solution will work fine also, but concerned about database usage. It appears to me that every user click will require database connection, query, etc...
What do you think? If you have better solution or comment about any of my solutions, please drop me a note.
Many thanks in advance for your help.
chanoch wiggers
Author
Ranch Hand

Joined: May 24, 2001
Posts: 245
it largely depends on how much time yuo are willing to spend and how much value there is in this. From the possible solution you offer, you would benefit greatly from the experience that this type of development work would offer and I think you would be happy with the result. I've implemented similar solutions for very low cost web sites
a connection or two per hit is not actually a problem so dont worry about that side of things. File IO can be more problematic but you havent really indicated how many users this involves and how often the content would change.
a third option might be to hold the data in the database but to generate static html pages from the resultant content which i have seen used to great effect to manage the content while limiting the load on the server


chanoch<p><a href="http://www.amazon.com/exec/obidos/ASIN/1861007736/" target="_blank" rel="nofollow">Author of Professional Apache Tomcat</a></p>
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Designing Webapp