Mysql利用存储过程获取结果集

1、创建

begin

     select * from yewu_hetong;

end

额外的方案

begin
create temporary table tmp1 like t;
insert into tmp1 select * from t;
create temporary table tmp2 like t;
insert into tmp2 select * from t;
end;

ps.....MySQL只能获取前10个结果集，如果有多余的，请自行用代码获取

2、获取

 con = Mytest.getConn();   //获取连接        String sql = "{call test()}";       cs = con.prepareCall(sql);       boolean hadResults = cs.execute();       int i=0;       while (hadResults) {           System.out.println(++i);           ResultSet rs = cs.getResultSet();           while (rs != null && rs.next()) {              String name= rs.getString(1);              System.out.println(name);           }           hadResults = cs.getMoreResults(); //检查是否存在更多结果集       }