jsp中同时应用“存储过程”和“javabean”的例子(2).txt

文档介绍：作者:asp2001 email: asp2001@ 日期:2000-8-12 11:14:26 存储过程和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"%> <%@ page language="java" import=".*" %> <% ResultSet RS = ("{call sp_shop_base('2','')}"); while (()) { ((1)); ((2)); ((3)); ((4)); ((5)); } (); %> __________________________________________________