1
CREATE TABLE testwsh_TAB (
BOOKID INTEGER NOT NULL,
classid varchar2(20) not null,
CONSTRAINT PK_testwsh_TAB
PRIMARY KEY ( BOOKID ) ) ;
2
*执行一条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;
/
3 insert.jsp
<%@ 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:@10.0.2.254:1521:ora";
Class.forName(driver);
Connection conn = DriverManager.getConnection(strUrl, "scott", "tiger");
String procedure = "{call p_test2 (?) }";
CallableStatement cstmt = conn.prepareCall(procedure);
cstmt.setInt(1,34);
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>
<% out.print(conn.isClosed()); %>
</body>
</html>
</body>
</html>
4 结果
http://10.0.2.254:8090/test4/insert.jsp
| 第一栏数据column1 | 第二栏数据column2 |
| 33 | x33 |
| 34 | x34 |
评论