• Mybatis传递多个参数


    ibatis3如何传递多个参数有两个方法:一种是使用java.Map,另一种是使用JavaBean。

    通过Map传递多个参数 

    parameterType 可以是别名或完全限定名,map或者java.util.Map,这两个都是可以的
            
    <select id="selectBlogByMap" parameterType="map" resultType="Blog">             
     select  t.ID, t.title, t.content               
     FROM blog t              
     where t.title = #{h_title}                
     and  t.content =#{h_content}         
    </select>        

      
    public void testSelectByMap() {             
         SqlSession session = sqlSessionFactory.openSession();             
         Map<String, Object> param=new HashMap<String, Object>();             
         param.put("h_title", "oracle");             
         param.put("h_content", "使用序列");             
         Blog blog = (Blog)session.selectOne("cn.enjoylife.BlogMapper.selectBlogByMap",param);            
         session.close();             
         System.out.println("blog title:"+blog.getTitle());         
    }        


    通过JavaBean传递多个参数
         
    <select id="selectBlogByBean" parameterType="Blog" resultType="Blog">
     select t.ID, t.title, t.content
     from blog t
     wheret.title = #{title}
     and t.content =#{content}         
    </select>

       
    public void testSelectByBean() {             
         SqlSession session = sqlSessionFactory.openSession();             
         Blog blog=new Blog();             
         blog.setTitle("oracle");              
         blog.setContent("使用序列!");             
         Blog newBlog = (Blog)session.selectOne("cn.enjoylife.BlogMapper.selectBlogByBean",blog);            
         session.close();             
         System.out.println("new Blog ID:"+newBlog.getId());         
    }

    原帖地址:http://kb.cnblogs.com/a/2291110/

  • 相关阅读:
    329. Longest Increasing Path in a Matrix
    2、evaluate-reverse-polish-notation
    1、minimum-depth-of-binary-tree
    2、替换空格
    C风格字符串和C++string对象的相互转化
    1、二维数组中的查找
    8、sort排序中比较函数的几种应用方式
    1131(★、※)Subway Map
    7、(★、※)判断一个序列是否是二叉查找树的后序、前序遍历序列
    041219~051219流水账
  • 原文地址:https://www.cnblogs.com/handsome1013/p/4994600.html
Copyright © 2020-2023  润新知