Doing JDBC code in a less unwieldy way?

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From	Steve <tinker123@gmail.com>
Newsgroups	comp.lang.java.help
Subject	Doing JDBC code in a less unwieldy way?
Date	Thu, 18 Aug 2011 11:26:34 -0400
Organization	M.Y.O.B.
Lines	18
Message-ID	<j2javb$4pq$1@dont-email.me> (permalink)
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding	7bit
Injection-Date	Thu, 18 Aug 2011 15:26:35 +0000 (UTC)
Injection-Info	mx04.eternal-september.org; posting-host="UABc+C86KOYqLGYF2e/KhQ"; logging-data="4922"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/BA+Pu8Rfpl5QU17mzorHs7A4z1TdMbbY="
User-Agent	Mozilla/5.0 (Windows NT 5.1; rv:5.0) Gecko/20110624 Thunderbird/5.0
Cancel-Lock	sha1:yXFwxzdRskHRjPT5vvJvB9v/X6o=
Xref	x330-a1.tempe.blueboxinc.net comp.lang.java.help:950

Show key headers only | View raw

I'm renovating an old servlet application.   It has some complex and 
poorly thought out database functions for inserting and updating a 
number of tables.

Some of the operations are simple, but made voluminous by setting 
values, field by field, for prepared statements and retrieving those 
values, from a holder object.

I can trim and detangle some of this mess by putting the field name in a 
collection then doing some of the operations in a loop.

The place where I work isn't ready to go to a framework and something 
like a hibernate yet.

Is there a design pattern for voluminous update and insert statements or 
articles about how to handle these things in a less unwieldy way.

Steve

Back to comp.lang.java.help | Previous | Next — Next in thread | Find similar

Thread

Doing JDBC code in a less unwieldy way? Steve <tinker123@gmail.com> - 2011-08-18 11:26 -0400
  Re: Doing JDBC code in a less unwieldy way? markspace <-@.> - 2011-08-18 08:57 -0700
    Re: Doing JDBC code in a less unwieldy way? Lew <lewbloch@gmail.com> - 2011-08-18 11:26 -0700
  Re: Doing JDBC code in a less unwieldy way? Roedy Green <see_website@mindprod.com.invalid> - 2011-08-19 02:00 -0700
    Re: Doing JDBC code in a less unwieldy way? Arved Sandstrom <asandstrom3minus1@eastlink.ca> - 2011-08-19 08:59 -0300
      Re: Doing JDBC code in a less unwieldy way? Lew <lewbloch@gmail.com> - 2011-08-19 07:57 -0700
      Re: Doing JDBC code in a less unwieldy way? Steve <tinker123@gmail.com> - 2011-08-19 19:50 -0400
        Re: Doing JDBC code in a less unwieldy way? Arved Sandstrom <asandstrom3minus1@eastlink.ca> - 2011-08-19 21:26 -0300
          Re: Doing JDBC code in a less unwieldy way? Lew <lewbloch@gmail.com> - 2011-08-19 20:20 -0700
      Re: Doing JDBC code in a less unwieldy way? Roedy Green <see_website@mindprod.com.invalid> - 2011-08-20 17:19 -0700
        Re: Doing JDBC code in a less unwieldy way? Lew <lewbloch@gmail.com> - 2011-08-20 18:53 -0700
        Re: Doing JDBC code in a less unwieldy way? Arved Sandstrom <asandstrom3minus1@eastlink.ca> - 2011-08-21 10:32 -0300
  Re: Doing JDBC code in a less unwieldy way? Ricardo Palomares Martínez <rpm.PUBLI@iespana.es> - 2011-08-20 13:07 +0200
    Re: Doing JDBC code in a less unwieldy way? Arved Sandstrom <asandstrom3minus1@eastlink.ca> - 2011-08-20 10:59 -0300
      Re: Doing JDBC code in a less unwieldy way? Lew <lewbloch@gmail.com> - 2011-08-20 10:02 -0700
        Re: Doing JDBC code in a less unwieldy way? Ricardo Palomares Martínez <rpm.PUBLI@iespana.es> - 2011-08-21 16:03 +0200
      Re: Doing JDBC code in a less unwieldy way? Ricardo Palomares Martínez <rpm.PUBLI@iespana.es> - 2011-08-21 15:54 +0200
        Re: Doing JDBC code in a less unwieldy way? Arved Sandstrom <asandstrom3minus1@eastlink.ca> - 2011-08-22 18:56 -0300

csiph-web