Mybatis传递多个参数

    xiaoxiao2021-03-25  116

    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/

    转载请注明原文地址: https://ju.6miu.com/read-18336.html

    最新回复(0)