DNchngguo/sql/InsertMenuDirectly.java

import java.sql.*;

public class InsertMenuDirectly {
    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 = "INSERT INTO SYS_MENU (menu_id, menu_name, parent_id, order_num, path, component, menu_type, visible, status, perms, icon) " +
                         "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
            PreparedStatement pstmt = conn.prepareStatement(sql);
            
            // 1. 添加流域管理主菜单
            pstmt.setInt(1, 2000);
            pstmt.setString(2, "流域管理");
            pstmt.setInt(3, 0);
            pstmt.setInt(4, 1);
            pstmt.setString(5, "watershed");
            pstmt.setString(6, null);
            pstmt.setString(7, "M");
            pstmt.setString(8, "0");
            pstmt.setString(9, "0");
            pstmt.setString(10, "");
            pstmt.setString(11, "water");
            pstmt.executeUpdate();
            System.out.println("成功添加流域管理主菜单");
            
            // 2. 添加流域平台子菜单
            pstmt.setInt(1, 2001);
            pstmt.setString(2, "流域平台");
            pstmt.setInt(3, 2000);
            pstmt.setInt(4, 1);
            pstmt.setString(5, "hydrological");
            pstmt.setString(6, "watershed/hydrological/index");
            pstmt.setString(7, "C");
            pstmt.setString(8, "0");
            pstmt.setString(9, "0");
            pstmt.setString(10, "watershed:hydrological:list");
            pstmt.setString(11, "monitor");
            pstmt.executeUpdate();
            System.out.println("成功添加流域平台子菜单");
            
            // 3. 添加机电设备管理子菜单
            pstmt.setInt(1, 2002);
            pstmt.setString(2, "机电设备");
            pstmt.setInt(3, 2000);
            pstmt.setInt(4, 2);
            pstmt.setString(5, "equipment");
            pstmt.setString(6, "watershed/equipment/index");
            pstmt.setString(7, "C");
            pstmt.setString(8, "0");
            pstmt.setString(9, "0");
            pstmt.setString(10, "watershed:equipment:list");
            pstmt.setString(11, "list");
            pstmt.executeUpdate();
            System.out.println("成功添加机电设备管理子菜单");
            
            // 4. 添加流域模型子菜单
            pstmt.setInt(1, 2003);
            pstmt.setString(2, "流域模型");
            pstmt.setInt(3, 2000);
            pstmt.setInt(4, 3);
            pstmt.setString(5, "model");
            pstmt.setString(6, "watershed/model/index");
            pstmt.setString(7, "C");
            pstmt.setString(8, "0");
            pstmt.setString(9, "0");
            pstmt.setString(10, "watershed:model:list");
            pstmt.setString(11, "build");
            pstmt.executeUpdate();
            System.out.println("成功添加流域模型子菜单");
            
            // 5. 添加水利设施子菜单
            pstmt.setInt(1, 2004);
            pstmt.setString(2, "水利设施");
            pstmt.setInt(3, 2000);
            pstmt.setInt(4, 4);
            pstmt.setString(5, "facility");
            pstmt.setString(6, "watershed/facility/index");
            pstmt.setString(7, "C");
            pstmt.setString(8, "0");
            pstmt.setString(9, "0");
            pstmt.setString(10, "watershed:facility:list");
            pstmt.setString(11, "tree");
            pstmt.executeUpdate();
            System.out.println("成功添加水利设施子菜单");
            
            // 6. 添加实时监控子菜单
            pstmt.setInt(1, 2005);
            pstmt.setString(2, "实时监控");
            pstmt.setInt(3, 2000);
            pstmt.setInt(4, 5);
            pstmt.setString(5, "monitor");
            pstmt.setString(6, "watershed/monitor/index");
            pstmt.setString(7, "C");
            pstmt.setString(8, "0");
            pstmt.setString(9, "0");
            pstmt.setString(10, "watershed:monitor:list");
            pstmt.setString(11, "chart");
            pstmt.executeUpdate();
            System.out.println("成功添加实时监控子菜单");
            
            // 关闭连接
            pstmt.close();
            conn.close();
            
            System.out.println("所有菜单项添加完成！");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}