service 方法
super.query(eiInfo, "QMJH030101TEST.query");
eiInfo:包含传入的参数,参数为查询数据库时的条件,eiInfo格式后面再讲。
QMJH030101TEST:写SQL语句的xml文件名
query:xml文件中的sql便签的id属性,表示使用的SQL语句
postman测试service方法
- 1
启动项目登录localhost:8080 用户名:admin 密码:123abc
- 2
进入F12 在NetWork中找到query,复制query中的 JSESSIONID
-3
进入postman,url为
http://localhost:8080/service/QMJH030101TEST/query2
其中,QMJH030101TEST为Service类名去掉"Service",query2位方法名
点击cookies
修改localhost中的JSESSIONID。就是刚才登录后复制的
- 4
在body中输入参数
{
"serviceType": "",
"efCurFormEname": "QMJH030101TEST",
"__resAppEname__": "ieqms-eq3",
"$$remote$$": "false",
"methodName": "query2",
"efFormCname": "测试",
"efFormStyle": " ",
"soaInvokeProtocol": "local",
"serviceName": "QMJH030101TEST",
"__resProjectEname__": "ieqms",
"__version__": "2.0",
"__sys__": {
"name": "",
"descName": "",
"msg": "",
"msgKey": "",
"detailMsg": "",
"status": 0,
"traceId": "a9fee4e916293384395550000002f"
},
"__blocks__": {
"result": {
"attr": {
"limit": 10
},
"meta": {
"desc": "",
"attr": {},
"columns": []
},
"rows": []
},
"inqu_status": {
"attr": {},
"meta": {
"desc": "",
"attr": {},
"columns": [{
"pos": 0,
"name": "internalCode"
}]
},
"rows": [
["1e73aa8c-0f21-4827-ac4a-94984818dbb7"]
]
}
}
}
- 5
通过请求查询的数据在"dddd"下的"rows"中。其中,"dddd"是在service方法中自定义的名称