调用存储过程+自定义json格式+jdbc查询存储过程的两个结果集，珍藏版

package com.yanshu.controller;


import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;


import org.jboss.jandex.Main;


import com.alibaba.fastjson.JSON;
import com.yanshu.utils.ConnSql;
import com.yanshu.utils.JdbcUtil;


public class Proc25 {

public static Map<String, Object> getRui(String storageName, String[] args) throws Exception {
Connection conn = null;
CallableStatement cs = null;
ResultSet rs = null;
Map<String, Object> map = new HashMap<String, Object>();
Map<String, Object> temp = null;
List<Map<String, String>> list = null;
List<List> listlist=null;
temp=new HashMap<String, Object>();
conn = JdbcUtil.getConn();
String newStorageName = ConnSql.storageNameHandle(storageName, args.length);
cs = conn.prepareCall("{call " + newStorageName + "}");
for (int i = 0; i < args.length; i++) {
cs.setString(i + 1, args[i]);
}
cs.execute();
rs = cs.getResultSet();
if (rs != null) {
list = new ArrayList<Map<String, String>>();
List list33 = new ArrayList<>();
/**
* list2用于接收遍历多条数据
*/
List list2 = new ArrayList<>();
List list25 = new ArrayList<>();
while (rs.next()) {
ResultSetMetaData rsmd33 = rs.getMetaData();
List list99 = new ArrayList<>();
for(int i = 1; i <= rsmd33.getColumnCount(); i++)
{
String columnLabel = rsmd33.getColumnLabel(i);
Object columnValue = rs.getObject(columnLabel);
list99.add(columnLabel);
}
temp.put("columns", list99);
List listRows=new ArrayList<>();
int count=rsmd33.getColumnCount();
for (int i = 1; i <count; i++) {
listRows.add(rs.getObject(i));
}
List list3 = new ArrayList<>();
for (int i = 1; i <= rsmd33.getColumnCount(); i++) {
Object columnValue = rs.getObject(i);
list3.add(columnValue);
}

list25.add(list3.get(2));
list2.add(list3);
Map<String, Object> dataMap = new HashMap<String, Object>(0);
for (int i = 1; i <= rsmd33.getColumnCount(); i++) {
dataMap.put(rsmd33.getColumnName(i), rs.getObject(i));
}
//System.out.println(dataMap);
list33.add(dataMap);

}
temp.put("rows", list2);
if (cs.getMoreResults()) {
rs = cs.getResultSet();
list = new ArrayList<Map<String, String>>();
while (rs.next()) {
ResultSetMetaData rsmd11 = rs.getMetaData();
/**
* 遍历循环出表的列名刘瑞光
*/
List list11 = new ArrayList<>();
for (int i = 0; i < rsmd11.getColumnCount(); i++) {
String columnLabel = rsmd11.getColumnLabel(i + 1);
Object columnValue = rs.getObject(columnLabel);
list11.add(columnValue);
map.put("count", columnValue);
}

}
map.put("data",temp );
map.put("取出某个列的值:", list25);


}


}
JdbcUtil.closeConn(rs, cs, null, null, conn);
return map;


}

public static void main(String[] args) throws Exception {
String[] par = new String[] { "1", "1", "2010525", "20170829", "1" };
Map<String, Object> map1 = getRui("op_auction_buy_informations", par);

System.out.println(JSON.toJSON(map1));
}


}