文档
测试

读取sql文件

POST
http://127.0.0.1:8190/modelForm/readSqlFile

请求参数

参数名
类型
描述
必填
file
MultipartFile
sql文件
必填

响应参数

参数名
类型
描述
必填
code
Integer
200 成功,其余失败
必填
msg
String
操作描述
必填
data
json
数据集
必填
fieldName
String
字段名称
必填
fieldChineseName
String
字段中文名称
必填
fieldType
Integer
字段类型
必填
fieldLength
Integer
字段长度
必填
whetherNull
Integer
是否可为空 0 否 1 是
必填
fieldDescribe
String
字段说明
必填
usedQuery
Integer
是否用于查询 0 否 1 是
必填

说明 / 示例

{ "msg": "操作成功", "code": 200, "data": [ { "serialNumber": null, "fieldName": "gddw", "fieldChineseName": "供电单位", "fieldType": 14, "fieldLength": 255, "whetherNull": 1, "fieldDescribe": "供电单位", "type": null, "tableName": null, "usedQuery": 0 }, { "serialNumber": null, "fieldName": "gdsmc", "fieldChineseName": "供电所名称", "fieldType": 14, "fieldLength": 255, "whetherNull": 1, "fieldDescribe": "供电所名称", "type": null, "tableName": null, "usedQuery": 0 }, { "serialNumber": null, "fieldName": "ywlx", "fieldChineseName": "业务类型", "fieldType": 14, "fieldLength": 255, "whetherNull": 1, "fieldDescribe": "业务类型", "type": null, "tableName": null, "usedQuery": 0 }, { "serialNumber": null, "fieldName": "slsj", "fieldChineseName": "受理时间", "fieldType": 14, "fieldLength": 6, "whetherNull": 1, "fieldDescribe": "受理时间", "type": null, "tableName": null, "usedQuery": 0 }, { "serialNumber": null, "fieldName": "yjlx", "fieldChineseName": "一级类型", "fieldType": 14, "fieldLength": 255, "whetherNull": 1, "fieldDescribe": "一级类型", "type": null, "tableName": null, "usedQuery": 0 }, { "serialNumber": null, "fieldName": "ejlx", "fieldChineseName": "二级类型", "fieldType": 14, "fieldLength": 255, "whetherNull": 1, "fieldDescribe": "二级类型", "type": null, "tableName": null, "usedQuery": 0 }, { "serialNumber": null, "fieldName": "sjlx", "fieldChineseName": "三级类型", "fieldType": 14, "fieldLength": 255, "whetherNull": 1, "fieldDescribe": "三级类型", "type": null, "tableName": null, "usedQuery": 0 }, { "serialNumber": null, "fieldName": "xcdz", "fieldChineseName": "现场地址", "fieldType": 14, "fieldLength": 255, "whetherNull": 1, "fieldDescribe": "现场地址", "type": null, "tableName": null, "usedQuery": 0 }, { "serialNumber": null, "fieldName": "gdsj", "fieldChineseName": "归档时间", "fieldType": 14, "fieldLength": 6, "whetherNull": 1, "fieldDescribe": "归档时间", "type": null, "tableName": null, "usedQuery": 0 }, { "serialNumber": null, "fieldName": "cljg", "fieldChineseName": "处理结果", "fieldType": 14, "fieldLength": 255, "whetherNull": 1, "fieldDescribe": "处理结果", "type": null, "tableName": null, "usedQuery": 0 }, { "serialNumber": null, "fieldName": "clqk", "fieldChineseName": "处理情况", "fieldType": 14, "fieldLength": 8000, "whetherNull": 1, "fieldDescribe": "处理情况", "type": null, "tableName": null, "usedQuery": 0 }, { "serialNumber": null, "fieldName": "clmyd", "fieldChineseName": "处理满意度", "fieldType": 14, "fieldLength": 255, "whetherNull": 1, "fieldDescribe": "处理满意度", "type": null, "tableName": null, "usedQuery": 0 }, { "serialNumber": null, "fieldName": "lx", "fieldChineseName": "类型", "fieldType": 14, "fieldLength": 255, "whetherNull": 1, "fieldDescribe": "类型", "type": null, "tableName": null, "usedQuery": 0 }, { "serialNumber": null, "fieldName": "zx", "fieldChineseName": "中心", "fieldType": 14, "fieldLength": 255, "whetherNull": 1, "fieldDescribe": "中心", "type": null, "tableName": null, "usedQuery": 0 }, { "serialNumber": null, "fieldName": "bz", "fieldChineseName": "班组", "fieldType": 14, "fieldLength": 255, "whetherNull": 1, "fieldDescribe": "班组", "type": null, "tableName": null, "usedQuery": 0 }, { "serialNumber": null, "fieldName": "scyx", "fieldChineseName": "生产营销", "fieldType": 14, "fieldLength": 255, "whetherNull": 1, "fieldDescribe": "生产营销", "type": null, "tableName": null, "usedQuery": 0 }, { "serialNumber": null, "fieldName": "tqmc", "fieldChineseName": "台区名称", "fieldType": 14, "fieldLength": 255, "whetherNull": 1, "fieldDescribe": "台区名称", "type": null, "tableName": null, "usedQuery": 0 }, { "serialNumber": null, "fieldName": "wtfl", "fieldChineseName": "问题分类", "fieldType": 14, "fieldLength": 255, "whetherNull": 1, "fieldDescribe": "问题分类", "type": null, "tableName": null, "usedQuery": 0 }, { "serialNumber": null, "fieldName": "zyfl", "fieldChineseName": "专业分类", "fieldType": 14, "fieldLength": 255, "whetherNull": 1, "fieldDescribe": "专业分类", "type": null, "tableName": null, "usedQuery": 0 } ] }