以下的例子转自csdn论坛:
CREATE TABLE
testwsh_TAB
(
BOOKID
INTEGER
NOT
NULL,
classid
varchar2(20)
not
null,
CONSTRAINT
PK_testwsh_TAB
PRIMARY
KEY
(
BOOKID
)
)
;
*执行一条insert语句并传参数*/
create or
replace
procedure
p_test2(i
in
number)
as
begin
insert into
testwsh_TAB
(BOOKID,classid)
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>第一栏数据column1</td><td>第二栏数据column2</td></tr>
<%
String driver
=
"oracle.jdbc.driver.OracleDriver";
String strUrl
=
"jdbc:oracle:thin:@172.20.29.10:1521:orawas";
Class.forName(driver);
Connection
conn
=
DriverManager.getConnection(strUrl,
"elms_test5",
"elms_test5");
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
testwsh_tab");
while(rs.next())
{
out.println("<tr><td>"
+
rs.getString(1)
+
"</td><td>"
+
rs.getString(2)
+
"</td></tr>");
}
rs.close();
stmt.close();
conn.close();
%>
</table>
CREATE
*执行一条insert语句并传参数*/
create
begin
insert
commit;
end;
/
<%@
<%@page
<html>
<body>
<table>
<tr><td>第一栏数据column1</td><td>第二栏数据column2</td></tr>
<%
String
String
%>
</table>
<% out.print(conn.isClosed()); %>
</body>
</html>
</body>
</html>