DNchngguo/sql/CheckTables.java

import java.sql.*;
import java.util.*;

public class CheckTables {
    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("数据库连接成功！");
            
            // 获取所有表名
            DatabaseMetaData metaData = conn.getMetaData();
            ResultSet tables = metaData.getTables(null, null, "%", new String[] {"TABLE"});
            
            List<String> menuTables = new ArrayList<>();
            List<String> roleTables = new ArrayList<>();
            
            while (tables.next()) {
                String tableName = tables.getString("TABLE_NAME");
                if (tableName.toUpperCase().contains("MENU")) {
                    menuTables.add(tableName);
                }
                if (tableName.toUpperCase().contains("ROLE") && tableName.toUpperCase().contains("MENU")) {
                    roleTables.add(tableName);
                }
            }
            
            System.out.println("包含MENU的表名:");
            for (String table : menuTables) {
                System.out.println("  " + table);
            }
            
            System.out.println("\n包含ROLE和MENU的表名:");
            for (String table : roleTables) {
                System.out.println("  " + table);
            }
            
            // 关闭连接
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}