jsp从mysql获取图片路径

<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>图片路径展示</title>
</head>
<body>
    <h1>图片路径列表</h1>
    <ul>
        <%
            // 加载JDBC驱动
            Class.forName("com.mysql.jdbc.Driver");
            // 获取数据库连接
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "password");
            // 创建SQL查询语句
            String sql = "SELECT path FROM images";
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery(sql);
            // 处理查询结果
            while (rs.next()) {
                String path = rs.getString("path");
        %>
        <li><img src="<%= path %>" alt="图片"></li>
        <%
            }
            // 关闭资源
            rs.close();
            stmt.close();
            conn.close();
        %>
    </ul>
</body>
</html>