一、创建存储过程返回值类
public class ProcReturnValueUtils {
private Integer value;
public Integer getValue() {
return value;
}
public void setValue(Integer value) {
this.value = value;
}
}
二、存储过程调用
ProcReturnValueUtils procReturnValueUtils = new ProcReturnValueUtils();
procReturnValueUtils.setValue(0);
tmsVehiclePointsChangeService.insertNewValue(tmsVehiclePointsChange,procReturnValueUtils);
if(procReturnValueUtils.getValue()>0){
return AjaxResult.success("添加成功!");
}else {
return AjaxResult.error("添加失败,请重试!");
}
三、mapper文件
<select id="insertNewValue" statementType="CALLABLE">
call procAddVehiclePointsChange(#{param1.plateNumber},#{param1.businessType},#{param1.changeType},#{param1.value},
#{param1.createBy},#{param1.remark},#{param2.value,mode=OUT, jdbcType=INTEGER});
</select>