springboot+mybatis存储过程调用

存储过程基本的应用

1.mapper.xml

<select id="getDate" statementType="CALLABLE">
    call stock_match.pro_get_range_datetime(#{actionIn,jdbcType=VARCHAR,mode=IN},#{beginDatetime,jdbcType=DATE,mode=OUT},#{endDatetime,jdbcType=DATE,mode=OUT})
</select>

输入参数：IN  输出参数：OUT

2.mapper

void getDate(CallGetDateDTO dto);

 3.CallGetDateDTO入参对象

@Data
public class CallGetDateDTO {

    private String actionIn;

    private Date beginDatetime;

    private Date endDatetime;
}

 4.入参对象也可以是map、String