javaµ÷Óô洢¹ý³Ì

 
A:²»´øÊä³ö²ÎÊýµÄ
  ---------------²»´øÊä³ö²ÎÊýµÄ----------------------------------
create procedure getsum
@n int =0<--´Ë´¦Îª²ÎÊý-->
as
declare @sum int<--¶¨Òå±äÁ¿-->
declare @i int
set @sum=0
set @i=0
while @i<=@n begin
set @sum=@sum+@i
set @i=@i+1
end
print 'the sum is '+ltrim(rtrim(str(@sum)))
--------------ÔÚSQLÖÐÖ´ÐÐ:--------------------
exec getsum 100
------------ÔÚJAVAÖе÷ÓÃ:---------------------
JAVA¿ÉÒÔµ÷Óà µ«ÊÇÔÚJAVA³ÌÐòÈ´²»ÄÜÈ¥ÏÔʾ¸Ã´æ´¢¹ý³ÌµÄ½á¹û ÒòΪÉÏÃæµÄ´æ´¢
¹ý³ÌµÄ²ÎÊýÀàÐÍint ´«µÝ·½Ê½ÊÇin(°´Öµ)·½Ê½
import java.sql.*;
public class ProcedureTest
{
public static void main(String args[]) throws Exception
{
//¼ÓÔØÇý¶¯
DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
//»ñµÃÁ¬½Ó
Connection conn=DriverManager.getConnection("jdbc:odbc:mydata","sa","");
    //´´½¨´æ´¢¹ý³ÌµÄ¶ÔÏó
    CallableStatement c=conn.divpareCall("{call getsum(?)}");
   
    //¸ø´æ´¢¹ý³ÌµÄ²ÎÊýÉèÖÃÖµ
    c.setInt(1,100); //½«µÚÒ»¸ö²ÎÊýµÄÖµÉèÖóÉ100
   
    //Ö´Ðд洢¹ý³Ì
    c.execute();
    conn.close();
}
}
 
B:´øÊä³ö²ÎÊýµÄ
  1:·µ»Øint
    -------------------------´øÊä³ö²ÎÊýµÄ----------------
alter procedure getsum
@n int =0,
@result int output
as
declare @sum int
declare @i int
set @sum=0
set @i=0
while @i<=@n begin
set @sum=@sum+@i
set @i=@i+1
end
set @result=@sum
  -------------------ÔÚ²éѯ·ÖÎöÆ÷ÖÐÖ´ÐÐ------------
declare @myResult int
exec getsum 100,@myResult output
print @myResult
  ------------ÔÚJAVAÖе÷ÓÃ---------------------
import java.sql.*;
public class ProcedureTest
{
public static void main(String args[]) throws Exception
{
//¼ÓÔØÇý¶¯
DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
//»ñµÃÁ¬½Ó
Connection conn=DriverManager.getConnection("jdbc:odbc:mydata","sa","");
&nbs