JDBC调用存储过程 返回多结果集

package com.demo1;


import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;


import com.demo.JdbcUtil;


//调用无参存储过程 包括查询和删除
public class Demo6 {
//1.存储过程只要有查询就返回true
//2.如果有多条查询语句，返回的是第一条查询语句执行的结果集
public static void main(String[] args) {
try {
Connection conn = JdbcUtil.getConnection();
CallableStatement stmt = conn.prepareCall("{call deleteEmp2()}");
//存储过程有查询也有更新
boolean result = stmt.execute();
/*
System.out.println(result);
ResultSet rs = stmt.getResultSet();
while(rs.next()){
System.out.println(rs.getString(2));
}
rs.close();
System.out.println("========忧愁的分割线===========");
stmt.getMoreResults();
rs = stmt.getResultSet();
while(rs.next()){
System.out.println(rs.getString(2));
}
*/
ResultSet rs  = stmt.getResultSet();
System.out.println(rs);
while(rs != null){
while(rs.next())
{
System.out.println(rs.getString(2));
}
rs.close();
stmt.getMoreResults();
rs = stmt.getResultSet();
}

JdbcUtil.closeAll(null, stmt, conn);
} catch (Exception e) {
e.printStackTrace();
}


}
}