📄 runstoredprocedure.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>RunStoredProcedure.jsp</TITLE>
</HEAD>
<BODY>
<H1>JSP with Stored Procedure Call</H1>
<dab:dataSourceSpec id="DSConnect" scope="page" dataSource='jdbc/ejbbank' />
<dab:procedureCall id="getCust" connectionSpec="DSConnect" scope="request">
	<dab:sql>
		{ CALL ITSO.GETCUSTOMER(:customerID) }
	</dab:sql>
	<dab:parameter parmName="customerID" type="INTEGER" mode="in" value="104" />
</dab:procedureCall>
<TABLE border="1">
	<TR><TH align="left">ID</TH>       
		<TD><dab:getColumn name="getCust" index="1" /></TD></TR>
	<TR><TH align="left">Title</TH>    
		<TD><dab:getColumn name="getCust" index="2" /></TD></TR>
	<TR><TH align="left">Firstname</TH>
		<TD><dab:getColumn name="getCust" index="3" /></TD></TR>
	<TR><TH align="left">Lastname</TH> 
		<TD><dab:getColumn name="getCust" index="4" /></TD></TR>
	<TR><TH align="left">User ID</TH>  
		<TD><dab:getColumn name="getCust" index="5" /></TD></TR>
</TABLE>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -