question about parameterMap and java class

[Ashish Kulkarni <as...@gmail.com>]

Hi
I have a class like below with get and set method
public ColorClass
{
private String name, desc;

public void setName(String _name)
{
this.name = _name;
}
public String getName()
{
return name;
}

}

How can i define this ColorClass in parameterMap and use it in SQL statement
for varaible substituation.
<parameterMap mymap" class="java.util.Map">
     <parameter property="id" javaType="java.util.List" />
</parameterMap>
where id is list of ColorClass,

I have a SQL statement as below

select name, id from mytable

<dynamic prepend="where">
<iterate prepend="AND" property="id" open="("
close=")" conjunction="OR">
C064ID=#id[]#
</iterate>
</dynamic>

I want to use getName method to get name of the colorclass,

Re: question about parameterMap and java class

[Stephen Boyd <sw...@gmail.com>]

Have you tried

<dynamic prepend="where">
<iterate prepend="AND" property="id" open="("
close=")" conjunction="OR">
C064ID=#id[].*name*#
</iterate>
</dynamic>

On Jan 3, 2008 1:46 PM, Ashish Kulkarni <as...@gmail.com> wrote:

> Hi
> I have a class like below with get and set method
> public ColorClass
> {
> private String name, desc;
>
> public void setName(String _name)
> {
> this.name = _name;
> }
> public String getName()
> {
> return name;
> }
>
> }
>
> How can i define this ColorClass in parameterMap and use it in SQL
> statement for varaible substituation.
> <parameterMap mymap" class="java.util.Map">
>      <parameter property="id" javaType=" java.util.List" />
> </parameterMap>
> where id is list of ColorClass,
>
> I have a SQL statement as below
>
> select name, id from mytable
>
> <dynamic prepend="where">
> <iterate prepend="AND" property="id" open="("
> close=")" conjunction="OR">
> C064ID=#id[]#
> </iterate>
> </dynamic>
>
> I want to use getName method to get name of the colorclass,
>
>