BBJSP SQLTags (Deprecated)
The BBJSP system is deprecated. For new development, use BBxServlet.
Description
In BBj 16.00 and higher, the BBJSP SQL library provides a common set of tags that can be used to access a database within the BBJSP framework.
Creation
Tag libraries need specifically importing into a BBJSP page by using the taglib directive. Here's an example of how to register this tag library in your page:
<%@ taglib uri='/WEB-CFG/tld/sql.tld' prefix='sql' %>
The uri points to the tag library definition within the web application and the
prefix defines how the tag will be prefixed in the markup.
Tags
|
Tag Name |
Description |
|---|---|
| Param | Passes parameters into an <SQL.Query> tag. |
| Query | Executes an SQL query |
Example
<!DOCTYPE html/>
<%@ taglib uri='/WEB-CFG/tld/core.tld' prefix='c' %>
<%@ taglib uri='/WEB-CFG/tld/sql.tld' prefix='sql' %>
<!-- Demo of executing an SQL query -->
<html>
<head>
<title>SQL Tags</title>
<style>
table {border:2px solid black;text-indent: 4px;padding:0px;border-spacing: 0px;}
th{border:0px;border-bottom:2px solid black;padding:4px;background-color:ABFBFF;}
td{border:0px;padding:1px;background-color:E3FEFF;}
.l {border-left:1px solid black;}
</style>
</head>
<body>
<sql:query template='tpl' var='result' datasource='ChileCompany' sql='SELECT * FROM SALESREP' />
<table width='100%'>
<tr>
<th align='left'>Code</th>
<th align='left' class='l'>Name</th>
<th align='left' class='l' colspan='4'>Address</th>
<th align='left' class='l'>Phone</th>
</tr>
<c:iterate data="${result}" id="item" >
<c:template id='theRecord' template='${tpl}' data='${item}' />
<tr>
<td>${theRecord['SALESPERSON']}</td>
<td class='l'>${theRecord['NAME']}</td>
<td class='l'>${theRecord['ADDRESS']} ${theRecord['ADDRESS2']}</td>
<td>${theRecord['CITY']}</td>
<td>${theRecord['STATE']}</td>
<td>${theRecord['ZIP']}</td>
<td class='l'>${theRecord['PHONE']}</td>
</tr>
</c:iterate>
</table>
<h3>The Query</h3>
<ul>
<p><code>SELECT * FROM SALESREP</code></p>
</ul>
<h3>The Template</h3>
<ul>
<textarea rows="3" cols="100">${tpl}</textarea>
</ul>
<h3>The RAW data</h3>
<ul>
<textarea rows="9" cols="100">${result}</textarea>
</ul>
</body>
</html>