MyBatis3傳遞多個(gè)參數(shù)(Multiple Parameters)

更新時(shí)間：2020年07月10日 11:53:45 作者：EasonJim

這篇文章主要介紹了MyBatis3傳遞多個(gè)參數(shù)，文中通過示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來一起學(xué)習(xí)學(xué)習(xí)吧

傳遞多個(gè)參數(shù)一般用在查詢上，比如多個(gè)條件組成的查詢，有以下方式去實(shí)現(xiàn)：

版本信息：

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、直接傳遞對(duì)象

  <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標(biāo)注

  <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);

說明：這種方法同樣可以用在一個(gè)參數(shù)的時(shí)候。

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節(jié)點(diǎn)：

  <select id="dynamicForeach3Test" 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> dynamicForeach3Test(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.dynamicForeach3Test(map);

5、List結(jié)合foreach節(jié)點(diǎn)一起使用

  <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、數(shù)組結(jié)合foreach節(jié)點(diǎn)一起使用

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

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

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

參考：

http://www.yihaomen.com/article/java/426.htm

到此這篇關(guān)于MyBatis3傳遞多個(gè)參數(shù)(Multiple Parameters)的文章就介紹到這了,更多相關(guān)MyBatis3傳遞多個(gè)參數(shù)內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！

您可能感興趣的文章: