spring boot+mybatis-plus+SQL server调用有返回值的存储过程
·
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("校验申请按钮")
@ApiImplicitParams({@ApiImplicitParam(value = "车牌号",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("数据查询成功!");
} else {
return ResultInfo.fail(902, sRet);
}
} catch (Exception e) {
return ResultInfo.fail(901,"数据查询失败!");
}
}
|
更多推荐
所有评论(0)