jsp mysql存储图片路径

CREATE TABLE images (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    path VARCHAR(255)
);

<%@ page import="java.sql.*" %>
<%
    String name = request.getParameter("name");
    String path = request.getParameter("path");

    Connection conn = null;
    PreparedStatement pstmt = null;

    try {
        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");

        String sql = "INSERT INTO images (name, path) VALUES (?, ?)";
        pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, name);
        pstmt.setString(2, path);
        pstmt.executeUpdate();

        out.println("图片路径存储成功！");
    } catch (Exception e) {
        out.println("存储失败：" + e.getMessage());
    } finally {
        if (pstmt != null) pstmt.close();
        if (conn != null) conn.close();
    }
%>