JeeSite4自动创建主子表、树表

以你之姓@ 2023-02-20 06:21 15阅读 0赞

### 一、主子表 ###

1、创建数据库表,外键要注意命名，命名不当会出现在自动创建时会出现：主表信息筛选不出子表数据（即每一条主表数据对应了所有子表数据），命名规范： 主表名\_id

#主表：demo_customer
    
    CREATE TABLE `demo_customer` (
      `id` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT '编号',
      `create_by` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT '创建人',
      `create_date` datetime NOT NULL COMMENT '创建时间',
      `update_by` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT '修改人',
      `update_date` datetime NOT NULL COMMENT '修改时间',
      `remarks` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注信息',
      `custname` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '客户姓名',
      `custcode` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '客户编号',
      `sex` char(1) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '性别',
      `phone` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '电话',
      `del_flag` char(1) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '删除标记',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    
    
    #子表：demo_customer_id
    
    CREATE TABLE `demo_customer_info` (
      `id` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT '编号',
      `demo_customer_id` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT '客户编号',
      `email` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '邮箱',
      `district` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '地区',
      `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '地址',
      `create_by` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT '创建人',
      `create_date` datetime NOT NULL COMMENT '创建时间',
      `update_by` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT '修改人',
      `update_date` datetime NOT NULL COMMENT '修改时间',
      `remark` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注信息',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

2、配置主表和子表的模板

**主表的配置：**[JeeSite快速开始与环境搭建][JeeSite]，最后一步点击 ‘保存并编译’ （该选项不会生成文件，等配置完子表再生成文件）

**子表的配置：** 注意选择’关联父表的表名’，‘本表关联的外键名’  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 1]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 2]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 3]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 4]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 5]  
代码生成好之后，将这个模块加入到系统，[JeeSite快速开始与环境搭建][JeeSite]

3、实现效果  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 6]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 7]

### 二、树表 ###

1、进入代码生成工具，使用：‘js\_sys\_area’表进行创建  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 8]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 9]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 10]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 11]  
2、分配到菜单栏，重启服务器让修改生效  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 12]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 13]  
3、实现效果  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 14]

[JeeSite]: https://blog.csdn.net/nov4th/article/details/106909225
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/2020062320074430.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/2020062320081969.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200623200928440.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200623200909136.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20200623201314608.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/202006232011187.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20200623201758221.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/20200623201826461.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 8]: https://img-blog.csdnimg.cn/20200623202104747.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 9]: https://img-blog.csdnimg.cn/20200623202116867.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 10]: https://img-blog.csdnimg.cn/20200623202446523.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 11]: https://img-blog.csdnimg.cn/20200623202553102.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 12]: https://img-blog.csdnimg.cn/20200623202657391.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 13]: https://img-blog.csdnimg.cn/20200623202913953.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA_size_16_color_FFFFFF_t_70 14]: https://img-blog.csdnimg.cn/20200623203128778.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25vdjR0aA==,size_16,color_FFFFFF,t_70