02| 项目基础数据构建&技术选型&项目构建

小滴课堂讲师 2024年07月29日预计阅读 3 分钟原文

#### 基础数据构建

项目结构：**前后端分离架构，容器编排部署**

独立数据库：

- 用户服务数据库： p_nla_user   (Project_New Lead Acquisition_User 拉新营销项目用户数据库）
- 商品服务数据库： p_nla_product
- 优惠券服务数据库： p_nla_coupon
- 订单服务数据库： p_nla_order

用户服务数据库中创建表：`user`、`address`

用户表

```sql
CREATE TABLE `user` (
 `id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
 `name` varchar(128) DEFAULT NULL COMMENT '昵称',
 `pwd` varchar(124) DEFAULT NULL COMMENT '密 码',
 `head_img` varchar(524) DEFAULT NULL COMMENT '头像',
 `slogan` varchar(524) DEFAULT NULL COMMENT '用户签名',
 `sex` tinyint(2) DEFAULT '1' COMMENT '0-女，1-男',
 `points` int(10) DEFAULT '0' COMMENT '积 分',
 `create_time` datetime DEFAULT NULL,
 `mail` varchar(64) DEFAULT NULL COMMENT '邮 箱',
 `secret` varchar(12) DEFAULT NULL COMMENT '盐，用于个人敏感信息处理',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mail_idx` (`mail`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT
CHARSET=utf8;
```

收货地址表

```sql
CREATE TABLE `address` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
 `default_status` int(1) DEFAULT NULL COMMENT '是否默认收货地址：0-否；1-是',
 `receive_name` varchar(64) DEFAULT NULL COMMENT '收发货人姓名',
 `phone` varchar(64) DEFAULT NULL COMMENT '收货人电话',
 `province` varchar(64) DEFAULT NULL COMMENT '省/直辖市',
 `city` varchar(64) DEFAULT NULL COMMENT '市',
 `region` varchar(64) DEFAULT NULL COMMENT '区',
 `detail_address` varchar(200) DEFAULT NULL COMMENT '详细地址',
 `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT
CHARSET=utf8mb4 COMMENT='电商-公司收发货地址表';
```

#### 技术选型

- SpringCloud
  - 通信方式：http restful
  - 注册中心：eureka
  - 配置中心：config
  - 断路器：hystrix
  - 网关：zuul/gateway
  - 分布式追踪系统：sleuth+zipkin
- Spring Cloud Alibaba
  - 通信方式：http restful
  - 服务注册发现：Nacos
  - 服务限流降级：Sentinel
  - 分布配置中心：Nacos
  - 服务网关：SpringCloud Gateway
  - 服务之间调用：Feign、Ribbon
  - 链路追踪：Sleuth+Zipkin

SpringCloud很多组件是基于第三方整合，`⽬前多个已经不更新了`，比如zuul、eureka、hystrix等

版本选择：

- SpringBoot 2.3.3.RELEASE 版本
- Spring Cloud Hoxton.SR8 版本
- AlibabaCloud 2.2.1.RELEASE 版本

#### 项目工程分类

1. 公共模块：nla-common
2. 商品服务模块：nla-product-service
3. 用户服务模块：nla-user-service
4. 订单服务模块：nla-order-service
5. 优惠券服务模块：nla-coupon-service
6. 网关模块：nla-gateway

父级项目的依赖`pom.xml`:

```xml
 <modelVersion>4.0.0</modelVersion>
 <groupId>cn.nla</groupId>
 <artifactId>nla-shop</artifactId>
 <version>1.0-SNAPSHOT</version>
 <packaging>pom</packaging>
 <description>拉新营销平台</description>
 <modules>
   <module>nla-common</module>
   <module>nla-product-service</module>
   <module>nla-user-service</module>
   <module>nla-order-service</module>
   <module>nla-coupon-service</module>
   <module>nla-gateway</module>
 </modules>
 <properties>
   <java.version>11</java.version>
   <maven.compiler.source>11</maven.compiler.source>
   <maven.compiler.target>11</maven.compiler.target>
   <spring.boot.version>2.3.3.RELEASE</spring.boot.version>
   <spring.cloud.version>Hoxton.SR8</spring.cloud.version> <alibaba.cloud.version>2.2.1.RELEASE</alibaba.cloud.version> <mybatisplus.boot.starter.version>3.4.0</mybatisplus.boot.starter.version>
   <lombok.version>1.18.16</lombok.version>
   <commons.lang3.version>3.9</commons.lang3.version>
   <commons.codec.version>1.15</commons.codec.version> <springfox.boot.starter.version>3.0.0</springfox.boot.starter.version>
   <docker.image.prefix>yuan-cloud</docker.image.prefix>
   
   <skipTests>true</skipTests>
 </properties>
 
 <dependencyManagement>
   <dependencies>
     <dependency> 
       <groupId>org.springframework.boot</groupId>
       <artifactId>spring-boot-dependencies</artifactId>
       <version>${spring.boot.version} </version>
       <type>pom</type>
       <scope>import</scope>
     </dependency>
     <dependency>
       <groupId>org.springframework.cloud</groupId>
       <artifactId>spring-cloud-dependencies</artifactId>
       <version>${spring.cloud.version}</version>
       <type>pom</type>
       <scope>import</scope>
     </dependency>
     <dependency> 
       <groupId>com.alibaba.cloud</groupId>
       <artifactId>spring-cloud-alibaba-dependencies</artifactId>
       <version>${alibaba.cloud.version}</version>
       <type>pom</type>
       <scope>import</scope>
     </dependency>
     
     <dependency>
       <groupId>com.baomidou</groupId>
       <artifactId>mybatis-plus-boot-starter</artifactId>
       <version>${mybatisplus.boot.starter.version}</version>
     </dependency>
     
     <dependency>
       <groupId>org.projectlombok</groupId>
       <artifactId>lombok</artifactId>
       <version>${lombok.version}</version>
       <scope>provided</scope>
     </dependency>
     
     <dependency>
       <groupId>org.apache.commons</groupId>
       <artifactId>commons-lang3</artifactId>
       <version>${commons.lang3.version}</version>
     </dependency>
     
     <dependency>
       <groupId>commons-codec</groupId>
       <artifactId>commons-codec</artifactId>
       <version>${commons.codec.version}</version>
     </dependency>
     
     <dependency>
       <groupId>io.springfox</groupId>
       <artifactId>springfox-boot-starter</artifactId>
       <version>${springfox.boot.starter.version}</version>
     </dependency>
   </dependencies>
 </dependencyManagement>
 
   <repositories>
     <repository>
       <id>maven-ali</id>
       <url>http://maven.aliyun.com/nexus/content/groups/public//</url>
       <releases>
         <enabled>true</enabled>
       </releases>
       <snapshots>
         <enabled>true</enabled> 
         <updatePolicy>always</updatePolicy>
         <checksumPolicy>fail</checksumPolicy>
       </snapshots>
     </repository>
   </repositories>
   <pluginRepositories>
     <pluginRepository>
       <id>public</id>
       <name>aliyun nexus</name> 
       <url>http://maven.aliyun.com/nexus/content/groups/public/</url>
       <releases>
         <enabled>true</enabled>
       </releases>
       <snapshots>
         <enabled>false</enabled>
       </snapshots>
     </pluginRepository>
   </pluginRepositories>

<build>
   <plugins>
     <plugin>
       <groupId>org.springframework.boot</groupId>
       <artifactId>spring-boot-maven-plugin</artifactId>
       <version>${spring.boot.version}</version>
       <configuration>
         <fork>true</fork>
         <addResources>true</addResources>
       </configuration>
     </plugin>
   </plugins>
 </build>
```

**提效利器**：`Lombok、MybaitsPlus、SwaggerUI`

Lombok常见注解:  @Getter/@Setter，@ToString，@EqualsAndHashCode，@NoArgsConstructor，@AllArgsConstructor，@Data，@Log / @Slf4j

nla-common项目的依赖：

```xml
<dependency>
  <groupId>org.projectlombok</groupId>
  <artifactId>lombok</artifactId>
</dependency>

<dependency>
  <groupId>org.springframework.boot</groupId>
  <artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
  <groupId>com.baomidou</groupId>
  <artifactId>mybatis-plus-boot-starter</artifactId>
</dependency>

<dependency>
  <groupId>com.baomidou</groupId>
  <artifactId>mybatis-plus-generator</artifactId>
  <version>3.4.1</version>
</dependency>

<dependency> 
  <groupId>org.apache.velocity</groupId>
  <artifactId>velocity-engine-core</artifactId>
  <version>2.0</version>
</dependency>


<dependency>
  <groupId>io.springfox</groupId>
  <artifactId>springfox-boot-starter</artifactId>
</dependency>
```

nla-user-service项目依赖：

```xml
<dependency>
  <groupId>cn.nla</groupId>
  <artifactId>nla-common</artifactId>
  <version>1.0-SNAPSHOT</version>
</dependency>
<dependency>
 <groupId>org.projectlombok</groupId>
 <artifactId>lombok</artifactId>
</dependency>
```

评论区