mybatis调用oracle存储过程 返回sys_refcursor

[java] view plain copy

print ?

1. <code class="language-sql">Map<String, Object> map = new HashMap<String, Object>();  
2.         map.put("id", "0");  
3.         mapper.selectPosBy(map);  
4.         return (List) map.get("poss");</code>  

  
  

    
    

     
     

    
    
    
    

     
     

      
      Map<String, Object> map = new HashMap<String, Object>();
     
     
    
    

    
    

     
     

    
    
    
    

     
     

      
      		map.put("id", "0");
     
     
    
    

    
    

     
     

    
    
    
    

     
     

      
      		mapper.selectPosBy(map);
     
     
    
    

    
    

     
     

    
    
    
    

     
     

      
      		return (List) map.get("poss");
     
     
    
    
  
  

存储过程：

 
 

   
   

    
    

   
   
   
   

    
    
  
     
     create 
     
     or 
     
     replace 
     
     procedure getPosBy(
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
       V_USERID   
     
     IN  
     
     NUMBER,
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
       V_CURSOR   
     
     OUT SYS_REFCURSOR
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
     ) 
     
     is
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
     begin
    
    
   
   

   
   

    
    

   
   
   
   

    
    
   
     
     OPEN  V_CURSOR 
     
     FOR 
     
     SELECT * 
     
     from tb_pos_recode;
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
     end getPosBy;
    
    
   
   
 
 

Mapper.xml

 
 

   
   

    
    

   
   
   
   

    
    

     
     <update id="selectPosBy" statementType="CALLABLE" parameterType="map">       
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
               <![CDATA[ 
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
               call getPosBy(#{id,mode=IN,jdbcType=DECIMAL}, 
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
                              #{poss,mode=OUT,jdbcType=CURSOR,javaType=java.sql.ResultSet,resultMap=com.lsh.dao.mapper.TbPosRecodeMapper.result}) 
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             ]]>  
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
     </update> 
    
    
   
   
 
 

Dao层或者service层调用

来源出自 https://blog.csdn.net/lsh009/article/details/8717131