📄 runtransfer.jsp

📁 噶额外噶外骨骼感广泛高热感就啊啊

💻 JSP

字号:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<%@taglib uri="jspsql" prefix="dab"%>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1" session="false" %>
<META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<META name="GENERATOR" content="IBM WebSphere Studio">
<META http-equiv="Content-Style-Type" content="text/css">
<LINK href="theme/Master.css" rel="stylesheet" 	type="text/css">
<TITLE>RunTransferStoredProcedure.jsp</TITLE>
</HEAD>
<BODY>
<H1>JSP - Transfer - Stored Procedure Call</H1>
<dab:dataSourceSpec id="DSConnect" scope="page" dataSource='jdbc/ejbbank' />
<dab:procedureCall id="transfer" connectionSpec="DSConnect" scope="request">
	<dab:sql>
		{ CALL ITSO.TRANSFERMONEY (:account1, :account2, :amount, :success) }
	</dab:sql>
	<dab:parameter parmName="account1" type="VARCHAR" mode="in" value="106-6002" />
	<dab:parameter parmName="account2" type="VARCHAR" mode="in" value="106-6001" />
	<dab:parameter parmName="amount"   type="DECIMAL"   mode="in" value="100.00" />
	<dab:parameter parmName="success"  type="INTEGER"   mode="out" />
</dab:procedureCall>
<P>
Account1: <dab:getParameter name="transfer" parmName="account1" /><br>
Account2: <dab:getParameter name="transfer" parmName="account2" /><br>
Amount:   <dab:getParameter name="transfer" parmName="amount"  /><br>
<br>
Result:   <dab:getParameter name="transfer" parmName="success" />
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -