Mybatis返回cursor,resultMap注解方式详解

• Mybatis返回结果集游标
• 注意要用@ResultType指定实体类
• 参数使用cursor时应添加resultMap属性：p_cur,mode=OUT,jdbcType=CURSOR,resultMap=result

public interface IUserInfoMapper {
	@Select({"call paging(#{p_cur,mode=OUT,jdbcType=CURSOR,resultMap=result}"})
	@Results(id="result",value={
//			@Result(id=true,column="userid",property="userid"),
//			@Result(column="uname",property="uname"),
//			@Result(column="age",property="age"),
//			@Result(column="sex",property="sex"),
//			@Result(column="birthday",property="birthday"),
//			@Result(column="cityid",property="cityid")
		})
	@ResultType(com.yq.entity.UserInfo.class)
	@Options(statementType=StatementType.CALLABLE)
	public void callProc(Map map);
}

• 测试端用List集合接收

List<UserInfo> list=(List)map.get("p_cur");
		for (UserInfo u : list) {
			System.out.println(u.getUname());
		}