jsp文件上传mysql

<%@ page import="java.io.*, java.sql.*, javax.servlet.http.*" %>
<%
    String uploadPath = application.getRealPath("/uploads");
    File fileUploadDir = new File(uploadPath);
    if (!fileUploadDir.exists()) fileUploadDir.mkdir();

    Part filePart = request.getPart("file");
    String fileName = getFileName(filePart);
    String filePath = uploadPath + File.separator + fileName;

    try (InputStream fileContent = filePart.getInputStream();
         OutputStream out = new FileOutputStream(filePath)) {
        byte[] buffer = new byte[1024];
        int bytesRead;
        while ((bytesRead = fileContent.read(buffer)) != -1) {
            out.write(buffer, 0, bytesRead);
        }
    } catch (IOException e) {
        e.printStackTrace();
    }

    // 存储文件元数据到MySQL数据库
    String url = "jdbc:mysql://localhost:3306/mydatabase";
    String username = "user";
    String password = "password";
    try (Connection conn = DriverManager.getConnection(url, username, password)) {
        String sql = "INSERT INTO files (filename, filepath) VALUES (?, ?)";
        try (PreparedStatement pstmt = conn.prepareStatement(sql)) {
            pstmt.setString(1, fileName);
            pstmt.setString(2, filePath);
            pstmt.executeUpdate();
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
%>

<%!
    private String getFileName(Part part) {
        for (String content : part.getHeader("content-disposition").split(";")) {
            if (content.trim().startsWith("filename")) {
                return content.substring(content.indexOf('=') + 1).trim().replace("\"", "");
            }
        }
        return null;
    }
%>