The required output was not displayed, while running the file jdbc.jspx, which should be the same output as the jdbc.jsp
Code for jdbc.jspx is as follows:
<?xml version="1.0" encoding="ISO-8859-1"?>
<
jsp:root
xmlns:jsp="http://java.sun.com/JSP/Page"
xmlns:c="http://java.sun.com/jsp/jstl/core"
xmlns:sql="http://java.sun.com/jsp/jstl/sql"
version="2.1"
>
<jsp:directive.page
language="java"
contentType="ISO-8859-1"
pageEncoding="ISO-8859-1"
/>
<jsp:output
doctype-root-element="html"
doctype-public="-//W3C//DTD XHTML 1.0 Strict//EN"
doctype-system="http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"
/>
<html xmlns="http://www.w3.org/1999/xhtml">
<head><title>JDBC/JSTL
test</title></head><body>
<sql:setDataSource driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/shop"
user="root" password="root" var="dataSource"
/>
<sql:query var="books" dataSource="${dataSource}">
select * from books
</sql:query>
<table border= "1">
<tr>
<c:forEach var="colName" items="${books.columnNames}">
<td>
<c:out value="${colName}"/></td>
</c:forEach>
</tr>
<c:forEach var="row" items="${books.rowsByIndex}">
<tr>
<c:forEach var="col" items="${row}">
<td><c:out value="${col}"/></td>
</c:forEach>
</tr>
</c:forEach>
</table>
</body></html>
</jsp:root>
And code for jdbc.jsp is as follows:
<%@page language="java" contentType="text/html"%>
<%@page import="java.sql.*"%>
<html><head><title>
JDBC test</title></head><body>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/shop", "root", "root");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from books");
%><table border= "1"><%
ResultSetMetaData resMetaData = rs.getMetaData();
int nCols = resMetaData.getColumnCount();
%><tr><%
for (int kCol = 1; kCol <= nCols; kCol++) {
out.print("<td><b>" + resMetaData.getColumnName(kCol) + "</b></td>");
}
%></tr><%
while (rs.next()) {
%><tr><%
for (int kCol = 1; kCol <= nCols; kCol++) {
out.print("<td>" + rs.getString(kCol) + "</td>");
}
%></tr><%
}
%></table><%
conn.close();
%>
</body></html>
