From 42940f5da4f29d35ef7455f71082f3b517f927cb Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期二, 09 十一月 2021 13:33:49 +0800
Subject: [PATCH] 优化代码
---
java110-generator/src/main/java/com/java110/code/TableToJson.java | 24 +++++++++++++-----------
1 files changed, 13 insertions(+), 11 deletions(-)
diff --git a/java110-generator/src/main/java/com/java110/code/TableToJson.java b/java110-generator/src/main/java/com/java110/code/TableToJson.java
index 67f6bce..2b945ed 100644
--- a/java110-generator/src/main/java/com/java110/code/TableToJson.java
+++ b/java110-generator/src/main/java/com/java110/code/TableToJson.java
@@ -7,23 +7,25 @@
public class TableToJson {
//show create table c_orders 鐢ㄨ繖涓鍙ヨ幏鍙�
- public static final String createTableSql = "CREATE TABLE `report_custom` (\n" +
- " `custom_id` varchar(30) NOT NULL COMMENT '鎶ヨ〃缂栧彿',\n" +
- " `group_id` varchar(30) NOT NULL COMMENT '缁勭紪鍙�',\n" +
- " `title` varchar(64) NOT NULL COMMENT '閫夐」鏍囬',\n" +
- " `seq` int(11) NOT NULL COMMENT '鎺掑簭',\n" +
+ public static final String createTableSql = "CREATE TABLE `report_custom_component_condition` (\n" +
+ " `condition_id` varchar(30) NOT NULL COMMENT '鏉′欢ID',\n" +
+ " `component_id` varchar(30) NOT NULL COMMENT '缁勪欢ID',\n" +
+ " `name` varchar(64) NOT NULL COMMENT '鍚嶇О',\n" +
+ " `holdpace` varchar(64) NOT NULL DEFAULT 'C' COMMENT '鎻愮ず',\n" +
+ " `param` varchar(64) NOT NULL COMMENT '鍙傛暟',\n" +
+ " `type` varchar(12) NOT NULL COMMENT '绫诲瀷 input 杈撳叆妗�',\n" +
" `remark` varchar(512) DEFAULT NULL COMMENT '鎻忚堪',\n" +
" `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',\n" +
" `status_cd` varchar(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥'\n" +
- ") ";
+ ")";
public static void main(String[] args) {
- String desc = "鎶ヨ〃缁勪欢";
- String id = "customId";
- String name = "reportCustom";
+ String desc = "鎶ヨ〃缁勪欢鏉′欢";
+ String id = "conditionId";
+ String name = "reportCustomComponentCondition";
String shareName = "report"; //鐢熸垚鍒伴偅涓湇鍔′笅
- String shareColumn = "custom_id";
- String shareParam = "customId";
+ String shareColumn = "condition_id";
+ String shareParam = "conditionId";
//涓氬姟鍚嶇О desc 涓氬姟缂栫爜鍚嶇О鐢熸垚鍚庣被鍚� name 涓婚敭 id 闇�瑕佹斁鍒伴偅涓湇鍔� shareName
String newSql = createTableSql.substring(createTableSql.indexOf("(") + 1, createTableSql.lastIndexOf(")"));
String tableName = createTableSql.substring(createTableSql.indexOf("TABLE") + 5, createTableSql.indexOf("("));
--
Gitblit v1.8.0