jsp上传文件到mysql数据库

<form action="upload.jsp" method="post" enctype="multipart/form-data">
  <input type="file" name="file" />
  <input type="submit" value="Upload" />
</form>

<%@ page import="java.io.*, java.sql.*" %>
<%@ page contentType="text/html;charset=UTF-8" %>

<%
  String saveDirectory = "路径/到/临时目录/";
  String filePath = "";

  File fileSaveDir = new File(saveDirectory);
  if (!fileSaveDir.exists()) {
    fileSaveDir.mkdirs();
  }

  for (Part part : request.getParts()) {
    String fileName = extractFileName(part);
    part.write(saveDirectory + File.separator + fileName);
    filePath = saveDirectory + File.separator + fileName;
  }

  // 这里可以添加对文件的处理逻辑，例如文件格式验证、文件大小限制等

  // 将文件路径保存到数据库中
  String url = "jdbc:mysql://数据库主机地址:端口/数据库名";
  String username = "用户名";
  String password = "密码";

  try {
    Class.forName("com.mysql.jdbc.Driver");
    Connection con = DriverManager.getConnection(url, username, password);
    String query = "INSERT INTO files (file_path) VALUES (?)";
    PreparedStatement pst = con.prepareStatement(query);
    pst.setString(1, filePath);
    pst.executeUpdate();
    pst.close();
    con.close();
  } catch (Exception e) {
    e.printStackTrace();
  }

  out.println("文件上传成功！");
%>

<%
  // 从Part中提取文件名
  private static String extractFileName(Part part) {
    String contentDisp = part.getHeader("content-disposition");
    String[] items = contentDisp.split(";");
    for (String item : items) {
      if (item.trim().startsWith("filename")) {
        return item.substring(item.indexOf("=") + 2, item.length() - 1);
      }
    }
    return "";
  }
%>