I'm writing something similar that starts from XML table definitions -
creating SQL table definitions, beans, table list/edit/view JSP pages and
servlets. I realized I was writing a lot of repetitive code whenever I
added a new database table, so instead of cranking away on SQL/JSP/Java
files to handle database tables for a new web site I'm working on, I've
spent the time writing SQL/JSP/Java generators to handle the repetitive
work. The resulting code takes care of a lot of the admin work, and
provides a good basis for the user's view of the site too.
My intent is to design a toolbox I can use to bring up the basis of a new
web site quickly - using the conventions I'm accustomed to. I expect to
continue working on it for a while, though it's functional now.
I also am interested in finding out if there are other similar projects out
there, I haven't heard of any.
David
[EMAIL PROTECTED]
> -----Original Message-----
> From: A mailing list about Java Server Pages specification and reference
> [mailto:[EMAIL PROTECTED]]On Behalf Of Keith Kwiatek
> Sent: Wednesday, July 18, 2001 4:54 PM
> To: [EMAIL PROTECTED]
> 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
