# zhouhailin18001020506

**Repository Path**: kingland-customized-classes/zhouhailin18001020506

## Basic Information

- **Project Name**: zhouhailin18001020506
- **Description**: 金兰订制班课程
- **Primary Language**: Unknown
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-05-25
- **Last Updated**: 2022-07-11

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# hailin

### 介绍
金兰定制班课程项目

---


> day1🧐

**MybatisGenerator**

`xml`文件 配置 model ，mapper，

Terminal 切到MybatisGenerator下 生成 

```bash
java -jar mybatis-generator-core-1.3.3-SNAPSHOT.jar -configfile generatorConfig.xml
```

**docker postsql**

````bash
docker run --name postgressql -p 5433:5432 -e POSTGRES_PASSWORD=postgres postgres
````

创建，postgres下的jump into console

```sql
create table user_access.user (
                                  id bigserial not null,
                                  username varchar(20) not null,
                                  password varchar(100) not null,
                                  name text not null,
                                  gender int not null,
                                  is_admin boolean not null default false,
                                  birthday timestamp(3) not null,
                                  phone_num varchar(15),
                                  home_address text,
                                  constraint user_pk PRIMARY KEY (id),
                                  constraint username_unique unique (username)
);
create table user_access.family (
                                    id bigserial not null,
                                    user_id bigint not null,
                                    name text not null,
                                    age int not null,
                                    relationshipType text,
                                    phone_num varchar(15),
                                    constraint family_pk PRIMARY KEY (id),
                                    constraint user_id_fk FOREIGN KEY (user_id) references user_access.user (id)
);
```

<img src="infor/img/截屏2021-05-25 下午9.04.11.png" style="zoom:50%;" />

<img src="infor/img/截屏2021-05-25 下午9.16.39.png" style="zoom:50%;" />

**业务**

addUser

---

> day2 🧐🧐





----

> Day3🧐🧐🧐