{ "properties" : { }, "id" : "1d0adb4921c2443f83ea84c202d0a9b5", "script" : null, "groupId" : "f2538e0f370a4cabab0ae920f5e77ae7", "name" : "列表", "createTime" : null, "updateTime" : 1652170803372, "lock" : null, "createBy" : null, "updateBy" : null, "path" : "/list", "method" : "POST", "parameters" : [ ], "options" : [ { "name" : "permission", "value" : "code:gen:view", "description" : "允许拥有该权限的访问", "required" : false, "dataType" : "String", "type" : null, "defaultValue" : null, "validateType" : null, "error" : null, "expression" : null, "children" : null } ], "requestBody" : "", "headers" : [ ], "paths" : [ ], "responseBody" : "{\n \"code\": 402,\n \"message\": \"凭证已过期\",\n \"data\": null,\n \"timestamp\": 1652170783940,\n \"executeTime\": null\n}", "description" : null, "requestBodyDefinition" : null, "responseBodyDefinition" : { "name" : "", "value" : "", "description" : "", "required" : false, "dataType" : "Object", "type" : null, "defaultValue" : null, "validateType" : "", "error" : "", "expression" : "", "children" : [ { "name" : "code", "value" : "402", "description" : "", "required" : false, "dataType" : "Integer", "type" : null, "defaultValue" : null, "validateType" : "", "error" : "", "expression" : "", "children" : [ ] }, { "name" : "message", "value" : "凭证已过期", "description" : "", "required" : false, "dataType" : "String", "type" : null, "defaultValue" : null, "validateType" : "", "error" : "", "expression" : "", "children" : [ ] }, { "name" : "data", "value" : "null", "description" : "", "required" : false, "dataType" : "Array", "type" : null, "defaultValue" : null, "validateType" : "", "error" : "", "expression" : "", "children" : [ ] }, { "name" : "timestamp", "value" : "1652170783940", "description" : "", "required" : false, "dataType" : "Long", "type" : null, "defaultValue" : null, "validateType" : "", "error" : "", "expression" : "", "children" : [ ] }, { "name" : "executeTime", "value" : "null", "description" : "", "required" : false, "dataType" : "Integer", "type" : null, "defaultValue" : null, "validateType" : "", "error" : "", "expression" : "", "children" : [ ] } ] } } ================================ return db.page(""" select id,table_name,table_comment,create_date,update_date from sys_gen_info where 1=1 ?{tableName, and table_name like concat('%',#{tableName},'%')} ?{tableComment, and table_comment like concat('%',#{tableComment},'%')} ?{createDate && createDate.split(',')[0], and create_date >= #{createDate.split(',')[0]}} ?{createDate && createDate.split(',')[1], and create_date <= #{createDate.split(',')[1]}} order by create_date desc """)