Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: domain of larry.meadors@gmail.com
 designates 64.233.184.224 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth;
        b=Vs71O+S3Cb22VTgyEHvVbIyHT/qrf4kkEvF2V5CBuZdk0rVOzsOJDsHW5tTJNsIZZqrkC+EHGpWS8PAEMHkdWI9/ndpULXZptuAc5PBaq1i/kvzsJAvpj+7BwCTZLIVsvCfVDF6PbO+68TiXrFUB/bK9j7K4Qxd2yQPOvmcyZLs=
Message-ID: <a10a823c0610111039q3dc1d9a5k8108c9dbd7dab389@mail.gmail.com>
Date: Wed, 11 Oct 2006 11:39:17 -0600
From: "Larry Meadors" <lmeadors@apache.org>
Reply-To: lmeadors@apache.org
Sender: larry.meadors@gmail.com
To: user-java@ibatis.apache.org
Subject: Re: Date format conversion to/from db
In-Reply-To: <E36BA0782071F1418A8508DB75F7921B8D508C@xmbcaf01.northgrum.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <a10a823c0610111025x582f1b43h9ba8a0e4c8f7b60c@mail.gmail.com>
	 <E36BA0782071F1418A8508DB75F7921B8D508C@xmbcaf01.northgrum.com>

Hmm, it's been years since I used the display: tags, but I think you
could use a decorator for that case - look in the docs for the
display: tags for examples.

Larry

On 10/11/06, Ou, Stan (Mission Systems) <STAN.OU@ngc.com> wrote:
> Thanks for your quick reply, Larry.
>
> In the jsp, we also use displaytag to display if it's a listing, so not
> sure if the <fmt:> tag could fit in, but will give it a try.  The
> displaytag syntax is as follow:
>
> <display:table id="aList" name="aList" pagesize="25"
> requestURI="/shr.gcss">
>         <display:column property="someDate" title="Some Date" />
>
>
> -----Original Message-----
> From: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com] On Behalf
> Of Larry Meadors
> Sent: Wednesday, October 11, 2006 10:25 AM
> To: user-java@ibatis.apache.org
> Subject: Re: Date format conversion to/from db
>
> Make your beans use java.util.Date.
>
> Use <fmt:*> jsp tags for output.
>
> In your forms, pick a date format, then on the backend, do the
> conversion from string to date - spring does most of that for you, IIRC.
>
> Larry
>
>
> On 10/11/06, Ou, Stan (Mission Systems) <STAN.OU@ngc.com> wrote:
> >
> >
> >
> > Hi all,
> >
> > I've an application that integrates Spring and iBatis with an Oracle
> > backend.  We were using Oracle's bc4j before we made the switch.
> > Since our dates are persisted to the db in a different format from
> > what we display on the jsp, what would be the best approach to do the
> > conversion?  The most straightforward way I think is use a util class
> > to do the conversion in the getter/setter of the pojo but I'll have to
>
> > make the pojo's setter smart enough to know whether I'm reading from
> > the db or being bound to a form by Spring, something along this line:
> >
> > If reading from db for display on jsp
> >   convert from db to gui format
> >
> > If being bound to Spring form and then persisted to db
> >   convert from gui to db format
> >
> > The same goes for the getter.
> >
> > Our pojos are auto generated, so any logic added will get wiped out if
>
> > someone regenerates the pojo.
> > Can anyone shed some lights on this?  Any suggestions are welcomed.
> Thanks.
> >
> > Stan
>