📄 testtaglib.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>TestTagLib.jsp</TITLE>
</HEAD>
<BODY>
<H1>JSP with DB Beans and Custom Tags</H1>
<dab:dataSourceSpec id="DSConnect" scope="page"   
   dataSource='jdbc/EJBBANK'/>
<dab:select id="select_master" scope="request" connectionSpec="DSConnect">
	<dab:sql>
		SELECT ITSO.TRANSRECORD.TRANSID, ITSO.CUSTOMER.FIRSTNAME, 
		ITSO.CUSTOMER.LASTNAME, ITSO.TRANSRECORD.ACCID, 
		ITSO.TRANSRECORD.TRANSAMT 
		FROM ITSO.CUSTACCT, ITSO.CUSTOMER, ITSO.TRANSRECORD 
		WHERE ITSO.CUSTACCT.CUSTOMERID = ITSO.CUSTOMER.CUSTOMERID 
		AND ITSO.CUSTACCT.ACCID = ITSO.TRANSRECORD.ACCID 
		AND ITSO.TRANSRECORD.TRANSTYPE = 'C' 
		AND ITSO.CUSTOMER.LASTNAME LIKE :lastname 
	</dab:sql>
	<dab:parameter position = "1" type="CHAR" value="Brown"/>
</dab:select>
  <TABLE border="1">
	<TR>
		<TH>TransID</TH><TH>Firstname</TH><TH>Lastname</TH><TH>Account</TH><TH>Amount</TH>
	</TR>
<dab:repeat name="select_master" index="rowNum" over="rows" >
	<TR>
		<TD>
			<dab:getColumn index="1"/>
				<INPUT TYPE="hidden" NAME="ITSO_TRANSRECORD_TRANSID<%=rowNum%>" 
				VALUE='<dab:getColumn index="1"/>'/>
		</TD> 
		<TD>
			<dab:getColumn index="2"/>
		</TD> 
		<TD>
			<dab:getColumn index="3"/>
		</TD> 
		<TD>
			<dab:getColumn index="4"/>
		</TD> 
		<TD>
			<dab:getColumn index="5"/>
		</TD>      
	</TR>
	<%select_master.next();%>
</dab:repeat>
  </TABLE>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -