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
}
处理MySQL存储过程返回多个结果集
最新推荐文章于 2021-08-20 23:13:04 发布