DNchngguo/sql/CheckAllMenuEntries.java

import java.sql.*;

public class CheckAllMenuEntries {
    public static void main(String[] args) {
        String url = "jdbc:dm://192.168.0.145:30236";
        String username = "WATERSHED";
        String password = "WaterShed./1224";
        
        try {
            // 加载DM JDBC驱动
            Class.forName("dm.jdbc.driver.DmDriver");
            
            // 建立数据库连接
            Connection conn = DriverManager.getConnection(url, username, password);
            System.out.println("数据库连接成功！");
            
            // 查询所有菜单项
            String sql = "SELECT menu_id, menu_name, parent_id, order_num, path, component, menu_type, visible, status, perms, icon FROM SYS_MENU ORDER BY menu_id";
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery(sql);
            
            System.out.println("\n所有菜单项:");
            System.out.println("ID\t名称\t\t\t父ID\t顺序\t路径\t\t组件\t类型");
            System.out.println("--------------------------------------------------------------------------------");
            
            int count = 0;
            while (rs.next()) {
                int menuId = rs.getInt("menu_id");
                String menuName = rs.getString("menu_name");
                int parentId = rs.getInt("parent_id");
                int orderNum = rs.getInt("order_num");
                String path = rs.getString("path");
                String component = rs.getString("component");
                String menuType = rs.getString("menu_type");
                
                System.out.printf("%d\t%-15s\t%d\t%d\t%-15s\t%-15s\t%s\n", 
                    menuId, menuName, parentId, orderNum, path, component, menuType);
                count++;
            }
            
            System.out.println("\n总菜单项数: " + count);
            
            // 查询最大菜单ID
            String maxIdSql = "SELECT MAX(menu_id) as max_id FROM SYS_MENU";
            ResultSet rs2 = stmt.executeQuery(maxIdSql);
            if (rs2.next()) {
                int maxId = rs2.getInt("max_id");
                System.out.println("最大菜单ID: " + maxId);
            }
            
            // 关闭连接
            rs.close();
            rs2.close();
            stmt.close();
            conn.close();
            
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}