mybatis调用oracle存储过程返回游标 读取到java的List<Map>

mybatis调用oracle存储过程返回结果集：http://blog.csdn.net/eunyeon/article/details/52745396

java读取ORACLE 存储过程 返回游标(cursor) 格式 读取到List中：https://my.oschina.net/u/1587544/blog/371792

mapper：

<select id="testP" statementType="CALLABLE" >  {call P_TEST(#{v_cursor, mode=OUT, jdbcType=CURSOR})}</select>

java：

Map<String, Object> param = new HashMap<String, Object>();testMapper.testP(param);ResultSet rs = (ResultSet) param.get("v_cursor");List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();try {if (rs != null) {int cl = rs.getMetaData().getColumnCount();System.out.println("cl:"+cl);while (rs.next()) {Map<String, Object> map = new HashMap<String, Object>();for (int i = 0; i < cl; i++) {String key = rs.getMetaData().getColumnName(i + 1);Object val = rs.getObject(key);map.put(key, val);}list.add(each);}}} catch (Exception e) {e.printStackTrace();}