这篇文章主要介绍MyBatis3传递多个参数的案例，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！

传递多个参数一般用在查询上，比如多个条件组成的查询，有以下方式去实现：

版本信息：

MyBatis：3.4.4

1、自带方法

<select id="getUserArticlesByLimit" resultMap="resultUserArticleList"> select user.id,user.userName,user.userAddress,article.id as aid,article.title,article.content from user,article where user.id=article.userid and user.id=#{arg0} limit #{arg1},#{arg2} </select>

public List<Article> getUserArticlesByLimit(int id,int start,int limit);List<Article> articles=userMapper.getUserArticlesByLimit(1,0,2);

说明，arg0...也可以写成param0...

2、直接传递对象

<select id="dynamicIfTest" parameterType="Article" resultType="Article"> select * from article where 1 = 1 <if test="title != null"> and title = #{title} </if> <if test="content != null"> and content = #{content} </if> limit 1 </select>

public Article dynamicIfTest(Article article); Article inArticle = new Article(); inArticle.setTitle("test_title"); Article outArticle = userOperation.dynamicIfTest(inArticle);

3、使用@Praam标注

<select id="dynamicChooseTest" resultType="Article"> select * from article where 1 = 1 <choose> <when test="title != null"> and title = #{title} </when> <when test="content != null"> and content = #{content} </when> <otherwise> and tile = "test_title" </otherwise> </choose> </select>

public Article dynamicChooseTest( @Param("title") String title, @Param("content") String content);Article outArticle2 = userOperation.dynamicChooseTest("test_title",null);

说明：这种方法同样可以用在一个参数的时候。

4、使用HashMap

<select id="getArticleBeanList" resultType="ArticleBean">　　select * from article where id = #{id} and name = #[code] </select>

说明：parameterType="hashmap"可以不用写。

public List<ArticleBean> getArticleBeanList(HashMap map);

HashMap<String, Object> map = new HashMap<String, Object>(); map.put("id", 1); map.put("code", "123"); List<Article> articless3 = userOperation.getArticleBeanList(map);

特殊的HashMap示例，用在foreach节点：

<select id="dynamicForeach4Test" resultType="Article"> select * from article where title like "%"#{title}"%" and id in <foreach collection="ids" index="index" item="item" open="(" separator="," close=")"> #{item} </foreach> </select>

public List<Article> dynamicForeach4Test(Map<String, Object> params);

HashMap<String, Object> map = new HashMap<String, Object>(); map.put("title", "title"); map.put("ids", new int[]{1,3,6}); List<Article> articless3 = userOperation.dynamicForeach4Test(map);

5、List结合foreach节点一起使用

<select id="dynamicForeachTest" resultType="Article"> select * from article where id in <foreach collection="list" index="index" item="item" open="(" separator="," close=")"> #{item} </foreach> </select>

public List<Article> dynamicForeachTest(List<Integer> ids);

List<Integer> ids = new ArrayList<Integer>(); ids.add(1); ids.add(3); ids.add(6); List<Article> articless = userOperation.dynamicForeachTest(ids);

6、数组结合foreach节点一起使用

<select id="dynamicForeach3Test" resultType="Article"> select * from article where id in <foreach collection="array" index="index" item="item" open="(" separator="," close=")"> #{item} </foreach> </select>

public List<Article> dynamicForeach3Test(int[] ids);

int[] ids2 = {1,3,6}; List<Article> articless2 = userOperation.dynamicForeach3Test(ids2);

以上是MyBatis3传递多个参数的案例的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注亿速云行业资讯频道！