# spring-sparrow

**Repository Path**: full-stack-5755/spring-sparrow

## Basic Information

- **Project Name**: spring-sparrow
- **Description**: 使用 Maven 搭建 SpringCloud 并整合 SpringBoot 的一个小项目
- **Primary Language**: Java
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-05-17
- **Last Updated**: 2020-12-18

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Spring Sparrow

### 项目环境

* JDK 1.8.x
* Maven 3.x
* Spring Boot 2.x
* MySQL 8.x

具体依赖请查阅项目 pom.xml 文件

### 创建数据库

```bash
mysql -u root -p # Enter 输入 mysql 密码, root 为 mysql 用户名, 登录 mysql
create database spring_sparrow; # 创建数据库 spring_sparrow
```

### 创建数据库表

```sql
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'pwd,111',
  `real_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `gender` int DEFAULT '0',
  `birthday` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '1970-01-01',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
```

### 插入初始数据
```sql
INSERT INTO `user` (`id`, `username`, `password`, `real_name`, `gender`, `birthday`)
VALUES
	(1,'yingzheng','yz,259','嬴政',1,'1970-01-01'),
	(2,'liuche','lc,156','刘彻',1,'1970-01-01'),
	(3,'lishimin','lsm,598','李世民',1,'1970-01-01'),
	(4,'wuzetian','wzt,624','武则天',0,'1970-01-01'),
	(5,'zhaokuangyin','zky,927','赵匡胤',1,'1970-01-01'),
	(6,'tiemuzhen','tmz,1162','铁木真',1,'1970-01-01');
```