1、接口功能:

根据webService接口,查询所有表数据

2、URL地址(示例)

http://192.168.1.117:8086/select/soap 

 

3、支持格式

JSON

 

4、HTTP请求方式

 

GET

 

5、请求参数(根据需求给出参数或者不给参数)

字段

字段类型

是否必须              长度

DataSource

String

true                   50

Scope

String

false                  255

 

 

6、返回字段(我这里是ResultMap封装了三个字段:status、success、result)

返回字段

字段类型

说明

status

String

返回状态:”OK”

success

String

成功标志:success

result

Map

查询到所有表中数据的封装被封装到map中,以json形式返回

 

7、请求示例(JSON类型)

"status": "OK",

"suceess": "success",

"result": {

"PRM_JCI_Material_SAP_JCAC":"[{\"SAP_NUMBER_O\":\"834810\",\"PLANT_O\":\"5068\",\"ALT_MAT_NUMBER_O\":\"024G00026-086\",\"DESC_EN\":\"CIRCUIT BREAKER 32.0A 1pole\",\"DESC_ZH\":\"断路器S201-C32\",\"MAT_TYPE\":\"YORK\",\"MAT_TYPE_PLANT\":\"PUR\",\"UOM\":\"PCS\",\"DWG_FNAME\":\"\",\"DWG_URL\":\"\",\"STD_FNAME\":\"\",\"STD_URL\":\"\",\"MAT_STATUS_X\":\"G2\",\"PROD_HIERARCHY\":\"0501\",\"IS_DESC\":\"\",\"MAT_GROUP\":\"\",\"MATERIAL_CODE\":\"\",\"DOCUMENT\":\"\",\"DOCUMENT_TYPE\":\"Q\",\"MATERIAL_PROFILE\":\"\",\"MAT_STATUS\":\"P2\",\"ABC_IND\":\"\",\"PURCH_GRP\":\"AD8\",\"MRP_CONTROL\":\"332\",\"MIN_LOT\":\"0.000\",\"SIZE\":\"\",\"GROSS_WT\":\"0.000\",\"NET_WT\":\"0.000\",\"WT_UNIT\":\"KG\",\"VOLUME\":\"0.000\",\"VOL_UNIT\":\"\",\"PROC_TYPE\":\"F\",\"SPECIAL_PROC\":\"10\",\"BACKFLUSH_IND\":\"\",\"ISSUE_STOR_LOC\":\"0060\",\"STOR_LOC_EXT\":\"0060\",\"PLAN_DEL_TIME\":\"45\",\"PROD_TIME\":\"0\",\"SAFE_STOCK\":\"0.000\",\"SAFE_TIME\":\"00\",\"REQ_IND\":\"2\",\"COMP_SCRAP\":\"0.00\",\"WH_NUMBER\":\"508\",\"STOR_TYP\":\"025\",\"STOR_BIN\":\"313-050203\",\"STOR_TYP_NAME\":\"E\&E Parts\",\"STD_PRICE\":\"20.26\",\"PRC_UNT\":\"1\",\"CURR_KEY\":\"CNY\",\"CHANGE_DATE\":\"2019-08-21\",\"CHANGE_TIME\":\"03:53:45\"},{...}]