学步园

creat  proc proc_select

             @pid varchar(20)

             @address varchar(20) output

as

        select   @address=address from userinfo where pid=@pid

go

用java调用:

class.forName("sun.jdbc.odbc.JdbcOdbcDriver");           //加载驱动

Connection con=DriverManager.getConnection("Jdbc:Odbc:test","sa","");    //获得连接

String call="{call proc_select(?,?)};"               //调用语句

CallableStatement proc=con.preparecall(call);                  //调用存储过程

proc.setString(1,"12345678");                            //给输入参数传值

proc.registerOutParameter(2,Type.varchar);                   //声明输出参数是什么类型的

proc.execute();                       //执行

String address=proc.getString(2);             //获得输出参数