冲刺博客1

1.昨天的成就
完成了运维管理子系统设备故障管理和维修工单管理的开发
2.遇到的困难
上传图片时无法自动检测图片模糊程度并驳回图片
3.今天的任务
完成巡检计划管理和巡检工单管理的开发
4.代码嵌入：
package com.yunwei.servlet;

import com.yunwei.model.EquipmentFault;
import com.yunwei.util.DBUtil;
import com.yunwei.util.ImageUtil;

import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.MultipartConfig;
import jakarta.servlet.annotation.WebServlet;
import jakarta.servlet.http.;
import java.io.File;
import java.io.IOException;
import java.sql.;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.ArrayList;
import java.util.List;

@MultipartConfig(maxFileSize = 5 * 1024 * 1024, maxRequestSize = 20 * 1024 * 1024)
@WebServlet("/fault/*")
public class EquipmentFaultServlet extends HttpServlet {
private static final DateTimeFormatter DTF = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");

@Override
protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String pathInfo = req.getPathInfo();
if (pathInfo == null) pathInfo = "/list";
switch (pathInfo) {
case "/list" -> list(req, resp);
case "/add" -> add(req, resp);
case "/edit" -> edit(req, resp);
case "/delete" -> delete(req, resp);
case "/detail" -> detail(req, resp);
case "/batchDelete" -> batchDelete(req, resp);
default -> list(req, resp);
}
}

private void list(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String keyword = req.getParameter("keyword");
String deviceType = req.getParameter("deviceType");
String status = req.getParameter("status");
String pageStr = req.getParameter("page");
int page = 1;
if (pageStr != null && !pageStr.isEmpty()) page = Integer.parseInt(pageStr);
int pageSize = 10;

StringBuilder sql = new StringBuilder("SELECT * FROM equipment_fault WHERE 1=1");
List