create procedure showAll
as
select * from jobs



create procedure obtainJob_desc
@outputParam varchar ( 20 )output,
@id int
as
select @outputParam = job_desc from jobs where job_id = @id


create procedure obtainReturn
as
declare @ret int
select @ret = count ( * ) from jobs
return @ret


declare @ret int
exec @ret = obtainReturn
print @ret

public ConnectiongetConnection() ... {
Connectioncon=null;
try...{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs","sa","");
}catch(Exceptione)...{
e.printStackTrace();
}
returncon;
}

public void getResultSet() ... {
//获得连接
Connectioncon=this.getConnection();
try...{
//showAll为存储过程名
java.sql.CallableStatementcstm=con.prepareCall("{callshowAll}");
ResultSetrs=cstm.executeQuery();
while(rs.next())...{
//这里写逻辑代码。
System.out.println(rs.getString(1));
}
rs.close();
con.close();
}catch(SQLExceptione)...{
//TODOAuto-generatedcatchblock
e.printStackTrace();
}

}

public void getOutParameter( int inParam) ... {
StringoutParam;
Connectioncon=this.getConnection();

try...{
CallableStatementcstm=con.prepareCall("{callobtainJob_desc(?,?)}");
cstm.registerOutParameter(1,Types.VARCHAR);
cstm.setInt(2,inParam);
cstm.execute();;

//得到输出参数。
StringoutParma=cstm.getString(2);
System.out.println(outParma);
cstm.close();
con.close();

}catch(SQLExceptione)...{
//TODOAuto-generatedcatchblock
e.printStackTrace();
}

}

public void getReturn() ... {
intret;
Connectioncon=this.getConnection();
try...{
CallableStatementcstm=con.prepareCall("{?=callobtainReturn()}");
cstm.registerOutParameter(1,Types.INTEGER);

cstm.execute();
//得到返回值
ret=cstm.getInt(1);

System.out.println(ret);
cstm.close();
con.close();

}catch(SQLExceptione)...{
//TODOAuto-generatedcatchblock
e.printStackTrace();
}

}