• 若依必须声明标量变量 "@parentId"。


    -- 菜单 SQL
    insert into sys_menu (menu_name, parent_id, order_num, url, menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
    values('全数据', '2058', '1', '/jyreports/jyreportsManage', 'C', '0', 'jyreports:jyreportsManage:view', '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '全数据菜单');
    
    -- 按钮父菜单ID
    SELECT @parentId := LAST_INSERT_ID();
    
    -- 按钮 SQL
    insert into sys_menu (menu_name, parent_id, order_num, url, menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
    values('全数据查询', @parentId, '1',  '#',  'F', '0', 'jyreports:jyreportsManage:list',         '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');
    
    insert into sys_menu (menu_name, parent_id, order_num, url, menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
    values('全数据新增', @parentId, '2',  '#',  'F', '0', 'jyreports:jyreportsManage:add',          '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');
    
    insert into sys_menu (menu_name, parent_id, order_num, url, menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
    values('全数据修改', @parentId, '3',  '#',  'F', '0', 'jyreports:jyreportsManage:edit',         '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');
    
    insert into sys_menu (menu_name, parent_id, order_num, url, menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
    values('全数据删除', @parentId, '4',  '#',  'F', '0', 'jyreports:jyreportsManage:remove',       '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');
    
    insert into sys_menu (menu_name, parent_id, order_num, url, menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
    values('全数据导出', @parentId, '5',  '#',  'F', '0', 'jyreports:jyreportsManage:export',       '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');

    解决办法

    -- 菜单 SQL
    insert into sys_menu (menu_name, parent_id, order_num, url, menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
    values('全数据', '2058', '1', '/jyreports/jyreportsManage', 'C', '0', 'jyreports:jyreportsManage:view', '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '全数据菜单');
    
    -- 按钮父菜单ID
    --SELECT @parentId := LAST_INSERT_ID();
    declare @parentId int;
    -- 按钮父菜单ID
    select parentId = @@IDENTITY;
    -- 按钮 SQL
    insert into sys_menu (menu_name, parent_id, order_num, url, menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
    values('全数据查询', @parentId, '1',  '#',  'F', '0', 'jyreports:jyreportsManage:list',         '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');
    
    insert into sys_menu (menu_name, parent_id, order_num, url, menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
    values('全数据新增', @parentId, '2',  '#',  'F', '0', 'jyreports:jyreportsManage:add',          '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');
    
    insert into sys_menu (menu_name, parent_id, order_num, url, menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
    values('全数据修改', @parentId, '3',  '#',  'F', '0', 'jyreports:jyreportsManage:edit',         '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');
    
    insert into sys_menu (menu_name, parent_id, order_num, url, menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
    values('全数据删除', @parentId, '4',  '#',  'F', '0', 'jyreports:jyreportsManage:remove',       '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');
    
    insert into sys_menu (menu_name, parent_id, order_num, url, menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
    values('全数据导出', @parentId, '5',  '#',  'F', '0', 'jyreports:jyreportsManage:export',       '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');
  • 相关阅读:
    C#实体类对象修改日志记录
    C#中关于增强类功能的几种方式
    Elasticsearch入坑指南之RESTful API
    React入门实例
    .Net Core+Vue.js+ElementUI 实现前后端分离
    ElasticSearch入坑指南之概述及安装
    MySQL优化技巧
    RabbitMQ入门教程——路由(Routing)
    RabbitMQ入门教程——发布/订阅
    RabbitMQ入门教程——工作队列
  • 原文地址:https://www.cnblogs.com/springcloud/p/16135391.html
Copyright © 2020-2023  润新知