例子:
数据库中,存储过程的类似写法:
CREATE OR REPLACE
procedure P_Track(V_Express_id in nvarchar2, --参数1
V_langid in nvarchar2, --参数2
ru out sys_refcursor --返回值
) is
row_tmp sys_tmp%rowtype;
//下面还有…
1,controller:
@PostMapping("/trace/getTrace")
public AjaxResult getTrace(String expressId, String langId) {//调用存储过程
Map param = new HashMap<>();//需要用Map来调用
param.put("V_Express_id", expressId);//参数1
param.put("V_langid", langId);//参数2
tmsOrderService.getTrace(param);//进行调用
List result = (List) param.get("result");//获取返回值,直接强转
//下面还有...
2,service:
void getTrace(Map param);
3,serviceImpl:
@Override
public void getTrace(Map param) {
tmsOrderMapper.getTrace(param);
}
4,mapper:
void getTrace(Map param);
5,mapper.xml:
getTrackVo:



