求救JSP中怎么调用SQLSERVER存储过程

求救JSP中如何调用SQLSERVER存储过程
求救JSP中如何调用SQLSERVER存储过程

[解决办法]
帮顶。
[解决办法]
上网找找
[解决办法]
我一个项目中的源码，可供参考
是调用sqlserver2000的存储过程

con = DriverManager.getConnection(driverUrl, userName, password);
call = con.prepareCall ( "{ CALL SAVE_ANSWER (?,?,?,?,?,?) } ");
call.setString(1, userId);
call.setInt(2, examId);
call.setBytes(3, answers.getBytes());
call.setTimestamp(4, new Timestamp(dt.getTime()));
call.setInt(5, score);
call.registerOutParameter (6, Types.INTEGER);
call.execute();
result = call.getInt(6);


[解决办法]
try{
int age = 39;

string poetname = "dylan thomas ";

callablestatement proc = connection.preparecall( "{ call set_death_age(?, ?) } ");

proc.setstring(1, poetname);

proc.setint(2, age);

cs.execute();

}catch (sqlexception