/* 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>
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
