1. Phân tích chức năng
Xây dựng chức năng:
- Hiển thị
- Thêm
- Sửa
- Xoá
dữ liệu bảng danh mục (categories)
2. Thực thi
Đối với mối chức năng chúng ta sẽ có 1 controller riêng để đảm nhiệm
2.1. Chức năng hiển thị
B1: Tạo controller IndexCategoryServlet kế thừa lớp BaseAdminServlet thực hiện chức năng quản lý trang hiển thị dữ liệu các danh mục
package binh.dev.admin.category;
import java.io.IOException;
import jakarta.servlet.ServletException;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import java.util.List;
import binh.dev.BaseServlet;
import binh.dev.data.dao.DatabaseDao;
import binh.dev.data.model.Category;
/**
*
* @author binhdev
*/
public class IndexCategoryServlet extends BaseServlet {
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
List<Category> categoryList = DatabaseDao.getInstance().getCategoryDao().findAll();
request.setAttribute("categoryList", categoryList);
request.getRequestDispatcher("admin/category/index.jsp").include(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
}
}
B2: Tạo giao diện index.jsp trong thư mục web/admin/categories làm chức năng view
<%--
Document : dashboard
Created on : May 23, 2023, 6:10:20 PM
Author : binhdev
--%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="">
<meta name="author" content="">
<title>CornSalad Admin - Dashboard</title>
<!-- Custom fonts for this template-->
<link href="./assets/admin/vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
<link
href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i"
rel="stylesheet">
<!-- Custom styles for this template-->
<link href="./assets/admin/css/sb-admin-2.min.css" rel="stylesheet">
</head>
<body id="page-top">
<!-- Page Wrapper -->
<div id="wrapper">
<!-- Sidebar -->
<%@include file="../inc/sidebar.jsp" %>
<!-- End of Sidebar -->
<!-- Content Wrapper -->
<div id="content-wrapper" class="d-flex flex-column">
<!-- Main Content -->
<!-- Topbar -->
<%@include file="../inc/header.jsp" %>
<!-- End of Topbar -->
<!-- Begin Page Content -->
<div class="container-fluid">
<!-- Page Heading -->
<h1 class="h3 mb-2 text-gray-800">Categories</h1>
<p class="mb-4">Danh sách các Loaị hàng cùng thuộc tính kèm theo trong CornSalad Store.</p>
<!-- DataTales Example -->
<div class="card shadow mb-4">
<div class="card-header py-3">
<h6 class="m-0 font-weight-bold text-primary">Category Table</h6>
</div>
<div class="card-body">
<div class="table-responsive">
<table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
<thead>
<tr>
<th>STT</th>
<th>Thumbnail</th>
<th>Name</th>
<th>#</th>
<th>#</th>
</tr>
</thead>
<tbody>
<c:set var="index" value="0"/>
<c:forEach items="${categoryList}" var="category">
<c:set var="index" value="${index + 1}"/>
<tr>
<td>${index}</td>
<td>
<img src="${category.thumbnail}" width="50" height="50" alt="alt"/>
</td>
<td>${category.name}</td>
<td>
<a href="EditCategoryServlet?categoryId=${category.id}">Edit</a>
</td>
<td>
<a href="DeleteCategoryServlet?categoryId=${category.id}">Delete</a>
</td>
</tr>
</c:forEach>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!-- /.container-fluid -->
<!-- End of Main Content -->
<!-- Footer -->
<%@include file="../inc/footer.jsp" %>
<!-- End of Footer -->
</div>
<!-- End of Content Wrapper -->
</div>
<!-- End of Page Wrapper -->
<!-- Scroll to Top Button-->
<a class="scroll-to-top rounded" href="#page-top">
<i class="fas fa-angle-up"></i>
</a>
<!-- Bootstrap core JavaScript-->
<script src="./assets/admin/vendor/jquery/jquery.min.js"></script>
<script src="./assets/admin/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- Core plugin JavaScript-->
<script src="./assets/admin/vendor/jquery-easing/jquery.easing.min.js"></script>
<!-- Custom scripts for all pages-->
<script src="./assets/admin/js/sb-admin-2.min.js"></script>
<!-- Page level plugins -->
<script src="./assets/admin/vendor/chart.js/Chart.min.js"></script>
<!-- Page level custom scripts -->
<script src="./assets/admin/js/demo/chart-area-demo.js"></script>
<script src="./assets/admin/js/demo/chart-pie-demo.js"></script>
</body>
</html>
2.2. Chức năng thêm mới
B1: Tạo controller CreateCategoryServlet kế thừa lớp BaseAdminServlet thực hiện chức năng quản lý trang hiển thị dữ liệu các danh mục
package binh.dev.admin.category;
import java.io.IOException;
import jakarta.servlet.ServletException;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import jakarta.servlet.http.HttpSession;
import binh.dev.BaseServlet;
import binh.dev.data.dao.DatabaseDao;
import binh.dev.data.model.Category;
/**
*
* @author binhdev
*/
public class CreateCategoryServlet extends BaseServlet {
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.getRequestDispatcher("admin/category/create.jsp").include(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
HttpSession session = request.getSession();
String name = request.getParameter("name");
String thumbnail = request.getParameter("thumbnail");
if (name.isEmpty() || thumbnail.isEmpty()) {
session.setAttribute("errorMessage", "Vui lòng điền đầy đủ thông tin đăng ký");
request.getRequestDispatcher("admin/category/create.jsp").forward(request, response);
} else {
Category category = new Category(name, thumbnail);
DatabaseDao.getInstance().getCategoryDao().insert(category);
response.sendRedirect("IndexCategoryServlet");
}
}
}
B2: Tạo tập tin create.jsp trong thư mục web/admin/categories làm chức năng view
<%--
Document : dashboard
Created on : May 23, 2023, 6:10:20 PM
Author : binhdev
--%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="">
<meta name="author" content="">
<title>CornSalad Admin - Dashboard</title>
<!-- Custom fonts for this template-->
<link href="./assets/admin/vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
<link
href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i"
rel="stylesheet">
<!-- Custom styles for t his template-->
<link href="./assets/admin/css/sb-admin-2.min.css" rel="stylesheet">
<link href="./assets/admin/css/style.css" rel="stylesheet">
</head>
<body id="page-top">
<!-- Page Wrapper -->
<div id="wrapper">
<!-- Sidebar -->
<%@include file="../inc/sidebar.jsp" %>
<!-- End of Sidebar -->
<!-- Content Wrapper -->
<div id="content-wrapper" class="d-flex flex-column">
<!-- Topbar -->
<%@include file="../inc/header.jsp" %>
<!-- End of Topbar -->
<!-- Main Content -->
<div class="container-fluid">
<h1 class="h3 mb-2 text-gray-800">Create Category</h1>
<form action="CreateCategoryServlet" method="post">
<div class="form-group">
<label for="exampleInputEmail1">Name</label>
<input type="text" name="name" class="form-control" placeholder="Enter name">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Picture</label>
<input type="text" name="thumbnail" class="form-control" placeholder="Enter link thumbnail">
</div>
<div class="form-text text-muted" >
${errorMessage}
<c:remove var="errorMessage" scope="session" />
</div>
<button type="submit" class="btn btn-primary">Submit</button>
</form>
</div>
<!-- End of Main Content -->
<!-- Footer -->
<%@include file="../inc/footer.jsp" %>
<!-- End of Footer -->
</div>
<!-- End of Content Wrapper -->
</div>
<!-- End of Page Wrapper -->
<!-- Scroll to Top Button-->
<a class="scroll-to-top rounded" href="#page-top">
<i class="fas fa-angle-up"></i>
</a>
<!-- Bootstrap core JavaScript-->
<script src="./assets/admin/vendor/jquery/jquery.min.js"></script>
<script src="./assets/admin/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- Core plugin JavaScript-->
<script src="./assets/admin/vendor/jquery-easing/jquery.easing.min.js"></script>
<!-- Custom scripts for all pages-->
<script src="./assets/admin/js/sb-admin-2.min.js"></script>
<!-- Page level plugins -->
<script src="./assets/admin/vendor/chart.js/Chart.min.js"></script>
<!-- Page level custom scripts -->
<script src="./assets/admin/js/demo/chart-area-demo.js"></script>
<script src="./assets/admin/js/demo/chart-pie-demo.js"></script>
</body>
</html>
2.3. Chức năng cập nhật
B1: Tạo controller EditCategoryServlet kế thừa lớp BaseAdminServlet thực hiện chức năng cập nhật danh mục
package binh.dev.admin.category;
import java.io.IOException;
import jakarta.servlet.ServletException;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import jakarta.servlet.http.HttpSession;
import binh.dev.BaseServlet;
import binh.dev.data.dao.CategoryDao;
import binh.dev.data.dao.DatabaseDao;
import binh.dev.data.model.Category;
/**
*
* @author binhdev
*/
public class EditCategoryServlet extends BaseServlet {
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
HttpSession session = request.getSession();
int categoryId = Integer.parseInt(request.getParameter("categoryId"));
Category category = DatabaseDao.getInstance().getCategoryDao().find(categoryId);
session.setAttribute("category", category);
request.getRequestDispatcher("admin/category/edit.jsp").include(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
CategoryDao categoryDao = DatabaseDao.getInstance().getCategoryDao();
HttpSession session = request.getSession();
int categoryId = Integer.parseInt(request.getParameter("categoryId"));
Category category = categoryDao.find(categoryId);
String name = request.getParameter("name");
String thumbnail = request.getParameter("thumbnail");
category.setName(name);
category.setThumbnail(thumbnail);
if (name.isEmpty() || thumbnail.isEmpty()) {
session.setAttribute("errorMessage", "Vui lòng điền đầy đủ thông tin");
request.getRequestDispatcher("admin/category/edit.jsp").forward(request, response);
} else {
categoryDao.update(category);
response.sendRedirect("IndexCategoryServlet");
}
}
}
B2: Tạo tập tin edit.jsp trong thư mục web/admin/categories làm chức năng view
<%--
Document : dashboard
Created on : May 23, 2023, 6:10:20 PM
Author : binhdev
--%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="">
<meta name="author" content="">
<title>CornSalad Admin - Dashboard</title>
<!-- Custom fonts for this template-->
<link href="./assets/admin/vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
<link
href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i"
rel="stylesheet">
<!-- Custom styles for this template-->
<link href="./assets/admin/css/sb-admin-2.min.css" rel="stylesheet">
<link href="./assets/admin/css/style.css" rel="stylesheet">
</head>
<body id="page-top">
<!-- Page Wrapper -->
<div id="wrapper">
<!-- Sidebar -->
<%@include file="../inc/sidebar.jsp" %>
<!-- End of Sidebar -->
<!-- Content Wrapper -->
<div id="content-wrapper" class="d-flex flex-column">
<!-- Topbar -->
<%@include file="../inc/header.jsp" %>
<!-- End of Topbar -->
<!-- Main Content -->
<div class="container-fluid">
<form action="EditCategoryServlet" method="post">
<input type="hidden" name="categoryId" value="${category.id}">
<div class="form-group">
<label for="exampleInputEmail1">Name</label>
<input type="text" name="name" class="form-control" placeholder="Enter name" value="${category.name}">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Name</label>
<input type="text" name="thumbnail" class="form-control" placeholder="Enter link thumbnail" value="${category.thumbnail}">
</div>
<div class="form-text text-muted" >
${errorMessage}
<c:remove var="errorMessage" scope="session" />
</div>
<button type="submit" class="btn btn-primary">Submit</button>
</form>
</div>
<!-- End of Main Content -->
<!-- Footer -->
<%@include file="../inc/footer.jsp" %>
<!-- End of Footer -->
</div>
<!-- End of Content Wrapper -->
</div>
<!-- End of Page Wrapper -->
<!-- Scroll to Top Button-->
<a class="scroll-to-top rounded" href="#page-top">
<i class="fas fa-angle-up"></i>
</a>
<!-- Bootstrap core JavaScript-->
<script src="./assets/admin/vendor/jquery/jquery.min.js"></script>
<script src="./assets/admin/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- Core plugin JavaScript-->
<script src="./assets/admin/vendor/jquery-easing/jquery.easing.min.js"></script>
<!-- Custom scripts for all pages-->
<script src="./assets/admin/js/sb-admin-2.min.js"></script>
<!-- Page level plugins -->
<script src="./assets/admin/vendor/chart.js/Chart.min.js"></script>
<!-- Page level custom scripts -->
<script src="./assets/admin/js/demo/chart-area-demo.js"></script>
<script src="./assets/admin/js/demo/chart-pie-demo.js"></script>
</body>
</html>
2.3. Chức năng xoá
B1: Tạo controller DeleteCategoryServlet kế thừa lớp BaseAdminServlet thực hiện chức năng xoá danh mục
package binh.dev.admin.category;
import java.io.IOException;
import jakarta.servlet.ServletException;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import binh.dev.BaseServlet;
import binh.dev.data.dao.DatabaseDao;
/**
*
* @author binhdev
*/
public class DeleteCategoryServlet extends BaseServlet {
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
int categoryId = Integer.parseInt(request.getParameter("categoryId"));
DatabaseDao.getInstance().getCategoryDao().delete(categoryId);
response.sendRedirect("IndexCategoryServlet");
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
}
}
B2: Với chức năng xoá thì chúng ta không cần giao diện chỉ sử lý việc xoá dữ liệu xong chuyển hướng trang lại trang index trong method doGet
response.sendRedirect("IndexCategoryServlet");
0 Nhận xét