DNchngguo/sql/CheckMenuEntries.java

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class CheckMenuEntries {
    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 WHERE menu_id >= 2000 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类型\t权限标识");
            System.out.println("--------------------------------------------------------------------------------------------");
            
            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");
                String perms = rs.getString("perms");
                
                System.out.printf("%d\t%-15s\t%d\t%d\t%-15s\t%-15s\t%s\t%s\n", 
                    menuId, menuName, parentId, orderNum, path, component, menuType, perms);
            }
            
            // 查询角色菜单关联
            String roleMenuSql = "SELECT role_id, menu_id FROM SYS_ROLE_MENU WHERE menu_id >= 2000 ORDER BY menu_id";
            ResultSet rs2 = stmt.executeQuery(roleMenuSql);
            
            System.out.println("\n角色菜单关联:");
            System.out.println("角色ID\t菜单ID");
            System.out.println("----------------");
            
            while (rs2.next()) {
                int roleId = rs2.getInt("role_id");
                int menuId = rs2.getInt("menu_id");
                System.out.printf("%d\t%d\n", roleId, menuId);
            }
            
            // 关闭连接
            rs.close();
            rs2.close();
            stmt.close();
            conn.close();
            
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}