Small Example of calling Oracle stored procedure in JSP
* Execute an insert statement and pass the parameter */
Create or replace procedure p_test2 (I in number)
Begin
Insert into T values (I, 'x' | to_char (I ));
Commit;
End;
/
<% @ Page Language = "Java" contenttype = "text/html; charset = gb2312" %>
<% @ Page import = "Java. SQL. *" %>
<HTML>
<Body>
<Table>
<Tr> <TD> AAA </TD> <TD> BBB </TD> </tr>
<%
String driver = "oracle. JDBC. Driver. oracledriver ";
String strurl = "JDBC: oracle: thin: @ 192.168.1.6: 1521: DB ";
Class. forname (driver );
Connection conn = drivermanager. getconnection (strurl, "Scott", "Tiger ");
String procedure = "{call p_test2 (?) }";
Callablestatement cstmt = conn. preparecall (Procedure );
Cstmt. setint (1, 33 );
Cstmt.exe cuteupdate ();
Statement stmt = conn. createstatement ();
Resultset rs = stmt.exe cutequery ("select * from t ");
While (Rs. Next ())
{
Out. println ("<tr> <TD>" + Rs. getstring (1) + "</TD> <TD>" + Rs. getstring (2) + "</TD> </tr> ");
}
Rs. Close ();
Stmt. Close ();
Conn. Close ();
%>
</Table>
<P>
<%
Out. Print (conn. isclosed ());
%>
</Body>
</Html>
</Body>
</Html>