网站导航
> 技术文档 > 基于SpringBoot的OA办公系统的设计与实现

基于SpringBoot的OA办公系统的设计与实现

网友: 技术文档 2025-08-08 13:12:15

文章目录

    • 前言
    • 详细视频演示
    • 具体实现截图
      • 后端框架SpringBoot
      • 持久层框架MyBaits
    • 成功系统案例：
    • 代码参考
    • 数据库
    • 源码获取

前言

博主介绍:CSDN特邀作者、985高校计算机专业毕业、现任某互联网大厂高级全栈开发工程师、Gitee/掘金/华为云/阿里云/GitHub等平台持续输出高质量技术内容、深耕Java、小程序、前端、python等技术领域和毕业项目实战，以及程序定制化开发、全栈讲解。

💯文末获取源码+数据库💯
感兴趣的可以先收藏起来，还有大家在毕设选题，项目以及论文编写等相关问题都可以找我咨询，希望帮助更多的人。

详细视频演示

视频演示

具体实现截图

在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述

后端框架SpringBoot

Spring Boot允许开发者快速构建出既可以独立运行又满足生产级别标准的Spring基础应用程序。此框架通过提供一系列便捷的工具和服务，极大地促进了基于Spring的应用开发工作的效率和质量。通过提供一系列大型项目中常用的默认配置，Spring Boot最大化减少配置文件的使用，开发者能够迅速启动和运行Spring应用程序。

Spring Boot通过约定优于配置的原则，避免了许多传统Spring应用开发时繁琐的配置，该框架支持对内嵌服务器的自动配置，如Tomcat、Jetty或Undertow，从而简化了Web应用的部署过程。

持久层框架MyBaits

MyBatis是一个开源的持久层框架，它可以帮助开发者简化数据库操作的编写和管理。MyBatis的核心思想是将SQL语句和Java代码分离，通过XML或注解的方式来描述数据库操作，从而实现了数据访问层的解耦和灵活性。

MyBatis的优势主要包括以下几点：

简化数据库操作：MyBatis通过提供强大的SQL映射功能，可以将Java对象与数据库表进行映射，开发者无需手动编写繁琐的SQL语句，大大简化了数据库操作的编写和维护。

灵活的SQL控制：MyBatis支持动态SQL，可以根据不同的条件和逻辑来动态生成SQL语句，使得查询、更新等操作更加灵活和可控。

缓存支持：MyBatis提供了一级缓存和二级缓存的支持，可以有效减少数据库的访问次数，提高系统性能。

可扩展性强：MyBatis采用插件机制，可以方便地扩展和定制自己的功能，满足各种不同的业务需求。

所有项目均为博主亲自收集、开发并严格测试，确保源码完整、可运行，无缺失依赖或兼容性问题！同学们拿到后就能使用！博主具备多年高级开发经验，能深入讲解代码架构、核心逻辑及技术难点，助你高效掌握项目精髓。

成功系统案例：

在这里插入图片描述
在这里插入图片描述
在这里插入图片描述

代码参考

package cn.gson.oasys.controller.system;import java.util.List;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpSession;import javax.validation.Valid;import org.slf4j.Logger;import org.slf4j.LoggerFactory;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.util.StringUtils;import org.springframework.validation.BindingResult;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.SessionAttribute;import com.alibaba.fastjson.JSONArray;import cn.gson.oasys.common.formValid.BindingResultVOUtil;import cn.gson.oasys.common.formValid.MapToList;import cn.gson.oasys.common.formValid.ResultEnum;import cn.gson.oasys.common.formValid.ResultVO;import cn.gson.oasys.model.dao.IndexDao;import cn.gson.oasys.model.dao.roledao.RoleDao;import cn.gson.oasys.model.dao.roledao.RolepowerlistDao;import cn.gson.oasys.model.dao.user.UserDao;import cn.gson.oasys.model.entity.role.Role;import cn.gson.oasys.model.entity.role.Rolepowerlist;import cn.gson.oasys.model.entity.system.SystemMenu;import cn.gson.oasys.model.entity.user.User;import cn.gson.oasys.services.role.RoleService;import cn.gson.oasys.services.system.MenuSysService;@Controller@RequestMapping(\"/\")public class MenuSysController {Logger log = LoggerFactory.getLogger(getClass());@Autowiredprivate IndexDao iDao;@Autowiredprivate MenuSysService menuService;@Autowiredprivate UserDao uDao;@Autowiredprivate RoleDao rdao;@Autowiredprivate RolepowerlistDao rldao;@Autowiredprivate RoleService roleService;/** * 显示菜单管理界面 * @param req * @return */@RequestMapping(\"testsysmenu\")public String testsysmenu(HttpServletRequest req) {menuService.findAllMenuSys(req);return \"systemcontrol/menumanage\";}/** * 查找菜单 */@RequestMapping(\"menutable\")public String menuTable(HttpServletRequest req){if(!StringUtils.isEmpty(req.getParameter(\"name\"))){req.setAttribute(\"oneMenuAll\", iDao.findByMenuNameLike(\"%\"+req.getParameter(\"name\")+\"%\"));}else{menuService.findAllMenuSys(req);}return \"systemcontrol/menutable\";}/** * 改变排序 * @param req * @return */@RequestMapping(\"changeSortId\")public String changeSortId(HttpServletRequest req,@SessionAttribute(\"userId\")Long userId) {User user=uDao.findOne(userId);Long parentId = Long.parseLong(req.getParameter(\"parentid\"));Long menuId = Long.parseLong(req.getParameter(\"menuid\"));Integer sortId = Integer.parseInt(req.getParameter(\"sortid\"));Integer arithNum = Integer.parseInt(req.getParameter(\"num\"));log.info(\"parentId:{}\", parentId);log.info(\"menuId:{}\", menuId);log.info(\"sortId:{}\", sortId);log.info(\"arithNum:{}\", arithNum);if (arithNum == 1) {int a1 = menuService.changeSortId(sortId, arithNum, parentId);int a2 = menuService.changeSortId2(sortId, arithNum, menuId);log.info(\"a1：{}\", a1);log.info(\"a2：{}\", a2);} else {int a1 = menuService.changeSortId(sortId, arithNum, parentId);int a2 = menuService.changeSortId2(sortId, arithNum, menuId);log.info(\"a1：{}\", a1);log.info(\"a2：{}\", a2);}menuService.findMenuSys(req,user);return \"redirect:/testsysmenu\";}/** * 菜单管理的编辑界面 * @param req * @return */@RequestMapping(\"menuedit\")public String newpage(HttpServletRequest req) {if(!StringUtils.isEmpty(req.getAttribute(\"errormess\"))){req.setAttribute(\"errormess\", req.getAttribute(\"errormess\"));}if(!StringUtils.isEmpty(req.getAttribute(\"success\"))){req.setAttribute(\"success\", req.getAttribute(\"success\"));}List<SystemMenu> parentList=iDao.findByParentIdOrderBySortId(0L);req.setAttribute(\"parentList\", parentList);HttpSession session = req.getSession();session.removeAttribute(\"getId\");if (!StringUtils.isEmpty(req.getParameter(\"id\"))) {Long getId = Long.parseLong(req.getParameter(\"id\"));SystemMenu menuObj = iDao.findOne(getId);if (!StringUtils.isEmpty(req.getParameter(\"add\"))) {Long getAdd = menuObj.getMenuId();String getName=menuObj.getMenuName();req.setAttribute(\"getAdd\", getAdd);req.setAttribute(\"getName\", getName);log.info(\"getAdd:{}\", getAdd);} else {session.setAttribute(\"getId\", getId);log.info(\"getId:{}\", getId);req.setAttribute(\"menuObj\", menuObj);}}return \"systemcontrol/menuedit\";}/** * 系统管理表单验证 * @param req * @param menu * @param br * 后台校验表单数据，不通过则回填数据，显示错误信息；通过则直接执行业务，例如新增、编辑等； * @return */@RequestMapping(\"test111\")public String testMess(HttpServletRequest req, @Valid SystemMenu menu, BindingResult br) {HttpSession session = req.getSession();Long menuId = null;req.setAttribute(\"menuObj\", menu);// 这里返回ResultVO对象，如果校验通过，ResultEnum.SUCCESS.getCode()返回的值为200；否则就是没有通过；ResultVO res = BindingResultVOUtil.hasErrors(br);// 校验失败if (!ResultEnum.SUCCESS.getCode().equals(res.getCode())) {List<Object> list = new MapToList<>().mapToList(res.getData());req.setAttribute(\"errormess\", list.get(0).toString());// 代码调试阶段，下面是错误的相关信息；System.out.println(\"list错误的实体类信息：\" + menu);System.out.println(\"list错误详情:\" + list);System.out.println(\"list错误第一条:\" + list.get(0));System.out.println(\"啊啊啊错误的信息——：\" + list.get(0).toString());// 下面的info信息是打印出详细的信息log.info(\"getData:{}\", res.getData());log.info(\"getCode:{}\", res.getCode());log.info(\"getMsg:{}\", res.getMsg());}// 校验通过，下面写自己的逻辑业务else {// 判断是否从编辑界面进来的，前面有\"session.setAttribute(\"getId\",getId);\",在这里获取，并remove掉；if (!StringUtils.isEmpty(session.getAttribute(\"getId\"))) {menuId = (Long)session.getAttribute(\"getId\"); // 获取进入编辑界面的menuID值menu.setMenuId(menuId);log.info(\"getId:{}\", session.getAttribute(\"getId\"));session.removeAttribute(\"getId\");menuService.save(menu);}else{//执行新增 的代码；menuService.save(menu);List<Role> roles=rdao.findAll();for (Role role : roles) {if(role.getRoleId()==1){roleService.sava(new Rolepowerlist(role, menu, true));}else{roleService.sava(new Rolepowerlist(role, menu, false));}}}//执行业务代码System.out.println(\"此操作是正确的\");req.setAttribute(\"success\", \"后台验证成功\");}System.out.println(\"是否进入最后的实体类信息：\" + menu);return \"forward:/menuedit\";}/** * 菜单管理的删除 * @return */@RequestMapping(\"deletethis\")public String delete(HttpServletRequest req){Long menuId=Long.parseLong(req.getParameter(\"id\"));int i=menuService.deleteThis(menuId);log.info(\"{}:i=\",i);return \"forward:/testsysmenu\";}}

数据库

/* Navicat Premium Data Transfer Source Server : local Source Server Type : MySQL Source Server Version : 50720 Source Host  : localhost:3306 Source Schema : tr18lx Target Server Type : MySQL Target Server Version : 50720 File Encoding : 65001 Date: 02/03/2018 14:28:18*/SET NAMES utf8mb4;SET FOREIGN_KEY_CHECKS = 0;-- ------------------------------ Table structure for aoa_attachment_list-- ----------------------------DROP TABLE IF EXISTS `aoa_attachment_list`;CREATE TABLE `aoa_attachment_list` ( `attachment_id` bigint(20) NOT NULL AUTO_INCREMENT, `attachment_name` varchar(255) DEFAULT NULL, `attachment_path` varchar(255) DEFAULT NULL, `attachment_shuffix` varchar(255) DEFAULT NULL, `attachment_size` varchar(255) DEFAULT NULL, `attachment_type` varchar(255) DEFAULT NULL, `model` varchar(255) DEFAULT NULL, `upload_time` datetime DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, PRIMARY KEY (`attachment_id`)) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8mb4;-- ------------------------------ Records of aoa_attachment_list-- ----------------------------BEGIN;INSERT INTO `aoa_attachment_list` VALUES (3, \'5.jpg\', \'/2017/09/罗密欧/a554a26e-546f-4da5-b9ed-80454851e590.jpg\', \'jpg\', \'175797\', \'image/jpeg\', \'note\', \'2025-06-18 16:33:25\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (6, \'4.jpg\', \'/2017/09/罗密欧/74b9678a-1689-4a62-9345-68825e256cd6.jpg\', \'jpg\', \'133831\', \'image/jpeg\', \'note\', \'2025-06-15 11:01:08\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (7, \'3.jpg\', \'/2017/09/罗密欧/fb8d46c2-fe8c-4e5e-9d1e-a7e937a16d77.jpg\', \'jpg\', \'231999\', \'image/jpeg\', \'note\', \'2025-06-15 11:04:38\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (8, \'3.jpg\', \'/2017/09/罗密欧/67ea8f24-1a07-4618-acf8-7a4b2f093e0d.jpg\', \'jpg\', \'231999\', \'image/jpeg\', \'note\', \'2025-06-15 11:09:21\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (9, \'2.jpg\', \'/2017/09/罗密欧/2818321d-76df-4b3f-80ea-a62effe28690.jpg\', \'jpg\', \'302654\', \'image/jpeg\', \'note\', \'2025-06-23 16:43:50\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (10, \'5.jpg\', \'/2017/09/罗密欧/e9a07fda-551f-4351-af86-68dfe5e8bad4.jpg\', \'jpg\', \'175797\', \'image/jpeg\', \'note\', \'2025-06-15 20:11:22\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (11, \'5.jpg\', \'/2017/09/罗密欧/0cdd59d1-1d49-4e03-aa9c-2f56779303f1.jpg\', \'jpg\', \'175797\', \'image/jpeg\', \'note\', \'2025-06-15 20:14:50\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (12, \'5.jpg\', \'/2017/09/罗密欧/9700c576-58bc-4036-aecd-e704b22f7175.jpg\', \'jpg\', \'175797\', \'image/jpeg\', \'note\', \'2025-06-15 20:37:24\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (13, \'5.jpg\', \'/2017/09/罗密欧/eec316a6-f7e8-4b85-a8d5-72f2af01256a.jpg\', \'jpg\', \'175797\', \'image/jpeg\', \'note\', \'2025-06-15 23:06:24\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (44, \'1.jpg\', \'/2017/09/罗密欧/aa5be2a8-5705-4199-b1ba-0df2424e3eb8.jpg\', \'jpg\', \'191177\', \'image/jpeg\', \'note\', \'2025-06-23 15:30:09\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (46, \'4.jpg\', \'/2017/09/罗密欧/f459a35a-439a-4d4d-a684-731d3bc48c88.jpg\', \'jpg\', \'133831\', \'image/jpeg\', \'note\', \'2025-06-23 16:11:11\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (47, \'1.jpg\', \'/2017/09/罗密欧/44bc1ad7-0e2e-4569-afc1-385783a955bf.jpg\', \'jpg\', \'191177\', \'image/jpeg\', \'note\', \'2025-06-23 16:37:05\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (48, \'touxiang.jpg\', \'/2017/09/罗密欧/32bd13b9-40f6-4273-bb4a-96a064db8931.jpg\', \'jpg\', \'12124\', \'image/jpeg\', \'mail\', \'2025-06-28 19:40:05\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (49, \'30D06FF1176D3C568E37CBE221D2E542.png\', \'/2017/09/罗密欧/db7577dd-c8aa-4276-a0af-44a1a19866f8.png\', \'png\', \'71260\', \'image/png\', \'mail\', \'2025-06-28 21:24:38\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (50, \'wenwu.gif\', \'/2017/09/罗密欧/ebbf1830-0808-4cd8-ac43-f40bef5eb514.gif\', \'gif\', \'3532\', \'image/gif\', \'mail\', \'2025-06-28 21:27:45\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (51, \'wenwu.gif\', \'/2017/09/罗密欧/f86b2292-0ebe-4d34-bf44-ef042b9b7869.gif\', \'gif\', \'3532\', \'image/gif\', \'mail\', \'2025-06-28 21:30:40\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (52, \'touxiang.jpg\', \'/2017/09/罗密欧/8235e27e-3ad3-4b86-bd6d-f26503d9f394.jpg\', \'jpg\', \'12124\', \'image/jpeg\', \'mail\', \'2025-06-28 21:37:44\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (53, \'touxiang.jpg\', \'/2017/09/罗密欧/fc55113a-d2ed-4d7a-bed1-8659c9cb301e.jpg\', \'jpg\', \'12124\', \'image/jpeg\', \'mail\', \'2025-06-28 21:46:48\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (54, \'touxiang.jpg\', \'/2017/09/罗密欧/e2bbea23-4b30-4407-b0c2-0fdced499a54.jpg\', \'jpg\', \'12124\', \'image/jpeg\', \'mail\', \'2025-06-28 21:53:24\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (55, \'touxiang.jpg\', \'/2017/09/罗密欧/3e3f94aa-b956-460f-811a-91af4438f9f3.jpg\', \'jpg\', \'12124\', \'image/jpeg\', \'mail\', \'2025-06-28 22:00:37\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (56, \'touxiang.jpg\', \'/2017/09/罗密欧/0c75fe6e-0e3b-4e3e-b1c2-50de92f09664.jpg\', \'jpg\', \'12124\', \'image/jpeg\', \'mail\', \'2025-06-28 22:03:46\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (57, \'touxiang.jpg\', \'/2017/09/罗密欧/9ef69729-1a49-4d3c-9ed1-75a601d0ae20.jpg\', \'jpg\', \'12124\', \'image/jpeg\', \'mail\', \'2025-06-28 22:20:12\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (58, \'截图.png\', \'/2017/09/罗密欧/61c319da-b1ea-4d83-815c-5abb824e977c.png\', \'png\', \'195652\', \'image/png\', \'mail\', \'2025-06-29 22:09:51\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (59, \'touxiang.jpg\', \'/2017/10/朱丽叶/e59201dd-65ef-4f0f-801d-999d31be6d75.jpg\', \'jpg\', \'12124\', \'image/jpeg\', \'mail\', \'2025-06-01 12:46:44\', \'2\');INSERT INTO `aoa_attachment_list` VALUES (60, \'touxiang.jpg\', \'/2017/10/罗密欧/e54faef8-b6aa-4451-8fef-a7c14aea2b86.jpg\', \'jpg\', \'12124\', \'image/jpeg\', \'mail\', \'2025-06-01 19:39:14\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (61, \'30D06FF1176D3C568E37CBE221D2E542.png\', \'/2017/10/罗密欧/7ab2398a-0295-4e53-8037-10e10b5519fb.png\', \'png\', \'71260\', \'image/png\', \'mail\', \'2025-06-02 14:49:56\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (62, \'touxiang.jpg\', \'/2017/10/罗密欧/e2036a84-4bf0-4637-bf0f-18888745986d.jpg\', \'jpg\', \'12124\', \'image/jpeg\', \'mail\', \'2025-06-06 11:02:49\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (64, \'4.jpg\', \'/2017/10/罗密欧/280308d8-2aca-40af-8868-b138aee8d71d.jpg\', \'jpg\', \'133831\', \'image/jpeg\', \'note\', \'2025-06-07 16:03:03\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (65, \'1.jpg\', \'/2017/10/罗密欧/eabc7cbe-5406-491a-a7f5-52214af201cc.jpg\', \'jpg\', \'191177\', \'image/jpeg\', \'note\', \'2025-06-07 16:03:58\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (66, \'touxiang.jpg\', \'/2017/10/光宇/ea6c9723-9a0f-46e0-adbc-1cf41b44a805.jpg\', \'jpg\', \'12124\', \'image/jpeg\', \'aoa_bursement\', \'2025-06-12 23:25:57\', \'18\');INSERT INTO `aoa_attachment_list` VALUES (67, \'touxiang.jpg\', \'/2017/10/伊丽莎白/b11342e1-bcf1-4196-b6a3-b900a5ce1c7a.jpg\', \'jpg\', \'12124\', \'image/jpeg\', \'aoa_bursement\', \'2025-06-14 21:22:35\', \'3\');INSERT INTO `aoa_attachment_list` VALUES (68, \'touxiang.jpg\', \'/2017/10/光宇/d2377f04-95b7-49a3-95d1-e7ea7d51b204.jpg\', \'jpg\', \'12124\', \'image/jpeg\', \'aoa_bursement\', \'2025-06-15 19:17:46\', \'18\');INSERT INTO `aoa_attachment_list` VALUES (69, \'touxiang.jpg\', \'/2017/10/光宇/ab5ebe75-a3ca-482f-96ea-ab353b3521fd.jpg\', \'jpg\', \'12124\', \'image/jpeg\', \'mail\', \'2025-06-16 17:17:51\', \'18\');INSERT INTO `aoa_attachment_list` VALUES (70, \'touxiang.jpg\', \'/2017/10/罗密欧/3190c54b-ccdd-435c-8796-59f3d714b605.jpg\', \'jpg\', \'12124\', \'image/jpeg\', \'mail\', \'2025-06-16 17:42:16\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (71, \'3.jpg\', \'/2017/10/罗密欧/49cca32e-a317-4cb3-b804-7a7ffe6b70ea.jpg\', \'jpg\', \'231999\', \'image/jpeg\', \'note\', \'2025-06-18 16:13:02\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (72, \'touxiang.jpg\', \'/2017/10/罗密欧/9bb7b8a0-cdc2-4e6a-bbf9-76741ec6d9f8.jpg\', \'jpg\', \'12124\', \'image/jpeg\', \'mail\', \'2025-06-18 17:45:16\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (73, \'timg.jpeg\', \'/2017/10/soli/f8055ab3-eb20-47bd-b015-b5b602ddb905.jpeg\', \'jpeg\', \'696381\', \'image/jpeg\', \'note\', \'2025-06-19 23:37:37\', \'5\');INSERT INTO `aoa_attachment_list` VALUES (74, \'2.jpg\', \'/2017/10/小李父斯基/294ccc18-1710-4fbf-8fff-4d547102d9d4.jpg\', \'jpg\', \'302654\', \'image/jpeg\', \'note\', \'2025-06-20 10:35:00\', \'4\');INSERT INTO `aoa_attachment_list` VALUES (75, \'3.jpg\', \'/2017/10/小李父斯基/7d7ffa12-5120-4c2d-85f0-71f3e61cde78.jpg\', \'jpg\', \'231999\', \'image/jpeg\', \'note\', \'2025-06-20 10:36:07\', \'4\');INSERT INTO `aoa_attachment_list` VALUES (76, \'5.jpg\', \'/2017/10/甄姬/9fbe4e2b-21be-40a4-bc95-0e10fdbc6183.jpg\', \'jpg\', \'175797\', \'image/jpeg\', \'note\', \'2025-06-20 10:40:03\', \'7\');INSERT INTO `aoa_attachment_list` VALUES (77, \'3.jpg\', \'/2017/10/罗密欧/1b01a1e2-17bf-4e96-98e5-dc8f30526c1c.jpg\', \'jpg\', \'231999\', \'image/jpeg\', \'note\', \'2025-06-22 09:21:27\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (78, \'4.jpg\', \'/2017/10/罗密欧/96d0f196-b218-4e26-88e5-5ec1116271a1.jpg\', \'jpg\', \'133831\', \'image/jpeg\', \'note\', \'2025-06-22 09:13:12\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (79, \'4.jpg\', \'/2017/10/罗密欧/3ac1f528-dac7-4635-8911-2d39e3ac6b03.jpg\', \'jpg\', \'133831\', \'image/jpeg\', \'note\', \'2025-06-22 09:26:33\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (80, \'2.jpg\', \'/2017/10/罗密欧/5026b08c-354d-427d-8fb2-37c0f7b70199.jpg\', \'jpg\', \'302654\', \'image/jpeg\', \'note\', \'2025-06-22 09:33:49\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (81, \'1.jpg\', \'/2017/10/罗密欧/000d6a4f-1a29-44fc-8daf-fe4208eebc54.jpg\', \'jpg\', \'191177\', \'image/jpeg\', \'note\', \'2025-06-22 10:00:19\', \'1\');INSERT INTO `aoa_attachment_list` VALUES (82, \'1.jpg\', \'/2017/10/罗密欧/976c2665-b059-4303-8e59-1ebc1a495ea5.jpg\', \'jpg\', \'191177\', \'image/jpeg\', \'note\', \'2025-06-22 11:28:16\', \'1\');COMMIT;-- ------------------------------ Table structure for aoa_attends_list-- ----------------------------DROP TABLE IF EXISTS `aoa_attends_list`;CREATE TABLE `aoa_attends_list` ( `attends_id` bigint(20) NOT NULL AUTO_INCREMENT, `attends_ip` varchar(20) DEFAULT NULL, `attends_remark` varchar(20) DEFAULT NULL, `attends_time` datetime DEFAULT NULL, `status_id` bigint(20) DEFAULT NULL, `type_id` bigint(20) DEFAULT NULL, `attends_user_id` bigint(20) DEFAULT NULL, `attend_hmtime` varchar(255) DEFAULT NULL, `week_ofday` varchar(255) DEFAULT NULL, `holiday_days` double(255,0) DEFAULT \'0\', `holiday_start` date DEFAULT NULL, PRIMARY KEY (`attends_id`), KEY `FKaxgqsm98npnl1rxysh9upfjee` (`attends_user_id`), CONSTRAINT `FKaxgqsm98npnl1rxysh9upfjee` FOREIGN KEY (`attends_user_id`) REFERENCES `aoa_user` (`user_id`)) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4;-- ------------------------------ Records of aoa_attends_list-- ----------------------------BEGIN;INSERT INTO `aoa_attends_list` VALUES (1, \'127.0.0.1\', \'上班正常4\', \'2025-06-27 08:16:36\', 10, 8, 4, \'08:16\', \'星期三\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (2, \'127.0.0.1\', \'上班迟到2\', \'2025-06-15 12:40:35\', 11, 8, 4, \'12:40\', \'星期二\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (3, \'127.0.0.1\', \'下班正常\', \'2025-06-02 18:49:13\', 10, 9, 4, \'18:49\', \'星期六\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (12, NULL, NULL, \'2025-06-28 22:17:16\', 11, 8, 2, \'22:17\', \'星期四\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (13, NULL, NULL, \'2025-06-28 22:35:24\', 10, 9, 2, \'22:35\', \'星期四\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (14, NULL, NULL, \'2025-06-29 13:04:10\', 11, 8, 2, \'09:50\', \'星期五\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (15, NULL, NULL, \'2025-06-29 18:49:42\', 10, 9, 2, \'18:49\', \'星期五\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (22, NULL, NULL, \'2025-06-06 20:02:40\', NULL, 8, 2, NULL, NULL, 0, NULL);INSERT INTO `aoa_attends_list` VALUES (23, NULL, NULL, \'2025-06-14 20:03:20\', NULL, 8, 2, NULL, NULL, 0, NULL);INSERT INTO `aoa_attends_list` VALUES (24, NULL, NULL, \'2025-06-01 10:49:32\', 11, 8, 2, \'10:49\', \'星期日\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (25, NULL, NULL, \'2025-06-01 20:29:38\', 10, 9, 2, \'20:29\', \'星期日\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (26, NULL, NULL, \'2025-06-02 13:10:48\', 11, 8, 2, \'13:10\', \'星期一\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (27, NULL, NULL, \'2025-06-02 18:53:15\', 10, 9, 2, \'18:53\', \'星期一\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (28, NULL, NULL, \'2025-06-03 12:30:51\', 11, 8, 2, \'12:30\', \'星期二\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (29, NULL, NULL, \'2025-06-05 13:26:12\', 11, 8, 2, \'13:26\', \'星期四\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (30, NULL, NULL, \'2025-06-05 13:29:58\', 12, 9, 2, \'13:29\', \'星期四\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (31, NULL, NULL, \'2025-06-07 16:11:07\', 11, 8, 2, \'16:11\', \'星期六\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (32, NULL, NULL, \'2025-06-07 16:24:15\', 10, 9, 2, \'16:24\', \'星期六\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (33, NULL, NULL, \'2025-06-08 10:19:24\', 11, 8, 2, \'10:19\', \'星期日\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (34, NULL, NULL, \'2025-06-09 10:59:13\', 11, 8, 2, \'10:59\', \'星期一\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (35, \'192.168.43.91\', NULL, \'2025-06-09 14:05:52\', 12, 9, 2, \'14:05\', \'星期一\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (36, \'172.31.16.188\', NULL, \'2025-06-09 16:08:00\', 11, 8, 1, \'16:08\', \'星期一\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (37, \'192.168.43.91\', NULL, \'2025-06-12 15:22:36\', 11, 8, 1, \'15:22\', \'星期四\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (39, \'172.31.17.170\', NULL, \'2025-06-21 15:08:36\', 11, 8, 5, \'15:08\', \'星期六\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (40, \'172.31.17.170\', NULL, \'2025-06-21 15:09:16\', 12, 9, 5, \'15:09\', \'星期六\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (41, \'172.31.17.170\', \'娃娃\', \'2025-06-21 15:09:58\', 11, 8, 6, \'15:09\', \'星期六\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (42, \'172.31.17.170\', NULL, \'2025-06-21 15:10:05\', 12, 9, 6, \'15:10\', \'星期六\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (43, \'172.31.17.170\', NULL, \'2025-06-21 15:10:53\', 11, 8, 7, \'15:10\', \'星期六\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (44, \'172.31.17.170\', NULL, \'2025-06-21 15:11:09\', 12, 9, 7, \'15:11\', \'星期六\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (45, \'172.31.17.170\', \'迟到了 尴尬\', \'2025-06-21 16:03:34\', 11, 8, 4, \'16:03\', \'星期六\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (46, NULL, NULL, NULL, 46, NULL, 7, NULL, NULL, 3, \'2025-06-19\');INSERT INTO `aoa_attends_list` VALUES (47, \'172.31.17.170\', NULL, \'2025-06-21 16:18:39\', 11, 8, 3, \'16:18\', \'星期六\', 0, NULL);INSERT INTO `aoa_attends_list` VALUES (48, \'192.168.1.233\', NULL, \'2025-06-22 10:28:57\', 11, 8, 7, \'10:28\', \'星期日\', NULL, NULL);COMMIT;-- ------------------------------ Table structure for aoa_bursement-- ----------------------------DROP TABLE IF EXISTS `aoa_bursement`;CREATE TABLE `aoa_bursement` ( `bursement_id` bigint(20) NOT NULL AUTO_INCREMENT, `all_money` double DEFAULT NULL, `allinvoices` int(11) DEFAULT NULL, `burse_time` datetime DEFAULT NULL, `financial_advice` varchar(255) DEFAULT NULL, `manager_advice` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `type_id` bigint(20) DEFAULT NULL, `operation_name` bigint(20) DEFAULT NULL, `pro_id` bigint(20) DEFAULT NULL, `user_name` bigint(20) DEFAULT NULL, PRIMARY KEY (`bursement_id`), KEY `FKt3xu5y23deh0mtqkfk3ly6219` (`operation_name`), KEY `FK666vswh4nl3voq8qalu73v2sq` (`pro_id`), KEY `FKgnqp4eax31sh7mn3lt2su7olr` (`user_name`), CONSTRAINT `FK666vswh4nl3voq8qalu73v2sq` FOREIGN KEY (`pro_id`) REFERENCES `aoa_process_list` (`process_id`), CONSTRAINT `FKgnqp4eax31sh7mn3lt2su7olr` FOREIGN KEY (`user_name`) REFERENCES `aoa_user` (`user_id`), CONSTRAINT `FKt3xu5y23deh0mtqkfk3ly6219` FOREIGN KEY (`operation_name`) REFERENCES `aoa_user` (`user_id`)) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;-- ------------------------------ Records of aoa_bursement-- ----------------------------BEGIN;INSERT INTO `aoa_bursement` VALUES (1, 25, 3, NULL, NULL, NULL, \'刘敏\', 25, NULL, 1, 1);INSERT INTO `aoa_bursement` VALUES (2, 11, 1, \'2025-06-11 22:40:26\', \'防微杜渐返回为子发hi黯然无光狂热就\', \'防微杜渐返回为子发hi黯然无光狂热就\', \'咕咕咕咕\', 25, 5, 2, 3);INSERT INTO `aoa_bursement` VALUES (3, 33, 3, NULL, NULL, NULL, \'刘敏\', 25, NULL, 3, 9);INSERT INTO `aoa_bursement` VALUES (4, 11, 1, NULL, NULL, NULL, \'刘敏\', 25, NULL, 4, 8);INSERT INTO `aoa_bursement` VALUES (5, 11, 1, \'2025-06-11 22:31:50\', \'范德萨地方大发地方撒大\', \'范德萨地方大发地方撒大\', \'宋佳\', 25, NULL, 5, 9);INSERT INTO `aoa_bursement` VALUES (6, 11, 1, NULL, NULL, NULL, \'多对多\', 25, NULL, 6, 4);INSERT INTO `aoa_bursement` VALUES (7, 5, 1, NULL, NULL, \'属实\', \'宋佳\', 25, NULL, 7, 9);INSERT INTO `aoa_bursement` VALUES (8, 1000, 1, NULL, NULL, NULL, \'宋佳\', 25, NULL, 8, 2);INSERT INTO `aoa_bursement` VALUES (9, 1000, 1, NULL, NULL, NULL, \'刘敏\', 25, NULL, 9, 9);COMMIT;-- ------------------------------ Table structure for aoa_catalog-- ----------------------------DROP TABLE IF EXISTS `aoa_catalog`;CREATE TABLE `aoa_catalog` ( `catalog_id` bigint(20) NOT NULL AUTO_INCREMENT, `catalog_name` varchar(255) DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, `cata_user_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`catalog_id`), KEY `FKbsk5nkjlqmd8j9rmkarse6j1x` (`cata_user_id`), CONSTRAINT `FKbsk5nkjlqmd8j9rmkarse6j1x` FOREIGN KEY (`cata_user_id`) REFERENCES `aoa_user` (`user_id`)) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4;-- ------------------------------ Records of aoa_catalog-- ----------------------------BEGIN;INSERT INTO `aoa_catalog` VALUES (1, \'note\', 1, 1);INSERT INTO `aoa_catalog` VALUES (2, \'诗词记录\', 1, 1);INSERT INTO `aoa_catalog` VALUES (9, \'秒懂百科\', 1, 2);INSERT INTO `aoa_catalog` VALUES (11, \'上课要案\', 1, 3);INSERT INTO `aoa_catalog` VALUES (12, \'错题收集\', 1, 3);INSERT INTO `aoa_catalog` VALUES (32, \'规划(3)\', 1, 1);INSERT INTO `aoa_catalog` VALUES (33, \'根目录\', 1, NULL);INSERT INTO `aoa_catalog` VALUES (34, \'规划(4)\', 1, 1);COMMIT;-- ------------------------------ Table structure for aoa_comment_list-- ----------------------------DROP TABLE IF EXISTS `aoa_comment_list`;CREATE TABLE `aoa_comment_list` ( `comment_id` bigint(20) NOT NULL AUTO_INCREMENT, `comment` varchar(255) DEFAULT NULL, `time` datetime DEFAULT NULL, `comment_user_id` bigint(20) DEFAULT NULL, `reply_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`comment_id`), KEY `FK2k00kkfhh93949ybod7qn56ax` (`comment_user_id`), KEY `FKeopff14rxco5thbwwlu7exglo` (`reply_id`), CONSTRAINT `FK2k00kkfhh93949ybod7qn56ax` FOREIGN KEY (`comment_user_id`) REFERENCES `aoa_user` (`user_id`), CONSTRAINT `FKeopff14rxco5thbwwlu7exglo` FOREIGN KEY (`reply_id`) REFERENCES `aoa_reply_list` (`reply_id`)) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8mb4;-- ------------------------------ Records of aoa_comment_list-- ----------------------------BEGIN;INSERT INTO `aoa_comment_list` VALUES (2, \'范德萨发\', \'2025-06-01 22:07:29\', 2, 2);INSERT INTO `aoa_comment_list` VALUES (8, \'@朱丽叶 你要干嘛？\', \'2025-06-02 13:37:48\', 1, 2);INSERT INTO `aoa_comment_list` VALUES (9, \'哇哇哇，interesting\', \'2025-06-02 13:38:20\', 1, 3);INSERT INTO `aoa_comment_list` VALUES (10, \'N这个死鬼\', \'2025-06-02 13:48:28\', 1, 4);INSERT INTO `aoa_comment_list` VALUES (15, \'有什么问题么？\', \'2025-06-02 16:48:21\', 1, 8);INSERT INTO `aoa_comment_list` VALUES (21, \'fasd fds \', \'2025-06-03 00:35:14\', 1, 7);INSERT INTO `aoa_comment_list` VALUES (23, \'年轻人，年轻的一批\', \'2025-06-03 00:52:28\', 1, 16);INSERT INTO `aoa_comment_list` VALUES (24, \'你要干嘛？\', \'2025-06-03 00:55:03\', 1, 14);INSERT INTO `aoa_comment_list` VALUES (25, \' 哇哇，你真的是过分呀\', \'2025-06-03 00:55:27\', 1, 9);INSERT INTO `aoa_comment_list` VALUES (26, \'大四范德萨\', \'2025-06-03 01:03:01\', 1, 17);INSERT INTO `aoa_comment_list` VALUES (27, \'范德萨发爱迪生\', \'2025-06-03 01:03:43\', 1, 17);INSERT INTO `aoa_comment_list` VALUES (29, \'@罗密欧 你好；\', \'2025-06-03 11:20:37\', 1, 17);INSERT INTO `aoa_comment_list` VALUES (30, \'@罗密欧 你好；；\', \'2025-06-03 11:21:25\', 1, 17);INSERT INTO `aoa_comment_list` VALUES (31, \' 回复你又没有问题；\', \'2025-06-03 11:22:06\', 1, 18);INSERT INTO `aoa_comment_list` VALUES (34, \'发生大法师\', \'2025-06-04 01:33:18\', 2, 61);INSERT INTO `aoa_comment_list` VALUES (35, \'富士达发\', \'2025-06-04 01:36:40\', 2, 61);INSERT INTO `aoa_comment_list` VALUES (36, \'范德萨\', \'2025-06-04 01:36:48\', 2, 61);INSERT INTO `aoa_comment_list` VALUES (37, \'@朱丽叶 有意思\', \'2025-06-04 01:37:51\', 2, 61);INSERT INTO `aoa_comment_list` VALUES (38, \'你哟啊干嘛？\', \'2025-06-04 01:38:05\', 2, 61);INSERT INTO `aoa_comment_list` VALUES (39, \'@朱丽叶 回复可以么？\', \'2025-06-04 01:40:22\', 2, 61);INSERT INTO `aoa_comment_list` VALUES (40, \' 来恢复把\', \'2025-06-04 01:41:28\', 2, 62);INSERT INTO `aoa_comment_list` VALUES (41, \'第一次回复是可以的\', \'2025-06-04 01:45:47\', 2, 61);INSERT INTO `aoa_comment_list` VALUES (42, \'@朱丽叶 第二次回复\', \'2025-06-04 01:46:07\', 2, 61);INSERT INTO `aoa_comment_list` VALUES (43, \'@朱丽叶 第二次回复，第三次回复\', \'2025-06-04 01:46:25\', 2, 61);INSERT INTO `aoa_comment_list` VALUES (44, \'@朱丽叶 你就是朱丽叶呀\', \'2025-06-04 01:46:43\', 2, 61);INSERT INTO `aoa_comment_list` VALUES (45, \'@朱丽叶 你就是朱丽叶呀，我不是，我什么都不是\', \'2025-06-04 01:46:58\', 2, 61);INSERT INTO `aoa_comment_list` VALUES (46, \' 没有东西是吧\', \'2025-06-04 01:51:41\', 2, 64);INSERT INTO `aoa_comment_list` VALUES (47, \'@朱丽叶 克可达\', \'2025-06-04 01:51:51\', 2, 64);INSERT INTO `aoa_comment_list` VALUES (48, \'你要干啥？\', \'2025-06-04 01:52:00\', 2, 64);INSERT INTO `aoa_comment_list` VALUES (49, \' 我也想知道为什么？\', \'2025-06-04 01:53:02\', 2, 66);INSERT INTO `aoa_comment_list` VALUES (50, \' 来，再加一条\', \'2025-06-04 01:54:12\', 2, 66);INSERT INTO `aoa_comment_list` VALUES (51, \'这一次试试\', \'2025-06-04 01:56:16\', 2, 67);INSERT INTO `aoa_comment_list` VALUES (52, \'第八条\', \'2025-06-04 01:57:53\', 2, 67);INSERT INTO `aoa_comment_list` VALUES (53, \' 再试一下\', \'2025-06-04 01:59:52\', 2, 67);INSERT INTO `aoa_comment_list` VALUES (54, \'发生\', \'2025-06-04 03:25:38\', 2, 60);INSERT INTO `aoa_comment_list` VALUES (55, \'范德萨\', \'2025-06-04 03:25:43\', 2, 60);INSERT INTO `aoa_comment_list` VALUES (56, \'@朱丽叶发 是粉色是\', \'2025-06-04 03:25:59\', 2, 60);INSERT INTO `aoa_comment_list` VALUES (57, \'@朱丽叶 现在开始没有entity了\', \'2025-06-04 03:26:34\', 2, 60);INSERT INTO `aoa_comment_list` VALUES (58, \' 再是一次\', \'2025-06-04 03:29:28\', 2, 60);INSERT INTO `aoa_comment_list` VALUES (59, \' 回复一下\', \'2025-06-04 03:30:23\', 2, 60);INSERT INTO `aoa_comment_list` VALUES (60, \' 没有评论，我怎么办嘛\\n\', \'2025-06-04 03:31:42\', 2, 71);INSERT INTO `aoa_comment_list` VALUES (61, \'再来一次\', \'2025-06-04 03:31:56\', 2, 72);INSERT INTO `aoa_comment_list` VALUES (64, \'@朱丽叶6666666\', \'2025-06-05 23:02:39\', 2, 73);INSERT INTO `aoa_comment_list` VALUES (65, \'@朱丽叶 地方撒\', \'2025-06-05 23:03:14\', 2, 73);INSERT INTO `aoa_comment_list` VALUES (66, \'@朱丽叶6767\', \'2025-06-05 23:04:05\', 2, 73);INSERT INTO `aoa_comment_list` VALUES (67, \'@朱丽叶鼎折覆餗\', \'2025-06-05 23:04:24\', 2, 73);INSERT INTO `aoa_comment_list` VALUES (68, \'让他\', \'2025-06-05 23:07:36\', 2, 58);INSERT INTO `aoa_comment_list` VALUES (69, \'手动阀\', \'2025-06-05 23:07:47\', 2, 58);INSERT INTO `aoa_comment_list` VALUES (70, \'@朱丽叶大\', \'2025-06-05 23:07:54\', 2, 58);INSERT INTO `aoa_comment_list` VALUES (71, \'发生\', \'2025-06-05 23:18:47\', 7, 73);INSERT INTO `aoa_comment_list` VALUES (72, \'@甄姬而我若\', \'2025-06-05 23:19:06\', 7, 73);INSERT INTO `aoa_comment_list` VALUES (73, \' 加一条评论\', \'2025-06-06 13:38:56\', 1, 33);INSERT INTO `aoa_comment_list` VALUES (74, \' 再加一条\', \'2025-06-06 13:39:19\', 1, 33);INSERT INTO `aoa_comment_list` VALUES (75, \' 哟哟\\n\', \'2025-06-06 13:46:02\', 2, 2);INSERT INTO `aoa_comment_list` VALUES (76, \'@朱丽叶 回复有问题么？\', \'2025-06-06 13:46:13\', 2, 2);INSERT INTO `aoa_comment_list` VALUES (81, \'回复jia1\', \'2025-06-06 14:16:20\', 2, 84);INSERT INTO `aoa_comment_list` VALUES (82, \' 有问题么？\', \'2025-06-06 15:25:41\', 2, 58);INSERT INTO `aoa_comment_list` VALUES (83, \'没有问题撒\', \'2025-06-06 16:53:48\', 2, 2);INSERT INTO `aoa_comment_list` VALUES (84, \'\', \'2025-06-06 16:54:05\', 2, 2);INSERT INTO `aoa_comment_list` VALUES (85, \'@朱丽叶 一点点小小的问题\', \'2025-06-06 16:54:05\', 2, 2);INSERT INTO `aoa_comment_list` VALUES (86, \'\', \'2025-06-06 16:54:18\', 2, 2);INSERT INTO `aoa_comment_list` VALUES (87, \'@朱丽叶 ？？\', \'2025-06-06 16:54:18\', 2, 2);INSERT INTO `aoa_comment_list` VALUES (88, \'\', \'2025-06-06 16:54:18\', 2, 2);INSERT INTO `aoa_comment_list` VALUES (89, \'\', \'2025-06-06 16:54:18\', 2, 2);INSERT INTO `aoa_comment_list` VALUES (90, \' 不知道发生什么问题了\', \'2025-06-06 16:56:22\', 2, 2);INSERT INTO `aoa_comment_list` VALUES (91, \'该配合你演出的我视而不见😂😂😂\', \'2025-06-08 15:24:03\', 8, 73);INSERT INTO `aoa_comment_list` VALUES (92, \'@罗密欧 好吧，你很棒棒\', \'2025-06-08 15:27:41\', 8, 3);COMMIT;-- ------------------------------ Table structure for aoa_sys_menu-- ----------------------------DROP TABLE IF EXISTS `aoa_sys_menu`;CREATE TABLE `aoa_sys_menu` ( `menu_id` bigint(20) NOT NULL AUTO_INCREMENT, `is_show` int(11) DEFAULT NULL, `menu_grade` int(11) DEFAULT NULL, `menu_icon` varchar(255) DEFAULT NULL, `menu_name` varchar(255) DEFAULT NULL, `menu_url` varchar(255) NOT NULL, `parent_id` bigint(20) DEFAULT NULL, `sort_id` int(11) DEFAULT NULL, PRIMARY KEY (`menu_id`)) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb4;-- ------------------------------ Records of aoa_sys_menu-- ----------------------------BEGIN;INSERT INTO `aoa_sys_menu` VALUES (1, 1, NULL, \'glyphicon-cog\', \'系统管理\', \'##\', 0, 0);INSERT INTO `aoa_sys_menu` VALUES (2, 1, NULL, \'glyphicon-education\', \'用户管理\', \'#\', 0, 2);INSERT INTO `aoa_sys_menu` VALUES (3, 1, NULL, \'glyphicon-user\', \'角色列表\', \'#\', 0, 3);INSERT INTO `aoa_sys_menu` VALUES (4, 1, NULL, \'glyphicon-time\', \'考勤管理\', \'#\', 0, 4);INSERT INTO `aoa_sys_menu` VALUES (5, 1, NULL, \'glyphicon-hourglass\', \'流程管理\', \'#\', 0, 5);INSERT INTO `aoa_sys_menu` VALUES (6, 1, NULL, \'glyphicon-bell\', \'公告管理\', \'#\', 0, 6);INSERT INTO `aoa_sys_menu` VALUES (7, 1, NULL, \'glyphicon-envelope\', \'邮件管理\', \'#\', 0, 7);INSERT INTO `aoa_sys_menu` VALUES (8, 1, NULL, \'glyphicon-flag\', \'任务管理\', \'#\', 0, 8);INSERT INTO `aoa_sys_menu` VALUES (9, 1, NULL, \'glyphicon-calendar\', \'日程管理\', \'#\', 0, 9);INSERT INTO `aoa_sys_menu` VALUES (10, 1, NULL, \'glyphicon-plane\', \'工作计划\', \'#\', 0, 10);INSERT INTO `aoa_sys_menu` VALUES (11, 1, NULL, \'glyphicon-folder-open\', \'文件管理\', \'#\', 0, 11);INSERT INTO `aoa_sys_menu` VALUES (12, 1, NULL, \'glyphicon-edit\', \'笔记管理\', \'#\', 0, 12);INSERT INTO `aoa_sys_menu` VALUES (13, 1, NULL, \'glyphicon-comment\', \'讨论区\', \'#\', 0, 14);INSERT INTO `aoa_sys_menu` VALUES (14, 1, NULL, \'glyphicon-record\', \'菜单管理\', \'/testsysmenu\', 1, 2);INSERT INTO `aoa_sys_menu` VALUES (15, 1, NULL, \'glyphicon-record\', \'类型管理\', \'/testsystype\', 1, 1);INSERT INTO `aoa_sys_menu` VALUES (16, 1, NULL, \'glyphicon-record\', \'状态管理\', \'/testsysstatus\', 1, 3);INSERT INTO `aoa_sys_menu` VALUES (17, 1, NULL, \'glyphicon-record\', \'部门管理\', \'/deptmanage\', 2, 1);INSERT INTO `aoa_sys_menu` VALUES (18, 1, NULL, \'glyphicon-record\', \'职位管理\', \'/positionmanage\', 2, 3);INSERT INTO `aoa_sys_menu` VALUES (19, 1, NULL, \'glyphicon-record\', \'用户管理\', \'/usermanage\', 2, 4);INSERT INTO `aoa_sys_menu` VALUES (20, 1, NULL, \'glyphicon-record\', \'在线用户\', \'/morelogrecord\', 2, 2);INSERT INTO `aoa_sys_menu` VALUES (21, 1, NULL, \'glyphicon-record\', \'角色列表\', \'/rolemanage\', 3, 1);INSERT INTO `aoa_sys_menu` VALUES (22, 1, NULL, \'glyphicon-record\', \'考勤管理\', \'/attendceatt\', 4, 1);INSERT INTO `aoa_sys_menu` VALUES (23, 1, NULL, \'glyphicon-record\', \'考勤周报表\', \'/attendceweek\', 4, 2);INSERT INTO `aoa_sys_menu` VALUES (24, 1, NULL, \'glyphicon-record\', \'考勤月报表\', \'/attendcemonth\', 4, 3);INSERT INTO `aoa_sys_menu` VALUES (25, 1, NULL, \'glyphicon-record\', \'我的申请\', \'/flowmanage\', 5, 1);INSERT INTO `aoa_sys_menu` VALUES (26, 1, NULL, \'glyphicon-record\', \'流程审核\', \'/audit\', 5, 2);INSERT INTO `aoa_sys_menu` VALUES (27, 1, NULL, \'glyphicon-record\', \'通知管理\', \'/infrommanage\', 6, 1);INSERT INTO `aoa_sys_menu` VALUES (28, 1, NULL, \'glyphicon-record\', \'通知列表\', \'/infromlist\', 6, 2);INSERT INTO `aoa_sys_menu` VALUES (29, 1, NULL, \'glyphicon-record\', \'账号管理\', \'/accountmanage\', 7, 1);INSERT INTO `aoa_sys_menu` VALUES (30, 1, NULL, \'glyphicon-record\', \'邮件管理\', \'/mail\', 7, 2);INSERT INTO `aoa_sys_menu` VALUES (31, 1, NULL, \'glyphicon-record\', \'任务管理\', \'/taskmanage\', 8, 1);INSERT INTO `aoa_sys_menu` VALUES (32, 1, NULL, \'glyphicon-record\', \'我的任务\', \'/mytask\', 8, 2);INSERT INTO `aoa_sys_menu` VALUES (33, 1, NULL, \'glyphicon-record\', \'日程管理\', \'/daymanage\', 9, 1);INSERT INTO `aoa_sys_menu` VALUES (34, 1, NULL, \'glyphicon-record\', \'我的日历\', \'/daycalendar\', 9, 2);INSERT INTO `aoa_sys_menu` VALUES (35, 1, NULL, \'glyphicon-record\', \'计划管理\', \'/planview\', 10, 1);INSERT INTO `aoa_sys_menu` VALUES (36, 1, NULL, \'glyphicon-record\', \'计划报表\', \'/myplan\', 10, 2);INSERT INTO `aoa_sys_menu` VALUES (37, 1, NULL, \'glyphicon-record\', \'文件管理\', \'/filemanage\', 11, 1);INSERT INTO `aoa_sys_menu` VALUES (38, 1, NULL, \'glyphicon-record\', \'笔记管理\', \'/noteview\', 12, 0);INSERT INTO `aoa_sys_menu` VALUES (39, 1, NULL, \'glyphicon-earphone\', \'通讯录\', \'#\', 0, 13);INSERT INTO `aoa_sys_menu` VALUES (40, 1, NULL, \'glyphicon-record\', \'通讯录\', \'/addrmanage\', 39, 1);INSERT INTO `aoa_sys_menu` VALUES (41, 1, NULL, \'glyphicon-record\', \'我的管理\', \'/chatmanage\', 13, 1);INSERT INTO `aoa_sys_menu` VALUES (42, 1, NULL, \'glyphicon-record\', \'讨论区列表\', \'/chatlist\', 13, 2);INSERT INTO `aoa_sys_menu` VALUES (67, 1, NULL, \'glyphicon-record\', \'考勤列表\', \'/attendcelist\', 4, 4);INSERT INTO `aoa_sys_menu` VALUES (76, NULL, NULL, \'21\', \'12\', \'21\', NULL, NULL);INSERT INTO `aoa_sys_menu` VALUES (77, 0, NULL, \'额\', \'额\', \'e\', NULL, NULL);INSERT INTO `aoa_sys_menu` VALUES (78, 0, NULL, \'312\', \'31\', \'312\', NULL, NULL);INSERT INTO `aoa_sys_menu` VALUES (79, 0, NULL, \'放大\', \'范德萨\', \'富士达\', NULL, NULL);INSERT INTO `aoa_sys_menu` VALUES (80, NULL, NULL, \'富士达\', \'任务\', \'富士达\', NULL, NULL);INSERT INTO `aoa_sys_menu` VALUES (81, 1, NULL, \'富士达\', \'任务\', \'富士达\', NULL, NULL);INSERT INTO `aoa_sys_menu` VALUES (82, 1, NULL, \'21\', \'12\', \'21\', NULL, NULL);INSERT INTO `aoa_sys_menu` VALUES (86, 1, NULL, \'glyphicon-record\', \'fds\', \'fdsa\', 999, 0);INSERT INTO `aoa_sys_menu` VALUES (87, 1, NULL, \'glyphicon-record\', \'1\', \'1\', 999, 0);INSERT INTO `aoa_sys_menu` VALUES (88, 0, NULL, \'glyphicon-record\', \'1\', \'1\', 999, 0);INSERT INTO `aoa_sys_menu` VALUES (89, 1, NULL, \'glyphicon-record\', \'超级管理员\', \'/adminmanage\', 13, 0);INSERT INTO `aoa_sys_menu` VALUES (90, 1, NULL, \'glyphicon-record\', \'新建流程\', \'/xinxeng\', 5, 0);COMMIT;

源码获取

如需交流/获取资料，请先【关注+私信】我，私信获取源码~

手机铃声下载

网络标签：

相关问题