将json菜单保存到数据库代码

/**
     * 将json菜单保存到数据库
     *
     * @return
     */
    @RequestMapping("save/menu")
    @ResponseBody
    public Map<String, Object> menu() {
        String jsonStr = "{\n" +
                "    \"data\": {\n" +
                "        \"list\": [{\n" +
                "                \"id\": 1,\n" +
                "                \"url\": \"gzt\",\n" +
                "                \"name\": \"工作台\",\n" +
                "                \"iconfont\": \"\",\n" +
                "                \"sub\": [{\n" +
                "                    \"id\":11,\n" +
                "                    \"url\": \"kfsh\",\n" +
                "                    \"name\": \"客服售后\",\n" +
                "                    \"iconfont\": \"\",\n" +
                "                    \"sub\": [{\n" +
                "                            \"id\": 1101,\n" +
                "                            \"url\": \"kfsh/ddgl\",\n" +
                "                            \"name\": \"订单管理\",\n" +
                "                            \"iconfont\": \"\"\n" +
                "                        },\n" +
                "                        {\n" +
                "                            \"id\": 1102,\n" +
                "                            \"url\": \"kfsh/pjgl\",\n" +
                "                            \"name\": \"评价管理\",\n" +
                "                            \"iconfont\": \"\"\n" +
                "                        },\n" +
                "                        {\n" +
                "                            \"id\": 1103,\n" +
                "                            \"url\": \"kfsh/tscl\",\n" +
                "                            \"name\": \"投诉处理\",\n" +
                "                            \"iconfont\": \"\"\n" +
                "                        },\n" +
                "                        {\n" +
                "                            \"id\": 1104,\n" +
                "                            \"url\": \"kfsh/tkgl\",\n" +
                "                            \"name\": \"退款管理\",\n" +
                "                            \"iconfont\": \"\"\n" +
                "                        }\n" +
                "                    ]\n" +
                "                },\n" +
                "                {\n" +
                "                    \"id\": 12,\n" +
                "                    \"url\": \"yggl\",\n" +
                "                    \"name\": \"员工管理\",\n" +
                "                    \"iconfont\": \"\",\n" +
                "                    \"sub\": [{\n" +
                "                            \"id\": 1201,\n" +
                "                            \"url\": \"yggl/yglb\",\n" +
                "                            \"name\": \"员工列表\",\n" +
                "                            \"iconfont\": \"\"\n" +
                "                          },\n" +
                "                          {\n" +
                "                            \"id\": 1203,\n" +
                "                            \"url\": \"yggl/yggl\",\n" +
                "                            \"name\": \"员工管理\",\n" +
                "                            \"iconfont\": \"\"\n" +
                "                          }\n" +
                "                    ]\n" +
                "                  },\n" +
                "                  {\n" +
                "                    \"id\": 13,\n" +
                "                    \"url\": \"gzgl\",\n" +
                "                    \"name\": \"工作管理\",\n" +
                "                    \"iconfont\": \"\",\n" +
                "                    \"sub\": [{\n" +
                "                            \"id\": 1301,\n" +
                "                            \"url\": \"gzgl/kjgl\",\n" +
                "                            \"name\": \"卡卷管理\",\n" +
                "                            \"iconfont\": \"\"\n" +
                "                          },\n" +
                "                            {\n" +
                "                              \"id\": 1302,\n" +
                "                              \"url\": \"gzgl/xtgg\",\n" +
                "                              \"name\": \"系统公告\",\n" +
                "                              \"iconfont\": \"\"\n" +
                "                            },\n" +
                "                            {\n" +
                "                              \"id\": 1303,\n" +
                "                              \"url\": \"gzgl/xtgug\",\n" +
                "                              \"name\": \"系统广告\",\n" +
                "                              \"iconfont\": \"\"\n" +
                "                            }\n" +
                "                    ]\n" +
                "                  },\n" +
                "                  {\n" +
                "                    \"id\": 14,\n" +
                "                    \"url\": \"cwgl\",\n" +
                "                    \"name\": \"财务管理\",\n" +
                "                    \"iconfont\": \"\",\n" +
                "                    \"sub\": [{\n" +
                "                            \"id\": 1401,\n" +
                "                            \"url\": \"cwgl/jsgl\",\n" +
                "                            \"name\": \"结算管理\",\n" +
                "                            \"iconfont\": \"\"\n" +
                "                          },\n" +
                "                            {\n" +
                "                              \"id\": 1402,\n" +
                "                              \"url\": \"cwgl/mdzw\",\n" +
                "                              \"name\": \"门店账务\",\n" +
                "                              \"iconfont\": \"\"\n" +
                "                            },\n" +
                "                            {\n" +
                "                              \"id\": 1403,\n" +
                "                              \"url\": \"cwgl/lszw\",\n" +
                "                              \"name\": \"历史账务\",\n" +
                "                              \"iconfont\": \"\"\n" +
                "                            },\n" +
                "                            {\n" +
                "                              \"id\": 1404,\n" +
                "                              \"url\": \"cwgl/cwfx\",\n" +
                "                              \"name\": \"财务分析\",\n" +
                "                              \"iconfont\": \"\"\n" +
                "                            },\n" +
                "                            {\n" +
                "                              \"id\": 1405,\n" +
                "                              \"url\": \"cwgl/ywfx\",\n" +
                "                              \"name\": \"业务分析\",\n" +
                "                              \"iconfont\": \"\"\n" +
                "                            },\n" +
                "                            {\n" +
                "                              \"id\": 1406,\n" +
                "                              \"url\": \"cwgl/pjfx\",\n" +
                "                              \"name\": \"评价分析\",\n" +
                "                              \"iconfont\": \"\"\n" +
                "                            },\n" +
                "                            {\n" +
                "                              \"id\": 1407,\n" +
                "                              \"url\": \"cwgl/yyfx\",\n" +
                "                              \"name\": \"营业分析\",\n" +
                "                              \"iconfont\": \"\"\n" +
                "                            }\n" +
                "                    ]\n" +
                "                  },\n" +
                "                  {\n" +
                "                    \"id\": 15,\n" +
                "                    \"url\": \"qygl\",\n" +
                "                    \"name\": \"区域管理\",\n" +
                "                    \"iconfont\": \"\",\n" +
                "                    \"sub\": [{\n" +
                "                            \"id\": 1501,\n" +
                "                            \"url\": \"qygl/mdgl\",\n" +
                "                            \"name\": \"门店管理\",\n" +
                "                            \"iconfont\": \"\"\n" +
                "                          },\n" +
                "                            {\n" +
                "                              \"id\": 1502,\n" +
                "                              \"url\": \"qygl/ddgl\",\n" +
                "                              \"name\": \"订单管理\",\n" +
                "                              \"iconfont\": \"\"\n" +
                "                            },\n" +
                "                            {\n" +
                "                              \"id\": 1503,\n" +
                "                              \"url\": \"qygl/cwgl\",\n" +
                "                              \"name\": \"财务管理\",\n" +
                "                              \"iconfont\": \"\"\n" +
                "                            },\n" +
                "                            {\n" +
                "                              \"id\": 1504,\n" +
                "                              \"url\": \"qygl/pjck\",\n" +
                "                              \"name\": \"评价查看\",\n" +
                "                              \"iconfont\": \"\"\n" +
                "                            }\n" +
                "                    ]\n" +
                "                  }]\n" +
                "            },\n" +
                "            {\n" +
                "                \"id\": 2,\n" +
                "                \"url\": \"mdgl\",\n" +
                "                \"name\": \"门店管理\",\n" +
                "                \"iconfont\": \"\",\n" +
                "                \"sub\": [{\n" +
                "                        \"id\": 21,\n" +
                "                        \"url\": \"mdgl/mdlb\",\n" +
                "                        \"name\": \"门店列表\",\n" +
                "                        \"iconfont\": \"\"\n" +
                "                    },\n" +
                "                    {\n" +
                "                        \"id\": 22,\n" +
                "                        \"url\": \"mdgl/ywgl\",\n" +
                "                        \"name\": \"业务管理\",\n" +
                "                        \"iconfont\": \"\"\n" +
                "                    },\n" +
                "                    {\n" +
                "                        \"id\": 23,\n" +
                "                        \"url\": \"mdgl/tcgl\",\n" +
                "                        \"name\": \"套餐管理\",\n" +
                "                        \"iconfont\": \"\"\n" +
                "\n" +
                "                    },\n" +
                "                    {\n" +
                "                        \"id\": 24,\n" +
                "                        \"url\": \"mdgl/mdzk\",\n" +
                "                        \"name\": \"门店折扣\",\n" +
                "                        \"iconfont\": \"\"\n" +
                "                    },\n" +
                "                    {\n" +
                "                        \"id\": 25,\n" +
                "                        \"url\": \"mdgl/czsz\",\n" +
                "                        \"name\": \"充值设置\",\n" +
                "                        \"iconfont\": \"\"\n" +
                "                    },\n" +
                "                    {\n" +
                "                        \"id\": 26,\n" +
                "                        \"url\": \"mdgl/spgl\",\n" +
                "                        \"name\": \"商品管理\",\n" +
                "                        \"iconfont\": \"\"\n" +
                "\n" +
                "                    },\n" +
                "                    {\n" +
                "                      \"id\": 27,\n" +
                "                      \"url\": \"mdgl/qygl\",\n" +
                "                      \"name\": \"区域管理\",\n" +
                "                      \"iconfont\": \"\"\n" +
                "\n" +
                "                    }\n" +
                "                ]\n" +
                "            },\n" +
                "            {\n" +
                "                \"id\": 3,\n" +
                "                \"url\": \"hygl\",\n" +
                "                \"name\": \"会员管理\",\n" +
                "                \"iconfont\": \"\",\n" +
                "                \"sub\": [{\n" +
                "                    \"id\": 31,\n" +
                "                    \"url\": \"hygl/hylb\",\n" +
                "                    \"name\": \"会员列表\",\n" +
                "                    \"iconfont\": \"\"\n" +
                "                  },\n" +
                "                  {\n" +
                "                    \"id\": 32,\n" +
                "                    \"url\": \"hygl/hydj\",\n" +
                "                    \"name\": \"会员等级\",\n" +
                "                    \"iconfont\": \"\"\n" +
                "                  },\n" +
                "                  {\n" +
                "                    \"id\": 33,\n" +
                "                    \"url\": \"hygl/hytj\",\n" +
                "                    \"name\": \"会员统计\",\n" +
                "                    \"iconfont\": \"\"\n" +
                "                  }]\n" +
                "            },\n" +
                "            {\n" +
                "                \"id\": 4,\n" +
                "                \"url\": \"xtgl\",\n" +
                "                \"name\": \"系统管理\",\n" +
                "                \"iconfont\": \"\",\n" +
                "                \"sub\": [{\n" +
                "                        \"id\": 41,\n" +
                "                        \"url\": \"xtgl/xtgl\",\n" +
                "                        \"name\": \"系统管理\",\n" +
                "                        \"iconfont\": \"\",\n" +
                "                        \"sub\": [\n" +
                "                            {\n" +
                "                                \"id\": 4102,\n" +
                "                                \"url\": \"xtgl/xtrz\",\n" +
                "                                \"name\": \"系统日志\",\n" +
                "                                \"iconfont\": \"\"\n" +
                "                            },\n" +
                "                            {\n" +
                "                                \"id\": 4103,\n" +
                "                                \"url\": \"xtgl/cdgl\",\n" +
                "                                \"name\": \"菜单管理\",\n" +
                "                                \"iconfont\": \"\"\n" +
                "                            },\n" +
                "                            {\n" +
                "                                \"id\": 4104,\n" +
                "                                \"url\": \"xtgl/pbc\",\n" +
                "                                \"name\": \"屏蔽词\",\n" +
                "                                \"iconfont\": \"\"\n" +
                "                            }\n" +
                "                        ]\n" +
                "                    },\n" +
                "                    {\n" +
                "                        \"id\": 42,\n" +
                "                        \"url\": \"qxgl\",\n" +
                "                        \"name\": \"权限管理\",\n" +
                "                        \"iconfont\": \"\",\n" +
                "                        \"sub\": [{\n" +
                "                                \"id\": 4201,\n" +
                "                                \"url\": \"qxgl/jsgl\",\n" +
                "                                \"name\": \"角色管理\",\n" +
                "                                \"iconfont\": \"\"\n" +
                "                            },\n" +
                "                            {\n" +
                "                                \"id\": 4202,\n" +
                "                                \"url\": \"qxgl/qxsz\",\n" +
                "                                \"name\": \"权限设置\",\n" +
                "                                \"iconfont\": \"\"\n" +
                "                            },\n" +
                "                            {\n" +
                "                                \"id\": 4203,\n" +
                "                                \"url\": \"qxgl/gly\",\n" +
                "                                \"name\": \"管理员\",\n" +
                "                                \"iconfont\": \"\"\n" +
                "                            }\n" +
                "                        ]\n" +
                "                    },\n" +
                "                    {\n" +
                "                        \"id\": 43,\n" +
                "                        \"url\": \"xtsj\",\n" +
                "                        \"name\": \"系统数据\",\n" +
                "                        \"iconfont\": \"\",\n" +
                "                        \"sub\": [{\n" +
                "                                \"id\": 4301,\n" +
                "                                \"url\": \"xtsj/xtyw\",\n" +
                "                                \"name\": \"系统业务\",\n" +
                "                                \"iconfont\": \"\"\n" +
                "                              },\n" +
                "                                {\n" +
                "                                  \"id\": 4302,\n" +
                "                                  \"url\": \"xtsj/ywfl\",\n" +
                "                                  \"name\": \"业务分类\",\n" +
                "                                  \"iconfont\": \"\"\n" +
                "                                },\n" +
                "                                {\n" +
                "                                  \"id\": 4303,\n" +
                "                                  \"url\": \"xtsj/cxcx\",\n" +
                "                                  \"name\": \"车型车系\",\n" +
                "                                  \"iconfont\": \"\"\n" +
                "                                },\n" +
                "                                {\n" +
                "                                \"id\": 4101,\n" +
                "                                \"url\": \"xtgl/dictionary\",\n" +
                "                                \"name\": \"数据字典\",\n" +
                "                                \"iconfont\": \"\"\n" +
                "                             }\n" +
                "                                \n" +
                "                        ]\n" +
                "                    }\n" +
                "                ]\n" +
                "            }\n" +
                "        ]\n" +
                "    },\n" +
                "    \"status\": 200\n" +
                "}";
        JSONObject jsStr = JSONObject.parseObject(jsonStr);
        Map<String, Object> map = (Map<String, Object>) jsStr.get("data");
        List<Object> list = (List<Object>) map.get("list");
        try {
            for (Object menu1 : list) {
                SysMenu menu = new SysMenu();
                JSONObject jsonObject = JSONObject.parseObject(menu1.toString());
                System.out.println("" + jsonObject.get("url").toString());
                menu.setMenuUrl(jsonObject.get("url").toString());
                menu.setMenuIcon(jsonObject.get("iconfont").toString());
                menu.setMenuName(jsonObject.get("name").toString());
                menu.setParentId("0");
                //保存
                SysMenu sysMenu = sysMenuService.saveEntity(menu);//保存save(menu)
                List<Object> list1 = (List<Object>) jsonObject.get("sub");
                if (list1.size() > 0) {
                    for (Object menu2 : list1) {
                        JSONObject jsonObject1 = JSONObject.parseObject(menu2.toString());
                        System.out.println("    " + jsonObject1.get("url").toString());
                        SysMenu m1 = new SysMenu();
                        m1.setMenuUrl(jsonObject1.get("url").toString());
                        m1.setMenuIcon(jsonObject1.get("iconfont").toString());
                        m1.setMenuName(jsonObject1.get("name").toString());
                        m1.setParentId(sysMenu.getMenuId() + "");
                        //保存

                        SysMenu sysMenu1 = sysMenuService.saveEntity(m1);//保存save(m1)


                        List<Object> list3 = (List<Object>) jsonObject1.get("sub");
                        if (list3 != null) {
                            for (Object menu3 : list3) {
                                JSONObject jsonObject2 = JSONObject.parseObject(menu3.toString());
                                System.out.println("        " + jsonObject2.get("url").toString());

                                SysMenu m2 = new SysMenu();
                                m2.setMenuUrl(jsonObject2.get("url").toString());
                                m2.setMenuIcon(jsonObject2.get("iconfont").toString());
                                m2.setMenuName(jsonObject2.get("name").toString());
                                m2.setParentId(sysMenu1.getMenuId() + "");
                                sysMenuService.saveEntity(m2);
                            }
                        }
                    }
                }
            }

        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
### 回答1: 使用Python编写这样一个代码需要掌握基本的Python编程知识,以及数据存储和认证验证等方面的专业知识。首先,需要编写用于注册和登录的前端页面,然后把这些信息存储到数据库中,最后在登录时,根据数据库中的信息进行验证。 ### 回答2: 下面是一个用Python编写的简单的登录注册系统的代码示例: ```python import json def register(): username = input("请输入用户名:") password = input("请输入密码:") user_info = {username: password} # 读取已存在的用户信息 try: with open('users.json', 'r') as f: existing_users = json.load(f) except FileNotFoundError: existing_users = {} # 检查用户名是否已存在 if username in existing_users: print("该用户名已被注册,请重新选择一个用户名。") else: # 将新用户信息加入已存在的用户信息中 existing_users.update(user_info) # 保存用户信息到文件中 with open('users.json', 'w') as f: json.dump(existing_users, f) print("注册成功!") def login(): username = input("请输入用户名:") password = input("请输入密码:") # 读取已存在的用户信息 try: with open('users.json', 'r') as f: existing_users = json.load(f) except FileNotFoundError: existing_users = {} # 检验用户名和密码是否匹配 if username in existing_users and existing_users[username] == password: print(f"欢迎回来,{username}!") else: print("用户名或密码错误。") menu = """ 1. 注册 2. 登录 3. 退出 """ while True: print(menu) choice = input("请选择操作: ") if choice == "1": register() elif choice == "2": login() elif choice == "3": break else: print("无效的选择,请重新输入。") ``` 该代码使用`json`模块来读取和保存用户信息,用户信息以字典的形式保存在文件`users.json`中。在注册时,会检查输入的用户名是否已存在,如果不存在则添加用户信息并保存到文件中。在登录时,会检验输入的用户名和密码与文件中保存的信息是否匹配。运行代码后,会出现一个简单的菜单供用户选择注册、登录或退出操作。 ### 回答3: 下面是一个用Python写的具有登录、注册和保存注册信息的代码。该代码将用户输入的用户名和密码保存到一个字典中,并在用户登录时检验对应信息是否正确。 ```python import json def register(users): username = input("请输入用户名: ") while username in users: print("该用户名已存在,请重新输入!") username = input("请输入用户名: ") password = input("请输入密码: ") users[username] = {"password": password} save_users(users) print("注册成功!") def login(users): username = input("请输入用户名: ") if username not in users: print("用户名不存在,请先注册!") return password = input("请输入密码: ") if password == users[username]["password"]: print("登录成功!") else: print("密码错误!") def save_users(users): with open("users.json", "w") as file: json.dump(users, file) def load_users(): try: with open("users.json", "r") as file: users = json.load(file) except FileNotFoundError: users = {} return users def main(): users = load_users() while True: print("1. 注册") print("2. 登录") print("3. 退出") choice = input("请选择操作: ") if choice == "1": register(users) elif choice == "2": login(users) elif choice == "3": break else: print("无效的操作,请重新选择!") if __name__ == "__main__": main() ``` 以上代码使用了`json`模块来保存和加载注册信息,将用户信息保存为一个字典,键为用户名,值为密码。在注册时,程序会检查用户名是否已存在,如果不存在,则将用户名和密码保存到字典中,并调用`save_users`函数将字典保存到磁盘文件中。在登录时,程序会检查用户名是否存在,如果存在,则比较密码是否一致。 希望对你有所帮助!

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值