ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: is this possible?
Date Tue, 31 May 2005 03:13:21 GMT
Yes, it should work, as long as you get the SQL template around all
the iterations correct.

Larry


On 5/29/05, Rob Butler <crodster2k@yahoo.com> wrote:
> Not yet.  It seemed a little "out there" that it would
> work.  So I thought I would ask.  Someone who really
> knows the internals of iBatis would be able to say
> yes/no right off.
> 
> Rob
> 
> --- Larry Meadors <larry.meadors@gmail.com> wrote:
> > Did you try it?
> >
> > On 5/29/05, Rob Butler <crodster2k@yahoo.com> wrote:
> > > I want to create a statement that performs inserts
> > (or
> > > updates, or creates tables) that can have the
> > table
> > > name as well as the number and type of the columns
> > > determined at run time.
> > >
> > > Assume a Map has two entries, tableName and
> > records.
> > > Records is a List of record objects.  Record
> > objects
> > > have 3 values, fieldName, value and type.
> > fieldName
> > > is the name of the column, and type is the JDBC
> > type
> > > of the column.  Value is always either a Date,
> > Integer
> > > (object, not primative), Long (object, not
> > primative)
> > > or String.
> > >
> > > So assuming everything above, would the sqlMap
> > segment
> > > below work?
> > >
> > > <insert id="insertRecord"
> > > parameterClass="java.util.Map">
> > >    insert into $tableName$
> > >      <iterate open="(" close=")" conjunction=", ">
> > >        $records[].fieldName$
> > >      </iterate>
> > >    values
> > >      <iterate open="(" close=")" conjunction=", ">
> > >        #records[].value#:$records[].type$
> > >      </iterate>
> > > </insert>
> > >
> > > Thanks!
> > > Rob
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam?  Yahoo! Mail has the best spam
> > protection around
> > > http://mail.yahoo.com
> > >
> >
> 
> 
> 
> __________________________________
> Do you Yahoo!?
> Yahoo! Small Business - Try our new Resources site
> http://smallbusiness.yahoo.com/resources/
>

Mime
View raw message