{"id":1419,"date":"2024-11-09T19:41:43","date_gmt":"2024-11-09T11:41:43","guid":{"rendered":"https:\/\/note.ui11.cc\/?p=1419"},"modified":"2024-11-11T11:12:55","modified_gmt":"2024-11-11T03:12:55","slug":"%e4%b8%aa%e4%ba%ba%e5%81%a5%e5%ba%b7%e5%b9%b3%e5%8f%b0%e9%a1%b9%e7%9b%ae%e7%ac%94%e8%ae%b0","status":"publish","type":"post","link":"https:\/\/note.ui11.cc\/index.php\/2024\/11\/09\/%e4%b8%aa%e4%ba%ba%e5%81%a5%e5%ba%b7%e5%b9%b3%e5%8f%b0%e9%a1%b9%e7%9b%ae%e7%ac%94%e8%ae%b0\/","title":{"rendered":"\u4e2a\u4eba\u5065\u5eb7\u5e73\u53f0\u9879\u76ee\u7b14\u8bb0"},"content":{"rendered":"\n

\u6b63\u5f0f\u5f00\u53d1<\/strong><\/p>\n\n\n\n

\u4e00\uff1a\u6570\u636e\u5e93\u8bbe\u8ba1\u3001<\/p>\n\n\n\n

SET FOREIGN_KEY_CHECKS=0;\n\n\n\u5173\u95ed\u5916\u952e\u7ea6\u675f\u68c0\u67e5\uff1a\u5f53\u6267\u884c SET FOREIGN_KEY_CHECKS=0; \u8bed\u53e5\u65f6\uff0c\u6570\u636e\u5e93\u4f1a\u6682\u65f6\u5173\u95ed\u5bf9\u5916\u952e\u7ea6\u675f\u7684\u68c0\u67e5\u673a\u5236\u3002\n<\/code><\/pre>\n\n\n\n
\u9996\u5148\u521b\u5efa\u7b80\u5355\u7684\u7528\u6237\u8868\uff08easyuser\uff09\uff1a<\/p>\n\n\n\n
\u7528\u6237\u8868\u7684\u5b57\u6bb5\u6709\uff1a<\/p>\n\n\n\n
id,\u81ea\u589e\uff0c\u4e3b\u952e<\/p>\n\n\n\n
username,password,email,role,state,<\/p>\n\n\n\n
ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;<\/p>\n\n\n\n
\u6570\u636e\u5e93\u521b\u5efa\uff1a<\/p>\n\n\n\n
# \u6743\u9650\u7cfb\u7edf\u8868\u8bbe\u8ba1\ncreate schema db_authority_system;\ndrop table if exists 'easyuaer';\nSET FOREIGN_KEY_CHECKS=0;\nuse db_authority_system;\ncreate table easyuser(\n  id int(24) auto_increment comment '\u4e3b\u952e',\n  username varchar(255) not null  comment '\u8d26\u53f7',\n  password varchar(255) default '123456'  ,\n  email varchar(255) not null  comment '\u90ae\u7bb1',\n   role  varchar(255) not null comment '\u89d2\u8272',\n    state tinyint(255) not null comment '\u72b6\u6001',\nprimary key (id)\n) ENGINE =InnoDB AUTO_INCREMENT=2 default charset =utf8;\n\nINSERT INTO easyuser\n    (username, password, email, role, state) VALUES\n                                                                  ('\u5f20\u4e00', 'password1', 'zhangyi@example.com', '\u7ba1\u7406\u5458', 1),\n                                                                  ('\u674e\u4e8c', 'password2', 'lier@example.com', '\u666e\u901a\u7528\u6237', 1),\n                                                                  ('\u738b\u4e09', 'password3', 'wangsan@example.com', '\u7f16\u8f91\u4eba\u5458', 0),\n                                                                  ('\u8d75\u56db', 'password4', 'zhaosi@example.com', '\u7ba1\u7406\u5458', 1),\n                                                                  ('\u5b59\u4e94', 'password5', 'sunwu@example.com', '\u666e\u901a\u7528\u6237', 0),\n                                                                  ('\u5468\u516d', 'password6', 'zhouliu@example.com', '\u7f16\u8f91\u4eba\u5458', 1),\n                                                                  ('\u5434\u4e03', 'password7', 'wuqi@example.com', '\u7ba1\u7406\u5458', 0),\n                                                                  ('\u90d1\u516b', 'password8', 'zhengba@example.com', '\u666e\u901a\u7528\u6237', 1),\n                                                                  ('\u51af\u4e5d', 'password9', 'fengjiu@example.com', '\u7f16\u8f91\u4eba\u5458', 0),\n                                                                  ('\u9648\u5341', 'password10', 'chenshi@example.com', '\u7ba1\u7406\u5458', 1),\n                                                                  ('\u891a\u5341\u4e00', 'password11', 'chushiyi@example.com', '\u666e\u901a\u7528\u6237', 0),\n                                                                  ('\u536b\u5341\u4e8c', 'password12', 'weisier@example.com', '\u7f16\u8f91\u4eba\u5458', 1),\n                                                                  ('\u848b\u5341\u4e09', 'password13', 'jiangshisan@example.com', '\u7ba1\u7406\u5458', 0),\n                                                                  ('\u6c88\u5341\u56db', 'password14', 'shenshisi@example.com', '\u666e\u901a\u7528\u6237', 1),\n                                                                  ('\u97e9\u5341\u4e94', 'password15', 'hanshiwu@example.com', '\u7f16\u8f91\u4eba\u5458', 0),\n                                                                  ('\u6768\u5341\u516d', 'password16', 'yangshiliu@example.com', '\u7ba1\u7406\u5458', 1),\n                                                                  ('\u6731\u5341\u4e03', 'password17', 'zhushiyi@example.com', '\u666e\u901a\u7528\u6237', 0),\n                                                                  ('\u79e6\u5341\u516b', 'password18', 'qinshiba@example.com', '\u7f16\u8f91\u4eba\u5458', 1),\n                                                                  ('\u5c24\u5341\u4e5d', 'password19', 'youshijiu@example.com', '\u7ba1\u7406\u5458', 0),\n                                                                  ('\u8bb8\u4e8c\u5341', 'password20', 'xushi@example.com', '\u666e\u901a\u7528\u6237', 1);<\/code><\/pre>\n\n\n\n
\u6211\u4eec\u4eceid=2\u5f00\u59cb\u63d2\u5165\u4e8620\u6761\u6570\u636e<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u83dc\u5355\u8868(mainmenu)\uff1a<\/strong><\/p>\n\n\n\n
SET FOREIGN_KEY_CHECKS=0;
<\/p>\n\n\n\n
drop table if exists mainmenu;\nset foreign_key_checks =0;\ncreate table  mainmenu(\n    id  int (50) auto_increment primary key not null ,\n    title varchar(255) not null ,\n    path varchar(255) not null\n\n)ENGINE =InnoDB char set =utf8,auto_increment=1;\nINSERT INTO `mainmenu` VALUES ('100', '\u6743\u9650\u7ba1\u7406', '\/admin');\nINSERT INTO `mainmenu` VALUES ('200', '\u8fd0\u52a8\u5e73\u53f0', '\/use');<\/code><\/pre>\n\n\n\n
<\/p>\n\n\n\n
id,title,path<\/p>\n\n\n\n
submenu(\u63d0\u4ea4\u83dc\u5355\u8868)\uff1a<\/p>\n\n\n\n
id,title,path,mid,<\/p>\n\n\n\n
#\u63d0\u4ea4\u83dc\u5355\ndrop table if exists submenu;\nset foreign_key_checks =0;\ncreate table submenu(\n    id int(50) primary key  auto_increment not null comment '\u4e3b\u952e',\n    title varchar(255) not null   comment '\u540d\u79f0',\n    path varchar(255) not null comment '\u8def\u5f84',\n    mid int(50) not null ,\n    INDEX mid_idx (mid),\n    constraint submenu_ibfk_1 foreign key (mid) references mainmenu (id) #\u5916\u952e\n)ENGINE =InnoDB char set =utf8 auto_increment=1;\nINSERT INTO `submenu` VALUES ('101', '\u7528\u6237\u5217\u8868', '\/user', '100');\nINSERT INTO `submenu` VALUES ('102', '\u4fee\u6539\u6743\u9650', '\/rights', '100');\nINSERT INTO `submenu` VALUES ('103', ' \u8fd0\u52a8\u6a21\u5757', '\/sport', '100');\nINSERT INTO `submenu` VALUES ('104', '\u5546\u54c1\u6a21\u5757', '\/goods', '100');\nINSERT INTO `submenu` VALUES ('201', '\u8fd0\u52a8\u79d1\u666e', '\/Introduction', '200');\nINSERT INTO `submenu` VALUES ('202', '\u5361\u8def\u91cc', '\/calories', '200');\nINSERT INTO `submenu` VALUES ('203', '\u8425\u517b\u914d\u9910', '\/food', '200');<\/code><\/pre>\n\n\n\n
\u521b\u5efa\u7d22\u5f15\u7684\u4e24\u79cd\u65b9\u5f0f\uff1a<\/p>\n\n\n\n
CREATE TABLE submenu (\n    id INT(50) PRIMARY KEY AUTO_INCREMENT NOT NULL COMMENT '\u4e3b\u952e',\n    title VARCHAR(255) NOT NULL COMMENT '\u540d\u79f0',\n    path VARCHAR(255) NOT NULL COMMENT '\u8def\u5f84',\n    mid INT(50) NOT NULL,\n    -- \u521b\u5efa\u7d22\u5f15\u4f7f\u7528\u4ee5\u4e0b\u65b9\u5f0f\u4e4b\u4e00\n    -- INDEX mid_idx (mid),\n    -- \u6216\u8005\u4f7f\u7528 CREATE INDEX \u8bed\u53e5\u5355\u72ec\u521b\u5efa\u7d22\u5f15\n    -- CREATE INDEX mid_idx ON submenu(mid);\n    CONSTRAINT submenu_ibfk_1 FOREIGN KEY (mid) REFERENCES mainmenu(id)\n) ENGINE=InnoDB CHARSET=utf8mb4;<\/code><\/pre>\n\n\n\n
\u4e8c\uff1a\u521b\u5efaSpringBoot\u9879\u76ee<\/p>\n\n\n\n
\u521b\u5efa\u5de5\u7a0b\u65f6\u52fe\u9009SpringWEB,JDBC API\uff0c\u521b\u5efaMybatis\u6846\u67b6\uff0c\u4ee5\u53caMysql\u9a71\u52a8<\/p>\n\n\n\n
\u542f\u52a8\u7c7b\uff1a<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u521b\u5efa\u540e\u6211\u4eec\u770b\u5230\u5de5\u7a0b\u91cc\u7684\u542f\u52a8\u7c7b\uff0c\u8fd9\u65f6\u6211\u4eec\u542f\u52a8\u4e0d\u4e86\uff0c\u56e0\u4e3a\u6211\u4eec\u6ca1\u6709\u914d\u7f6e\u6570\u636e\u6e90<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u5728Spring Boot\u5f00\u53d1\u4e2d\uff0c\u9700\u8981\u5728application.yml\u4e2d\u88ab\u6307\u6570\u636e\u5e93\u7684\u8fde\u63a5\u4fe1\u606f\uff0c\u4ee5\u4e0b\u662fMySQL\u8fde\u63a5\u914d\u7f6e\u4ee5\u53capom\u6587\u4ef6\u7684MySQL\u4f9d\u8d56<\/a><\/p>\n\n\n\n
server:\n  port: 8080\nspring:\n  datasource:\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql:\/\/localhost:3306\/test?&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia\/Shanghai\n    username: root\n    password: 123456<\/code><\/pre>\n\n\n\n
1\u3001port\u662f\u7aef\u53e3
2\u3001drive-class-name\uff1a\u8868\u793aMySql\u7248\u672c\u662f8.0\u7248\u672c
3\u3001URL:\u8fde\u63a5\u6570\u636e\u5e93\u5176\u4e2d jdbc:mysql\u8868\u793a\u901a\u8fc7jdbc\u6765\u8fde\u63a5\u6570\u636e\u5e93\u3002
4\u3001Localhost\uff1a\u8868\u793a\u672c\u673a\u5730\u5740\uff0c
5\u3001\u628atest\u6362\u6210\u81ea\u5df1\u6570\u636e\u5e93\u540d\u79f0\u5373\u53ef\uff0c
6\u3001username\uff1a\u8868\u793a\u8d26\u53f7\u540d\u79f0\uff0c
7\u3001password\uff1a\u8f93\u5165\u81ea\u5df1\u7684\u5bc6\u7801\u5373\u53ef\uff0c
\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014<\/p>\n\n\n\n
                        \n<\/code><\/pre>\n\n\n\n
\u8bb0\u5f97\u5237\u65b0maven\u54e6\u3002<\/p>\n\n\n\n
<\/p>\n\n\n\n
\u89e3\u51b3\u8de8\u57df\u95ee\u9898\uff08\u4e00\u79cd\u65b9\u6cd5\uff0c\u4e5f\u53ef\u4ee5\u5728\u914d\u7f6e\u6587\u4ef6\u91cc\u8bbe\u7f6e\uff09\uff1a<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u521b\u5efa\u524d\u7aef\u9879\u76ee\u4f7f\u7528\u547d\u4ee4<\/p>\n\n\n\n
vue ui<\/p>\n\n\n\n
\u63d2\u4ef6\uff1aelement ui<\/p>\n\n\n\n
\u4f9d\u8d56\uff1aless lessloder  axios<\/p>\n\n\n\n
\u8def\u7531\u914d\u7f6e\uff1a<\/p>\n\n\n\n
Vue.use(VueRouter)\n\nconst routes = [\n  {     \n    path : \"\/\",\n    redirect:\"\/login\" \/\/\u91cd\u5b9a\u5411\n   \n  },\n  {\n   path:\"\/login\",\/\/\u8bbf\u95ee\u8def\u5f84\n   component: login\/\/ \u8bbf\u95ee\u5230\u7684\u7ec4\u4ef6\n  }\n]\n\nconst router = new VueRouter({\n  routes\n})\n\nexport default router<\/code><\/pre>\n\n\n\n
Css\u5168\u5c40\u6837\u5f0f\uff1aheight:\u9ad8\u5ea6<\/p>\n\n\n\n
margin:\u5916\u8fb9\u8ddd<\/p>\n\n\n\n
padding:\u5185\u8fb9\u8ddd<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
login\u9875\u9762\u8bbe\u8ba1\uff1a<\/p>\n\n\n\n
\u77e5\u8bc6\u70b9\uff1a<\/p>\n\n\n\n
<template >\n    <div class=\"login_container\">\n        <!-- \u767b\u5f55\u5757 -->\n        \u6b22\u8fce\u767b\u5f55\u5927\u5065\u5eb7\u5e78\u798f\u7cfb\u7edf\n        <div class=\"login_box\">\n            <!-- \u5934\u50cf\u533a -->\n            <div class=\"avatar_box\">\n\n                <img src=\"..\/assets\/image\/xinxin.jpg\" alt=\"6666\" height=\"200\" width=\"200\">\n\n            <\/div>\n            <!-- \u8868\u5355\u533a\u57df -->\n\n            <el-form ref=\"loginFormRef\" :model=\"loginForm\" class=\"login_form\" label-width=\"0\">\n                <!-- \u7528\u6237\u540d -->\n                <el-form-item>\n                    <el-input v-model=\"loginForm.username\"><\/el-input>\n                <\/el-form-item>\n                <!-- \u5bc6\u7801 -->\n                <el-form-item>\n                    <el-input v-model=\"loginForm.password\"><\/el-input>\n                <\/el-form-item>\n                <!-- \u6309\u94ae -->\n                <el-form-item class=\"btns\">\n                    <el-button type=\"primary\" disabled>\u63d0\u4ea4<\/el-button>\n                    <el-button type=\"info\" disabled>\u91cd\u7f6e<\/el-button>\n                <\/el-form-item>\n\n            <\/el-form>\n\n\n        <\/div>\n\n    <\/div>\n\n\n<\/template>\n\n\n\n<script>\nexport default {\n    data() {\n        return {\n            loginForm:{\n                   username:\"username\",\n                   password:\"password\" \n\n\n            }\n        }\n    },\n\n}\n<\/script>\n\n\n<style lang=\"less\" scoped>\n\n<\/style><\/code><\/pre>\n\n\n\n
div\u6807\u7b7e\u4e2d\u52a0class:<\/p>\n\n\n\n
\u5173\u8054 CSS \u6837\u5f0f\u89c4\u5219<\/strong>\uff1a\u8fd9\u662f\u6700\u4e3b\u8981\u7684\u4f5c\u7528\u3002\u5728\u5bf9\u5e94\u7684 CSS \u6587\u4ef6\uff08\u6216\u8005\u5728 Vue \u7ec4\u4ef6\u7684 <style><\/code> \u90e8\u5206\u7b49\uff09\u4e2d\uff0c\u53ef\u4ee5\u901a\u8fc7\u5b9a\u4e49 .login_container<\/code> \u8fd9\u4e2a CSS \u7c7b\u6765\u4e3a\u8be5 <div><\/code> \u5143\u7d20\u8bbe\u7f6e\u5404\u79cd\u5404\u6837\u7684\u6837\u5f0f\u5c5e\u6027\uff0c\u6bd4\u5982\u8bbe\u7f6e\u80cc\u666f\u989c\u8272\u3001\u5b57\u4f53\u5927\u5c0f\u3001\u8fb9\u6846\u6837\u5f0f\u3001\u5185\u8fb9\u8ddd\u3001\u5916\u8fb9\u8ddd\u7b49\u7b49\u3002\u4f8b\u5982\uff1a<\/p>\n\n\n\n
.login_container {\n    background-color: #f5f5f5;\n    font-size: 16px;\n    border: 1px solid #ccc;\n    padding: 20px;\n    margin: 10px;\n}<\/code><\/pre>\n\n\n\n
<el-form><\/code> \u7ec4\u4ef6<\/p>\n\n\n\n
<el-form ref=\"loginFormRef\" :model=\"loginForm\" class=\"login_form\" label-width=\"0\">\n                <!-- \u7528\u6237\u540d -->\n                <el-form-item>\n                    <el-input v-model=\"loginForm.username\"><\/el-input>\n                <\/el-form-item>\n                <!-- \u5bc6\u7801 -->\n                <el-form-item>\n                    <el-input v-model=\"loginForm.password\"><\/el-input>\n                <\/el-form-item>\n                <!-- \u6309\u94ae -->\n                <el-form-item class=\"btns\">\n                    <el-button type=\"primary\" disabled>\u63d0\u4ea4<\/el-button>\n                    <el-button type=\"info\" disabled>\u91cd\u7f6e<\/el-button>\n                <\/el-form-item>\n\n            <\/el-form><\/code><\/pre>\n\n\n\n
\u529f\u80fd\u6982\u8ff0<\/strong>\uff1a\u8fd9\u662f Element UI \u5e93\u4e2d\u7528\u4e8e\u521b\u5efa\u8868\u5355\u7684\u7ec4\u4ef6\u3002\u5b83\u63d0\u4f9b\u4e86\u65b9\u4fbf\u7684\u65b9\u5f0f\u6765\u6784\u5efa\u548c\u7ba1\u7406\u8868\u5355\u76f8\u5173\u7684\u529f\u80fd\uff0c\u6bd4\u5982\u6536\u96c6\u7528\u6237\u8f93\u5165\u3001\u8fdb\u884c\u8868\u5355\u9a8c\u8bc1\u7b49<\/p>\n\n\n\n