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); //获得输出参数