1 在 XXXmapper.xml 文件中
<select id="callProOutStock" parameterType="map" statementType="CALLABLE" resultType="int"> { call pro_out_stock( #{deptId, mode=IN, jdbcType=VARCHAR}, #{goodsNo, mode=IN, jdbcType=VARCHAR}, #{storageNo, mode=IN, jdbcType=VARCHAR}, #{amount, mode=IN, jdbcType=NUMERIC}, #{result, mode=OUT, jdbcType=NUMERIC} ) } </select>
2 在 XXXmapper.java中
int callProOutStock(@Param("deptId") String deptId, @Param("goodsNo") String goodsNo, @Param("storageNo") String storageNo, @Param("amount") int amount, @Param("result") int result);