• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

generate JSP from database

 
Nuevo Juan
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We look for tool to generate JSP from database schema.

Struts is good too.

tx
J.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34973
378
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Nuevo,
Welcome to JavaRanch!

What do you want the JSP to display? The full database table or something else?
 
Pj Murray
Ranch Hand
Posts: 194
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If I understand the task correctly, you want to be able to access data stored in a database via a Web client.

You've worked out that it probably means JSPs or JSP/Struts.

Both are excellent choices for thin Web clients, especially if the application is simply to access/update information stored in a database.

I'd image there's lots of business applications that require that and not much else.

I'd like to recommend the following:

-you'll be better off with a three tier rather than two tier application. I think you should have a data access tier based on Data Access Objects as your middle tier. DAOs are a core J2EE design pattern so you won't be doing anything unusual or unsustainable for long term maintenance even if another developer takes over later

-either Struts or plain JSPs are fine really. So go with your whatever skill level you can handle.

-you could try generating the entire application using a tool such as FireStorm/DAO. It can import you existing database schema and generate both a persistence tier (based on JDBC DAOs, EJB CMP, JDO, or Hibernate - I suggest using JDBC DAOs in this case) and can also generate your presentation tier (either Struts or plain JSPs - I suggest using plain JSPs in this case).

A simple application like this should really have a simple architecture. You should be able to download a tool like FireStorm/DAO and generate a working application in less than 30 minutes.

Some useful links:

DAOs

http://www.java.sun.com/blueprints/corej2eepatterns/Patterns/DataAccessObject.html

http://www.codefutures.com/java-dao/

FireStorm/DAO (generates both the DAOs AND JSPs)

http://www.codefutures.com/products/firestorm/


I hope this helps. Remember: keep it simple!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic