The following examples of js|oracle| stored procedures are transferred from the CSDN forum:
* Execute an INSERT statement and pass the parameter * *
Create or Replace procedure P_test2 (i in number) as
Begin
INSERT into t values (I, ' X ' | | To_char (i));
Commit
End
/
<%@ page language= "java" contenttype= "text/html;charset=gb2312"%>
<% @page import= "java.sql.*"%>
<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.executeupdate ();
Statement stmt = Conn.createstatement ();
ResultSet rs = stmt.executequery ("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>
</body>
