hi all,
I have developed something similar
generic beans for search/update/insert/delete
but instead of using the metadata I have used an auxiliary table to
allow to personalize the screens, fields that appear in each one ...
this table also obtains the data of the metadata
this table also maintenances with these beans ;-)
with Oracle JDeveloper, you have wizard for JSP's
for any table you can generate query, browse,edit & insert page JSP
the problem is, if you change any field of table, you may regenerate all
and you lost any manual modify on pages
Another solution is Oracle Designer , with Web PL/SQL Generator
but only works with Oracle Application Server :-(
best regards
[EMAIL PROTECTED]
----- Original Message -----
From: "Keith Kwiatek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 19, 2001 12:54 AM
Subject: Utility to auto-generate JDBC Beans and JSP for
insert/update/delete/search.
> Hello,
>
> In my pursuit of mastering JSP/JDBC/Java I wrote a utility that
interrogates
> an oracle database table and then generates the correlated JSP forms and
> JDBC beans to search/update/insert/delete rows from the database table.
By
> pointing the utility at a few related tables you can quickly string
together
> a nice application...
>
> I use the meta data from the database to write form field validation
methods
> (null/required, max size, alpha/numeric checking, date, etc)..... So if
your
> submit an update/insert with invalid field data, it redisplays the form
data
> with the field tag highlighted in red. Handles select and checkbox
> statements also.
>
> Sure seems to save me a bunch of typing when creating applications. The
> closest thing I have found is Macromedia dreamweaver ultraDev, BUT it only
> allows you to drop a JDBC bean (that you have written) onto a JSP page so
> you can manually connect the db fields to HTML widgets .
>
> I also found something that Generates a jdbc bean, BUT not the JSP:
> http://space.tin.it/computer/csadun/software/cmaker/cmaker.html
>
>
> Is there anything else like this out there?
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
