Following sql tags have been implemented for
8.1.7.
</jml:dbOpen>
<%@ taglib uri="/WEB-INF/sqltaglib.tld" prefix="jml"
%>
<HTML>
<HEAD>
<TITLE>Nested tags - XML string</TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<HR>
<jml:dbOpen URL="jdbc:oracle:thin:@dlsun991:1521:816" user="scott"
password="tiger" >
<jml:dbQuery output="xml">
select * from EMP
</jml:dbQuery>
<jml:dbOpen>
<HR>
</BODY>
</HTML>
<%@ taglib uri="/WEB-INF/sqltaglib.tld" prefix="jml" %>
<HTML>
<HEAD>
<TITLE>A
sample that iterates over resultset </TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<HR>
<jml:dbOpen connId="con1" URL="jdbc:oracle:thin:@dlsun991:1521:816"
user="scott" password="tiger">
</jml:dbOpen>
<jml:dbQuery connId="con1" output="jdbc" queryId="myquery">
select * from EMP
</jml:dbQuery>
<jml:dbNextRow queryId ="myquery">
<%= myquery.getString(1) %>
</jml:dbNextRow>
</jml:dbCloseQuery queryId="myquery"/>
</jml:dbClode connId="con1" />
<HR>
</BODY>
</HTML>
<%@ taglib uri="/WEB-INF/sqltaglib.tld" prefix="jml"
%>
<HTML>
<HEAD>
</TITLE>DML
Sample <TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<HR>
<jml:dbOpen URL="jdbc:oracle:thin:@dlsun991:1521:816" user="scott"
password="tiger" connId="con1">
</jml:dbOpen>
<jml:dbExecute connId="con1">
insert into EMP (EMPNO, ENAME) values (1500, "LESLIE")
</jml:dbExecute>
<jml:dbClose connId="con1" />
<HR>
</BODY>
</HTML>
%@ taglib uri="/WEB-INF/sqltaglib.tld" prefix="jml"
%>
<HTML>
<HEAD>
<TITLE>Connection
Taglib </TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<HR>
<jml:dbOpen URL="jdbc:oracle:thin:@dlsun991:1521:816" user="scott"
password="tiger">
<jml:dbQuery output="jdbc">
select * from EMP
<jml:dbNextRow >
<%
if (result == null)
out.print("result was null");
else
out.println("String is " + result.getString(1));
%>
</jml:dbNextRow>
</jml:dbQuery>
</jml:dbOpen>
<HR>
</BODY>
</HTML>