处理MySQL存储过程返回多个结果集

Connection conn = null;
CallableStatement cs = null;
ResultSet rs = null;

try
{
    // get connection
    cs = conn.prepareCall("{call SP_TEST(?, ?)}");
    cs.registerOutParameter(1, Types.INTEGER);
    cs.registerOutParameter(2. Types.VARCHAR);
    cs.execute();

    do
    {
        rs = cs.getResultSet();
        if (rs == null)
        {
            continue;
        }

        while (rs.next())
        {
            // deal with the result
        }
        cs.getMoreResultSet();
    }
    while (rs != null)
}
catch (Exception e)
{
    // log exception
}
finally
{
    // close rs, cs & conn
}