<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %> <%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %> <%@ taglib prefix="portlet" uri="http://java.sun.com/portlet" %>
Create DB:
 
Delete DB:
 
Use DB:
 
SQL Command/s:
<%-- Display action result --%> Result:

Note:
1) Use ';' to separate multiple statements
2) Query results will be displayed for single 'Select' statement
3) Use single quotes to encapsulate literal strings

<%-- Display query result from single select statement --%> <%-- Datasource --%> <%-- Create the connection manually --%> <%-- Select statement --%> <%= request.getAttribute("singleSelectStmt") %>
Query Result
<%-- Get the column names for the header of the table --%> <%-- Check if there are table data to display --%> <%-- Get the value of each column while iterating over rows --%>
*** Empty ***