基于SpringBoot+Mybatus-Plus+Redis+SpringSecurity开发的公司官网

于 2024-04-07 13:27:05 发布
阅读量629 收藏 3
点赞数 3
文章标签： spring boot redis 后端
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_53445260/article/details/132059734
版权
简介

本项目中前端使用 Vue 框架进行编写，后台使用 SpringBoot+StringSecurity+Mybayis-Plus 架构，并选用 mysql数据库和 Redis 数据库进行设计与开发工作。

基于奇响天官网的优化开发
项目是一个由前端展示界面和后台控制界面组成的公司
官网，满足于用户查看以及管理员管理界面信息的功能。前台操作是
用户进行查看，反馈等行为操作；

后台管理主要是管理员可以对网页
上的展示的公司，成员等信息进行管理。


奇响天官网的特点是较为新颖的前段展示界面，让用户能便捷的
查找到自己需求的信息，和后台便捷的修改功能；

用户访问无需登录
便可查看全部信息，登录后台界面必须进行登录操作，必要时可进行
注册新的管理员账号。

一、配置环境 :

JDK8.0，Maven3.8.3，Redis4.0.0，Mysql8.0.30，

二、创建SpringBoot项目，版本2.4.5
1.新建项目结构

2.application.yml文件内容

部分需要根据自己的情况修改

server:
  port: 8080
spring:
  application:
    name: fantasy
  datasource:
    druid:
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://127.0.0.1:3306/fantasy?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true
      username: root         #你的mysql账号密码
      password: 123456
  redis:
    host: 192.168.100.100     #启动redis服务的虚拟机的ip
    port: 6379                #默认端口号
    password: 123456          #你的密码
    database: 0           
  cache:
    redis:
      time-to-live: 1800000    #缓存过期时间
mybatis-plus:
  configuration:
    #数据库名称转驼峰类型
    map-underscore-to-camel-case: true
#    日志输出
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
#      设置id的生成策略
  global-config:
    db-config:
      id-type: auto

company:
  path: D:\jpg\md\    #修改成你的照片存储位置
3.pom文件
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.4.5</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>

    <dependencies>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.2</version>
        </dependency>

        <!--登录判断，拦截spring-security-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-security</artifactId>
        </dependency>

        <!--@Sfj4-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>

        <!--json格式转换-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.76</version>
        </dependency>

        <!--@Date-->
        <dependency>
            <groupId>commons-lang</groupId>
            <artifactId>commons-lang</artifactId>
            <version>2.6</version>
        </dependency>

        <!--mysql连接器
        与数据库建立连接
        发送 SQL 语句
        处理结果
        -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

        <!--数据库连接池-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.23</version>
        </dependency>

        <!--spring catch缓存处理框架-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-cache</artifactId>
        </dependency>

        <!--redis数据库，存储缓存-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-redis</artifactId>
        </dependency>

        <!--swagger管理接口-->
        <dependency>
            <groupId>com.github.xiaoymin</groupId>
            <artifactId>knife4j-spring-boot-starter</artifactId>
            <version>3.0.2</version>
        </dependency>

    </dependencies>

    <!--将项目依赖的jar包 打包进jar或者war当中-->
    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <version>2.4.5</version>
            </plugin>
        </plugins>
    </build>
4.图片数据

https://gitee.com/wangzzpeng/pic.git

打不开，可采用数据库中的文件名，随便找些图片。

或者直接运行项目，在后台管理界面进行修改信息，导入你的图片。

 三、数据库搭建:

1.新建数据库fantasy

2.新建查询，复制sql代码，运行

/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 80030
 Source Host           : localhost:3306
 Source Schema         : fantasy

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

 Date: 21/07/2023 14:17:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for firm_event
-- ----------------------------
DROP TABLE IF EXISTS `firm_event`;
CREATE TABLE `firm_event`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `date_times` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `event` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 44 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of firm_event
-- ----------------------------
INSERT INTO `firm_event` VALUES (2, '2016年初', '奇响天外注册成立公司，同年加入成员有小N、林景、秦且歌、花玲、紫苏九月、肿圆。');
INSERT INTO `firm_event` VALUES (3, '2016年4月', '由奇响天外制作音频部分的动漫《唐山葬》在B站发布');
INSERT INTO `firm_event` VALUES (4, '2016年中', '奇响天外为游戏作品《崩坏3》配音，林簌、花玲、小N、Mace等成员参与。《崩坏3》由彭博担任配音总导演。');
INSERT INTO `firm_event` VALUES (5, '2017年4月', '杜冥鸦加入奇响天外，并担任《崩坏3》八重樱角色配音。');
INSERT INTO `firm_event` VALUES (6, '2017年至2018年间', '奇响天外配音并混录完成《无论如何都想加入生肖》、《忍者哈特利》等日本动画作品的中文版');
INSERT INTO `firm_event` VALUES (7, '2018年末至2019年初', '小敢、萧翟、鹿喑、宴宁、诺辰、子音、鱼冻加入奇响天外。');
INSERT INTO `firm_event` VALUES (8, '2018年', '彭博、林簌、小N、林景为核心团队成员，小N和诺亚分别作为导演完成了双语游戏《封印者》和迪士尼动画《元素英雄小波波》的配音工作，');
INSERT INTO `firm_event` VALUES (9, '2018年底', '林景担任《剑网三》舞台剧《曲云传》男主孙飞亮，展示出奇响天外团队配音以外的表演能力。');
INSERT INTO `firm_event` VALUES (10, '2019年', '奇响天外录音棚在上海市普陀区交通路2447号甘泉德比易园开业。 ');

-- ----------------------------
-- Table structure for firm_intro
-- ----------------------------
DROP TABLE IF EXISTS `firm_intro`;
CREATE TABLE `firm_intro`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司名',
  `intro` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '公司简介',
  `photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '图片',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of firm_intro
-- ----------------------------
INSERT INTO `firm_intro` VALUES (1, ' 上海奇响天外文化传播有限公司公司', '奇响天外文化传播有限公司位于上海，业务始于2014年，公司于2016年1月注册。公司业务以配音及设计为主，业务范围有演艺经纪，音像衍生品生产销售，舞台剧制作，展会活动策划、公关活动策划等。', 'b37e2a67-6138-41a5-b7f4-aa02d84d56cf.jpg');

-- ----------------------------
-- Table structure for firm_live
-- ----------------------------
DROP TABLE IF EXISTS `firm_live`;
CREATE TABLE `firm_live`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `member_id` int(0) NOT NULL COMMENT '成员id',
  `flat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '直播平台',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '直播名称',
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '直播号',
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '直播时间',
  `where_this` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of firm_live
-- ----------------------------
INSERT INTO `firm_live` VALUES (1, 1, 'bilibili', '笨笨笂_彭博', '28021954', '未知', 'https://live.bilibili.com/400738?broadcast_type=0&is_room_feed=0&spm_id_from=333.999.to_liveroom.0.click&live_from=86002');
INSERT INTO `firm_live` VALUES (2, 2, 'bilibili', '林景', '121231313', '18点', NULL);
INSERT INTO `firm_live` VALUES (3, 123, '123', '123', '123', '', NULL);
INSERT INTO `firm_live` VALUES (7, 1231, 'asdadasd', 'asasdasd', 'sadasdasd', NULL, NULL);
INSERT INTO `firm_live` VALUES (8, 123, 'wqeqe', 'qweqe', 'qwee', '', NULL);
INSERT INTO `firm_live` VALUES (9, 3, 'bilibili', '鹿喑', '302145', NULL, 'https://live.bilibili.com/558405?broadcast_type=0&is_room_feed=1&spm_id_from=333.999.to_liveroom.0.click&live_from=86002');
INSERT INTO `firm_live` VALUES (10, 4, 'bilibili', '秦且歌', '41190', NULL, 'https://live.bilibili.com/730921?broadcast_type=0&is_room_feed=1&spm_id_from=333.999.to_liveroom.0.click&live_from=86002');
INSERT INTO `firm_live` VALUES (11, 5, 'bilibili', '萧翟', '2764283', NULL, 'https://live.bilibili.com/888429?broadcast_type=0&is_room_feed=1&spm_id_from=333.999.to_liveroom.0.click&live_from=86002');
INSERT INTO `firm_live` VALUES (12, 6, 'bilibili', '鱼冻', '35303886', NULL, 'https://live.bilibili.com/6476327?broadcast_type=0&is_room_feed=1&spm_id_from=333.999.to_liveroom.0.click&live_from=86002');
INSERT INTO `firm_live` VALUES (13, 7, 'bilibili', '诺辰', '', NULL, NULL);
INSERT INTO `firm_live` VALUES (14, 8, 'bilibili', '肿圆', '319585', NULL, NULL);
INSERT INTO `firm_live` VALUES (15, 9, 'bilibili', '林簌', '7223194', NULL, 'https://live.bilibili.com/227422?broadcast_type=0&is_room_feed=1&spm_id_from=333.999.to_liveroom.0.click&live_from=86002');
INSERT INTO `firm_live` VALUES (16, 10, 'bilibili', '小N', '249118', NULL, 'https://live.bilibili.com/363889?broadcast_type=0&is_room_feed=1&spm_id_from=333.999.to_liveroom.0.click&live_from=86002');
INSERT INTO `firm_live` VALUES (17, 11, 'bilibili', 'bananaMace', '1589613', NULL, 'https://space.bilibili.com/1589613?spm_id_from=333.337.0.0');
INSERT INTO `firm_live` VALUES (18, 12, 'bilibili', '杜冥鸦', '325844', NULL, 'https://live.bilibili.com/5656730?broadcast_type=0&is_room_feed=0&spm_id_from=333.999.to_liveroom.0.click&live_from=86002');
INSERT INTO `firm_live` VALUES (19, 13, 'bilibili', '花玲', '7966', NULL, 'https://live.bilibili.com/597450?broadcast_type=0&is_room_feed=1&spm_id_from=333.999.to_liveroom.0.click&live_from=86002');
INSERT INTO `firm_live` VALUES (20, 14, 'bilibili', '多多poi', '11253297', NULL, 'https://live.bilibili.com/392523?broadcast_type=0&is_room_feed=1&spm_id_from=333.999.to_liveroom.0.click&live_from=86002');
INSERT INTO `firm_live` VALUES (21, 15, 'bilibili', '小敢', '642228', NULL, 'https://live.bilibili.com/6331310?broadcast_type=0&is_room_feed=1&spm_id_from=333.999.to_liveroom.0.click&live_from=86002');
INSERT INTO `firm_live` VALUES (22, 16, 'bilibili', '宴宁ccccc', '14897804', NULL, 'https://live.bilibili.com/7953876?broadcast_type=0&is_room_feed=1&spm_id_from=333.999.to_liveroom.0.click&live_from=86002');
INSERT INTO `firm_live` VALUES (23, 17, 'bilibili', '紫苏九月', '8199', NULL, 'https://live.bilibili.com/598192?broadcast_type=0&is_room_feed=1&spm_id_from=333.999.to_liveroom.0.click&live_from=86002');
INSERT INTO `firm_live` VALUES (24, 18, 'bilibili', '诺亚', '3493141629896727', NULL, 'https://live.bilibili.com/27433801?broadcast_type=0&is_room_feed=1&spm_id_from=333.999.to_liveroom.0.click&live_from=86002');
INSERT INTO `firm_live` VALUES (25, 19, 'bilibili', '风荷醉_子音追', '22152819', NULL, 'https://live.bilibili.com/10229354?broadcast_type=0&is_room_feed=1&spm_id_from=333.999.to_liveroom.0.click&live_from=86002');

-- ----------------------------
-- Table structure for firm_member
-- ----------------------------
DROP TABLE IF EXISTS `firm_member`;
CREATE TABLE `firm_member`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名字',
  `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '性别（female,male）',
  `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '艺名',
  `birthday` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '出生日期',
  `place` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '荣誉',
  `photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '照片',
  `plcpt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '职务',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 39 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of firm_member
-- ----------------------------
INSERT INTO `firm_member` VALUES (1, '彭博', 'male', '彭博', '02-12', '奇响天外创始人，有导演工作经验', '1.jpeg', NULL);
INSERT INTO `firm_member` VALUES (2, '林景', 'female', '林景', '07-18', '曾参加舞台表演', '2.jpeg', NULL);
INSERT INTO `firm_member` VALUES (3, '鹿喑', 'male', '鹿喑', '03-31', '配音演员', '3.jpeg', NULL);
INSERT INTO `firm_member` VALUES (4, '', 'male', '秦且歌', NULL, '青年配音演员', '4.jpeg', NULL);
INSERT INTO `firm_member` VALUES (5, '', 'male', '萧翟', '01-01', '新人配音演员', '5.jpeg', NULL);
INSERT INTO `firm_member` VALUES (6, NULL, 'male', '鱼冻', NULL, '新人配音演员', '6.jpeg', NULL);
INSERT INTO `firm_member` VALUES (7, NULL, 'male', '诺辰', NULL, '配音演员', '7.jpeg', NULL);
INSERT INTO `firm_member` VALUES (8, NULL, 'male', '肿圆', '01-01', '《舌尖上的中国2》副导演', '8.jpeg', NULL);
INSERT INTO `firm_member` VALUES (9, NULL, 'female', '林簌', '01-09', '配音演员，话剧演员', '9.jpeg', NULL);
INSERT INTO `firm_member` VALUES (10, '蒋丽', 'female', '小N', '', '女性配音演员', '10.jpeg', NULL);
INSERT INTO `firm_member` VALUES (11, NULL, 'female', 'Mace', '04-05', '配音演员', '11.jpeg', NULL);
INSERT INTO `firm_member` VALUES (12, NULL, 'female', '杜冥鸦', '11-15', '奇响天外配音演员', '12.jpeg', NULL);
INSERT INTO `firm_member` VALUES (13, NULL, 'female', '花玲', '07-12', '中日双语配音演员、歌手', '13.jpeg', NULL);
INSERT INTO `firm_member` VALUES (14, NULL, 'female', '多多poi', '01-04', '配音演员，曾获第十四届中国国际动漫节声优大赛最具网络人气奖、bilibili英雄联盟7周年创作大赛一等奖', '14.jpeg', NULL);
INSERT INTO `firm_member` VALUES (15, NULL, 'female', '小敢', '03-24', '中日双语配音演员', '15.jpeg', NULL);
INSERT INTO `firm_member` VALUES (16, NULL, 'female', '宴宁', '06-26', '配音演员', '16.jpeg', NULL);
INSERT INTO `firm_member` VALUES (17, NULL, 'female', '紫苏九月', '01-01', '配音演员', '17.jpeg', NULL);
INSERT INTO `firm_member` VALUES (18, NULL, 'female', '诺亚', NULL, '日本儿童节目《咿呀咿呀》指定合作演员', '18.jpeg', NULL);
INSERT INTO `firm_member` VALUES (19, NULL, 'female', '子音 ', '05-04', '配音演员', '19.jpeg', NULL);
INSERT INTO `firm_member` VALUES (38, '123', '1', '123', '2023-07-09T16:00:00.000Z', '123', 'd29a502d-3793-426d-aa6e-7b53d9401111.webp', '管理层');

-- ----------------------------
-- Table structure for firm_tickling
-- ----------------------------
DROP TABLE IF EXISTS `firm_tickling`;
CREATE TABLE `firm_tickling`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `e_mail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '联系方式',
  `sort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '反馈类型',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '反馈内容',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '反馈时间',
  `state` int(0) NULL DEFAULT NULL COMMENT '处理阶段（0：未处理，1：已查看，2：已回复）',
  `reply` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '回复信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of firm_tickling
-- ----------------------------
INSERT INTO `firm_tickling` VALUES (1, 'asdsad@163.com', '直播方面', 'asdasd', '2023-07-15 10:08:31', 1, '12313');
INSERT INTO `firm_tickling` VALUES (2, 'asdsass2131d@163.com', '配音方面', 'asdsdsadasdd', '2023-07-15 10:11:13', 1, NULL);
INSERT INTO `firm_tickling` VALUES (3, 'asdsad@163.com', '直播方面', 'qwqeqeqwe', '2023-07-15 10:11:53', 1, 'asdasd');
INSERT INTO `firm_tickling` VALUES (4, 'asdsad@163.com', '配音方面', 'wewdqdqwdwq', '2023-07-15 14:53:21', 1, 'nice');
INSERT INTO `firm_tickling` VALUES (5, 'asdsad@163.com', '其他方面', 'wadwadawdwadwa', '2023-07-15 14:53:29', 1, NULL);
INSERT INTO `firm_tickling` VALUES (6, 'asdsad@163.com', '直播方面', 'wwwwwwwwwwwwwwwwwwwwwwwwwwwwww', '2023-07-15 14:53:36', 0, NULL);
INSERT INTO `firm_tickling` VALUES (7, 'asdsad@163.com', '配音方面', '2452522222222222222222', '2023-07-15 14:53:44', 1, NULL);
INSERT INTO `firm_tickling` VALUES (8, 'asdsad@163.com', '直播方面', 'rwefewef', '2023-07-15 14:55:18', 0, NULL);
INSERT INTO `firm_tickling` VALUES (9, 'asdsadsa@163.com', '直播方面', 'sadadssss', '2023-07-15 16:17:23', 0, NULL);
INSERT INTO `firm_tickling` VALUES (10, 'asdsadddddddddd@163.com', '配音方面', 'saaaaaaaaaaaaaaaaa', '2023-07-15 16:17:42', 0, NULL);
INSERT INTO `firm_tickling` VALUES (11, 'asdsad5324@163.com', '其他方面', 'sadsadddddddddd', '2023-07-15 16:17:51', 0, NULL);
INSERT INTO `firm_tickling` VALUES (12, '', '', '', '2023-07-20 09:20:10', 0, NULL);
INSERT INTO `firm_tickling` VALUES (13, 'asdsad@163.com', '配音方面', 'sacascascc', '2023-07-20 09:20:31', 0, NULL);
INSERT INTO `firm_tickling` VALUES (14, 'asdsad@163.com', '配音方面', '配音声音，存在前后剧情中声音不同的现象', '2023-07-20 14:53:47', 0, NULL);

-- ----------------------------
-- Table structure for firm_works
-- ----------------------------
DROP TABLE IF EXISTS `firm_works`;
CREATE TABLE `firm_works`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `member_id` int(0) NOT NULL COMMENT '成员id',
  `works_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '作品名称',
  `role_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '配音角色',
  `style` int(0) NULL DEFAULT NULL COMMENT '作品类型(0：游戏，1：动漫)',
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '配音时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 130 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of firm_works
-- ----------------------------
INSERT INTO `firm_works` VALUES (1, 1, '英雄联盟', '德莱文', 0, '2011');
INSERT INTO `firm_works` VALUES (2, 1, '英雄联盟', '卢锡安', 0, '2011');
INSERT INTO `firm_works` VALUES (3, 1, '英雄联盟', '布隆', 0, '2011');
INSERT INTO `firm_works` VALUES (4, 1, '守望先锋', '源氏', 0, '2016');
INSERT INTO `firm_works` VALUES (5, 1, '守望先锋', '青年莱因哈特', 0, '2016');
INSERT INTO `firm_works` VALUES (6, 1, '崩坏三', '齐格飞·卡斯兰娜', 0, '2016');
INSERT INTO `firm_works` VALUES (7, 1, '王牌战士', '李正宇', 0, '2019');
INSERT INTO `firm_works` VALUES (8, 1, '反恐精英Online', '乌列尔', 0, '2019');
INSERT INTO `firm_works` VALUES (9, 1, '原神', '钟离', 0, '2022');
INSERT INTO `firm_works` VALUES (10, 1, '原神', '特瓦林', 0, '2022');
INSERT INTO `firm_works` VALUES (11, 1, '赛博朋克2077', '	\r\n杰克·威尔斯', 0, '2022');
INSERT INTO `firm_works` VALUES (12, 1, '巫师3狂猎', '血腥男爵', 0, '2022');
INSERT INTO `firm_works` VALUES (13, 1, '崩坏：星穹铁道', '	\r\n瓦尔特', 0, '2022');
INSERT INTO `firm_works` VALUES (14, 1, '白夜极光', '索克&贝克', 0, '2022');
INSERT INTO `firm_works` VALUES (15, 1, '魔兽世界', '乌瑟尔', 0, '未知');
INSERT INTO `firm_works` VALUES (16, 1, '魔兽世界', '宙斯 ', 0, '未知');
INSERT INTO `firm_works` VALUES (17, 1, '最终幻想14', '劳班·阿尔丁', 0, '未知');
INSERT INTO `firm_works` VALUES (18, 1, '最后的厂牌', '周怀夜(新版)', 0, '未知');
INSERT INTO `firm_works` VALUES (19, 1, '秦时明月之君临天下', '	\r\n吴旷', 1, '2014');
INSERT INTO `firm_works` VALUES (20, 1, '秦时明月之君临天下', '典庆 ', 1, '2014');
INSERT INTO `firm_works` VALUES (21, 1, '秦时明月之君临天下', '骨妖 ', 1, '2014');
INSERT INTO `firm_works` VALUES (22, 1, '勇者大冒险', '张天师', 1, '2015');
INSERT INTO `firm_works` VALUES (23, 1, '天行九歌', '兀鹫', 1, '2016');
INSERT INTO `firm_works` VALUES (24, 1, '天行九歌', '雁春君', 1, '2016');
INSERT INTO `firm_works` VALUES (25, 1, '灵石茂险王', '	\r\n门爷', 1, '2016');
INSERT INTO `firm_works` VALUES (26, 1, '元素英雄：小波波', '	\r\n博拉拉、古威球', 1, '2016');
INSERT INTO `firm_works` VALUES (27, 1, '武庚纪', '云中子', 1, '2017');
INSERT INTO `firm_works` VALUES (28, 1, '拳皇命运', '高尼茨', 1, '2017');
INSERT INTO `firm_works` VALUES (29, 1, '无论如何都想加入生肖', '	\r\n威威虎 ', 1, '2017');
INSERT INTO `firm_works` VALUES (30, 1, '无论如何都想加入生肖', '神大人', 1, '2017');
INSERT INTO `firm_works` VALUES (31, 1, '平博士密码', '平博士', 1, '2017');
INSERT INTO `firm_works` VALUES (32, 1, '女武神的餐桌', '齐格飞·卡斯兰娜 ', 1, '2019');
INSERT INTO `firm_works` VALUES (33, 1, '女武神的餐桌', '士兵', 1, '2019');
INSERT INTO `firm_works` VALUES (34, 1, '斗罗大陆', '杀戮之王', 1, '2020');
INSERT INTO `firm_works` VALUES (35, 1, '秦时明月之沧海横流', '	\r\n吴旷', 1, '2020');
INSERT INTO `firm_works` VALUES (36, 1, '无限世界', '零点', 1, '2022');
INSERT INTO `firm_works` VALUES (37, 1, '超蛙战士之威武教官', '大炮', 1, '2012');
INSERT INTO `firm_works` VALUES (38, 1, '犹太女孩在上海2：项链密码', '大卫', 1, '2015');
INSERT INTO `firm_works` VALUES (39, 1, '麦兜·饭宝奇兵', '校长', 1, '2016');
INSERT INTO `firm_works` VALUES (40, 1, '我是哪吒', '夜叉', 1, '2016');
INSERT INTO `firm_works` VALUES (41, 1, '元素英雄小波波剧场版', '博拉拉 ', 1, '2016');
INSERT INTO `firm_works` VALUES (42, 1, '元素英雄小波波剧场版', '古威球', 1, '2016');
INSERT INTO `firm_works` VALUES (43, 12, '12', '1', NULL, '2023-07-30T16:00:00.000Z');
INSERT INTO `firm_works` VALUES (47, 2, '剑网3•曲云传', '孙飞亮（男主）', 1, '未知');
INSERT INTO `firm_works` VALUES (48, 2, '空盒游戏', '男主', 1, NULL);
INSERT INTO `firm_works` VALUES (49, 2, '山海镜花', '黄龙', 1, NULL);
INSERT INTO `firm_works` VALUES (50, 2, '王者荣耀', '云中君', 0, NULL);
INSERT INTO `firm_works` VALUES (51, 3, '山海镜花', '金乌', 1, NULL);
INSERT INTO `firm_works` VALUES (52, 3, '盛世妆娘', '云离', 1, NULL);
INSERT INTO `firm_works` VALUES (53, 3, '我心中的白月光', '少年向海东', 1, NULL);
INSERT INTO `firm_works` VALUES (54, 4, '武庚纪', '子羽', 1, NULL);
INSERT INTO `firm_works` VALUES (55, 4, '凹凸世界', '格瑞', 1, NULL);
INSERT INTO `firm_works` VALUES (56, 4, '时之歌', '界海•兰纳尔', 1, NULL);
INSERT INTO `firm_works` VALUES (57, 5, '封印者', '衰仔锋', 1, NULL);
INSERT INTO `firm_works` VALUES (58, 5, '风之大陆', '男性玩家', 0, NULL);
INSERT INTO `firm_works` VALUES (59, 5, '球球大作战', '赵云', 0, NULL);
INSERT INTO `firm_works` VALUES (60, 6, '樱桃小丸子', '藤木', 1, NULL);
INSERT INTO `firm_works` VALUES (61, 6, '樱桃小丸子', '大野', 1, NULL);
INSERT INTO `firm_works` VALUES (62, 6, '丛林特战队', '莫里斯', 1, NULL);
INSERT INTO `firm_works` VALUES (63, 6, '守望先锋', 'cg', 1, NULL);
INSERT INTO `firm_works` VALUES (64, 6, '荣耀', NULL, 1, NULL);
INSERT INTO `firm_works` VALUES (65, 7, '三色△绘恋', '骆衍', 1, NULL);
INSERT INTO `firm_works` VALUES (66, 7, '妖恋奇谭', '赤鱬', 1, NULL);
INSERT INTO `firm_works` VALUES (67, 7, '妖恋奇谭', '座敷童子', 1, NULL);
INSERT INTO `firm_works` VALUES (68, 8, '魔兽世界', 'GenralBrestHughes', 0, NULL);
INSERT INTO `firm_works` VALUES (69, 8, '天涯明月刀OL', '孙浩然', 1, NULL);
INSERT INTO `firm_works` VALUES (70, 8, '樱桃小丸子', '樱宏志（爸爸）', 1, NULL);
INSERT INTO `firm_works` VALUES (71, 8, '樱桃小丸子', '山根 ', 1, NULL);
INSERT INTO `firm_works` VALUES (72, 9, '崩坏3', '无量塔姬子', 0, NULL);
INSERT INTO `firm_works` VALUES (73, 9, '崩坏3', '姬轩辕', 0, NULL);
INSERT INTO `firm_works` VALUES (74, 9, '王者荣耀', '阿轲', 0, NULL);
INSERT INTO `firm_works` VALUES (75, 9, '王者荣耀', '公孙离', 0, NULL);
INSERT INTO `firm_works` VALUES (76, 9, '魔兽世界', NULL, 0, NULL);
INSERT INTO `firm_works` VALUES (77, 9, '炉石传说', NULL, 0, NULL);
INSERT INTO `firm_works` VALUES (78, 9, '风暴英雄', '少女吉安娜', 0, NULL);
INSERT INTO `firm_works` VALUES (79, 9, '风暴英雄', '温蕾沙', 0, NULL);
INSERT INTO `firm_works` VALUES (80, 9, '风暴英雄', '泰兰德', 0, NULL);
INSERT INTO `firm_works` VALUES (81, 10, '守望先锋', '黑影', 0, NULL);
INSERT INTO `firm_works` VALUES (82, 10, '王者荣耀', '沈梦溪', 0, NULL);
INSERT INTO `firm_works` VALUES (83, 10, '崩坏3', '爱酱', 0, NULL);
INSERT INTO `firm_works` VALUES (84, 10, '崩坏3', '杏', 0, NULL);
INSERT INTO `firm_works` VALUES (85, 10, '崩坏3', '丽塔', 0, NULL);
INSERT INTO `firm_works` VALUES (86, 11, '王者荣耀', '上官婉儿', 0, NULL);
INSERT INTO `firm_works` VALUES (87, 11, '英雄联盟', '阿卡丽', 0, NULL);
INSERT INTO `firm_works` VALUES (88, 11, '崩坏3', '符华', 0, NULL);
INSERT INTO `firm_works` VALUES (89, 11, '崩坏学园2', '符华', 0, NULL);
INSERT INTO `firm_works` VALUES (90, 12, '崩坏3', '八重樱', 0, NULL);
INSERT INTO `firm_works` VALUES (91, 12, '虚荣', '风暴公主瓦妮亚', 1, NULL);
INSERT INTO `firm_works` VALUES (92, 12, '幽林怪谈', '文姜', 1, NULL);
INSERT INTO `firm_works` VALUES (93, 13, '崩坏3', '德丽莎', 0, NULL);
INSERT INTO `firm_works` VALUES (94, 13, '崩坏学园2', '德丽莎', 0, NULL);
INSERT INTO `firm_works` VALUES (95, 13, '英雄联盟', '佐伊', 0, NULL);
INSERT INTO `firm_works` VALUES (96, 13, '封印者', '卡米拉', 1, NULL);
INSERT INTO `firm_works` VALUES (97, 13, '封印者', '缇娜', 1, NULL);
INSERT INTO `firm_works` VALUES (98, 14, '崩坏3', '萝萨莉娅•阿琳', 0, NULL);
INSERT INTO `firm_works` VALUES (99, 14, '夜光', '黄以琳', 1, NULL);
INSERT INTO `firm_works` VALUES (100, 15, '英雄联盟', '艾瑞莉娅（重制版）', 0, NULL);
INSERT INTO `firm_works` VALUES (101, 15, '王者荣耀', '米莱狄', 0, NULL);
INSERT INTO `firm_works` VALUES (102, 15, '封印者', '休格', 1, NULL);
INSERT INTO `firm_works` VALUES (103, 15, '封印者', '哈比', 1, NULL);
INSERT INTO `firm_works` VALUES (104, 16, '英雄联盟', '妮蔻', 0, NULL);
INSERT INTO `firm_works` VALUES (105, 16, '幽林怪谈', '桃夭', 1, NULL);
INSERT INTO `firm_works` VALUES (106, 16, '幽林怪谈', '铜镜', 1, NULL);
INSERT INTO `firm_works` VALUES (107, 16, '幽林怪谈', '精卫', 1, NULL);
INSERT INTO `firm_works` VALUES (108, 16, '封印者', '薇尔莉', 1, NULL);
INSERT INTO `firm_works` VALUES (109, 17, '崩坏3', '丹朱', 0, NULL);
INSERT INTO `firm_works` VALUES (110, 17, '崩坏3', '八重凛', 0, NULL);
INSERT INTO `firm_works` VALUES (111, 17, '崩坏3', '吼美', 0, NULL);
INSERT INTO `firm_works` VALUES (112, 17, '诺亚幻想', '锦鲤', 0, NULL);
INSERT INTO `firm_works` VALUES (113, 17, '诺亚幻想', '蝴蝶', 0, NULL);
INSERT INTO `firm_works` VALUES (114, 17, '战舰少女R', '赤城', 1, NULL);
INSERT INTO `firm_works` VALUES (115, 17, '战舰少女R', '独角兽', 1, NULL);
INSERT INTO `firm_works` VALUES (116, 18, '忍者哈特利', '哈特利', 1, NULL);
INSERT INTO `firm_works` VALUES (117, 18, '崩坏3', '绯玉丸', 0, NULL);
INSERT INTO `firm_works` VALUES (118, 18, '阿布扎比卢浮宫', '导览', 1, NULL);
INSERT INTO `firm_works` VALUES (119, 19, '云裳羽衣', '艾斯托芙', 1, NULL);
INSERT INTO `firm_works` VALUES (120, 19, '云裳羽衣', '军官维鲁特', 1, NULL);
INSERT INTO `firm_works` VALUES (121, 19, '面具关系', '方怡', 1, NULL);
INSERT INTO `firm_works` VALUES (122, 19, '全职法师 第一季 ', '彩棠', 1, NULL);

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '管理员账号',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '管理员密码(Md5加密)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, 'admin', '123456');
INSERT INTO `users` VALUES (2, '12', '123');
INSERT INTO `users` VALUES (3, '111', '222');
INSERT INTO `users` VALUES (4, 'qwe', 'qwe');
INSERT INTO `users` VALUES (5, 'cgk', '123');
INSERT INTO `users` VALUES (6, '333', '333');
INSERT INTO `users` VALUES (7, '4444', '4444');
INSERT INTO `users` VALUES (8, '', '');
INSERT INTO `users` VALUES (9, 'cysb', 'cysb');
INSERT INTO `users` VALUES (10, 'root', '111111');
INSERT INTO `users` VALUES (11, 'roott', '123456');
INSERT INTO `users` VALUES (12, 'zhangsan', '123456');

-- ----------------------------
-- Table structure for webpage
-- ----------------------------
DROP TABLE IF EXISTS `webpage`;
CREATE TABLE `webpage`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司地址',
  `copyright` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '版权所有',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '备注号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of webpage
-- ----------------------------
INSERT INTO `webpage` VALUES (1, '上海市徐汇区东盛路6号南方水产市场商务大厦第七层 ', '上海奇响天外文化传播有限公司 保留一切权利222', '沪ICP备15046665号-1');

SET FOREIGN_KEY_CHECKS = 1;
四、测试

1.运行项目

2.浏览器中输入

127.0.0.1:8080   

回车

即可查看后台界面

3.前台界面点击右上角的第一个图标，地球形状

即可跳转前台界面

小小爪
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值