jsp上传图片 mysql

// 示例代码：保存图片并记录路径到数据库
<%@ page import="java.io.*, java.sql.*, javax.servlet.http.*, javax.servlet.annotation.MultipartConfig" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
    Part filePart = request.getPart("file");
    String fileName = getFileName(filePart);
    String filePath = "/path/to/save/" + fileName;
    filePart.write(filePath);

    // 保存路径到数据库
    String url = "jdbc:mysql://localhost:3306/mydatabase";
    String user = "username";
    String password = "password";
    try (Connection conn = DriverManager.getConnection(url, user, password)) {
        String sql = "INSERT INTO images (name, path) 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;
}

<!-- 示例：修改Tomcat的server.xml -->
<Connector port="8080" protocol="HTTP/1.1"
           connectionTimeout="20000"
           redirectPort="8443"
           maxPostSize="10485760" /> <!-- 10MB -->

// 示例代码：检查文件类型
private boolean isValidFileType(Part part) {
    String contentType = part.getContentType();
    return contentType != null && (contentType.startsWith("image/jpeg") || contentType.startsWith("image/png"));
}