软件构造项目-小学生加减乘除法: 软件构造考察项目，用于初次使用springboot同学学习demo

# 1、示例图

![1](https://cdn.jsdelivr.net/gh/lmlx6688/img/xxssf/1.png)

![2](https://cdn.jsdelivr.net/gh/lmlx6688/img/xxssf/2.png)

添加错题

![3](https://cdn.jsdelivr.net/gh/lmlx6688/img/xxssf/3.png)

错题展示

![4](https://cdn.jsdelivr.net/gh/lmlx6688/img/xxssf/4.png)

后台接口

![5](https://cdn.jsdelivr.net/gh/lmlx6688/img/xxssf/5.png)

# 2、版本迭代

## V1.0

后端：Spring，SPringMVC，MyBatis-Plus，SpringBoot，themlefy

前端：layui+jquery

实现生成随机加减乘除，并返回页面中

### v1.1

* 实现页面展示功能
* 实现后端验证

### v1.2

* 优化随机生成算法，优化除法生成问题
* 优化service层，拿数据更快

### v1.3

* 将答案传前端实现前端验证（失败）

## V2.0

后端：Spring，SPringMVC，MyBatis-Plus，SpringBoot，Hutool

前端：Vue+elementUI+axios

前后端分离项目

### v2.1

* 实现前端验证功能
* 解决跨域问题

### v2.2

* 实现加减乘除分离数据，减少数据访问时间
* 实现路由跳转功能

### v2.3

* 修复固定读取数据库前n条的bug
* 修复算式生成答案大于一百的bug
* 新增加下一项和重做按钮

### v2.4

* 实现错题本功能
* 工具类优化，引入hutool
* config设置优化

### v2.5

* 增加添加接口后台界面实现

### v2.6

* 移除接口实现
* 移除接口的后台界面实现
* 后台界面添加密码验证防止误操作

# 3、接口文档

[在线文档链接](https://www.showdoc.com.cn/xxssf)

## 2.1、添加接口

``` 
localhost:8090/addRandom #向数据库添加随机算式

localhost:8090/addAddition #向数据库添加加法算式

localhost:8090/addSubtraction #向数据库添加减法算式

localhost:8090/addMultiplication #向数据库添加乘法算式

localhost:8090/addDivision #向数据库添加除法算式
```

## 2.2、展示接口

展示接口将五个算式，随机拿出四十条展示到页面上

``` 
localhost:8090/all #拿到四十条随机算式

localhost:8090/getAddition #拿到四十条加法算式

localhost:8090/getSubtraction #拿到四十条减法算式

localhost:8090/getMultiplication #拿到四十条乘法算式

localhost:8090/getDivision #拿到四十条除法算式
```

## 2.3、错题集接口

``` java
localhost:8090/wrongSet #展示错题集
    
localhost:8090/removeWrong?id #通过id移除错题
    
localhost:8090/addWrong?id #通过id添加错题
```

## 2.4、删除错题集接口

```
localhost:8090/removeAll # 移除随机题目集

localhost:8090/removeAddition # 移除加法题目集

localhost:8090/removeDivision # 移除减法题目集

localhost:8090/removeMultiplication # 移除乘法题目集

localhost:8090/removeSubtraction # 移除触发题目集
```

# 4、通过导出构建

### 1.基本环境

jdk11

mysql5.7

maven3.6.0

nodejs12

### 2.构建数据库

创建数据库

名字：binary

```sql
/*
 Navicat Premium Data Transfer

Source Server         : hy
 Source Server Type    : MySQL
 Source Server Version : 50732
 Source Host           : localhost:3306
 Source Schema         : binary

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

Date: 08/11/2021 22:11:43
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sequence
-- ----------------------------
DROP TABLE IF EXISTS `sequence`;
CREATE TABLE `sequence`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id，同时也是序列',
  `forward` int(4) NULL DEFAULT NULL COMMENT '第一个数字',
  `symbol` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '运算符',
  `behind` int(4) NULL DEFAULT NULL COMMENT '第二个数字',
  `answer` int(6) NULL DEFAULT NULL COMMENT '答案',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10001 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sequence_addition
-- ----------------------------
DROP TABLE IF EXISTS `sequence_addition`;
CREATE TABLE `sequence_addition`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id，同时也是序列',
  `forward` int(4) NULL DEFAULT NULL COMMENT '第一个数字',
  `symbol` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '运算符',
  `behind` int(4) NULL DEFAULT NULL COMMENT '第二个数字',
  `answer` int(6) NULL DEFAULT NULL COMMENT '答案',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5001 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sequence_division
-- ----------------------------
DROP TABLE IF EXISTS `sequence_division`;
CREATE TABLE `sequence_division`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id，同时也是序列',
  `forward` int(4) NULL DEFAULT NULL COMMENT '第一个数字',
  `symbol` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '运算符',
  `behind` int(4) NULL DEFAULT NULL COMMENT '第二个数字',
  `answer` int(6) NULL DEFAULT NULL COMMENT '答案',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5001 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sequence_multiplication
-- ----------------------------
DROP TABLE IF EXISTS `sequence_multiplication`;
CREATE TABLE `sequence_multiplication`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id，同时也是序列',
  `forward` int(4) NULL DEFAULT NULL COMMENT '第一个数字',
  `symbol` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '运算符',
  `behind` int(4) NULL DEFAULT NULL COMMENT '第二个数字',
  `answer` int(6) NULL DEFAULT NULL COMMENT '答案',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5001 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sequence_subtraction
-- ----------------------------
DROP TABLE IF EXISTS `sequence_subtraction`;
CREATE TABLE `sequence_subtraction`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id，同时也是序列',
  `forward` int(4) NULL DEFAULT NULL COMMENT '第一个数字',
  `symbol` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '运算符',
  `behind` int(4) NULL DEFAULT NULL COMMENT '第二个数字',
  `answer` int(6) NULL DEFAULT NULL COMMENT '答案',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5001 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for wrong_set
-- ----------------------------
DROP TABLE IF EXISTS `wrong_set`;
CREATE TABLE `wrong_set`  (
  `id` int(10) NOT NULL COMMENT '错题集id',
  `user_id` int(10) NOT NULL COMMENT '用户id',
  `wset` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '错误题号集合',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wrong_set
-- ----------------------------
INSERT INTO `wrong_set` VALUES (1, 1, '[]');

SET FOREIGN_KEY_CHECKS = 1;
```

### 3.配置数据库基本信息

由于我们项目已经导出，配置文件已经写死

数据库用户名：root

数据库密码：123456

### 4.运行后端jar包

后端项目启动端口：8090

``` 
java -jar Binary-0.0.1-SNAPSHOT.jar
```

### 5.运行前端

前端项目，直接打开`index.html`即可

### 6.测试项目

进入后端管理添加数据，密码为`admin`

# 5、通过源码构建

### 1.基本环境

jdk11

mysql5.7

maven3.6.0

nodejs12

### 2.构建数据库

创建数据库

名字：binary

```sql
/*
 Navicat Premium Data Transfer

Source Server         : hy
 Source Server Type    : MySQL
 Source Server Version : 50732
 Source Host           : localhost:3306
 Source Schema         : binary

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

Date: 08/11/2021 22:11:43
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sequence
-- ----------------------------
DROP TABLE IF EXISTS `sequence`;
CREATE TABLE `sequence`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id，同时也是序列',
  `forward` int(4) NULL DEFAULT NULL COMMENT '第一个数字',
  `symbol` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '运算符',
  `behind` int(4) NULL DEFAULT NULL COMMENT '第二个数字',
  `answer` int(6) NULL DEFAULT NULL COMMENT '答案',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10001 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sequence_addition
-- ----------------------------
DROP TABLE IF EXISTS `sequence_addition`;
CREATE TABLE `sequence_addition`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id，同时也是序列',
  `forward` int(4) NULL DEFAULT NULL COMMENT '第一个数字',
  `symbol` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '运算符',
  `behind` int(4) NULL DEFAULT NULL COMMENT '第二个数字',
  `answer` int(6) NULL DEFAULT NULL COMMENT '答案',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5001 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sequence_division
-- ----------------------------
DROP TABLE IF EXISTS `sequence_division`;
CREATE TABLE `sequence_division`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id，同时也是序列',
  `forward` int(4) NULL DEFAULT NULL COMMENT '第一个数字',
  `symbol` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '运算符',
  `behind` int(4) NULL DEFAULT NULL COMMENT '第二个数字',
  `answer` int(6) NULL DEFAULT NULL COMMENT '答案',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5001 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sequence_multiplication
-- ----------------------------
DROP TABLE IF EXISTS `sequence_multiplication`;
CREATE TABLE `sequence_multiplication`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id，同时也是序列',
  `forward` int(4) NULL DEFAULT NULL COMMENT '第一个数字',
  `symbol` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '运算符',
  `behind` int(4) NULL DEFAULT NULL COMMENT '第二个数字',
  `answer` int(6) NULL DEFAULT NULL COMMENT '答案',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5001 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sequence_subtraction
-- ----------------------------
DROP TABLE IF EXISTS `sequence_subtraction`;
CREATE TABLE `sequence_subtraction`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id，同时也是序列',
  `forward` int(4) NULL DEFAULT NULL COMMENT '第一个数字',
  `symbol` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '运算符',
  `behind` int(4) NULL DEFAULT NULL COMMENT '第二个数字',
  `answer` int(6) NULL DEFAULT NULL COMMENT '答案',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5001 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for wrong_set
-- ----------------------------
DROP TABLE IF EXISTS `wrong_set`;
CREATE TABLE `wrong_set`  (
  `id` int(10) NOT NULL COMMENT '错题集id',
  `user_id` int(10) NOT NULL COMMENT '用户id',
  `wset` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '错误题号集合',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wrong_set
-- ----------------------------
INSERT INTO `wrong_set` VALUES (1, 1, '[]');

SET FOREIGN_KEY_CHECKS = 1;
```

### 3.配置数据库基本信息

在application.yaml配置数据库配置

```yaml
# 基础配置
spring:
  # 数据库配置
  datasource:
    url: jdbc:mysql://localhost:3306/binary?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8 # 需要手动配置
    username: root # 需要手动配置
    password: 123456 # 需要手动配置
    driver-class-name: com.mysql.cj.jdbc.Driver

# mybatis-plus
mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    map-underscore-to-camel-case: true
  mapper-locations: classpath*:/dao/*.xml

# 服务端口
server:
  port: 8090
```

### 4.运行后端

默认端口：8090，前端调用也是写死了8090

### 4.启动前端项目

需要我们的nodejs12

``` cmd
npm install yarn # 下载yarn包管理器

yarn # 项目的依赖下载

yarn serve # 启动前端项目
```

### 5.访问添加接口

进入后台管理，密码为`admin`，执行添加题目操作

李翔/软件构造项目-小学生加减乘除法

简介

发行版

贡献者

近期动态

李翔/软件构造项目-小学生加减乘除法 .gitee-modal { width: 500px !important; }

简介

发行版

贡献者

近期动态

搜索帮助

李翔/软件构造项目-小学生加减乘除法