IDC资讯中心
存储过程和javabean的应用
存储过程sp_shop_base：
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();
%>
__________________________________________________
