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: ibatis3 : multiple parameters in statement without map or bean
Date Mon, 17 May 2010 11:02:21 GMT
Yes, you have to annotate the parameters (because java reflection is
kinda weak).

It's in the user guide.

Larry


On Mon, May 17, 2010 at 4:15 AM, Nicolas ANTONIAZZI
<nicolas.antoniazzi@gmail.com> wrote:
> Hi,
> Is it possible to pass multiple parameters in iBatis3 without having to pass
> a map or a bean ?
> example :
> ------------- UserMapper.xml ------------
> <select id="selectUsers" parameterType="hashmap" resultType="List<User>">
>   SELECT * FROM user OFFSET #{offset} LIMIT #{limit}
> </select>
> ------------- UserMapper.java -----------
> public interface UserMapper {
>   public List<User> selectUsers(HashMap<String, Integer> parameters);
> }
> -----------------------------------------
> Now, I can call my statement with :
>
> int offset = 10;
> int limit = 10;
> UserMapper userMapper = session.getMapper(UserMapper.class);
> HashMap<String, Integer> parameters = new HashMap<String, Integer>();
> parameters.put("offset", offset);
> parameters.put("limit", limit);
> List<Question> selections = questionMapper.selectQuestions(parameters);
> ------------------------------------------
> I think that a cleaner way would be to do somethink like :
> public interface UserMapper {
>   public List<User> selectUsers(int offset, int limit);
> }
> UserMapper userMapper = session.getMapper(UserMapper.class);
> List<Question> selections = questionMapper.selectQuestions(10, 10);
> -------------------------------------------
> Is there such a method to achieve it with iBatis 3 ?
> Thanks,
> Nicolas ANTONIAZZI.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message