JDBC Update Questions

["Mike Silvers" <msilvers@xxxxxxxxxxx>]

All,

I am creating wrapper classes for my database files.  I have created a
utility that creates the wrappers.  I have a question about the UPDATE
statement.  In my wrapper class, a result set is retrieved and the user can
scroll through the resultset by calling methods.  I am using prepared
statements for the JDBC statements.  I am trying to figure out how to use an
update statement and dynamically setting the correct values.  In other
words, the wrapper will have the data values of the record selected.  If the
user changes one or more values, how would I use the UPDATE statement to
update the record.  As I see it, the problem is that the user can change one
or more values, and the UPDATE needs to SET the new values depending on what
was changed.  Any ideas or suggestions?

Thanks

Mike


================================
Mike Silvers
AS/400 Senior Programmer/Analyst
AS/400 IBM Certified RPG IV Developer
AS/400 IBM Certified Solutions Expert
Hainey Business Systems
8 E. Canal St
Dover, PA 17315
Branch Office:  (410) 397-8739
Phone:  (800) 932-3380 ext. 237
Fax:  (717) 292-9474
Web: http://www.hbs-inc.com
________________________________
Providing E-Commerce, EDI, AS/400
Development, Java Development,
and related services nationwide.
================================