admin 管理员组

文章数量: 888526

【学生管理系统】环境搭建

1. 环境搭建

1.1 前端环境

1.2 后端环境

1.2.1 父项目

1.2.2 domain项目

1.2.3 gateway项目

1.3 数据库环境

1.3.1 用户数据库

1.3.2 班级数据库

1.3.3 学生数据库

1.3.4 课程数据库

1. 环境搭建

1.1 前端环境

项目名：nacos-nuxt-student-fore
创建项目（整合Element ui、整合axios）
修改axios baseURL
修改Element UI 整合文件

1.2 后端环境

1.2.1 父项目

项目名：nacos-nuxt-student-parent

pom文件

<!-- 1 确定spring boot的版本--><parent><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-parent</artifactId><version>2.2.5.RELEASE</version></parent>
<!--2  确定版本--><properties><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><java.version>1.8</java.version><spring-cloud-release.version>Hoxton.SR3</spring-cloud-release.version><nacos.version>1.1.0</nacos.version><alibaba.cloud.version>2.2.1.RELEASE</alibaba.cloud.version><mysql.version>5.1.32</mysql.version><mybatis.plus.version>3.4.0</mybatis.plus.version><druid.starter.version>1.1.9</druid.starter.version><jwt.jjwt.version>0.9.0</jwt.jjwt.version><jwt.joda.version>2.9.7</jwt.joda.version><swagger.version>2.7.0</swagger.version><swagger.anno.version>1.5.13</swagger.anno.version><beanutils.version>1.9.3</beanutils.version><aliyun.sdk.core.version>3.3.1</aliyun.sdk.core.version><aliyun.sdk.dysmsapi.version>1.0.0</aliyun.sdk.dysmsapi.version><fastjson.version>1.2.9</fastjson.version><zx.version>1.0-SNAPSHOT</zx.version></properties>
<!-- 3 锁定版本--><dependencyManagement><dependencies><!-- sprig cloud--><dependency><groupId>org.springframework.cloud</groupId><artifactId>spring-cloud-dependencies</artifactId><version>${spring-cloud-release.version}</version><type>pom</type><scope>import</scope></dependency><!--nacos --><dependency><groupId>com.alibaba.nacos</groupId><artifactId>nacos-client</artifactId><version>${nacos.version}</version></dependency>
<!--nacos cloud 发现 --><dependency><groupId>com.alibaba.cloud</groupId><artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId><version>${alibaba.cloud.version}</version></dependency>
<!--nacos cloud 配置 --><dependency><groupId>com.alibaba.cloud</groupId><artifactId>spring-cloud-starter-alibaba-nacos-config</artifactId><version>${alibaba.cloud.version}</version></dependency>
<!-- .alibaba.cloud/spring-cloud-starter-alibaba-sentinel --><dependency><groupId>com.alibaba.cloud</groupId><artifactId>spring-cloud-starter-alibaba-sentinel</artifactId><version>${alibaba.cloud.version}</version></dependency>
<dependency><groupId>com.alibaba.cloud</groupId><artifactId>spring-cloud-starter-alibaba-seata</artifactId><version>${alibaba.cloud.version}</version></dependency>

<!-- mybatis plus--><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-boot-starter</artifactId><version>${mybatis.plus.version}</version></dependency><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-annotation</artifactId><version>${mybatis.plus.version}</version></dependency>
<!-- mysql驱动 --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>${mysql.version}</version></dependency>
<!-- druid启动器 --><dependency><groupId>com.alibaba</groupId><artifactId>druid-spring-boot-starter</artifactId><version>${druid.starter.version}</version></dependency>
<!--swagger2--><dependency><groupId>io.springfox</groupId><artifactId>springfox-swagger2</artifactId><version>${swagger.version}</version></dependency><dependency><groupId>io.springfox</groupId><artifactId>springfox-swagger-ui</artifactId><version>${swagger.version}</version></dependency><dependency><groupId>io.swagger</groupId><artifactId>swagger-annotations</artifactId><version>${swagger.anno.version}</version></dependency>
<!--jwt--><!--JavaBean工具类，用于JavaBean数据封装--><dependency><groupId>commons-beanutils</groupId><artifactId>commons-beanutils</artifactId><version>${beanutils.version}</version></dependency>
<!--jwt工具--><dependency><groupId>io.jsonwebtoken</groupId><artifactId>jjwt</artifactId><version>${jwt.jjwt.version}</version></dependency>
<!--joda 时间工具类 --><dependency><groupId>joda-time</groupId><artifactId>joda-time</artifactId><version>${jwt.joda.version}</version></dependency>
<!--短信--><dependency><groupId>com.aliyuncs</groupId><artifactId>aliyun-java-sdk-core</artifactId><version>${aliyun.sdk.core.version}</version></dependency><dependency><groupId>com.aliyuncs.dysmsapi</groupId><artifactId>aliyun-java-sdk-dysmsapi</artifactId><version>${aliyun.sdk.dysmsapi.version}</version></dependency>
<!--fastjson--><dependency><groupId>com.alibaba</groupId><artifactId>fastjson</artifactId><version>${fastjson.version}</version></dependency><!--自定义项目 zx.version--><dependency><groupId>com.czxy</groupId><artifactId>nacos-nuxt-student-domain</artifactId><version>${zx.version}</version></dependency>
</dependencies>
</dependencyManagement>

1.2.2 domain项目

项目名：nacos-nuxt-student-domain

pom文件

<dependencies><!--lombok , @Data 等--><dependency><groupId>io.swagger</groupId><artifactId>swagger-annotations</artifactId><version>1.5.13</version></dependency><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId></dependency><!--jackson , @JsonFormat--><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-json</artifactId></dependency><!--mybatis-plus , @TableName @TableId 等 --><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-annotation</artifactId></dependency>
</dependencies>

拷贝JavaBean

1.2.3 gateway项目

项目名：nacos-nuxt-student-gateway

pom文件

<dependencies><!-- 网关 --><dependency><groupId>org.springframework.cloud</groupId><artifactId>spring-cloud-starter-gateway</artifactId></dependency>
<!-- nacos 服务发现 --><dependency><groupId>com.alibaba.cloud</groupId><artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId></dependency>
<!--自定义项目--><dependency><groupId>com.czxy</groupId><artifactId>nacos-nuxt-student-domain</artifactId></dependency>
<!--jwt工具--><dependency><groupId>io.jsonwebtoken</groupId><artifactId>jjwt</artifactId></dependency><!--joda 时间工具类 --><dependency><groupId>joda-time</groupId><artifactId>joda-time</artifactId></dependency><!--JavaBean工具类，用于JavaBean数据封装--><dependency><groupId>commons-beanutils</groupId><artifactId>commons-beanutils</artifactId></dependency>
</dependencies>

yml文件

#端口号
server:port: 10010
spring:application:name: gatewayservlet:multipart:max-file-size: 2MB    #上传文件的大小cloud:nacos:discovery:server-addr: 127.0.0.1:8848   #nacos服务地址gateway:discovery:locator:enabled: true               #开启服务注册和发现的功能，自动创建router以服务名开头的请求路径转发到对应的服务lowerCaseServiceId: true    #将请求路径上的服务名配置为小写

启动类

package com.czxy;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.cloud.client.discovery.EnableDiscoveryClient;

/*** @author 桐叔* @email liangtong@itcast* @description*/
@SpringBootApplication
@EnableDiscoveryClient      //服务发现
public class GatewayApplication {public static void main(String[] args) {SpringApplication.run(GatewayApplication.class, args);}
}

拷贝跨域配置类

1.3 数据库环境

1.3.1 用户数据库

# 用户数据库
CREATE DATABASE cloud_es_user;
USE cloud_es_user;

CREATE TABLE `tb_user` (`u_id` VARCHAR(32) PRIMARY KEY NOT NULL COMMENT '用户编号',`user_name` VARCHAR(50) UNIQUE DEFAULT NULL COMMENT '用户名',`password` VARCHAR(32) DEFAULT NULL COMMENT '密码',`gender` BIT(1) DEFAULT NULL COMMENT '性别,1表示男，0表示女',`image` VARCHAR(50) UNIQUE DEFAULT NULL COMMENT '头像图片'
);

INSERT  INTO `tb_user`(`u_id`,`user_name`,`password`,`gender`,`image`) VALUES ('u001','jack','1234',1,'1.jpg');
INSERT  INTO `tb_user`(`u_id`,`user_name`,`password`,`gender`,`image`) VALUES ('u002','rose','1234',0,'2.jpg');
INSERT  INTO `tb_user`(`u_id`,`user_name`,`password`,`gender`,`image`) VALUES ('u003','tom','1234',1,'3.jpg');

1.3.2 班级数据库

# 班级数据库
CREATE DATABASE cloud_es_classes;
USE cloud_es_classes;

CREATE TABLE `tb_teacher` (`tid` INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,`tname` VARCHAR(50) DEFAULT NULL COMMENT '老师姓名',`type` INT(11) DEFAULT NULL COMMENT '老师类型：1.授课老师、2.助理老师、3.辅导员老师'
);
INSERT  INTO `tb_teacher`(`tid`,`tname`,`type`) VALUES (1,'梁桐老师',1);
INSERT  INTO `tb_teacher`(`tid`,`tname`,`type`) VALUES (2,'马坤老师',2);
INSERT  INTO `tb_teacher`(`tid`,`tname`,`type`) VALUES (3,'仲燕老师',3);
INSERT  INTO `tb_teacher`(`tid`,`tname`,`type`) VALUES (4,'袁新奇老师',1);
INSERT  INTO `tb_teacher`(`tid`,`tname`,`type`) VALUES (5,'任林达老师',2);
INSERT  INTO `tb_teacher`(`tid`,`tname`,`type`) VALUES (6,'王珊珊老师',3);


CREATE TABLE `tb_class` (`cid` INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,`cname` VARCHAR(50) DEFAULT NULL COMMENT '班级名称',`teacher1_id` INT(11) DEFAULT NULL COMMENT '授课老师',`teacher2_id` INT(11) DEFAULT NULL COMMENT '助理老师',`teacher3_id` INT(11) DEFAULT NULL COMMENT '辅导员老师'
);

INSERT  INTO `tb_class`(`cid`,`cname`,`teacher1_id`,`teacher2_id`,`teacher3_id`) VALUES (1,'Java56',1,2,3);
INSERT  INTO `tb_class`(`cid`,`cname`,`teacher1_id`,`teacher2_id`,`teacher3_id`) VALUES (2,'Java78',1,2,3);
INSERT  INTO `tb_class`(`cid`,`cname`,`teacher1_id`,`teacher2_id`,`teacher3_id`) VALUES (3,'Java12',4,5,6);
INSERT  INTO `tb_class`(`cid`,`cname`,`teacher1_id`,`teacher2_id`,`teacher3_id`) VALUES (4,'Java34',4,5,6);

1.3.3 学生数据库

#学生数据库
CREATE DATABASE cloud_es_student;
USE cloud_es_student;

CREATE TABLE tb_city(c_id VARCHAR(32) PRIMARY KEY COMMENT '城市ID',city_name VARCHAR(20) COMMENT '城市名称' ,parent_id VARCHAR(32) COMMENT '父ID'
);

INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('320000','江苏省','0');
INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('140000','山西省','0');
INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('130000','河北省','0');

INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('320100','南京市','320000');
INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('320102','玄武区','320100');
INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('320103','白下区','320100');

INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('321300','宿迁市','320000');
INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('321322','沭阳县','321300');
INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('321323','泗阳县','321300');


INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('140100','太原市','140000');
INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('140106','迎泽区','140100');
INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('140108','尖草坪区','140100');

INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('140800','运城市','140000');
INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('140823','闻喜县','140800');
INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('140828','夏　县','140800');

INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('130100','石家庄市','130000');
INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('130127','高邑县','130100');
INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('130185','鹿泉市','130100');

INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('131000','廊坊市','130000');
INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('131003','广阳区','131000');
INSERT INTO tb_city(c_id,city_name,parent_id) VALUES('131022','固安县','131000');


CREATE TABLE `tb_student` (`s_id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT COMMENT '学生ID',`sname` VARCHAR(50) DEFAULT NULL COMMENT '姓名',`age` INT(11) DEFAULT NULL COMMENT '年龄',`birthday` DATETIME DEFAULT NULL COMMENT '生日',`gender` CHAR(1) DEFAULT NULL COMMENT '性别',`c_id` INT DEFAULT NULL,`city_ids` VARCHAR(32) DEFAULT NULL COMMENT '城市：320000,321300,321322'
);

INSERT  INTO `tb_student`(`s_id`,`sname`,`age`,`birthday`,`gender`,`c_id`,`city_ids`) VALUES (1,'赵三33',21,'2001-01-17 00:00:00','1',1,'320000,321300,321322');
INSERT  INTO `tb_student`(`s_id`,`sname`,`age`,`birthday`,`gender`,`c_id`,`city_ids`) VALUES (2,'钱四444',1900,'2001-05-16 00:00:00','1',2,'320000,321300,321322');
INSERT  INTO `tb_student`(`s_id`,`sname`,`age`,`birthday`,`gender`,`c_id`,`city_ids`) VALUES (3,'孙五56',189,'2022-03-15 00:00:00','0',1,'320000,321300,321322');
INSERT  INTO `tb_student`(`s_id`,`sname`,`age`,`birthday`,`gender`,`c_id`,`city_ids`) VALUES (4,'张三',20,'2020-12-21 00:00:00','0',2,'320000,321300,321322');
INSERT  INTO `tb_student`(`s_id`,`sname`,`age`,`birthday`,`gender`,`c_id`,`city_ids`) VALUES (5,'xxx',18,'2020-12-21 00:00:00','0',2,'140000,140800,140823');
INSERT  INTO `tb_student`(`s_id`,`sname`,`age`,`birthday`,`gender`,`c_id`,`city_ids`) VALUES (6,'123',18,'2020-11-01 00:00:00','0',3,'130000,130100,130127');
INSERT  INTO `tb_student`(`s_id`,`sname`,`age`,`birthday`,`gender`,`c_id`,`city_ids`) VALUES (7,'xx',18,'2020-11-02 00:00:00','0',1,'130000,131000,131003');

1.3.4 课程数据库

#课程数据库
CREATE DATABASE cloud_es_course;
USE cloud_es_course;

CREATE TABLE `tb_course` (`c_id` INT NOT NULL PRIMARY KEY COMMENT '课程ID',`cname` VARCHAR(50) DEFAULT NULL COMMENT '课程名称',`desc` VARCHAR(100) DEFAULT NULL COMMENT '课程描述'
);

INSERT  INTO `tb_course`(`c_id`,`cname`,`desc`) VALUES (1,'Java基础','JavaSE所有课程');
INSERT  INTO `tb_course`(`c_id`,`cname`,`desc`) VALUES (2,'JavaWeb','Java Web 所有课程');
INSERT  INTO `tb_course`(`c_id`,`cname`,`desc`) VALUES (3,'SSM','Spring Mvc、Spring、MyBatis所有课程');


CREATE TABLE `tb_student_course` (`s_id` INT NOT NULL COMMENT '学生ID',`c_id` INT NOT NULL COMMENT '课程ID',`score` DOUBLE DEFAULT NULL,PRIMARY KEY (`s_id`,`c_id`)
);

INSERT INTO tb_student_course(s_id,c_id,score) VALUES(1,1,100);
INSERT INTO tb_student_course(s_id,c_id,score) VALUES(1,2,95);
INSERT INTO tb_student_course(s_id,c_id,score) VALUES(1,3,NULL);

INSERT INTO tb_student_course(s_id,c_id,score) VALUES(2,1,100);
INSERT INTO tb_student_course(s_id,c_id,score) VALUES(2,2,95);
INSERT INTO tb_student_course(s_id,c_id,score) VALUES(2,3,100);

INSERT INTO tb_student_course(s_id,c_id,score) VALUES(3,1,80);
INSERT INTO tb_student_course(s_id,c_id,score) VALUES(3,2,NULL);
INSERT INTO tb_student_course(s_id,c_id,score) VALUES(3,3,90);

本文标签：学生管理系统环境搭建

版权声明：本文标题：【学生管理系统】环境搭建内容由网友自发贡献，该文观点仅代表作者本人，转载请联系作者并注明出处：http://www.freenas.com.cn/jishu/1693585113h230716.html，本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。

技术交流 – FreeNAS中文网

【学生管理系统】环境搭建

【学生管理系统】环境搭建

1. 环境搭建

1.1 前端环境

1.2 后端环境

1.2.1 父项目

1.2.2 domain项目

1.2.3 gateway项目

1.3 数据库环境

1.3.1 用户数据库

1.3.2 班级数据库

1.3.3 学生数据库

1.3.4 课程数据库

更多相关文章

【学生管理系统】环境搭建

发表评论

推荐文章

从google辞职创业后，我更焦虑了

WIndows10系统 安装Anaconda、Pycharm以及在其中导入Pytorch环境（NVIDIA GPU版本）

win10 U盘装机找不到启动盘等问题

Windows Server 2003 中从 GUI 或命令行激活 Telnet

Windows服务器安全策略设置

热门文章

Fast convolutional neural network training using selective data sampling: Application to hemorrhage

计算机英语场景对话,快速英语情景对话大全 日常生活对话 7 排除电脑故障

21款奔驰S450L四驱版升级原厂主动式氛围灯

华为云OBS权限控制

win7修复计算机消失,win7系统引导文件丢失的修复妙招

ChatGPT论文润色：一键提升学术写作质量的智能助手

Windows Server 2016 Standard此操作系统不支持此选项

windows7 matlab 兼容性 解决办法

ChatGPT实战手册

Windows10+Ubuntu16.04双系统安装

最新文章

Raid技术

LSI_阵列卡操作手册

破解Centos7_root用户密码

Redhat重置Root用户密码方法

远程批量修改linux服务器密码的脚本

win7电脑如何重装系统,win7电脑重装系统教程

惠普电脑C盘满了变红清理攻略

无头浏览器Chromedriver、Phantomjs安装及教程、Chrome插件xpath下载及安装

Android 默认浏览器下载apk，点击无法安装

Chrome 浏览器下载安装教程，保姆级教程

WIndows10系统安装Anaconda、Pycharm以及在其中导入Pytorch环境（NVIDIA GPU版本）

计算机英语场景对话,快速英语情景对话大全日常生活对话 7 排除电脑故障

windows7 matlab 兼容性解决办法