File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Struts and the fly likes Generic database table maintenance application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Generic database table maintenance application" Watch "Generic database table maintenance application" New topic

Generic database table maintenance application

Rai Singh

Joined: Apr 11, 2003
Posts: 5
Hello, this problem has been puzzling me.
I have developed a JSP application using a MVC(model 2) type framework (not Struts). The problem to solve was to build an application which would allow easy relational database table maintenance on simple tables without requiring a new Java Bean (page bean) to be generated for each table.
Another part of the requirement was to allow this be dynamic at the presentation layer. In other words, if I add or drop a column from a table, the HTML should be rendered to reflect this change.
Both a multiple row page view and a single row page view gets generated by some input source XML. The single row page XML is transformed for each column on the table being edited (this way an option list amongst a bunch of input boxes can get rendered).
My one big question is are there tools like this already in use or can Struts support this type of design?
I don't like to reinvent the wheel, but I guess at the time I didn't have the luxury to research more on this.
I agree. Here's the link:
subject: Generic database table maintenance application
It's not a secret anymore!