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