Vasudev:
If you want to do this kind of thing with servlets, it's handled well by
Expresso, an open-source servlet framework. You can reverse-engineer an
existing DB, create database objects & have all the capabilties you describe
below in a few minutes (once you're installed & set up of course). Avail for
download at http://www.javacorporate.com
Mike
Javacorporate Ltd
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's
> Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
> RVASUDEV
> Sent: Friday, October 29, 1999 10:30 AM
> To: [EMAIL PROTECTED]
> Subject: Partly OT: Q on Java GUI/DB app design
>
>
> Hi Java servlet experts,
>
> I initially posted this on a general Java
> mailing list, but posting it here as well,
> since I'd like to know how the functionality
> below can be implemented with servlets as well,
> either servlet-to-HTML or servlet-to-applet.
>
> Original Q :
> ------------
>
> I have some questions about the GUI design of
> a small database maintenance application in Java
> that I want to develop.
>
> Description of the app :
>
> It is an app to maintain a single table of a
> database. Similar to the kind of app that can
> be automatically generated by most GUI/RAD
> Windows tools, such as PB/VB/Delphi. Features :
>
> - be a Java application (possibly with ability to
> convert to an applet/servlet later)
> - GUI (AWT, not Swing - it's too slow)
> - SDI (initially, maybe MDI later)
> - will use JDBC
> - menus, with menu options for the functions below
> - functions (only for a single table initially) :
> - login screen for database user/password
> - add a record
> - delete a record
> - edit/update a record
> - view a record
> - search for records matching a condition :
> - by primary key
> - by column value(s) (only all AND or all OR
> initially,
> i.e. if user enters col1 = val1, col2 = val2
> and checks an AND radio button, the SQL where
> condition should be "col1 = val1 AND
> col2 = val2,
> while if user checks OR button, OR
> should be used
> in the SQL condition)
> Once the search returns, the matching records should be
> displayed, and if the user clicks on one, the edit/update
> screen should be shown. When the user saves/cancels the
> edit, the list of records should be shown again.
>
> Please suggest which GUI components would be suitable for this.
>
> My initial stab at it suggests :
>
> - Frame with Menus
> - login option to be a menu option rather than the initial
> screen, to allow the user to
> connect/disconnect without
> having to reload the app each time
> - clicking each menu option like add/mod should
> change the lower
> part of the Frame contents to show the appropriate controls
> for that option, e.g. if Add/Mod, should have Save/Cancel
> buttons, while if View field, should only have Close button
> - TextFields for the table columns, except a TextArea for
> one memo-type column which is large - varchar(32000).
> - Buttons for the actions like Save/Cancel/Close
> - Choice for the AND/OR value
> - a List for the matching records
>
> Particularly interested in using the most suitable components
> and the logic to communicate between them, e.g. should a different
> Frame be popped up for each menu option, or should I just change
> the panel in the frame that contains the table columns ?
> If separate Frames, how to communicate between them, e.g. when
> the user finishes an edit of a selected record, how to redisplay
> the List ? Etc.
>
> Appreciate any answers.
>
> Vasudev
>
> ______________________________________________________________
> _____________
> To unsubscribe, send email to [EMAIL PROTECTED] and
> include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources:
> http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
