最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
jsp中同时应用“存储过程”和“javabean”的例子
时间:2022-07-02 18:14:41 编辑:袖梨 来源:一聚教程网
存储过程和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"%>
JSP 存储过程 - javabean - JDBC-ODBC - SQL Server
<%@ 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();
%>
__________________________________________________
存储过程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="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();
%>
__________________________________________________
相关文章
- 浪人崛起超级石火流玩法指南 07-04
- 浪人崛起前期技能推荐指南 07-04
- 燕云十六声红线人物传满完成度达成方法 07-04
- 虚拟币交易平台最新榜单:2025年虚拟币交易平台排行榜 07-04
- 地下城与勇士手游格兰之森副本攻略 07-04
- 崩坏星穹铁道给我停止吧成就怎么做 07-04