1.在mapper.xml中

<select id="checkXkEnable" parameterType="java.util.Map" statementType="CALLABLE" resultType="java.util.Map">{call up_Ty_CheckXkEnable(#{CphOrYyZh,mode=IN,jdbcType=VARCHAR},#{XkWh,mode=IN,jdbcType=VARCHAR},#{Czr,mode=IN,jdbcType=VARCHAR},#{sequence,mode=OUT,jdbcType=VARCHAR},#{sBackValue,mode=OUT,jdbcType=VARCHAR},#{sRet,mode=OUT,jdbcType=VARCHAR})} </select>

2.在mapper.java中

List<Map<String,Object>> checkXkEnable(Map<String, Object> map);

3.在controller中

@ApiOperation("校驗(yàn)申請(qǐng)按鈕") @ApiImplicitParams({@ApiImplicitParam(value = "車牌號(hào)",name = "cphOrYyZh",dataType = "String",paramType = "query"),@ApiImplicitParam(value = "",name = "xkWh",dataType = "String",paramType = "query"),@ApiImplicitParam(value = "czr",name = "czr",dataType = "String",paramType = "query")}) @PostMapping("/checkXkEnable") public ResultInfo checkXkEnable(String cphOrYyZh, String xkWh,String czr) {try {Map<String, Object> params = new HashMap<>();params.put("CphOrYyZh",cphOrYyZh);params.put("XkWh",xkWh);params.put("Czr",czr);xkSqMapper.checkXkEnable(params);String sRet = (String) params.get("sRet");if ("succeed".equals(sRet)) {return ResultInfo.ok("數(shù)據(jù)查詢成功！");} else {return ResultInfo.fail(902, sRet);}} catch (Exception e) {return ResultInfo.fail(901,"數(shù)據(jù)查詢失敗！");} }

?

總結(jié)

以上是生活随笔為你收集整理的spring boot+mybatis-plus+SQL server调用有返回值的存储过程的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。