Jsp中调用Oracle存储过程的小例子(二)

最新推荐文章于 2021-04-06 04:30:59 发布

zlsunnan

最新推荐文章于 2021-04-06 04:30:59 发布

阅读量1.4k

点赞数

分类专栏：数据库和访问JDBC 文章标签： jsp 存储 oracle sql server output import

本文链接：https://blog.csdn.net/zlsunnan/article/details/82762

版权

数据库和访问JDBC 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

Create Procedure sp_shop_base (@shop_id int,@msg char(50) output)
As
SELECT shop_name, shop_phone, shop_email, shop_cash, shop_address
FROM shop_shop
WHERE shop_id = @shop_id
SELECT @msg = 'Retrieval Finished'
return 1

程序：
<%@ page contentType="text/html;charset=gb2312"%>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>JSP 存储过程 - javabean - JDBC-ODBC - SQL Server </title>
</head>
<body>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="bka" scope="page" class="shop.bka" />
<%
ResultSet RS = bka.executeQuery("{call sp_shop_base('2','')}");
while (RS.next()) {
out.println(RS.getString(1));
out.println(RS.getString(2));
out.println(RS.getString(3));
out.println(RS.getString(4));
out.println(RS.getString(5));
}
RS.close();
%>