?? 0083.htm
字號:
<html>
<head>
<title>新時代軟件教程:操作系統 主頁制作 服務器 設計軟件 網絡技術 編程語言 文字編輯</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
<!--
body, table {font-size: 9pt; font-family: 宋體}
a {text-decoration:none}
a:hover {color: red;text-decoration:underline}
.1 {background-color: rgb(245,245,245)}
-->
</style>
</head>
<p align="center"><script src="../../1.js"></script></a>
<p align="center"><big><strong>jsp中同時應用“存儲過程”和“javabean”的例子</strong></big></p>
<div align="right">摘自《ChinaAsp》（文/asp2001）</div>
<p><span class=smallFont>
存儲過程和javabean的應用<br>
<br>
存儲過程sp_shop_base：<br>
Create Procedure sp_shop_base (@shop_id int,@msg char(50) output)<br>
As<br>
SELECT shop_name, shop_phone, shop_email, shop_cash, shop_address<br>
FROM shop_shop<br>
WHERE shop_id = @shop_id<br>
SELECT @msg = 'Retrieval Finished'<br>
return 1<br>
<br>
程序：<br>
<%@ page contentType="text/html;charset=gb2312"%><br>
<br>
<html><br>
<head><br>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><br>
<title>JSP 存儲過程 - javabean - JDBC-ODBC - SQL Server </title><br>
</head><br>
<body><br>
<%@ page language="java" import="java.sql.*" %><br>
<jsp:useBean id="bka" scope="page" class="shop.bka" /><br>
<%<br>
ResultSet RS = bka.executeQuery("{call sp_shop_base('2','')}");<br>
while (RS.next()) {<br>
out.println(RS.getString(1));<br>
out.println(RS.getString(2));<br>
out.println(RS.getString(3));<br>
out.println(RS.getString(4));<br>
out.println(RS.getString(5));<br>
}<br>
RS.close();<br>
%><br>
<br>
<br>
<br>
__________________________________________________<br>
</table>
<p align="center"><script src="../../2.js"></script></a>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -