# micro_service_study

**Repository Path**: Xenolies/micro_service_study

## Basic Information

- **Project Name**: micro_service_study
- **Description**: JAVA 微服务分布式学习
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2023-06-20
- **Last Updated**: 2023-06-26

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# micro_service_study

#### 介绍
JAVA 微服务分布式学习
使用 SpringBoot框架编写,使用 Eureka 进行微服务管理,Ribbon 负载均衡


#### 建表语句

```mysql
DROP DATABASE IF EXISTS cloudDB01;
CREATE DATABASE cloudDB01 CHARACTER SET UTF8;
USE cloudDB01;
CREATE TABLE dept
(
  dept_no BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  d_name VARCHAR(60),
  db_source   VARCHAR(60)
);

INSERT INTO dept(d_name,db_source) VALUES('研发部',DATABASE());
INSERT INTO dept(d_name,db_source) VALUES('人事部',DATABASE());
INSERT INTO dept(d_name,db_source) VALUES('财务部',DATABASE());
INSERT INTO dept(d_name,db_source) VALUES('市场部',DATABASE());
```

```mysql
DROP DATABASE IF EXISTS cloudDB02;
CREATE DATABASE cloudDB02 CHARACTER SET UTF8;
USE cloudDB02;
CREATE TABLE dept
(
  dept_no BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  d_name VARCHAR(60),
  db_source   VARCHAR(60)
);

INSERT INTO dept(d_name,db_source) VALUES('研发部',DATABASE());
INSERT INTO dept(d_name,db_source) VALUES('人事部',DATABASE());
INSERT INTO dept(d_name,db_source) VALUES('财务部',DATABASE());
INSERT INTO dept(d_name,db_source) VALUES('市场部',DATABASE());
INSERT INTO dept(d_name,db_source) VALUES('运维部',DATABASE());
```

```mysql
DROP DATABASE IF EXISTS cloudDB03;
CREATE DATABASE cloudDB03 CHARACTER SET UTF8;
USE cloudDB03;
CREATE TABLE dept
(
  dept_no BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  d_name VARCHAR(60),
  db_source   VARCHAR(60)
);

INSERT INTO dept(d_name,db_source) VALUES('研发部',DATABASE());
INSERT INTO dept(d_name,db_source) VALUES('人事部',DATABASE());
INSERT INTO dept(d_name,db_source) VALUES('财务部',DATABASE());
INSERT INTO dept(d_name,db_source) VALUES('市场部',DATABASE());
INSERT INTO dept(d_name,db_source) VALUES('运维部',DATABASE());
INSERT INTO dept(d_name,db_source) VALUES('测试部',DATABASE());
```