From 971023df5fd3795e24d10d4d4d03ee112df12297 Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期四, 24 三月 2022 12:17:41 +0800
Subject: [PATCH] 优化查询为空问题

---
 java110-generator/src/main/java/com/java110/code/TableToJsonWeb.java |   32 +++++++++++++-------------------
 1 files changed, 13 insertions(+), 19 deletions(-)

diff --git a/java110-generator/src/main/java/com/java110/code/TableToJsonWeb.java b/java110-generator/src/main/java/com/java110/code/TableToJsonWeb.java
index 30c539f..78415a2 100644
--- a/java110-generator/src/main/java/com/java110/code/TableToJsonWeb.java
+++ b/java110-generator/src/main/java/com/java110/code/TableToJsonWeb.java
@@ -7,26 +7,20 @@
 public class TableToJsonWeb {
 
     //show create table c_orders  鐢ㄨ繖涓鍙ヨ幏鍙�
-    public static final String createTableSql = "CREATE TABLE `report_custom_component` (\n" +
-            "  `component_id` varchar(30) NOT NULL COMMENT '缁勪欢ID',\n" +
-            "  `name` varchar(64) NOT NULL COMMENT '缁勪欢鍚嶇О',\n" +
-            "  `component_group` varchar(12) NOT NULL DEFAULT 'C' COMMENT '缁勪欢缁�',\n" +
-            "  `component_type` varchar(12) NOT NULL COMMENT '缁勪欢绫诲瀷',\n" +
-            "  `query_model` varchar(1) NOT NULL COMMENT '鏌ヨ鏂瑰紡',\n" +
-            "  `sql` longtext(1024) COMMENT '鎵цsql',\n" +
-            "  `java_script`  longtext(1024) COMMENT '鎵цjava鑴氭湰浠ｇ爜',\n" +
-            "  `remark` varchar(512) DEFAULT NULL COMMENT '鎻忚堪',\n" +
-            "  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿'\n" +
-            ") ";
-
+    public static final String createTableSql = "CREATE TABLE `inspection_item` (\n" +
+            "  `item_id` varchar(30) NOT NULL COMMENT '涓婚敭ID',\n" +
+            "  `item_name` varchar(256) NOT NULL COMMENT '宸℃椤圭洰',\n" +
+            "  `community_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '灏忓尯ID',\n" +
+            "  `remark` varchar(512) DEFAULT NULL COMMENT '澶囨敞',\n" +
+            ")";
     public static void main(String[] args) {
-        String templateName = "鎶ヨ〃缁勪欢"; //涓氬姟鍚嶇О
-        String templateCode = "reportCustomComponent"; //琛ㄥ悕澶у啓
-        String templateKey = "componentId"; //琛ㄤ富閿�
-        String templateKeyName = "缁勪欢ID";//涓婚敭璇存槑
-        String searchCode = "componentId"; //鍒嗙墖瀛楁
-        String searchName = "缁勪欢ID"; //鍒嗙墖瀛楁璇存槑
-        String directories = "dev"; //鍓嶇鐢熸垚鍒伴偅涓洰褰曚笅
+        String templateName = "宸℃椤圭洰"; //涓氬姟鍚嶇О
+        String templateCode = "inspectionItem"; //琛ㄥ悕澶у啓
+        String templateKey = "itemId"; //琛ㄤ富閿�
+        String templateKeyName = "缂栧彿";//涓婚敭璇存槑
+        String searchCode = "itemId"; //鍒嗙墖瀛楁
+        String searchName = "缂栧彿"; //鍒嗙墖瀛楁璇存槑
+        String directories = "property"; //鍓嶇鐢熸垚鍒伴偅涓洰褰曚笅
         // templateName 涓氬姟鍚嶇О 涓氬姟缂栫爜鍚嶇О鐢熸垚鍚庢枃浠跺悕 templateCode 涓婚敭 templateKey
         // 涓氬姟涓婚敭鍚嶇О templateKeyName=templateName+ID 涓绘満椹煎嘲 searchCode 涓婚敭鍚嶇О searchName
         // directories 鏀惧湪鍓嶇閭ｄ釜鐩綍涓�

--
Gitblit v1.8.0