Show Data from DB to the HTML Page
Show data to the browser from the database using JSTL Tags -
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Show User</title>
<link rel="stylesheet"
href="https://cdn.jsdelivr.net/npm/bootstrap@4.5.3/dist/css/bootstrap.min.css"
integrity="sha384-TX8t27EcRE3e/ihU7zmQxVncDAy5uIKz4rEkgIXeMed4M0jlfIDPvg6uqKI2xXr2"
crossorigin="anonymous">
</head>
<body>
<h1>All data from the database:</h1>
<sql:setDataSource driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/youtube" user="root" password="mysql"
var="ds"></sql:setDataSource>
<sql:query dataSource="${ds}" var="rs">select * from jspsqltag;</sql:query>
<br>
<br>
<div class="container">
<table class="table">
<tr>
<td><h3>User Id</h3></td>
<td><h3>User Name</h3></td>
<td><h3>User Email</h3></td>
</tr>
<c:forEach items="${rs.rows}" var="row">
<tr>
<td><c:out value="${row.id}"></c:out></td>
<td><c:out value="${row.name}"></c:out></td>
<td><c:out value="${row.email}"></c:out></td>
</tr>
</c:forEach>
</table>
</div>
</body>
</html>
// NOTE - JSTL and MYSQL JAR File or add dependency in maeven
// NOTE - Create database and Table
// DATABASE Name - youtube
//Table Name - jspsqltag
Comments
Post a Comment