Win a copy of Practical SVG this week in the HTML/CSS/JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Help for a Good Design program

 
Sherif Shehab
Ranch Hand
Posts: 487
Android Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi pals ,

I need to read some data from Db in jsp with an option to export this data to Excel sheet file with a specific design , So anyone can help me with a good Design for this project & what suggested technologies will be used in this project, because this is the first time for me to do web project from scratch
 
Muhammad Saifuddin
Ranch Hand
Posts: 1325
Android Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jsp and Servlet is only the right choice for you in the beginning.. I said "only" because these technologies always works/use behind in J2EE world.

for more about work with excel you can consider FAQs entries, or search into the FAQs. try keyword "Excel".

hope it helps.
 
Sherif Shehab
Ranch Hand
Posts: 487
Android Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks , it's very useful link i found many tools, but what about the project design? do you got any ideas for it?
 
Kai Witte
Ranch Hand
Posts: 356
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Sherif,

isn't that exactly your area of expertise? :-)

I recommend to get familiar with the general concept for Java EE architectures. The best brief description is in the EE spec, chapter 2.

You may or may not use EJB for this. Either way is acceptable.

Usually it makes sense to use an ORM framework, in that case I recommend JPA. Not sure if that applies in your specific situation. When you use EJB, use a session EJB as facade for the data access. Otherwise use a web facade.

Try to couple components loosely. The part that creates the Excel data does not have to depend on Servlets or EJB at all.

Usually a web framework like JSF + Seam makes sense. But if the UI doesn't have to be fancy you can use plain Servlets & JSP and focus on the generall architecture and design instead. That might be better for the learning effect.

Of course no scriptlets, scripting declarations or scripting expressions. Controller logic in the Servlet (if no web framework is used), JSP only for presentation, business logic on dedicated classes have no dependency on the web tier (CAN partially be EJB).

Kai
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!