如何在jsp中调用oracle的存储过程！(100分)

如题！越详细越好！

到google下搜索一下，有很多相关文章的，给你贴几个：
http://class.gzrail.net/read.php?classid=140
http://www.itraining.net.cn/lzh/showArticle.asp?art_ID=546
http://www.huihoo.com/java/oracle/oracle8i_java.html

<h2>调用存储过程</h2>
<%
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbcracle:thinlocalhost:1521:数据库";
String user="system";
String password="ss";

Connection Conn = DriverManager.getConnection(url,login,password);
CallableStatement Prepare = Conn.prepareCall("exec p_test");
Prepare.executeQuery();
ResultSet rs = Prepare.getResultSet();
while(rs.next())
{
out.println(rs.getString(1) );
}
rs.close();
Conn.close();
%>

gz.......................

<h2>调用函数</h2>
<%
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbcracle:thinlocalhost:1521:数据库";
String user="system";
String password="ss";
Connection Conn = DriverManager.getConnection(url,login,password);
CallableStatement cs = Conn.prepareCall("begin
? := func(?,?);
end;
");
cs.registerOutParameter(1, Types.INTEGER);
cs.setString(2, "param1");
cs.setString(3, "param2");
cs.execute();
int result = cs.getInt(1);
cs.close();
Conn.close();
%>

西北浪人,何方神圣

参考
http://www.java-cn.com