Untitled
unknown
plain_text
2 years ago
2.8 kB
9
Indexable
<%@page import="java.util.List"%>
<%@page import="Models.Account"%>
<%@page import="DAOs.AccountDAO"%>
<%@page import="java.text.SimpleDateFormat"%>
<%@ page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>User List</title>
<link href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" href="https://cdn.datatables.net/1.13.4/css/jquery.dataTables.min.css">
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-light bg-light">
<div class="container">
<a class="navbar-brand" href="#">User List</a>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav ml-auto">
<li class="nav-item">
<span class="nav-link">Hello <%= session.getAttribute("fullname")%></span>
</li>
<li class="nav-item">
<a class="nav-link" href="index.jsp">Sign Out</a>
</li>
</ul>
</div>
</div>
</nav>
<div class="container mt-4">
<h1>Show Data</h1>
<table id="userTable" class="table table-bordered">
<thead>
<tr>
<th>Username</th>
<th>Password</th>
<th>Full Name</th>
<th>Gender</th>
<th>Birthday</th>
<th>Department</th>
</tr>
</thead>
<tbody>
<%
AccountDAO dao = new AccountDAO();
List<Account> accounts = dao.getAll();
if (!accounts.isEmpty()) {
SimpleDateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");
for (Account acc : accounts) {
String birthdateStr = dateFormat.format(acc.getBirthday());
%>
<tr>
<td><%= acc.getUsername()%></td>
<td><%= acc.getPassword()%></td>
<td><%= acc.getFullname()%></td>
<td><%= acc.getGender()%></td>
<td><%= birthdateStr%></td>
<td><%= acc.getDepartment()%></td>
</tr>
<%
}
}
%>
</tbody>
</table>
</div>
<script src="https://code.jquery.com/jquery-3.5.1.js"></script>
<script src="https://cdn.datatables.net/1.13.4/js/jquery.dataTables.min.js"></script>
<script>
$(document).ready(function () {
$('#userTable').DataTable();
});
</script>
</body>
</html>Editor is loading...