jsp动态导航菜单

CREATE TABLE menu (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    url VARCHAR(200),
    parent_id INT
);

<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>

<%
    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;
    List<Map<String, String>> menuItems = new ArrayList<>();

    try {
        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", "username", "password");
        stmt = conn.createStatement();
        rs = stmt.executeQuery("SELECT * FROM menu WHERE parent_id IS NULL");

        while (rs.next()) {
            Map<String, String> item = new HashMap<>();
            item.put("name", rs.getString("name"));
            item.put("url", rs.getString("url"));
            menuItems.add(item);
        }
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        if (rs != null) rs.close();
        if (stmt != null) stmt.close();
        if (conn != null) conn.close();
    }
%>

<ul>
    <% for (Map<String, String> item : menuItems) { %>
        <li><a href="<%= item.get("url") %>"><%= item.get("name") %></a></li>
    <% } %>
</ul>