You could even go so far as to say...
List names = new ArrayList();
names.add("moive one");
names.add("movie two");
Map params = new HashMap();
params.put("startDate", startDate);
params.put("endDate",endDate);
params.put("movieNames", names);
SELECT movie_name
FROM movies
WHERE
release_date between #startDate# AND #endDate#
<iterate property="movieNames" prepend="AND movie_name IN" open="("
close=")">
#movieNames[]#
</iterate>
You will have to refer to the correct syntax for the iterate tag. I just
threw that up there off the top of my head. Really you can accomplish just
about anything you need with a Map parameter.
Nathan
On 6/15/07, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:
Yes, you can do that or you can pass in a java.util.Map that contains
your values. This is probably the simpler.
java.util.Map map = new java.util.Hashmap();
map.put("value1", date1);
map.put("value2", date2);
------------------------------
*From:* vinays84 <[EMAIL PROTECTED]> [mailto:vinays84 <
[EMAIL PROTECTED]>]
*Sent:* Friday, June 15, 2007 12:12 PM
*To:* [email protected]
*Subject:* Re: New to iBatis
Just as only a single object can be passed in for the return class, can
only
a single object be passed in for a parameter class? Consider the query:
SELECT movie_name FROM movies WHERE release_date between #value1# AND
#value2#
Could I pass in two dates as parameters, or would I have to create a class
containing value1 and value2 as properties. (this class obviously would be
created solely for this one query).
--
View this message in context:
http://www.nabble.com/New-to-iBatis-tf3922862.html#a11145189
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
