EDU教育机构的教务系统后端接口实现1

1.技术选型和数据库构建

技术选型

前言:在需求分析阶段本来打算使用springcloud相关技术实现该教务系统，但是考虑到微服务的项目规模和资源损耗。最后降级使用springboot+mybatis-plus的单体架构去实现

技术选型及对应版本：
jdk:19
maven:4.0
mysql:8.0.3
springboot:2.7.3
mybatis-plus:3.5.3.1

pom依赖：

<modelVersion>4.0.0</modelVersion>
<parent>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-parent</artifactId>
	<version>2.7.3</version>
	<relativePath/> 
</parent>
<groupId>com.pickles</groupId>
<artifactId>EDUSystem</artifactId>
<version>2.0.1</version>
<packaging>jar</packaging>
<name>EDUSystem</name>
<description>EDUSystem</description>
<properties>
	<java.version>17</java.version>
</properties>
<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>
		<scope>test</scope>
	</dependency>
	<!--        jdbc-->
	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-jdbc</artifactId>
	</dependency>
	<!--        web-->
	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-web</artifactId>
	</dependency>
	<!--        lombok-->
	<dependency>
		<groupId>org.projectlombok</groupId>
		<artifactId>lombok</artifactId>
	</dependency>

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

	<dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
	</dependency>

	<dependency>
		<groupId>com.alibaba</groupId>
		<artifactId>fastjson</artifactId>
		<version> 2.0.23</version>
	</dependency>

	<!--自动文档生成工具-->
	<!--      swagger2 依赖-->
	<dependency>
		<groupId>io.springfox</groupId>
		<artifactId>springfox-swagger2</artifactId>
		<version>2.9.2</version>
	</dependency>
	<!--    swaggerui-->
	<dependency>
		<groupId>com.github.xiaoymin</groupId>
		<artifactId>swagger-bootstrap-ui</artifactId>
		<version>1.9.6</version>
	</dependency>
	<!--        knife4j-->
	<dependency>
		<groupId>com.github.xiaoymin</groupId>
		<artifactId>knife4j-spring-boot-starter</artifactId>
		<version>2.0.4</version>
	</dependency>

	<!--        数据连接池-->
	<!--Druid-->
	<dependency>
		<groupId>com.alibaba</groupId>
		<artifactId>druid</artifactId>
		<version>1.2.13-SNSAPSHOT</version>
	</dependency>
	<!--    Druid Spring Boot 组件-->
	<dependency>
		<groupId>com.alibaba</groupId>
		<artifactId>druid-spring-boot-starter</artifactId>
		<version>1.2.13-SNSAPSHOT</version>
	</dependency>

	<dependency>
		<groupId>log4j</groupId>
		<artifactId>log4j</artifactId>
		<version>1.2.17</version>
	</dependency>

	<!--登录框架-->
	<!--sa-token-->
	<dependency>
		<groupId>cn.dev33</groupId>
		<artifactId>sa-token-spring-boot-starter</artifactId>
		<version>1.31.0</version>
	</dependency>

	<!--验证码框架-->
	<dependency>
		<groupId>com.github.penggle</groupId>
		<artifactId>kaptcha</artifactId>
		<version>2.3.2</version>
	</dependency>


	<dependency>
		<groupId>redis.clients</groupId>
		<artifactId>jedis</artifactId>
		<version>5.0.0-alpha2</version>
	</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>

数据库设计