[IBATIS-669] Support for two and more parameters for query input

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 3.0 Beta 3
• Component/s: Core
• Assignee: Clinton Begin
• Reporter: Tomáš Procházka
• Created: 06/Oct/09 05:51
• Updated: 13/Oct/09 04:44
• Resolved: 12/Oct/09 19:15

Description

Ibatis now support only one parametrs for query input. Use special class or map for input multiple parametrs is annoying.

It's not possible write this:

SendMapper sm = session.getMapper(SendMapper.class);
List<Send> ls = sm.getAllItems(10, 2);

and in SendMapper:

@Select({"SELECT * FROM send LIMIT #

{1}

, #

{2}

"})
List getAllItems(int offset, int limit);

OR

@Select({"SELECT * FROM send LIMIT #

{offset}, #{limit}"})
List getAllItems(@Param("offset") int offset, @Param("limit") int limit);

OR use XML mapper:

<select id="getAllItems" parameters="offset:int,limit:int">
SELECT * FROM send LIMIT #{offset}

, #

{limit}
<select>

or more java like syntax:
<select id="getAllItems" parameters="int offset, int limit">
SELECT * FROM send LIMIT #{offset}, #{limit}

<select>