Spring Cloud 实战（一）-点餐系统

前言

学习 Spring Cloud 也很久了，今天开始准备拿点餐系统来练练手。虽然网上也有很多例子，但是，鞋到底合不合适，只有自己穿上了才知道。所以实践出真知。JUST DO IT!（嗯，咱挺适合搞 IT 的<->）

项目设计

1.角色划分

• 买家（手机端）
• 卖家（PC端）

2.功能分析

买家

• 查看商品列表
• 订单创建
• 订单查询
• 订单取消
  …

卖家

• 订单管理
• 商品管理
• 类目管理
  …

3.数据库设计

1）数据库表之间的关系说明

• 类目表 product_category
• 商品表 product_info
• 订单详情表 order_detail
• 订单主表 order_master
• 买家/卖家信息表 user_info

2）设计数据库表

create table `product_info` (
   `product_id` varchar(32) not null,
   `product_name` varchar(64) not null comment '商品名称',
   `product_price` decimal(8,2) not null comment '单价',
   `product_stock` int not null comment '库存',
   `product_description` varchar(64) comment '描述',
   `product_icon` varchar(512) comment '小图',
   `product_status` tinyint(3) DEFAULT '0' COMMENT '商品状态,0正常1下架',
   `category_type` int not null comment '类目编号',
   `create_time` timestamp not null default current_timestamp comment '创建时间',
   `update_time` timestamp not null default current_timestamp on update current_timestamp comment '修改时间',
   primary key (`product_id`)
) comment '商品表';
 
create table `product_category` (
   `category_id` int not null auto_increment,
   `category_name` varchar(64) not null comment '类目名称',
   `category_type` int not null comment '类目编号',
   `create_time` timestamp not null default current_timestamp comment '创建时间',
   `update_time` timestamp not null default current_timestamp on update current_timestamp comment '修改时间',
   primary key (`category_id`),
   unique key `uqe_category_type` (`category_type`)
) comment '类目表';
 
create table `order_master` (
   `order_id` varchar(32) not null,
   `buyer_name` varchar(32) not null comment '买家名称',
   `buyer_phone` varchar(32) not null comment '买家电话',
   `buyer_address` varchar(128) not null comment '买家地址',
   `buyer_openid` varchar(64) not null comment '买家微信openid',
   `order_amount` decimal(8,2) not null comment '订单总金额',
   `order_status` tinyint(3) not null default '0' comment '订单状态,默认0，新下单',
   `pay_status` tinyint(3) not null default '0' comment '支付状态,默认0，未支付',
   `create_time` timestamp not null default current_timestamp comment '创建时间',
   `update_time` timestamp not null default current_timestamp on update current_timestamp comment '修改时间',
   primary key (`order_id`),
   key `idx_buyer_openid` (`buyer_openid`)
) comment '订单主表';
 
create table `order_detail` (
   `detail_id` varchar(32) not null,
   `order_id` varchar(32) not null,
   `product_id` varchar(32) not null,
   `product_name` varchar(64) not null comment '商品名称',
   `product_price` decimal(8,2) not null comment '单价',
   `product_quantity` int not null comment '商品数量',
   `product_icon` varchar(512) comment '小图',
   `create_time` timestamp not null default current_timestamp comment '创建时间',
   `update_time` timestamp not null default current_timestamp on update current_timestamp comment '修改时间',
   primary key (`detail_id`),
   key `idx_order_id` (`order_id`)
) comment '订单详情表';

CREATE TABLE `user_info` (
  `id` varchar(32) NOT NULL,
  `username` varchar(32) DEFAULT '',
  `password` varchar(32) DEFAULT '',
  `openid` varchar(64) DEFAULT '' COMMENT '微信openid',
  `role` tinyint(1) NOT NULL COMMENT '1买家2卖家',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Spring Boot 环境

环境/版本一览：

1. 开发工具：Intellij IDEA 2018.2.5
2. springboot: 2.0.6.RELEASE
3. jdk：1.8.0_181
4. maven:3.5.4
5. alibaba Druid 数据库连接池：1.1.9
6. swagger: 2.9.2

开始搭建（以 product服务为例）

1. 创建项目

2. 基础依赖

3. 补充依赖

引入 swagger

<!-- https://mvnrepository.com/artifact/io.springfox/springfox-swagger2 -->
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger2</artifactId>
<version>2.9.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/io.springfox/springfox-swagger-ui -->
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger-ui</artifactId>
<version>2.9.2</version>
</dependency>

swagger2.java 文件

package com.taeyeon.product;

/**
 * @Author: zyx
 * @Date: 18/9/29 下午4:37
 * @Description:
 */

import io.swagger.annotations.Api;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import springfox.documentation.builders.ApiInfoBuilder;
import springfox.documentation.builders.PathSelectors;
import springfox.documentation.builders.RequestHandlerSelectors;
import springfox.documentation.service.ApiInfo;
import springfox.documentation.spi.DocumentationType;
import springfox.documentation.spring.web.plugins.Docket;
import springfox.documentation.swagger2.annotations.EnableSwagger2;

@Configuration
@EnableSwagger2
public class Swagger2 {

    private ApiInfo apiInfo() {
        return new ApiInfoBuilder().title("管理后台 RESTful APIs").description("This is created by ZYX")
                .termsOfServiceUrl("http://zyx.yy.com")
                .contact("15612345678").version("1.0").build();
    }

    @Bean
    public Docket createRestApi() {
        return new Docket(DocumentationType.SWAGGER_2)
                .apiInfo(apiInfo())
                .select()
                .apis(RequestHandlerSelectors.withClassAnnotation(Api.class)).paths(PathSelectors.any())
                .paths(PathSelectors.any())
                .build();
    }
}

4. pom 文件概览

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>

	<groupId>com.taeyeon</groupId>
	<artifactId>product</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>jar</packaging>

	<name>product</name>
	<description>Product project for Spring Boot</description>

	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.0.6.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>

	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
		<java.version>1.8</java.version>
		<spring-cloud.version>Finchley.SR1</spring-cloud.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-devtools</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
		<dependency>
			<groupId>org.springframework.cloud</groupId>
			<artifactId>spring-cloud-starter-config</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.cloud</groupId>
			<artifactId>spring-cloud-netflix-core</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.cloud</groupId>
			<artifactId>spring-cloud-netflix-eureka-client</artifactId>
			<version>2.0.1.RELEASE</version>
		</dependency>

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

		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<scope>test</scope>
		</dependency>
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.3.2</version>
		</dependency>
		<!-- alibaba的druid数据库连接池 -->
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid-spring-boot-starter</artifactId>
			<version>1.1.9</version>
		</dependency>
		<!-- swagger2 -->
		<dependency>
			<groupId>io.springfox</groupId>
			<artifactId>springfox-swagger2</artifactId>
			<version>2.9.2</version>
		</dependency>
		<dependency>
			<groupId>io.springfox</groupId>
			<artifactId>springfox-swagger-ui</artifactId>
			<version>2.9.2</version>
		</dependency>

	</dependencies>

	<dependencyManagement>
		<dependencies>
			<dependency>
				<groupId>org.springframework.cloud</groupId>
				<artifactId>spring-cloud-dependencies</artifactId>
				<version>${spring-cloud.version}</version>
				<type>pom</type>
				<scope>import</scope>
			</dependency>
		</dependencies>
	</dependencyManagement>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
			<!-- mybatis generator 自动生成代码插件 -->
			<plugin>
				<groupId>org.mybatis.generator</groupId>
				<artifactId>mybatis-generator-maven-plugin</artifactId>
				<version>1.3.7</version>
				<configuration>
					<configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
					<overwrite>true</overwrite>
					<verbose>true</verbose>
				</configuration>
			</plugin>
		</plugins>
	</build>
</project>

注意：
有关自动生成代码的mybatis generator，可参考这篇文章 Spring boot Mybatis 整合（完整版）

项目概览