Springboot+VUE

最新推荐文章于 2024-07-14 21:33:55 发布
最新推荐文章于 2024-07-14 21:33:55 发布
阅读量168 收藏
点赞数
文章标签： spring boot vue.js 后端
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_58259152/article/details/131253037
版权

第一步:导入数据

/*
 Navicat Premium Data Transfer

 Source Server         : zzj
 Source Server Type    : MySQL
 Source Server Version : 50733
 Source Host           : localhost:3306
 Source Schema         : goods

 Target Server Type    : MySQL
 Target Server Version : 50733
 File Encoding         : 65001

 Date: 16/06/2023 20:03:25
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for books
-- ----------------------------
DROP TABLE IF EXISTS `books`;
CREATE TABLE `books`  (
  `book_id` int(6) NOT NULL,
  `type_id` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `book_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `author` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `publisher` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `price` int(3) NULL DEFAULT NULL,
  PRIMARY KEY (`book_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of books
-- ----------------------------
INSERT INTO `books` VALUES (109101, 'BAS', '高等数学', '李方健', '清华大学出版社', 20);
INSERT INTO `books` VALUES (109104, 'BAS', '离散数学', '孙德风', '天津大学出版社', 22);
INSERT INTO `books` VALUES (109107, 'ELC', '数字电路', '刘国庆', '高等教育出版社', 13);
INSERT INTO `books` VALUES (109109, 'CMP', 'C语言程序设计', '谭浩强', '清华大学出版社', 15);
INSERT INTO `books` VALUES (109110, 'CMP', '数据结构', '王志国', '高等教育出版社', 32);
INSERT INTO `books` VALUES (109111, 'CMP', '操作系统', '王志国', '高等教育出版社', 25);
INSERT INTO `books` VALUES (109112, 'CMP', '计算机组成原理', '张小敏', '南大在学出版社', 27);
INSERT INTO `books` VALUES (109113, 'CMP', '微机原理与接口技术', '刘国庆', '人民大学出版社', 34);
INSERT INTO `books` VALUES (109114, 'CMP', '数据库原理', '彭来德', '高等教育出版社', 16);
INSERT INTO `books` VALUES (109115, 'CMP', '计算机网络', '马国露', '人民大学出版社', 11);
INSERT INTO `books` VALUES (109116, 'CMP', '计算机网络', '谭浩强', '南大在学出版社', 13);
INSERT INTO `books` VALUES (109117, 'CMP', '编译原理', '方刚', '清华大学出版社', 38);
INSERT INTO `books` VALUES (209101, 'CMP', 'VB与WINDOWS程序设计', '谭浩强', '清华大学出版社', 30);
INSERT INTO `books` VALUES (209102, 'CMP', 'C++与面向对象技术', '谭浩强', '人民大学出版社', 19);
INSERT INTO `books` VALUES (209103, 'CMP', 'Java与网络程序设计', '付勇', '高等教育出版社', 20);
INSERT INTO `books` VALUES (209106, 'CMP', '单片机原理及应用', '刘国庆', '人民大学出版社', 22);
INSERT INTO `books` VALUES (209107, 'CMP', 'PLC原理及其应用开发', '刘国庆', '南大在学出版社', 16);
INSERT INTO `books` VALUES (209111, 'CMP', '人工智能导论', '丁宝康', '高等教育出版社', 18);
INSERT INTO `books` VALUES (209116, 'CMP', '信息论与编码学概论', '丁宝康', '高等教育出版社', 21);
INSERT INTO `books` VALUES (209117, 'CMP', '密码学基础', '张顺志', '人民大学出版社', 25);
INSERT INTO `books` VALUES (209123, 'CMP', 'Internet应用及网页设计', '李朋', '高等教育出版社', 16);
INSERT INTO `books` VALUES (209124, 'CMP', '多媒体技术及应用', '谭浩强', '高等教育出版社', 15);
INSERT INTO `books` VALUES (209130, 'CMP', 'PB与数据库应用开发', '张华强', '清华大学出版社', 42);
INSERT INTO `books` VALUES (209132, 'CMP', '计算机图形学', '徐志超', '人民大学出版社', 27);
INSERT INTO `books` VALUES (309102, 'CMP', '计算机学科教学论', '丁宝康', '高等教育出版社', 12);
INSERT INTO `books` VALUES (309103, 'CMP', '中学计算机教材研究与分析', '徐志超', '人民大学出版社', 14);
INSERT INTO `books` VALUES (309104, 'CMP', '信息技术概论', '付勇', '天津大学出版社', 24);
INSERT INTO `books` VALUES (309105, 'CMP', '数据库分析与设计', '丁宝康', '人民大学出版社', 30);
INSERT INTO `books` VALUES (309106, 'CMP', '数据库导论', '付勇', '清华大学出版社', 29);

-- ----------------------------
-- Table structure for borrow_info
-- ----------------------------
DROP TABLE IF EXISTS `borrow_info`;
CREATE TABLE `borrow_info`  (
  `reader_id` int(7) NOT NULL,
  `book_id` int(6) NOT NULL,
  `borrow_time` date NULL DEFAULT NULL,
  `notes` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`reader_id`, `book_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of borrow_info
-- ----------------------------
INSERT INTO `borrow_info` VALUES (34103, 109101, '2005-06-02', 'NULL');
INSERT INTO `borrow_info` VALUES (34301, 209130, '2005-06-14', 'NULL');
INSERT INTO `borrow_info` VALUES (34301, 209132, '2005-06-01', 'NULL');
INSERT INTO `borrow_info` VALUES (34301, 309102, '2005-06-09', 'NULL');
INSERT INTO `borrow_info` VALUES (34301, 309103, '2005-06-21', 'NULL');
INSERT INTO `borrow_info` VALUES (34301, 309104, '2005-06-14', 'NULL');
INSERT INTO `borrow_info` VALUES (34429, 109107, '2005-06-01', 'NULL');
INSERT INTO `borrow_info` VALUES (134101, 109101, '2005-06-01', 'NULL');
INSERT INTO `borrow_info` VALUES (134101, 109109, '2005-06-03', 'NULL');
INSERT INTO `borrow_info` VALUES (134102, 109104, '2005-06-08', 'NULL');
INSERT INTO `borrow_info` VALUES (134102, 109110, '2005-06-30', 'NULL');
INSERT INTO `borrow_info` VALUES (134103, 109111, '2005-06-13', 'NULL');
INSERT INTO `borrow_info` VALUES (134104, 109107, '2005-06-01', 'NULL');
INSERT INTO `borrow_info` VALUES (134104, 109112, '2005-06-01', 'NULL');
INSERT INTO `borrow_info` VALUES (134105, 109109, '2005-06-01', 'NULL');
INSERT INTO `borrow_info` VALUES (134105, 109113, '2005-06-14', 'NULL');
INSERT INTO `borrow_info` VALUES (134106, 109114, '2005-06-01', 'NULL');
INSERT INTO `borrow_info` VALUES (134107, 109115, '2005-06-01', 'NULL');
INSERT INTO `borrow_info` VALUES (134108, 109116, '2005-06-12', 'NULL');
INSERT INTO `borrow_info` VALUES (134109, 109117, '2005-06-01', 'NULL');
INSERT INTO `borrow_info` VALUES (134110, 209101, '2005-06-22', 'NULL');
INSERT INTO `borrow_info` VALUES (134111, 209102, '2005-06-01', 'NULL');
INSERT INTO `borrow_info` VALUES (134112, 209103, '2005-06-16', 'NULL');
INSERT INTO `borrow_info` VALUES (134113, 209106, '2005-06-01', 'NULL');
INSERT INTO `borrow_info` VALUES (134114, 209107, '2005-06-11', 'NULL');
INSERT INTO `borrow_info` VALUES (134115, 209111, '2005-06-01', 'NULL');
INSERT INTO `borrow_info` VALUES (134116, 209106, '2005-06-14', 'NULL');
INSERT INTO `borrow_info` VALUES (134426, 109110, '2005-06-15', 'NULL');
INSERT INTO `borrow_info` VALUES (134427, 109111, '2005-06-05', 'NULL');
INSERT INTO `borrow_info` VALUES (134428, 109112, '2005-06-05', 'NULL');
INSERT INTO `borrow_info` VALUES (134429, 109113, '2005-06-05', 'NULL');
INSERT INTO `borrow_info` VALUES (134430, 109114, '2005-06-05', 'NULL');
INSERT INTO `borrow_info` VALUES (134430, 209103, '2005-06-05', 'NULL');
INSERT INTO `borrow_info` VALUES (134430, 209106, '2005-06-05', 'NULL');
INSERT INTO `borrow_info` VALUES (134430, 209107, '2005-06-21', 'NULL');
INSERT INTO `borrow_info` VALUES (134430, 209111, '2005-06-05', 'NULL');
INSERT INTO `borrow_info` VALUES (134430, 209116, '2005-06-05', 'NULL');
INSERT INTO `borrow_info` VALUES (134430, 209124, '2005-06-05', 'NULL');
INSERT INTO `borrow_info` VALUES (134431, 109115, '2005-06-01', 'NULL');
INSERT INTO `borrow_info` VALUES (134432, 109116, '2005-06-14', 'NULL');
INSERT INTO `borrow_info` VALUES (134433, 109117, '2005-06-01', 'NULL');
INSERT INTO `borrow_info` VALUES (134434, 209101, '2005-06-02', 'NULL');
INSERT INTO `borrow_info` VALUES (134435, 209102, '2005-06-01', 'NULL');

-- ----------------------------
-- Table structure for goods_info
-- ----------------------------
DROP TABLE IF EXISTS `goods_info`;
CREATE TABLE `goods_info`  (
  `goodsid` int(11) NOT NULL AUTO_INCREMENT,
  `goodsname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `goodstype` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `goodsstore` int(11) NOT NULL,
  `goodsprice` decimal(8, 2) NOT NULL,
  PRIMARY KEY (`goodsid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of goods_info
-- ----------------------------
INSERT INTO `goods_info` VALUES (1, '佳洁士', '牙膏', 66, 300.00);
INSERT INTO `goods_info` VALUES (2, '舒肤佳', '香皂', 4, 500.00);
INSERT INTO `goods_info` VALUES (3, 'Dell', '电脑', 900, 98.00);
INSERT INTO `goods_info` VALUES (4, '小天鹅', '洗衣机', 800, 96.00);

-- ----------------------------
-- Table structure for readers
-- ----------------------------
DROP TABLE IF EXISTS `readers`;
CREATE TABLE `readers`  (
  `reader_id` int(7) NOT NULL,
  `name` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `sex` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '男',
  `dept` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `status` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `address` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`reader_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of readers
-- ----------------------------
INSERT INTO `readers` VALUES (34103, '范元帅', '男', '艺术学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (34301, '杨凡', '男', '电信学院', '教师', '八里台禄小区');
INSERT INTO `readers` VALUES (34429, '许丹丹', '女', '艺术学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134101, '陈超', '男', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134102, '范金良', '男', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134103, '国皓', '男', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134104, '贺云龙', '男', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134105, '刘德文', '男', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134106, '彭俊', '男', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134107, '彭志成', '男', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134108, '沈举', '男', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134109, '田强', '男', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134110, '王旭', '男', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134111, '吴卫', '男', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134112, '熊敏', '男', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134113, '颜东', '男', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134114, '殷建鹏', '男', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134115, '周春林', '男', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134116, '陈洁', '女', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134117, '陈琪', '女', '计算机学院', '研究生', '师大南院');
INSERT INTO `readers` VALUES (134118, '丁璐', '女', '计算机学院', '研究生', '师大南院');
INSERT INTO `readers` VALUES (134119, '丁岩', '女', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134120, '董蕾', '女', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134121, '何芳', '女', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134122, '蒋莎', '女', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134123, '李颖', '女', '计算机学院', '研究生', '师大南院');
INSERT INTO `readers` VALUES (134124, '李芬', '女', '计算机学院', '研究生', '师大南院');
INSERT INTO `readers` VALUES (134125, '李锦萍', '女', '计算机学院', '教授', '师大南院');
INSERT INTO `readers` VALUES (134126, '李小汐', '女', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134127, '李玥玖', '女', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134128, '郦莎', '女', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134129, '廖英', '女', '计算机学院', '本科生', '师大南院');
INSERT INTO `readers` VALUES (134130, '林琳', '女', '计算机学院', '教师', '师大南院');
INSERT INTO `readers` VALUES (134131, '林敏', '女', '计算机学院', '本科生', '师大南院');

-- ----------------------------
-- Table structure for tbl_class
-- ----------------------------
DROP TABLE IF EXISTS `tbl_class`;
CREATE TABLE `tbl_class`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tbl_class
-- ----------------------------
INSERT INTO `tbl_class` VALUES (1, '小班');
INSERT INTO `tbl_class` VALUES (2, '中班');
INSERT INTO `tbl_class` VALUES (3, '大班');

-- ----------------------------
-- Table structure for tbl_dept
-- ----------------------------
DROP TABLE IF EXISTS `tbl_dept`;
CREATE TABLE `tbl_dept`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `loc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tbl_dept
-- ----------------------------
INSERT INTO `tbl_dept` VALUES (1, '研发部', '郑州');
INSERT INTO `tbl_dept` VALUES (2, '市场部', '北京');
INSERT INTO `tbl_dept` VALUES (3, '财务部', '成都');
INSERT INTO `tbl_dept` VALUES (4, '人事部', '杭州');
INSERT INTO `tbl_dept` VALUES (6, '商务部', '重庆');
INSERT INTO `tbl_dept` VALUES (12, '商务部', '青岛');
INSERT INTO `tbl_dept` VALUES (13, '商务部', '青岛');

-- ----------------------------
-- Table structure for tbl_emp
-- ----------------------------
DROP TABLE IF EXISTS `tbl_emp`;
CREATE TABLE `tbl_emp`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `salary` double(10, 2) NULL DEFAULT NULL COMMENT '薪水',
  `birthday` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '出生日期',
  `dept_id` int(11) NULL DEFAULT NULL COMMENT '部门id 关联部门表',
  `headImg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tbl_emp
-- ----------------------------
INSERT INTO `tbl_emp` VALUES (1, '刘德华', 2500.00, '2000-10-11', 2, '\r\nhttps://aaamain.oss-cn-beijing.aliyuncs.com/01.jpg');
INSERT INTO `tbl_emp` VALUES (2, '张学友', 3200.00, '2001-11-15', 2, '\r\nhttps://aaamain.oss-cn-beijing.aliyuncs.com/05.jpg');
INSERT INTO `tbl_emp` VALUES (3, '黎明', 2800.00, '2002-12-12', 4, '\r\n\r\nhttps://aaamain.oss-cn-beijing.aliyuncs.com/09.jpg');
INSERT INTO `tbl_emp` VALUES (4, '郭富城', 5000.00, '2008-11-12', 3, '\r\n\r\nhttps://aaamain.oss-cn-beijing.aliyuncs.com/09.jpg');
INSERT INTO `tbl_emp` VALUES (5, '张振嘉', 50000.00, '2010-12-12', 1, '\r\nhttps://aaamain.oss-cn-beijing.aliyuncs.com/01.jpg');
INSERT INTO `tbl_emp` VALUES (6, '谷歌', 122.00, '2023-05-01', 2, '\r\n\r\nhttps://aaamain.oss-cn-beijing.aliyuncs.com/09.jpg');
INSERT INTO `tbl_emp` VALUES (7, '冻干粉', 12345.00, '2023-05-15', 2, '\r\nhttps://aaamain.oss-cn-beijing.aliyuncs.com/01.jpg');
INSERT INTO `tbl_emp` VALUES (8, '是多少', 1230.22, '2023-05-15', 3, '\r\nhttps://aaamain.oss-cn-beijing.aliyuncs.com/01.jpg');
INSERT INTO `tbl_emp` VALUES (9, '艾尔登', 123.00, '2023-05-08', 1, '\r\nhttps://aaamain.oss-cn-beijing.aliyuncs.com/01.jpg');
INSERT INTO `tbl_emp` VALUES (10, '第三方', 145.02, '2023-05-04', 3, '\r\nhttps://aaamain.oss-cn-beijing.aliyuncs.com/01.jpg');
INSERT INTO `tbl_emp` VALUES (11, '东方闪电', 1548.23, '2023-05-15', 2, '\r\nhttps://aaamain.oss-cn-beijing.aliyuncs.com/01.jpg');
INSERT INTO `tbl_emp` VALUES (12, '挖地方', 145.20, '2023-05-15', 4, '\r\nhttps://aaamain.oss-cn-beijing.aliyuncs.com/01.jpg');
INSERT INTO `tbl_emp` VALUES (13, '山东人', 165.23, '2023-05-11', 2, '\r\nhttps://aaamain.oss-cn-beijing.aliyuncs.com/01.jpg');
INSERT INTO `tbl_emp` VALUES (14, '色彩上午', 15.65, '2023-05-10', 2, '\r\nhttps://aaamain.oss-cn-beijing.aliyuncs.com/01.jpg');
INSERT INTO `tbl_emp` VALUES (15, '课骨干', 156.23, '2023-05-15', 2, '\r\nhttps://aaamain.oss-cn-beijing.aliyuncs.com/01.jpg');
INSERT INTO `tbl_emp` VALUES (16, '问题吧', 153.20, '2023-05-02', 3, '\r\nhttps://aaamain.oss-cn-beijing.aliyuncs.com/01.jpg');
INSERT INTO `tbl_emp` VALUES (19, '发发发', 888.80, '2023-05-15', 3, 'https://aaamain.oss-cn-beijing.aliyuncs.com/33f9dab9-e5d8-4171-b0c2-dcadcb43323104.jpg');
INSERT INTO `tbl_emp` VALUES (20, 'AAA', 150.56, '2023-05-08', 2, 'https://aaamain.oss-cn-beijing.aliyuncs.com/d0e5d586-9903-4fed-9652-0ac90b6add6f00.jpg');
INSERT INTO `tbl_emp` VALUES (21, '儿童', 12345.00, '2023-05-08', 3, 'https://aaamain.oss-cn-beijing.aliyuncs.com/75ef686b-7df1-4b8d-b6b9-99cd126c53b101.jpg');
INSERT INTO `tbl_emp` VALUES (22, '规划局', 12312.00, '2023-05-15', 2, 'https://aaamain.oss-cn-beijing.aliyuncs.com/35.jpg');
INSERT INTO `tbl_emp` VALUES (24, '黎明', 215.23, '2000-02-17', 3, 'https://qy165.oss-cn-qingdao.aliyuncs.com/1.jpg');

-- ----------------------------
-- Table structure for tbl_student
-- ----------------------------
DROP TABLE IF EXISTS `tbl_student`;
CREATE TABLE `tbl_student`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `age` int(11) NULL DEFAULT NULL,
  `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `class_id` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `class_id`(`class_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tbl_student
-- ----------------------------
INSERT INTO `tbl_student` VALUES (1, '输入', 18, '男', 2);
INSERT INTO `tbl_student` VALUES (2, '二手', 20, '女', 3);
INSERT INTO `tbl_student` VALUES (3, '泰国', 18, '男', 3);
INSERT INTO `tbl_student` VALUES (4, '示范', 18, '男', 2);
INSERT INTO `tbl_student` VALUES (5, '覆盖', 19, '女', 1);
INSERT INTO `tbl_student` VALUES (6, '幅度', 20, '女', 1);
INSERT INTO `tbl_student` VALUES (14, '干饭', 18, '女', 2);
INSERT INTO `tbl_student` VALUES (15, '干饭', 20, '女', 1);

SET FOREIGN_KEY_CHECKS = 1;

2.搭建springboot项目工程 ,导入所需的maven依赖

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.3.12.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.aaa</groupId>
    <artifactId>boot03</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>boot03</name>
    <description>boot03</description>
    <properties>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.3.1</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.4.6</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <configuration>
                    <excludes>
                        <exclude>
                            <groupId>org.projectlombok</groupId>
                            <artifactId>lombok</artifactId>
                        </exclude>
                    </excludes>
                </configuration>
            </plugin>
        </plugins>
    </build>

</project>

3.连接数据库

#数据源信息
spring.dataource.driver-class-name=com.mysql.jdbc.Driver
# characterEncoding防止您添加到数据的数据出现乱码。
# jdbc:mysql://localhost:3306/goods?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
spring.datasource.url=jdbc:mysql://localhost:3306/goods?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
# serverTimezone=Asia/Shanghai&characterEncoding=UTF-8
spring.datasource.username=root
spring.datasource.password=123456

#指定mybatis映射文件的路径 classpath编译后的路径
mybatis.mapper-locations=classpath:mapper/*.xml
#控制台打印sql日志
mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

4.创建Controller层

 

package com.aaa.controller;

import com.aaa.pojo.Emp;
import com.aaa.service.EmpService;
import com.aaa.vo.EmpVo;
import com.aaa.vo.ResultVo;
import com.github.pagehelper.PageInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;


/**
 * @ClassName: EmpController
 * @Description: TODO
 * @date: 2023/6/16 14:41
 * @author: zzj
 * @Version: 1.0
 */

/**
 * @RestController
 *
 * 相当于@Controller+@ResponseBody合在一起的作用。
 *  @RestController是Spring4.0之后新增的注解。
 *	@Controller	  处理 Http 请求
 *  @ResponseBody 后端 json 格式 数据响应给后端
 * @RestController 相当于处理http请求.返回json格式数据
 *
 *
 */
@RestController
@RequestMapping("/emp")
public class EmpController {
    @Autowired
    private EmpService empService;

    // @PostMappering 用于添加时的操作
    @PostMapping
    public ResultVo save(@RequestBody Emp emp){
        Integer save = empService.save(emp);
        return save > 0 ? new ResultVo(200,"添加成功",null) : new ResultVo(500,"添加失败",null);
    }
    // @putmapping 用于修好时的操作
    @PutMapping
    public ResultVo update(@RequestBody Emp emp){
        Integer save = empService.upadte(emp);
        return save > 0 ? new ResultVo(200,"修改成功",null) : new ResultVo(500,"修改失败",null);
    }
    // @deletemapping 用于删除时的操作
    @DeleteMapping
    public ResultVo delete(Integer id){
        Integer delete = empService.delete(id);
        return delete > 0? new ResultVo(200,"删除成功",null) : new ResultVo(500,"删除失败",null);
    }

    // @GetMapping 用于查询时的操作
    @GetMapping
    public ResultVo get(Integer id){
        System.out.println(id);
        Emp emp = empService.selectId(id);
        return new ResultVo(200,"查询成功",emp);
    }

    // 如果前端传递json对象 那么必须使用post或put 提交
    @PostMapping("/findByCondition")
    public ResultVo findByCondition(Integer current, Integer pageSize, @RequestBody EmpVo empVo){
        PageInfo<Emp> pageInfo = empService.selectByCondition(current,pageSize,empVo);
        return new ResultVo(200,"查询成功",pageInfo);
    }

}

5.创建service层接口

package com.aaa.service;

import com.aaa.pojo.Emp;
import com.aaa.vo.EmpVo;
import com.github.pagehelper.PageInfo;
import org.springframework.stereotype.Service;

/**
 * @ClassName: EmpService
 * @Description: TODO
 * @date: 2023/6/16 14:48
 * @author: zzj
 * @Version: 1.0
 */

public interface EmpService {
    public Integer save(Emp emp);

    Integer upadte(Emp emp);

    Integer delete(Integer id);

    Emp selectId(Integer id);

    PageInfo<Emp> selectByCondition(Integer current, Integer pageSize, EmpVo empVo);
}

创建service接口实现类

package com.aaa.service.Impl;

import com.aaa.dao.EmpDao;
import com.aaa.pojo.Emp;
import com.aaa.service.EmpService;
import com.aaa.vo.EmpVo;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * @ClassName: EmpServiceImpl
 * @Description: TODO
 * @date: 2023/6/16 15:56
 * @author: zzj
 * @Version: 1.0
 */

@Service
public class EmpServiceImpl implements EmpService {

    @Autowired
    private EmpDao empDao;
    @Override
    public Integer save(Emp emp) {
        return empDao.save(emp);
    }

    @Override
    public Integer upadte(Emp emp) {
        return empDao.update(emp);
    }

    @Override
    public Integer delete(Integer id) {
        return empDao.delete(id);
    }

    @Override
    public Emp selectId(Integer id) {
        return empDao.selectId(id);
    }

    @Override
    public PageInfo<Emp> selectByCondition(Integer current, Integer pageSize, EmpVo empVo) {

        PageHelper.startPage(current,pageSize);
        List<Emp> emps = empDao.selectByCondition(empVo);
        PageInfo<Emp> pageInfo = new PageInfo<>(emps);
        return pageInfo;
    }


}

6.创建dao层接口

package com.aaa.dao;

import com.aaa.pojo.Emp;
import com.aaa.vo.EmpVo;

import java.util.List;

/**
 * @ClassName: EmpDao
 * @Description: TODO
 * @date: 2023/6/16 16:00
 * @author: zzj
 * @Version: 1.0
 */
public interface EmpDao {
    Integer save(Emp emp);

    Integer update(Emp emp);

    Integer delete(Integer id);

    Emp selectId(Integer id);

    List<Emp> selectByCondition(EmpVo empVo);
}

 书写sql语句

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--namesapce的内容必须和对应的接口路径映射-->
<mapper namespace="com.aaa.dao.EmpDao">

    <insert id="save">
        insert into tbl_emp( name, salary, birthday, dept_id, headimg)
        values (#{name},#{salary},#{birthday},#{deptId},#{headimg})
    </insert>
    <update id="update">
        update tbl_emp set name = #{name},salary = #{salary},birthday = #{birthday},
            dept_id = #{deptId},headimg = #{headimg}
            where id = #{id}
    </update>

    <delete id="delete">
        delete from tbl_emp where id= #{id}
    </delete>

    <select id="selectId" resultType="com.aaa.pojo.Emp">
        select * from tbl_emp where id = #{id}
    </select>

    <select id="selectByCondition" resultType="com.aaa.pojo.Emp">
        select e.*,d.id did,d.name from tbl_emp e join tbl_dept d on e.dept_id = d.id
        <where>
            <if test="name != null and name!=''">
                and e.name like concat('%',#{name},'%')
            </if>

            <if test="birthday != null and birthday!=''">
                and e.birthday = #{birthday}
            </if>
        </where>
    </select>


</mapper>

像太阳那样耀眼
关注
SpringBoot+Vue
07-24
SpringBoot+Vue 实现的前后端分离技术，感谢代码技术的编写者，看了之后学到了很多，建议可以看看。Vue是建立在node.js环境搭好的情况下运行，里面有一个自己整理的Vue环境搭建文档，希望可以帮到，有什么问题望大家告知，一起学习
springboot+vue.rar
08-10
这是关于springboot+vue前后端分离的入门级项目，前端使用了vue框架，后端使用了springboot+mybatis+mysql+shiro，前端包含四个页面，包括首页，笔记本，图书页面的增删改查功能，后台页面，其中后台页面只有页面，具体的逻辑没有实现。
springBoot+vue
rincoo_的博客
07-04 350
配置文件 server: port: 8081 ​ mybatis: configuration:   log-impl: org.apache.ibatis.logging.stdout.StdOutImpl mapper-locations: mapper/*.xml ​ spring: datasource:   url: jdbc:mysql://localhost:3306/kj08?useUnicode=true&characterEncodi
SpringBoot + vue 管理系统
最新发布
小林的博客
07-14 2079
SpringBoot + vue 管理系统步骤： 生成的pom.xml文件 创建项目工程目录结构配置文件application.yml 设置统一返回数据 构建一个vue项目功能模块分为六部分：班级管理、学员管理、部门管理、员工管理、员工信息统计、学员信息统计开发的部门管理功能包含： 3.1.2、后端代码实现 service接口 serviceImpl 3.2、员工管理 我们可以把员工管理功能分为： 3.2.2、后端代码实现 mapper.xml 因为需要涉及到oss文件上传所
springboot+vue
weixin_44953928的博客
05-23 4755
文章目录一、环境需求1.vue方式 一方式 二2.element-ul2 vue 的简单介绍2.1 组件：简单介绍2.2全局布置2.3 组件内设置和改动2.3.1、style2.3.2背景颜色和文字颜色2.3.3 点击高亮2.3.4 导航栏收缩2.3.5 加图片2.3.3 主页设置(搜索框、分页等等) 一、环境需求 jdk 1.8 mysql 5.7 node navicat idea 1.vue 官网：https://cn.vuejs.org/v2/guide/ 方式 一 方式同：https:/
基于springboot+vue开发前后端分离的开源开发框架源码.zip
01-09
基于springboot+vue开发前后端分离的开源开发框架源码.zip 基于springboot+vue开发前后端分离的开源开发框架源码.zip 基于springboot+vue开发前后端分离的开源开发框架源码.zip 基于springboot+vue开发前后端分离的...
Java毕业设计 基于SpringBoot+Vue+ChatGPT的对话知识分享面试辅助网站源码+部署文档+全部资料（优秀项目
04-22
Java毕业设计 基于SpringBoot+Vue+ChatGPT的对话知识分享面试辅助网站源码+部署文档+全部资料（优秀项目Java毕业设计 基于SpringBoot+Vue+ChatGPT的对话知识分享面试辅助网站源码+部署文档+全部资料（优秀项目Java...
基于SpringBoot+Vue的购物商城管理系统源码+数据库（高分毕业设计）.zip
06-14
基于SpringBoot+Vue的购物商城管理系统源码+数据库（高分毕业设计）.zip 已获导师指导并通过的高分项目，也可作为期末大作业和课程设计，纯手打高分项目，代码完整下载可用，小白也可实战。 基于SpringBoot+Vue的...
基于SpringBoot+vue知识管理系统（源码+部署说明+演示视频+源码介绍）.zip
03-10
基于SpringBoot+vue的知识管理系统是一个前后端分离的项目，前端使用Vue.js框架，后端使用SpringBoot框架。该系统主要用于知识管理，包括知识的添加、删除、修改、查询等功能。 项目源码主要包括两个部分：前端和...
基于springboot+vue的商城管理系统源码+数据库（高分毕业设计）.zip
06-08
基于springboot+vue的商城管理系统源码+数据库（高分毕业设计）.zip 高分毕业设计项目，代码完整下载可用，纯手打高分毕业设计，也可作为期末大作业和课程设计，小白也可实战。 基于springboot+vue的商城管理系统...
springboot+shiro+boostrap+vue.js
09-28
此项目采用的是springboot+shiro+boostrap+vue.js 对于初学springboot,vue.js 的同学有很大的帮助，该项目采用的是maven 项目中有sql脚本，直接部署运行近可以跑起来了，登录用户名和密码都是admin
Springboot+Vue
xxiyy0411的博客
11-29 344
Springboot+Vue Springboot+Vue博客项目总结 ...
SpringBoot+Vue项目（后端项目搭建 + 添加家居）
Sun的个人博客
03-19 1772
【代码】SpringBoot+Vue项目（后端项目搭建 + 添加家居）
springboot+vue整理
雨落倾城的博客
06-28 189
今天整理了一个springboot+vue的项目文档，自己写下收藏一下，省得以后找不到了。 项目下载链接：https://github.com/lenve/VBlog 这是一个多用户博客管理平台，采用Vue+SpringBoot开发。 blogserver对应springboot开发的后端代码，vueblog对应vue开发的前端代码。 前端结构介绍： 前端结构： 用idea运行vue项目的基础是先下载node.js,之后配置环境变量，在idea中下载vue插件。 idea运行vue项目时一直
SpringBoot+Vue开发环境配置指南
"SpringBoot+VUE开发环境搭建" 在现代软件开发中，SpringBoot和Vue.js是两个非常流行的技术框架，分别用于后端和前端开发。本资源主要讲解如何搭建一个整合SpringBoot后端和Vue.js前端的开发环境。以下是详细步骤：...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值