Mybatis调用存储过程返回多个结果集

Mybatis调用存储过程返回结果集

配置文件

  <resultMap type="Integer" id="test1">  
    <result column="test1"   jdbcType="INTEGER" javaType="Integer" />   
  </resultMap>  

  <resultMap type="test.Test2" id="test2">   
    <result column="Id" property="id" jdbcType="VARCHAR" javaType="String"/>  
  </resultMap> 

  <select id="getTests" statementType="CALLABLE" parameterType="Map"  
      resultMap="test1,test2" >
   {call P_GetTest(#{id,mode=IN,jdbcType=VARCHAR})}
  </select>

 resultMap="test1,test2" 这里返回多个结果集

接口

 public List<List<?>>  getTests(Map<String, Object> map);

Service调用

   Map<String,Object> map=new HashMap<String, Object>();
        map.put("id", "22333");
   //取得返回的结果集   
   List<List<?>> results = testDao.getTests(map);
   //结果集1
   System.out.println(((List<Integer>)results.get(0)).get(0));
   //结果集2
   System.out.println((List<Test2>)results.get(1));