前端传参调用MyBatis执行MySQL存储过程及返回结果详解

public class StockProc extends BaseEntity {
    private int id;
    @Excel(name = "第一参数趟次") private int a;
    @Excel(name = "第二参数趟次") private int b ;
    @Excel(name = "第三参数趟次") private int c;
    @Excel(name = "第四参数趟次") private int d;
    // ... 省略其他字段 e, f, g, h, abc, t, tc, min1
}

<!-- MyBatis Mapper XML -->
<mapper namespace="com.ruoyi.stock.mapper.StockProcMapper">
    <resultMap type="StockProc" id="StockProcResult">
        <result property="Id" column="id"/>
        <result property="a" column="a"/>
        <result property="b" column="b"/>
        <result property="c" column="c"/>
        <result property="d" column="d"/>
        <result property="e" column="e"/>
        <result property="f" column="f"/>
        <result property="g" column="g"/>
        <result property="h" column="h"/>
        <result property="abc" column="abc"/>
        <result property="t" column="t"/>
        <result property="tc" column="tc"/>
        <result property="min1" column="min1"/>
    </resultMap>

    <!-- 调用存储过程 -->
    <select id="selectStockProcParamList" parameterType="StockProc" resultMap="StockProcResult" statementType="CALLABLE">
        call bill_a_forbusiness(#{a},#{b},#{c},#{d},#{e},#{f},#{g},#{h},#{abc})
    </select>

    <!-- 普通查询用于回填数据 -->
    <select id="selectStockProcList" parameterType="StockProc" resultMap="StockProcResult">
        SELECT a,b,c,d,e,f,g,h,abc,t,tc,min1 FROM a_tmp
    </select>
</mapper>

@RestController
@RequestMapping("/stock/proc")
public class StockProcController extends BaseController {
    @Autowired
    private IStockProcService stockProcService;

    /** 触发存储过程执行 */
    @GetMapping("/list")
    public TableDataInfo list(StockProc stockProc) {
        startPage();
        // 注意：某些情况下执行后需查库而非直接返回Call结果，具体视DB驱动而定
        List<StockProc> paramlist = stockProcService.selectStockProcParamList(stockProc);
        return getDataTable(paramlist);
    }

    /** 查询执行后的数据结果 */
    @GetMapping("/query")
    public TableDataInfo getInfo(StockProc stockProc) {
        startPage();
        List<StockProc> list = stockProcService.selectStockProcList(stockProc);
        return getDataTable(list);
    }
}

// api/stock/proc.js
import request from '@/utils/request'
export function listProc(query) {
    return request({ url: '/stock/proc/list', method: 'get', params: query })
}
export function returnProc(query) {
    return request({ url: '/stock/proc/query', method: 'get', params: query }) // 修正 parameters 为 params
}

// Proc.vue (部分核心逻辑)
export default {
  data() {
    return {
      queryParams: { pageNum: 1, pageSize: 10, a: null, b: null, ... }, // 包含存储过程参数
      returnprocList: []
    };
  },
  methods: {
    handleQuery() {
      this.queryParams.pageNum = 1;
      // 1. 传入参数调用存储过程
      listProc(this.queryParams).then((response) => {
         // 如果存储过程直接返回游标，这里处理；通常执行后需再次查询
      });
    },
    returnQuery() {
      this.queryparameters.pageNum = 1;
      // 2. 查询数据库最新数据展示
      returnProc(this.queryparameters).then((response) => {
        this.returnprocList = response.rows;
        this.total = response.total;
      });
    }
  }
}