<%
String connStr=request.getParameter("connStr");
if (connStr==null) {
connStr=(String)session.getValue("connStr");
} else {
session.putValue("connStr",connStr);
}
if (connStr==null) { %>
<%
}
%>
<%@ taglib uri="/WEB-INF/sqltaglib.tld" prefix="jml" %>
DML Sample
Note: You should first create a table before you drop it.
Result:
<% if (request.getParameter("drop")!=null) { %>
drop table test_table
<% } %>
<% if (request.getParameter("create")!=null) { %>
create table test_table (col1 NUMBER)
<% } %>
<% if (request.getParameter("insert")!=null) { %>
insert into test_table values (1234)
<% } %>
<% if (request.getParameter("select")!=null) { %>
select * from test_table
<% } %>