162基于springboot宠物管理系统，阿里Java社招面试

’, 3, ‘2020-04-25 22:10:52’, ‘宠物预防针多久打一次’);

INSERT INTO notice VALUES (3, ’

请填写文字内容

\n\n

如果你的小狗已经出现了一定情况的问题，那么请先从自己／现有环境的身上找原因——毕竟养狗行为课程，其实最重要的不是小狗，而是小狗的主人。

\n\n

我们对待小狗的方式，就是我们对待小孩，或者说是童年的自己的方式。是选择恐吓训斥，让他们永远失去好奇心，对周围充满恐惧？还是选择给小孩以积极尊重，探索周边，予以互动？培养小狗的自信心和成就感，也是重要的课程内容。

\n\n

', 5, ‘2020-04-26 11:35:09’, ‘养犬最重要的是什么？’);

INSERT INTO notice VALUES (4, ‘

宠物…

’, 2, ‘2020-04-26 19:15:57’, ‘养犬’);

INSERT INTO notice VALUES (5, ‘

怎么养宠物…

’, 1, ‘2020-04-26 19:46:22’, ‘养犬重要的是什么？’);

INSERT INTO notice VALUES (6, ‘

怎么养宠物…

’, 12, ‘2020-04-26 19:46:28’, ‘养犬重要的是什么？’);

INSERT INTO notice VALUES (8, ‘

宠物

’, 1, ‘2020-05-30 10:37:36’, ‘宠物’);

---

– Table structure for page

---

DROP TABLE IF EXISTS page;

CREATE TABLE page (

page_id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘自增主键’,

parent_id int(11) DEFAULT NULL COMMENT ‘父页面id’,

name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘页面名称’,

url varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘页面地址’,

level_type int(11) DEFAULT NULL COMMENT ‘页面层级’,

level_index int(11) DEFAULT NULL COMMENT ‘页面索引’,

delete_flag int(1) UNSIGNED ZEROFILL NOT NULL DEFAULT 0 COMMENT ‘是否删除’,

desc varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘描述’,

PRIMARY KEY (page_id) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 39 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

---

– Records of page

---

INSERT INTO page VALUES (1, 0, ‘系统设置’, NULL, 0, 10, 0, ‘manager’);

INSERT INTO page VALUES (2, 1, ‘用户管理’, ‘/admin/userPage’, 1, 22, 0, ‘manager’);

INSERT INTO page VALUES (3, 1, ‘页面管理’, ‘/admin/page’, 1, 23, 0, ‘manager’);

INSERT INTO page VALUES (4, 1, ‘角色管理’, ‘/admin/role’, 1, 24, 0, ‘manager’);

INSERT INTO page VALUES (6, 0, ‘宠物管理’, ‘’, 0, 1, 0, ‘left_menu_shop’);

INSERT INTO page VALUES (7, 6, ‘宠物列表’, ‘/user/pet/petList’, 1, 1, 0, ‘’);

INSERT INTO page VALUES (8, 6, ‘宠物健康史’, ‘/user/diagnosis/diagnosisList’, 1, 2, 0, ‘’);

INSERT INTO page VALUES (9, 0, ‘预约管理’, ‘’, 0, 2, 0, ‘left_menu_data’);

INSERT INTO page VALUES (10, 9, ‘预约列表’, ‘/user/apply/applyList’, 1, 1, 0, ‘’);

INSERT INTO page VALUES (12, 0, ‘日常健康’, ‘’, 0, 3, 0, ‘user’);

INSERT INTO page VALUES (13, 12, ‘健康指南’, ‘/user/notice/list’, 1, 1, 0, ‘’);

INSERT INTO page VALUES (14, 12, ‘健康监测’, ‘/health/assess’, 1, 2, 0, ‘’);

INSERT INTO page VALUES (19, 0, ‘宠物档案’, ‘’, 0, 4, 0, ‘left_menu_house’);

INSERT INTO page VALUES (20, 19, ‘预约统计’, ‘/health/tjApply’, 1, 1, 0, ‘’);

INSERT INTO page VALUES (21, 0, ‘医院管理’, ‘’, 0, 5, 0, ‘page’);

INSERT INTO page VALUES (23, 21, ‘预约统计’, ‘/health/tjApplyDoctor’, 1, 2, 0, ‘’);

INSERT INTO page VALUES (24, 21, ‘发布指南’, ‘/user/notice/publish’, 1, 3, 0, ‘’);

INSERT INTO page VALUES (27, 19, ‘宠物日志’, ‘/user/petDaily/petDailyList’, 1, 2, 0, ‘’);

INSERT INTO page VALUES (28, 19, ‘预约统计’, ‘/health/tjApply’, 1, 3, 0, NULL);

INSERT INTO page VALUES (30, 6, ‘宠物健康史’, ‘/user/diagnos