procedemo3.java

在 java中调用 sqlserver存储过程

/*
 **
 *--存储过程 带游标
alter procedure CursorIntoProcedure
@pname varchar(8000) output
as
--定义游标
declare cur cursor for select stuname from student
--定义一个变量来接受游标值
declare @v varchar(10) --两个字节表示一个汉字
--打开游标
open cur
set @pname= '' --给@pname初值
--提取游标的值
fetch next from cur into @v
while @@fetch_status = 0
begin
	set @pname = @pname+';'+@v
	fetch next from cur into @v
end
print @pname
--关闭游标
close cur
--销毁游标
deallocate cur

-------------执行了
exec CursorIntoProcedure ''
 */
import java.sql.*;
public class ProceDemo3
{
	public static void main(String [] args)
    {
    	try {
    		DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
    		Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DataBaseName=Demo","sa","ok");
    		CallableStatement cstmt = con.prepareCall("{call CursorIntoProcedure(?)}");
    		cstmt.registerOutParameter(1,java.sql.Types.VARCHAR);
    		cstmt.execute();
    		System.out.println (cstmt.getString(1));  //--输出一个集合
    		con.close();
	    }
	    catch (SQLException ex) {
	    	ex.printStackTrace();
	    }
    }
}