SQLServer多结果集

1.存储过程：

-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
/*
sp_more
*/
alter PROCEDURE sp_more 
AS
BEGIN
	set nocount on;
	select 1 a
	select 2 b
	select 3 c
	set nocount off;
END
GO

2.调用：

this.getJdbcTemplate().execute("{call sp_more()}", new CallableStatementCallback() {
			public Object doInCallableStatement(CallableStatement cs)
					throws SQLException, DataAccessException {
				cs.execute();
				ResultSet rs = null;
				int rid = 0;
				while(cs.getUpdateCount()!=-1);
				while((rs=cs.getResultSet())!=null)
				{
					while(rs.next())
					{
						if(rid==0)
						{
							System.out.println(rs.getString("a"));
						}
						else if(rid==1)
						{
							System.out.println(rs.getString("b"));
						}
						else if(rid==2)
						{
							System.out.println(rs.getString("c"));
						}
					}
					//while(cs.getUpdateCount()!=-1);
					cs.getMoreResults();
					rid++;
				}
				return null;
			}
		});
		return null;